Hands-On SQL

Free-Ed.Net > Information Technology > Hands-On SQL

Contact Us - Tell A Friend - Make a Donation - Free-Ed.Net Home

	SQL Quick Ref
	Quiz

Select a lesson:

Home

Part 1 SQL Basic

	1-1 SQL Syntax
	1-2 SELECT
	1-3 DISTINCT
	1-4 WHERE
	1-5 AND & OR
	1-6 ORDER BY
	1-7 TOP

SQL Demo : Try It

Part 2 Advanced SQL

	2-1 LIKE
	2-2 Wildcards
	2-3 IN
	2-4 BETWEEN
	2-5 Alias
	2-6 Join
	2-7 INNER JOIN
	2-8 LEFT JOIN
	2-9 RIGHT JOIN
	2-10 FULL JOIN
	2-11 UNION
	2-12 SELECT INTO
	2-13 CREATE DB
	2-14 CREATE TABLE
	2-15 Constraints
	2-16 NOT NULL
	2-17 UNIQUE
	2-18 PRIMARY KEY
	2-19 FOREIGN KEY
	2-20 CHECK
	2-21 DEFAULT
	2-22 CREATE INDEX
	2-23 DROP
	2-24 ALTER
	2-25 INSERT
	2-26 INCREMENT
	2-27 UPDATE
	2-28 DELETE
	2-29 CREATE VIEW

Part 3 SQL Functions

	3-1 SQL Functions
	3-2 AVG()
	3-3 COUNT()
	3-4 FIRST()
	3-5 LAST()
	3-6 MAX()
	3-7 MIN()
	3-8 SUM()
	3-9 GROUP BY
	3-10 HAVING
	3-11 UCASE()
	3-12 LCASE()
	3-13 MID()
	3-14 LEN()
	3-15 ROUND()
	3-16 NOW()
	3-17 FORMAT()

Part 4 SQL Specials

	4-1 NULLS
	4-2 ISNULL()
	4-3 SQL Data Types

About This Course