Learn SQL Step-By-Step

SQL Classes -
Offered Online Or Onsite

Custom Training Available

Each of the following SQL Classes is:

• Eight (8) hours of training that can be covered in one full day or in two 4-hour sessions
• Taught online by an expert SQL trainer using web conferencing
• Available for onsite training
• Customizable to your needs and requirements
• Scheduled on-demand
• Geared for your database of choice (SQL Server, Oracle, Interbase/Firebird, MySQL, PostgreSQL)
• Offered for $499 per person per day

SQL101 - Introduction To SQL Programming (Level: Beginner; Prerequisites: None; Price: $499)

Learn SQL step-by-step and from the ground up.

This class assumes no prior knowledge of the Structured Query Language (SQL) and is an absolute necessity if you have not had any background with SQL or relational databases.

The class presents an overview of databases and of the Relational Database Model and the foundations of database design. It covers the foundations of SQL and how to use the language to create a database, tables, indexes, constraints, views, and to manipulate the data structure.

Class Details:

• Overview of database models
• Introduction to the Relational Database Model
• Understanding Relation Types & Properties
• Working with a Relational Database
• Designing a database
• Understanding data entities and relationships
• Overview of Database Normalization
• Guidelines for Normalization in design
• Overview of Set Theory
• Introduction to the Structured Query Language (SQL)
• Understanding SQL syntax
• Creating the database and objects
• Creating tables and indexes
• Understanding SQL constraints
• Modifying and deleting databases and objects
• Populating databases
• Modifying and deleting existing data

SQL102 - Selecting & Presenting Data With SQL (Level: Beginner; Prerequisites: SQL101; Price: $499)

This interactive SQL class introduces the two areas of the Structured Query Language (SQL): The Data Definition Language (DDL) and the Data Manipulation Language (DML).

The class covers the main components of a SQL statement and provides multiple examples on how to use SQL to access and modify data.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Class Details:

• Elements of a select statement
• Narrowing down specific selections
• Sorting your query results
• Eliminating duplicate rows
• Working with Aggregates
• Grouping data
• Handling Null values
• You will learn how to work with:
• CREATE
• INSERT
• UPDATE
• DELETE
• SELECT
• WHERE Clause & Operators
• AND, OR, NOT
• TOP
• ORDER BY
• GROUP BY
• BETWEEN
• IN
• LIKE
• Operators
• IS NULL
• Aliases for tables and fields
• Aggregate Functions
• Scalar Functions
• Primary & Foreign Keys
• Wildcards
• Problem solving techniques

SQL201 - Structuring SQL Queries (Level: Intermediate; Prerequisites: SQL101, SQL102; Price: $499)

This interactive SQL class focuses on the different ways we can join multiple tables using basic and advanced SQL queries. You will learn all about Inner Joins, Outer Joins, Self Joins, Unions and Correlated and Non-Correlated Subqueries.

The class covers these topics step-by-step and in great details, and provides multiple examples on how to use SQL to access and modify data using one or multiple tables.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Class Details:

• Working with multiple tables
• Joins and their uses
• Working with joins
• Using Equijoins or Inner Joins
• Understanding and using Self Joins
• Understanding and using Outer Joins
• Understanding and using Unions
• Understanding subqueries, their need and how they work
• Joins vs. Subqueries - Know the difference
• Evaluating different return values with subqueries
• Nesting queries

SQL202 - Advanced SQL Concepts (Level: Intermediate; Prerequisites: SQL101, SQL102, SQL201; Price: $499)

This interactive SQL class focuses on Views, Temporary Tables and advanced database queries. Views will be covered step-by-step, beginning with the most basic concepts to the creation of advanced views. The class will provide multiple examples on how to use Views and Temporary Tables in real-life scenarios. You will learn how to analyze the data requirements and avoid serious logical errors in the structuring of your queries.

The class is hands-on and students will be engaged to test knowledge and to solve SQL problems.

Class Details:

• Formatting your output using functions
• Working with Date & Time functions
• The CASE expression and its uses
• Understanding Views
• Working with Views
• Updating data through Views
• Understanding patterns
• Complex joins and subqueries
• Understanding Temporary Tables
• Working with Temporary Tables
• Common mistakes - how to spot them and avoid them

Home | SQL Classes | Onsite Training | Our Students | Contact Us