# SQL Server Bootcamp (Self-Paced)

Canonical URL: <https://www.creativelive.com/classes/sql-server-bootcamp-self-paced>

## Overview

In this self-paced SQL Server Bootcamp, you'll learn how to turn raw data into valuable insights by writing SQL queries. Starting with the basics of viewing tables, columns, and rows, you'll progress to filtering, grouping, and extracting the specific data you need. You'll also learn how to combine information from multiple tables using JOIN statements, and explore more advanced techniques like aggregate functions, subqueries, and working with parameters in functions, as well as implementing stored procedures.

This course provides hands-on practice using Microsoft SQL Server and the free SQL Server Management Studio (SSMS) app to explore databases and run queries. While focused on SQL Server, the concepts you’ll learn are transferable to other SQL variations like PostgreSQL, MySQL, and Microsoft Access, with only minor syntax differences. Combining our Level 1, 2, and 3 SQL classes into a single comprehensive bootcamp, this course is perfect for anyone looking to work with data in fields like business analysis, data science, and web development, where SQL skills are essential for making data-driven decisions.

## What you'll learn

- Explore data stored in a database (tables, columns, rows, etc.) using SQL Server Management Studio (Microsoft's free database tool)
- Write SQL queries to retrieve data from tables in a database
- Combine information from multiple tables using JOIN statements
- Filter, group, and sort data to extract the specific information you need
- Learn advanced techniques like subqueries, string functions, and IF-Else logic with CASE
- Use views and functions with parameters instead of directly querying tables

## Pricing

**Tuition:** $975