SQL Scripting Essentials

This two-day, instructor-led SQL training class will give you the skills to write simple and complex queries using SQL (Structured Query Language) statements to retrieve results from a database. You will know how to query database tables and manipulate the results from a variety of databases like Microsoft Access, Oracle, SQL Server and MySQL. This course features units on:

I. What is Structured Query Language (SQL)?
II. Selecting Data
III. Retrieving Data from Multiple Tables
IV. Using Criteria in SQL Statements
V. Generating Totals Using SQL
VI. Generating Calculated Fields Using SQL
VII. Unions, Subqueries, and More Joins
VIII. Action Queries
IX. Advanced SQL Functions
X. Conditional Queries