SQL Training Course

I've added this here in case someone would like a guided SQL training course. This will better familiarize you with database schema and how to manipulate data.

To begin training make an account on SQLZoo.net:
Website: http://sqlzoo.net/w/index.php?title=Special:UserLogin&type=signup

Then begin reading the SQL material on the W3Schools website and refer to the SQL Training Curriculum below for required and optional chapters: http://www.w3schools.com/sql/default.asp

Some training links are also gathered from http://www.sqlteaching.com to provide a more complete learning experience, but no login creation is required.

SQL Training Curriculum (Section Chapters are located on W3Schools.com):

Section 1:
Introduction to SQL
SQL Syntax
SQL SELECT Statement
SQL SELECT DISTINCT Statement
SQL WHERE Clause
SQL AND & OR Operators
SQL ORDER BY Keyword

Exercises

1. SELECT

http://sqlzoo.net/wiki/SELECT_basics
http://sqlzoo.net/wiki/SELECT_Quiz

http://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial
http://sqlzoo.net/wiki/BBC_QUIZ

http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial
http://sqlzoo.net/wiki/Nobel_Quiz

http://www.sqlteaching.com/#!distinct

1. WHERE
   http://www.sqlteaching.com/#!where_equals
   http://www.sqlteaching.com/#!where_greater_than
   http://www.sqlteaching.com/#!where_greater_than_or_equal

2. AND
   http://www.sqlteaching.com/#!and

3. ORDER BY
   http://www.sqlteaching.com/#!order_by

Section 1 Advanced:

1. Subqueries

http://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial
http://sqlzoo.net/wiki/Nested_SELECT_Quiz

http://www.sqlteaching.com/#!nested

Section 2:
SQL INSERT INTO Statement
SQL UPDATE Statement
SQL DELETE Statement
SQL SELECT TOP Clause
(Just understand what SELECT TOP means if you see it in a query and why you might need to add/remove it)

Exercises

1. INSERT INTO
   http://sqlzoo.net/wiki/INSERT_..VALUES
   http://sqlzoo.net/wiki/INSERT.._SELECT

2. UPDATE
   http://sqlzoo.net/wiki/UPDATE

3. DELETE
   http://sqlzoo.net/wiki/DELETE

4. LIMIT/SELECT TOP
   http://www.sqlteaching.com/#!limit
   (Similar to SELECT TOP, with different syntax)

Section 3:
SQL LIKE Operator
SQL Wildcards
SQL IN Operator
SQL BETWEEN Operator

Exercises

1. LIKE
   http://www.sqlteaching.com/#!like

2. IN
   http://www.sqlteaching.com/#!in

Section 4:
SQL Joins
SQL INNER JOIN Keyword
SQL LEFT JOIN Keyword
SQL RIGHT JOIN Keyword
SQL FULL OUTER JOIN Keyword
SQL UNION Operator

Exercises

1. JOIN
   http://sqlzoo.net/wiki/SELECT_.._JOIN

http://sqlzoo.net/wiki/The_JOIN_operation
http://sqlzoo.net/wiki/JOIN_Quiz

http://sqlzoo.net/wiki/More_JOIN_operations
http://sqlzoo.net/wiki/JOIN_Quiz_2

http://sqlzoo.net/wiki/LEFT_JOIN

1. UNION
   http://sqlzoo.net/wiki/UNION

Section 4 Advanced:

http://sqlzoo.net/wiki/Self_join
http://sqlzoo.net/wiki/Self_join_Quiz

Section 5:
SQL Constraints
SQL PRIMARY KEY Constraint
SQL FOREIGN KEY Constraint

ADVANCED SECTIONS 6-9
Section 6:
SQL DROP INDEX, DROP TABLE, and DROP DATABASE
SQL ALTER TABLE Statement

Exercises

1. DROP
   http://sqlzoo.net/wiki/DROP

2. ALTER
   http://sqlzoo.net/wiki/ALTER

Section 7:
SQL Views
SQL Date Functions
SQL NULL Values
SQL NULL Functions
SQL General Data Types

Exercises

1. VIEWS
   http://sqlzoo.net/wiki/CREATE_VIEW

2. NULL
   http://sqlzoo.net/wiki/NULL

Section 8:
SQL Functions
SQL AVG() Function
SQL COUNT() Function
SQL FIRST() Function
SQL LAST() Function
SQL MAX() Function
SQL MIN() Function
SQL SUM() Function

Exercises

1. FUNCTIONS
   http://sqlzoo.net/wiki/FUNCTIONS

A) AVG
http://www.sqlteaching.com/#!avg

B) COUNT
http://www.sqlteaching.com/#!count
http://www.sqlteaching.com/#!count_where
http://sqlzoo.net/wiki/SUM_and_COUNT

C) MAX & MIN
http://www.sqlteaching.com/#!max_min

D) SUM
http://sqlzoo.net/wiki/SUM_and_COUNT

Section 9:
SQL GROUP BY Statement
SQL HAVING Clause

Exercises

1. GROUP BY
   http://sqlzoo.net/wiki/SELECT_.._GROUP_BY

REVIEW AND FINAL QUIZ
Review/Reference Chapter:

http://www.w3schools.com/sql/sql_quickref.asp

W3 Schools Quiz:
http://www.w3schools.com/sql/sql_quiz.asp

Optional Chapters:
SQL Injection
SQL Aliases
SQL INSERT INTO SELECT Statement
SQL CREATE DATABASE Statement
SQL CREATE TABLE Statement
SQL NOT NULL Constraint
SQL UNIQUE Constraint
SQL CHECK Constraint
SQL DEFAULT Constraint
SQL CREATE INDEX Statement
SQL AUTO INCREMENT Field
SQL Data Types for Various DBs
SQL UCASE() Function
SQL LCASE() Function
SQL MID() Function
SQL LEN() Function
SQL ROUND() Function
SQL NOW() Function
SQL FORMAT() Function
SQL Hosting