Back

Database Various SQL Languages

On-the-Job Training
IT TRAINING
The 24-Hour Solution
Try it out,
24 hrs for $24

Prepare for an upcoming exam. Make corporate training decisions without risk. Access all of our IT training for 24 hours. Learn More
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.

All trademarks and copyrights are the property of their respective holders.
  • Videos
  • Purchase Options
Title Duration
 
Introduction
Overview of the series, what variations of SQL this series works with
 00:08:23
 
Database and Querying Concepts and Overview
Terminology, ANSI standards, what is "null," default values, auto-incrementing columns
 00:20:29
 
SELECT: The Basics
Querying data, selecting columns, basic filtering, basic sorting
 00:21:01
 
Filtering Data with WHERE
Comparison operators, IN and BETWEEN operators, Boolean operators, IS operator, string and date delimiters, special functions like SOUNDEX and DIFFERENCE
 00:20:19
 
SELECT: Using Functions
How to use common functions in the SELECT statement
 00:19:32
 
SELECT: Aggregates, GROUP BY, and HAVING
Aggregate/set functions, COUNT, MAX, MIN, SUM, AVG, and so on, GROUP BY and HAVING clauses
 00:22:09
 
SELECT: Advanced Tricks
TOP/LIMIT, sub-queries, table and column aliasing, DISTINCT, CASTing data types
 00:26:52
 
INSERT, DELETE, and UPDATE Queries
Adding data, deleting data, and changing data; using SELECT in an INSERT, using TOP/LIMIT and WHERE
 00:18:04
 
SELECT: Multiple Tables
CROSS JOIN, NATURAL JOIN, INNER JOIN, and OUTER JOINs
 00:18:27
 
SELECT: Advanced MUlti-Table Queries
UNION operator, UNION JOIN, INTERSECT and EXCEPT operators
 00:16:19
 
Common SQL Functions
Numeric functions, String functions, Date/Time functions
 00:18:02
 
Transactions
START TRANSACTION / BEGIN WORK / BEGIN TRANSACTION, COMMIT, ROLLBACK, and transaction concepts
 00:15:46
 
Data Definition
CREATE TABLE, common data types, ALTER TABLE, DROP TABLE
 00:19:47
 
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
 00:23:47
 
Speeding Up Queries, and Slowing them Down: Indexes
Index concepts, CREATE INDEX, rebuilding/reorganizing indexes, DROP INDEX
 00:23:34
 
CAUTION: SQL Injection Attacks
How they work, how to prevent them (escaping data and stored procedures)
 00:22:06
 
Tools for working with SQL
phpMyAdmin, SQL Server Management Studio, MySQL Query Analyzer, Other Tools
 00:17:31
 
Cursors
Introduction and concepts, OPEN and CLOSE, FETCH, downsides of cursors
 00:20:12
 
Database Design Principles
First, Second, and Third Normal form; denormalization
 00:28:42
 
Advanced Database Capabilities
Platform-specific features, triggers, XML data manipulation, background jobs, and so on.
 00:21:06
Total Series Duration: 6 hours
Which option is right for you?
Buy a Single Series
"Focus your training on one series, for one month, for one low price."
StreamOne
StreamOne SUBSCRIPTION
StreamOne is your monthly option for streaming access to Database Various SQL Languages. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.
MULTI-USER
$199
per license
Add to Cart
$499
EDM
Download
Download Database Various SQL Languages.
$499
DVD
DVD
Have Database Various SQL Languages delivered on DVD.
 
Buy an Annual Subscription to Everything IT
"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."
All topics. From admin to programming.
Image
IT Nuggets
Productivity for Companies and IT Advancement for Professionals
Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.
YEARLY
MULTI-USER
$1999
per license
Add to Cart
Bookmarks

No Bookmarks