Main content

SQL Level 1: Introduction

This course introduces you to SQL, the standardized language used by all of the popular business database management systems including Oracle, SQL Server, Access, DB2 and My SQL. The course teaches the fundamentals of relational database theory and the SQL language. The course covers the SQL skills required for practical every day SQL coding that are in demand today.


CLICK HERE FOR REQUIRED BOOK

Upon completion of this course students will be able to:

  • Explain database and SQL fundamentals
  • Work with SQL in a development environment
  • Return data with the SELECT statement
  • Use the FROM clause to return table data
  • Filter data with the WHERE clause
  • Sort data with the ORDER BY clause
  • Describe relational database theory and data diagrams
  • Create multi table queries
  • Explain different join types and what they do
  • Join data sets with sub-queries
  • Join sets of data with set operators
  • Retrieve data about data sets using GROUP BY

Course Content

Course Outline
1. Database and SQL Fundamentals

  • Setting up the class databases
  • Fundamentals of SQL and data types
2. Working with SQL Script Files
  • Creating/Saving/Opening Script Files
  • SQL Basics, Terminologies, and Standards
3. Returning Data from a Single Table
  • Returning columns with SELECT and renaming with AS
  • Removing duplicate records with DISTINCT
  • Sorting the output with ORDER BY
4. Using SQL Expressions and Built-in Functions
  • Performing calculations and order of evaluation
  • Adding a derived column to query
5. Filtering Records with the WHERE Clause
  • Formatting criteria based on field data type
  • Using AND, OR and NOT in a WHERE clause
6. Advanced Filtering Techniques using WHERE
  • Using LIKE for matching and BETWEEN with ranges
  • Using IN and NOT IN with criteria lists
  • Filtering NULL values
7. Relational Database Theory and Terminologies
  • Create a multi-table data diagram
  • Identify primary keys, foreign keys, and relationship types
8. Writing Multi-Table JOIN Clauses
  • Planning a multi-table query and qualifying field names
  • Coding an INNER JOIN step-by-step
9. Understanding Different JOIN Types
  • INNER JOIN and matching data
  • OUTER JOIN and non-matching data
  • Explain what CROSS JOIN and SELF JOIN are
10. Summarizing Data with GROUP BY
  • Working with aggregate functions
  • Grouping with GROUP BY and filtering with HAVING
11. Using Action Queries
  • Action queries, database permissions, and best practices
  • Code a SELECT INTO to copy a data table
12. Working with Sub-Queries and Best Practices
  • Understanding sub-queries and their uses
  • Coding and debugging a sub-query