# SQL Server Bootcamp (Self-Paced)

Canonical URL: <https://www.nobledesktop.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 and MySQL, 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.
- Learn to filter, group, and sort data to extract the specific information you need.
- Practice advanced techniques like subqueries, string functions, and IF-Else logic with CASE.
- Use views and functions with parameters instead of directly querying tables.

## Curriculum
1. **SQL Level I (Self-Paced)**
2. **SQL Level III (Self-Paced)**
3. **SQL Level III (Self-Paced)**

## FAQ

### How is this class structured?

In this self-paced course, you’ll master the fundamentals of SQL at your own pace. You’ll learn to explore data using SQL Server Management Studio, write SQL queries, combine data from multiple tables, and more. The course includes lectures that explain key concepts, coding demonstrations to guide you in writing SQL, and challenges to help you apply what you've learned by writing your own queries.

### What flavor of SQL will I learn in this class?

In this training, you'll learn Microsoft SQL Server, but the core concepts apply to other SQL variations like PostgreSQL, Microsoft Access, and MySQL, with only minor syntax differences.

Which version of SQL should you learn? Ideally, you should learn the version used by the company you'll be working with. If you're unsure, here's a quick guide:

- SQL Server runs only on Windows (not Mac) and is commonly used by businesses.
- PostgreSQL works on both Mac and Windows and is popular in data science and analytics, used by companies like Apple, Instagram, Uber, and Netflix.

Ultimately, the concepts you learn here are transferable to other SQL flavors, so choose based on whether you're using a Mac or Windows.

## Pricing

**Tuition:** $975