CNZJ.NET

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

CBT Nuggets The SQL Language On the Job Training
CBT Nuggets The SQL Language: On-the-Job Training
Homepage  2010-01-08  402.3 MB  22