Learn how to extract information from databases and turn it into actionable insights by writing SQL queries, filtering data, and joining tables. This comprehensive SQL Server Bootcamp will teach you the fundamentals of SQL and how to apply them to various database systems.
Overview
Syllabus
- SQL Level 1
- Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
- Write SQL queries to retrieve data from tables in a database
- Primary SQL clauses including SELECT and FROM
- Filtering the results using WHERE, AND/OR, IN, and NOT
- Wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc.
- Combine information from multiple tables with inner JOINs
- SQL Level 2
- Learn to use Outer Joins and find NULL data
- Group data and perform common statistical calculations using Aggregate Functions
- Filter grouped data with HAVING
- Use CAST to make a data type fit your query’s needs
- Work with dates and time
- SQL Level 3
- Use Subqueries to grab data from anywhere in a database and use that result in another query
- Query from Views instead of tables
- Add If-Else logic to queries using CASE
- Learn how to use Functions, and execute reusable Stored Procedures
- Use String Functions to get just the part of text you need
Taught by
Dan Rodney and Garfield Stinvil