Sprint - Database & SQLIntro Database & SQL
Learn SQL - Part 1SQL Intro
What is SQL?
What can SQL do?
SQL is a Standard - BUT...
Using SQL in Your Web Site
RDBMS
SQL SyntaxDatabase Tables
Some of The Most Important SQL Commands
SQL SELECT Statement
The SQL WHERE Clause
Text Fields vs. Numeric Fields
Operators in The WHERE Clause
SQL AND, OR and NOT Operators
SQL ORDER BY Keyword
SQL INSERT INTO Statement
Insert Data Only in Specified Columns
SQL NULL ValuesWhat is a NULL Value?
How to Test for NULL Values?
SQL WildcardsSQL Wildcard Characters
Wildcard Characters in SQL Server Using the % Wildcard
Using the _ Wildcard
Using the [charlist] Wildcard
Using the [!charlist] Wildcard
SQL Aliases
Learn SQL - Part 2SQL Joins
Different Types of SQL JOINs
SQL INNER JOIN Keyword
JOIN Three Tables
SQL LEFT JOIN Keyword
SQL RIGHT JOIN Keyword
|