CBT Nuggets The SQL Language On the Job Training-iNKiSO | 638.30 MB
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.
Every CBT Nuggets series -- whether it's certification track or, like this one, solely on-the-job training -- gives you the hands-on skills you need to be a more effective IT professional.
The SQL Language On-the-Job trainingcontents:
* Introduction
* Database and Querying Concepts and Overview
* SELECT: The Basics
* Filtering Data with WHERE
* SELECT: Using Functions
* SELECT: Aggregates, GROUP BY, and HAVING
* SELECT: Advanced Tricks
* INSERT, DELETE, and UPDATE Queries
* SELECT: Multiple Tables
* SELECT: Advanced MUlti-Table Queries
* Common SQL Functions
* Transactions
* Data Definition
* Understanding Relational Data
* Speeding Up Queries, and Slowing them Down: Indexes
* CAUTION: SQL Injection Attacks
* Tools for working with SQL
* Cursors
* Database Design Principles
* Advanced Database Capabilities
Here's what you'll learn in each video of The SQL Language On-the-Job training series:
Video 1 - "Introduction" - overview of the series, what variations of SQL this series works with
Video 2 - "Database and QUerying Concepts and Overview" - terminology, ANSI standards, what is "null," default values, auto-incrementing columns
Video 3 - "SELECT: The Basics" - querying data, selecting columns, basic filtering, basic sorting
Video 4 - "Filtering Data with WHERE" - 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" - how to use common functions in the SELECT statement
Video 6 - "SELECT: Aggregates, GROUP BY, and HAVING" - aggregate/set functions, COUNT, MAX, MIN, SUM, AVG, and so on, GROUP BY and HAVING clauses
Video 7 - "SELECT: Advanced Tips" - TOP/LIMIT, sub-queries, table and column aliasing, DISTINCT, CASTing data types
Video 8 - "INSERT, DELETE, and UPDATE Queries" - adding data, deleting data, and changing data; using SELECT in an INSERT, using TOP/LIMIT and WHERE
Video 9 - "SELECT: Multiple Tables" - CROSS JOIN, NATURAL JOIN, INNER JOIN, and OUTER JOINs
Video 10 - "SELECT: Advanced MUlti-Table Queries" - UNION operator, UNION JOIN, INTERSECT and EXCEPT operators
Video 11 - "Common SQL Functions" - Numeric functions, String functions, Date/Time functions
Video 12 - "Transactions" - START TRANSACTION / BEGIN WORK / BEGIN TRANSACTION, COMMIT, ROLLBACK, and transaction concepts
Video 13 - "Data Definition" - CREATE TABLE, common data types, ALTER TABLE, DROP TABLE
Video 14 - "Understanding Relational Data" - 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" - Index concepts, CREATE INDEX, rebuilding/reorganizing indexes, DROP INDEX
Video 16 - "CAUTION: SQL Injection Attacks" - How they work, how to prevent them (escaping data and stored procedures)
Video 17 - "Tools for Working with SQL" - phpMyAdmin, SQL Server Management Studio, MySQL Query Analyzer, Other Tools
Video 18 - "Cursors" - Introduction and concepts, OPEN and CLOSE, FETCH, downsides of cursors
Video 19 - "Database Design Principles" - First, Second, and Third Normal form; denormalization
Video 20 - "Advanced Database Capabilities" - Platform-specific features, triggers, XML data manipulation, background jobs, and so on.
Education / Tutorials → CBT Nuggets The SQL Language On the Job Training31 Mar 2012, 14:10 http://www.fileserve.com/file/ZKH7bBM/i-cbtnsqllotj_db.rar You have to login or register to post comments. |
Linked with requests |
