Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Noble Desktop

SQL Server Bootcamp

via Noble Desktop

Overview

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.

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

Reviews

Start your review of SQL Server Bootcamp

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.