Course duration
- 2 days
Course Benefits
- Manage and manipulate your data using SQL.
- Understand the basics of relational databases.
- Gather data using SELECT queries and then use the WHERE clause to shape the results.
- Handle complex data retrieval tasks with ease using subqueries, joins, outer joins, and unions.
- Leverage CASE Statements to retrieve the most relevant data.
- Use INSERT, UPDATE, and DELETE to maintain your records.
- Create insightful, data-driven reports.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Learn at your own pace with 24/7 access to an On-Demand course.
Course Outline
- Relational Database Basics
- Brief History of SQL
- Relational Databases
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
- Popular Databases
- Commercial Databases
- Popular Open Source Databases
- SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
- Simple SELECTs
- Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
- SELECTing All Columns in All Rows
- Exercise: Exploring the Tables
- SELECTing Specific Columns
- Exercise: SELECTing Specific Columns
- Sorting Records
- Sorting by a Single Column
- Sorting By Multiple Columns
- Ascending and Descending Sorts
- Exercise: Sorting Results
- The WHERE Clause and Logical Operator Symbols
- Checking for Equality
- Checking for Inequality
- Exercise: Using the WHERE Clause to Check for Equality or Inequality
- Checking for Greater or Less Than
- Exercise: Using the WHERE Clause to Check for Greater or Less Than
- Checking for NULL
- Exercise: Checking for NULL
- WHERE and ORDER BY
- Exercise: Using WHERE and ORDER BY Together
- Checking Multiple Conditions with Boolean Operators
- AND
- OR
- Order of Evaluation
- Exercise: Writing SELECTs with Multiple Conditions
- The WHERE Clause and Logical Operator Keywords
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Exercise: More SELECTs with WHERE
- Advanced SELECTs
- Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
- Exercise: Calculating Fields
- Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Exercise: Working with Aggregate Functions
- Selecting Distinct Records
- Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
- Exercise: Data Manipulation Functions
- Calculated Fields
- Subqueries, Joins and Unions
- Subqueries
- Exercise: Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Exercise: Using Joins
- Outer Joins
- Unions
- UNION ALL
- UNION Rules
- Exercise: Working with Unions
- Conditional Processing with CASE
- Using CASE
- Exercise: Working with CASE
- Inserting, Updating and Deleting Records (if time allows)
- Inserting Records
- Updating and Deleting Records
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.