In our courses, we will query large data sets via Microsoft SQL Server. These courses will cover real-world Fortune 500 SQL Query Examples. This is a true beginner’s course. If you have little to no SQL experience or looking for a smooth refresher, then these courses are for you.

SQL Basics: Beginner Level

  • Overview of relational databases and data flow
  • Review Basic SQL Syntax- SELECT, FROM, and WHERE Statement
  • Database, Schema, and Tables Overview
  • Retrieve Data from a Single Table
  • Perform basic queries utilizing different SQL functions and commenting
  • Overview of different data types
  • Converting Data Types
  • Sorting data
  • Utilize conditional operators to filter data
  • Apply string and numeric functions to filter data

SQL Basics: Intermediate Level (Aggregate Functions)

  • Aggregate functions (MIN, MAX, SUM, AVERAGE, COUNT)
  • Advance SQL Commands (Group By, Having)
  • Differentiate between Having vs. Where Statement
  • Perform mathematical operations on multiple fields
  • Utilize case statements
  • Perform grand totals on mathematical queries

SQL Basics: Advanced Level

  • Retrieve Data from multiple tables and fields utilizing join and union functions
  • Query date related data with various date data types
  • After the bootcamp, homework will be assigned through Showbie and students will be assigned a Completion Certificate.

PC Laptops Required