CBT Nuggets - The SQL Language On the Job Training
English | WMV | 800x600 | WMV1 71.7Kbps | WMA2 48.0Kbps | 530 MB
Genre: 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.
No Password | Single Extraction | Interchangeable Links
Download from Fileserve.com:
http://www.fileserve.com/file/JRA2tSx/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part1.rar
http://www.fileserve.com/file/WU7k8KA/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part2.rar
http://www.fileserve.com/file/qEkVxqQ/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part3.rar
http://www.fileserve.com/file/RKjc3fa/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part4.rar
http://www.fileserve.com/file/XzQMhyX/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part5.rar
http://www.fileserve.com/file/aCasBce/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part6.rar
From Hotfile.com:
http://hotfile.com/dl/80498809/72ea008/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part1.rar.html
http://hotfile.com/dl/80498888/15465ba/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part2.rar.html
http://hotfile.com/dl/80498949/66cdb5a/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part3.rar.html
http://hotfile.com/dl/80499062/336e332/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part4.rar.html
http://hotfile.com/dl/80499127/bd8d165/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part5.rar.html
http://hotfile.com/dl/80499149/633e3f3/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part6.rar.html
From Filesonic.com:
http://www.filesonic.com/file/29669877/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part1.rar
http://www.filesonic.com/file/29670487/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part2.rar
http://www.filesonic.com/file/29670513/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part4.rar
http://www.filesonic.com/file/29670553/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part5.rar
http://www.filesonic.com/file/29669887/CBT.Nuggets.The.SQL.Language.On.the.Job.Training.part6.rar
