Skip to content

Classes Software Development

SQL-E Taught by us

SQL Fundamentals of Querying

  • 2 days
  • 4 upcoming dates
  • 1 guaranteed to run

Upcoming dates

All times shown in the class's own timezone. 1 of 4 are guaranteed to run, meaning they go ahead regardless of enrollment. Dates we teach ourselves run once 1 people are booked, so a pair of seats confirms one.

Dates Starts Where Status Seat Book
Oct 21-22 9:00 AM to 4:00 PM PDT Taught by us Live virtual GUARANTEED $795
Nov 24-25 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $795
Dec 17-18 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $795
Jan 20-21 9:00 AM to 4:00 PM PST Taught by us Live virtual RUNS WITH 1+ $795

About this class

We have 4 scheduled dates of SQL Fundamentals of Querying, from Oct 21-22 through Jan 20-21. 1 of them is guaranteed to run regardless of enrollment. We teach this one ourselves, with our own instructors and courseware. Seats are $795 each over 2 days, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

This two day instructor-led course serves two main audiences: those who have never touched Structured Query Language (SQL), and those who have seen SQL queries and may even have worked with existing SQL queries or tried to build a query but want to understand the language behind the query. Or, maybe you are reading this and thinking, I have seen others build SQL statements but I want or need to know how to do it myself. In any of these cases, you have come to the right place. This course will introduce you to SQL and its use in writing queries, questions you ask of data in your database, to retrieve information from a database. You will learn about SQL and its basic keywords and phrases used to build statements that will get the data you need from a database.

What you'll be able to do

  • Write basic SQL Queries
  • Perform SQL Joins
  • Use criteria in queries
  • Generate calculated fields and totals in queries
  • Build subqueries
  • Change data through the use of queries
  • Create SQL Views
  • Create tables using SQL
  • Index columns
  • Perform conditional queries

Course outline

Module 1 What is Structured Query Language (SQL)?

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

Module 2 Selecting Data

  • Using Select Statements to Examine Database Tables
  • Using Results to Figure out other Tables to Examine
  • Narrowing your SQL Statements to Fields you Need
  • Sorting Records
  • Using Field Aliasing
  • Saving a SQL Statement

Module 3 Getting Data from Multiple Tables

  • Inner and Outer Joins
  • Table Aliasing
  • Self Joins

Module 4 Using Criteria in SQL Statements

  • Avoiding Ambiguous Situations
  • Using a Single Criterion to Limit Records
  • And/Or Situations in Criteria
  • Criteria Keywords
  • Using Comparison Criteria
  • Using Wildcards

Module 5 Generating Totals Using SQL

  • Aggregate Keywords
  • The Group By Clause
  • Using Criteria in Aggregate-Based Queries

Module 6 Generating Calculated Fields using SQL

  • Math Calculations
  • Using SQL Keywords to Enhance the Display of Data
  • Date Calculations
  • Text Calculations

Module 7 Unions, Subqueries and More Joins

  • Using where clause as an inner join
  • Using unions
  • Using Subqueries

Module 8 Action Queries

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

Module 9 Working with Views

  • Creating a View to Simplify Data Retrieval
  • Altering a View
  • Creating a View to Restrict Accessible Data
  • Inserting Data Through a View
  • Deleting Views

Module 10 Using SQL to Structure Databases

  • Understanding Data Types
  • Creating Tables
  • Altering Tables
  • Deleting Tables

Module 11 Indexing

  • Creating a single column index
  • Creating a multiple-column index

Module 12 Conditional Queries

  • Using an IF statement
  • Using a Case statement

Before you attend

Students should have at least a basic knowledge of relational databases and how they are designed.

How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.

Request a quote

Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.

Class SQL Fundamentals of Querying

No obligation, and we don't add you to a mailing list.