SQL Scripting Fundamentals Training

Increase your marketability as a web developer, programmer, or database administrator with our SQL training.

In this SQL training class, you'll master the skill of writing correct and effective SQL (Structured Query Language) statements that manipulate and retrieve data from your database. Once you know SQL, you can use it to interact with most major databases, such as MS Access, Oracle, Microsoft SQL Server, and MySQL.

Prerequisites:

  • Experience with a desktop database such as Filemaker or MS Access

What is Structured Query Language (SQL)?

  • Relational Databases
  • Basic SQL Keywords
  • Tips for Planning Queries
  • What People Do with Queries
  • SQL Platforms

Selecting Data

  • Using SELECT Statements to Examine Database Tables
  • Using Results to Figure Out Other Tables to Examine
  • Narrowing Your SQL Statements Down to Fields You Need
  • Sorting Records
  • Using Field Aliasing
  • Saving a SQL Statement

Getting Data From Multiple Tables

  • Inner and Outer JOINS
  • Table Aliasing
  • Self JOINS

Using Criteria in SQL Statements

  • Avoiding Ambigious Situations
  • Using A Single Criterion to Limit Records
  • AND/OR Situations in Criteria
  • Criteria Keywords
  • Using Comparison Criteria
  • Using Wildcards

Generating Totals Using SQL

  • Aggregate Keywords
  • The GROUP BY Clause
  • Using Criteria in Aggregate-based Queries

Generating Calculated Fields Using SQL

  • Math Calculations
  • Using SQL Keywords to Enhance the Display of Data
  • DATE Calculations
  • TEXT Calculations

UNIONS, SUBQUERIES, and More JOINS

  • Using a WHERE Clause as an INNER JOIN
  • Using UNIONS
  • Using SUBQUERIES

Action Queries

  • Using the INSERT Keyword
  • Using the UPDATE Statements
  • Using the DELETE Keyword

Working with VIEWS

  • Creating a VIEW to Simplify Data Retrieval
  • Altering a VIEW
  • Creating a VIEW to Restrict Accessbile Data
  • Inserting Data Through a VIEW
  • Delete VIEWS

Using SQL to Structure Databases

  • Understanding DATA Types
  • Creating Tables
  • Altering Tables
  • Deleting Tables

Indexing

  • Creating a Single-Column Index
  • Creating a Multiple-Column Index
  • Dropping an Index

Conditional Queries

  • Using an IF Statement
  • Using a CASE Statement

Common Tables Expressions

  • Creating and Using Common Table Expressions (CTES)

SQL training is offered at four locations: