2013
Pluralsight
Jon Flanders
3h 22m
English

This course is a gentle introduction to Structured Query Language (SQL).

-01. SQL Basics
01. Introduction.wmv
02. What is A Database.wmv
03. What Does Relational Mean.wmv
04. An Example.wmv
05. SQL Statement.wmv
06. Naming Things.wmv
07. Creating Things.wmv
08. RDMS.wmv
09. SQL in This Course.wmv
10. Summary.wmv

-02. The SELECT Statement
01. Introduction.wmv
02. The FROM clause.wmv
03. Limiting The Result Set.wmv
04. WHERE clause.wmv
05. AND and OR.wmv
06. Demo AND and OR.wmv
07. More Operators.wmv
08. Demo Between.wmv
09. LIKE.wmv
10. Demo LIKE.wmv
11. IN.wmv
12. Demo IN.wmv
13. IS and IS NOT.wmv
14. Demo IS and IS NOT.wmv
15. Summary.wmv

-03. JOINS
01. Introduction.wmv
02. Demo OrderBY.wmv
03. Set Functions.wmv
04. Demo Set Functions.wmv
05. Qualifiers and Set Functions.wmv
06. Demo Qualifiers and Set Functions.wmv
07. GROUP BY.wmv
08. Demo GROUP BY.wmv
09. HAVING.wmv
10. Demo HAVING.wmv
11. JOINS.wmv
12. Demo JOINS.wmv
13. Summary.wmv

-04. Adding, Changing, and Removing Data
01. Introduction.wmv
02. INSERT.wmv
03. Demo INSERT.wmv
04. Inserting Multiple Rows.wmv
05. UPDATE.wmv
06. Demo UPDATE.wmv
07. DELETE.wmv
08. Demo DELETE.wmv
09. Summary.wmv

-05. Creating Tables
01. Introduction.wmv
02. CREATE TABLE Example.wmv
03. NULL or NOT NULL.wmv
04. PRIMARY KEY & CONSTRAINT.wmv
05. ALTER TABLE.wmv
06. DROP TABLE.wmv
07. DEMO CREATE TABLE.wmv
08. Summary.wmv

http://pluralsight.com/

Download File Size:232.76 MB

---