Производитель: CBT Nuggets
Год выпуска: 2009
Язык: английский

#777
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

Техданные:
Audio: Windows Media Audio 44100Hz mono 48Kbps [Raw Audio 0]
Video: Windows Media Video 7 800x600 15.00fps 119Kbps [Raw Video 1]

Скриншоты