Main content

SQL (Structured Query Language)

Learn how to manage data and create queries that extract and manipulate information from relational databases (RDBMS) with SQL.

SQL Level 1: Introduction

Discover how to use SQL to create queries that extract and manipulate information from relational databases. Create expressions and learn how to search, filter, and sort your data using more than 30 different SQL clauses and functions.

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

SQL Level 2: Intermediate

Using a time-efficient "problem/solution/discussion" approach, we'll cover essential SQL topics including window functions, pivoting and reverse-pivoting rows and columns, data bucketization, histograms, and advanced data-warehousing techniques.

This course expands your SQL knowledge by solidifying your base skills and teaching you: conditional selection, windowing functions, scalar and table variables, common table expressions (CTEs), and conditional sorting and filtering. The course completes the toolbox of SQL skills needed to solve any SQL query request that you may encounter in the workplace.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course students will be able to:
  • Work with SQL in a development environment
  • Describe relational database theory and data diagrams
  • Return data from multiple tables and join types
  • Join data sets with sub-queries
  • Join sets of data with set operators
  • Retrieve data about data sets using GROUP BY
  • Using Window Functions
  • Building Complex SELECT Statements
  • Table Objects and the FROM Clause
  • Table Objects and the WITH Statement
  • Building Complex WHERE Clauses
  • Complex Ordering Using ORDER BY