FileBeta

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

More Info:

http://cbtnuggets.com/webapp/product?id=553

Download:

http://hotfile.com/dl/23361545/595d7e7/i-cbtnsqllotj_www.FileBeta.com.part1.rar.html

http://hotfile.com/dl/23361547/4219bb5/i-cbtnsqllotj_www.FileBeta.com.part2.rar.html