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.