CBT Nuggets The SQL Language On the Job Training-iNKiSO

Tutorial & e-learning. January 9, 2010 by CONFiG.

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.

NFO | Homepage

CBT.Nuggets.The.SQL.Language.On.the.Job.Training-iNKiSO

http://www.filesonic.com/file/WbdSCZU/i-cbtnsqllotj_db.rar
or
http://www.fileserve.com/file/ZKH7bBM/i-cbtnsqllotj_db.rar
or
http://rapidshare.com/files/3797965910/i-cbtnsqllotj_db.rar

Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
Share
  • Featured link
  • [9-01-2010]
  • k-006
  • [4 July 2013 02:55]
Can you please reupload the links?

Thanks
  • Jason
  • [14 January 2012 23:53]
Taichou,
done


Regards,
J.

  • Taichou
  • [14 January 2012 23:12]
Can reupload the links please?

Comment