SQL Basics



Course Length: 3 Days

Learning Objectives:
By the end of this training, you’ll be able to:
  • Write SQL SELECT statements, including all allowable WHERE expressions, sorting, functions joins and subqueries.
  • Write INSERT, UPDATE and DELETE statements.
Target Student:
This course is designed for application developers who work in any relational database environment, including Oracle, Sybase, SQL Server, Access, DB2, Ingres, Informix and many others.

Prerequisites :
The student should have experience using the editor in which the class is taught, which can be TSO/ISPF in an IBM mainframe environment, any version of Microsoft Windows or other editor and have experience with any programming or query language.

Course Outline:
Section 1: SQL Overview
  • Relational database concepts, specific products
  • SQL syntax rules
  • Data definition, data manipulation, and data control statements
  • Getting acquainted with the course database and editor
Section 2: SQL SELECT Statements
  • Clauses
  • The SELECT clause: columns and aliases, WHERE expressions, order by expressions how null values behave
Section 3: SQL Functions and Expressions
  • Eliminating duplicates with DISTINCT arithmetic expressions
  • Replacing null values
  • Literals, concatenation, other string functions
  • Numeric operations, including rounding
  • Date and time functions
  • Nested table expressions
  • Case logic
  • Other expressions in specific dbms products
Section 4: SQL Updating
  • The INSERT, UPDATE and DELETE statements
  • Column constraints and defaults
  • Referential integrity constraints
Section 5: SQL Joins
  • Inner joins with original and SQL 92 syntax
  • Table aliases
  • Left, right and full outer joins
  • Self-joins
Section 6: SQL Subqueries and Unions
  • Intersection with IN and EXISTS
  • Subqueries
  • Difference with NOT IN and NOT EXISTS subqueries
  • The purpose and usage of UNION and UNIONALL
Section 7: SQL Summarization
  • The column functions MIN, MAX, AVG, SUM and COUNT
  • The GROUP BY and HAVING clauses
  • Grouping in a combination with joining

This Course Comes With

PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices


Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you


Delivered by Our Trusted Partner Protech
Basics
Date(s) Price Qty
August 29-31, 2022 10am to 5pm EST $2,160.00 (CAD)*  
January 9-11, 2023 10am to 5pm EST $2,160.00 (CAD)*  
May 1-3, 2023 10am to 5pm EST $2,160.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here