CBT Nuggets - The SQL Language On the Job Training

Regardless of which database platform you use -- Oracle, SQL Server, MySQL, SQLite, PostgreSQL, and more -- learning industry-standard SQL query syntax will give your database efforts a real boost.
This Don Jones training shows you how to write simple and complex queries in industry-standard SQL syntax, adapt syntax to vendor-specific SQL variants, defend against attacks like SQL injection, understand and optimize database designs, and even help optimize query performance through indexing.
What You'll Learn

*
Video 1: Introduction|08:23

Overview of the series, what variations of SQL this series works with
*
Video 2: Database and Querying Concepts and Overview|20:29

Terminology, ANSI standards, what is "null," default values, auto-incrementing columns
*
Video 3: SELECT: The Basics|21:01

Querying data, selecting columns, basic filtering, basic sorting
*
Video 4: Filtering Data with WHERE|20:19

Comparison operators, IN and BETWEEN operators, Boolean operators, IS operator, string and date delimiters, special functions like SOUNDEX and DIFFERENCE
*
Video 5: SELECT: Using Functions|19:32

How to use common functions in the SELECT statement
*
Video 6: SELECT: Aggregates, GROUP BY, and HAVING|22:09

Aggregate/set functions, COUNT, MAX, MIN, SUM, AVG, and so on, GROUP BY and HAVING clauses
*
Video 7: SELECT: Advanced Tricks|26:52

TOP/LIMIT, sub-queries, table and column aliasing, DISTINCT, CASTing data types
*
Video 8: INSERT, DELETE, and UPDATE Queries|18:04

Adding data, deleting data, and changing data; using SELECT in an INSERT, using TOP/LIMIT and WHERE
*
Video 9: SELECT: Multiple Tables|18:27

CROSS JOIN, NATURAL JOIN, INNER JOIN, and OUTER JOINs
*
Video 10: SELECT: Advanced MUlti-Table Queries|16:19

UNION operator, UNION JOIN, INTERSECT and EXCEPT operators
*
Video 11: Common SQL Functions|18:02

Numeric functions, String functions, Date/Time functions
*
Video 12: Transactions|15:46

START TRANSACTION / BEGIN WORK / BEGIN TRANSACTION, COMMIT, ROLLBACK, and transaction concepts
*
Video 13: Data Definition|19:47

CREATE TABLE, common data types, ALTER TABLE, DROP TABLE
*
Video 14: Understanding Relational Data|23:47

Creating primary keys, creating foreign key constrains, creating NOT NULL constraints, create UNIQUE constrains, creating CHECK constraints, understanding constraints' impact on relational data
*
Video 15: Speeding Up Queries, and Slowing them Down: Indexes|23:34

Index concepts, CREATE INDEX, rebuilding/reorganizing indexes, DROP INDEX
*
Video 16: CAUTION: SQL Injection Attacks|22:06

How they work, how to prevent them (escaping data and stored procedures)
*
Video 17: Tools for working with SQL|17:31

phpMyAdmin, SQL Server Management Studio, MySQL Query Analyzer, Other Tools
*
Video 18: Cursors|20:12

Introduction and concepts, OPEN and CLOSE, FETCH, downsides of cursors
*
Video 19: Database Design Principles|28:42

First, Second, and Third Normal form; denormalization
*
Video 20: Advanced Database Capabilities|21:06

Platform-specific features, triggers, XML data manipulation, background jobs, and so on.