SQL CASE Tutorial - How to Use the SQL CASE Statement
Wondering how to use the IF condition in SQL. Confused how to use the SQL CASE statement? Learn how to use the SQL CASE statement from this step by …
Continue ReadingWondering how to use the IF condition in SQL. Confused how to use the SQL CASE statement? Learn how to use the SQL CASE statement from this step by …
Continue ReadingStarting off learning SQL? Learn the different ways of using the SQL SELECT statement. This is an easy step by step tutorial with some examples to …
Continue ReadingBy using the SQL DELETE command, you can get rid of unwanted rows of data in your table. Read more to learn how to use the DELETE command and how it …
Continue ReadingThe SQL LIKE operator is used in situations where a pattern needs to be matched. Read more to learn how useful the LIKE operator is. This article also …
Continue ReadingThe SQL order by clause isn’t difficult to learn to use and it can really come in handy whenever you need to sort query results so that your …
Continue ReadingHTML and PHP are often combined to accomplish web development tasks such as the generation of dynamic HTML which is almost always essential when …
Continue ReadingPHP is a very powerful scripting language. Using PHP, you can perform various file operations. In this tutorial, I will show you how you can create, …
Continue ReadingJoins in SQL are used to select data from multiple tables based on a specific relationship. There are 4 SQL join types: Inner, Left, Right and Full. …
Continue ReadingIn this tutorial, I will explain how you can create, retrieve and delete cookies using PHP. Cookies can be used to store user information like …
Continue ReadingPHP includes a lot of built in math functions which you can use in your program. In this tutorial, I will list the most commonly used ones along with …
Continue ReadingUnderstanding how to extract the data you need from an SQL database can be hard at first. Read on to discover how to filter out unwanted rows from …
Continue ReadingLearn how to write SQL scripts, or Structured Query Language, a programming language used in databases. It retrieves data from a variety of tables, …
Continue Reading