# SQL Level I (Self-Paced)

Canonical URL: <https://www.nobledesktop.com/classes/sql-level-i-self-paced>

## Overview

In this self-paced introductory SQL course, you’ll explore the fundamentals of database architecture and learn how to write SQL queries to extract and analyze data. You’ll gain hands-on experience writing SELECT statements, filtering results with WHERE, AND/OR, IN, and NOT clauses, and combining data from multiple tables using INNER JOINs.

By the end of the course, you’ll be able to write and run basic SQL queries confidently in Microsoft SQL Server using SQL Server Management Studio. The skills you develop will also transfer seamlessly to other SQL platforms with only minor syntax variations.

## What you'll learn

- Understand core database concepts, including tables, rows, columns, and different types of SQL
- Connect to databases and navigate SQL Server Management Studio using tools like Object Explorer and Query Editor
- Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
- Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
- Explore data types, comparison operators, and case sensitivity to refine queries with greater control
- Learn to join tables using INNER JOIN and understand relational database concepts through ER diagrams and table aliases

## Curriculum

### Foundations of SQL & Databases

#### SQL Fundamental Concepts

- What is SQL & why is it used?
- Flavors of SQL: SQL Server vs Postgres, etc.
- Database Tables, Rows, & Columns

#### Exploring Databases & Writing SQL Statements (with the free SQL Server Management Studio app)

- Connecting to a Database
- Object Explorer
- SQL Query Editor
- Using Code Hints
- Viewing the Results of your SQL query
- Setting Preferences (Options)

### Writing SQL Queries

#### Writing SELECT Statements

- Syntax of a SELECT statement
- Selecting all columns or specific columns from a table
- Limiting the number of results using TOP
- Ordering the results using ORDER BY
- Returning only DISTINCT records (eliminating duplicates)

#### Filtering Results

- Data Types (Strings vs Numbers)
- Comparison Operators: equal to, greater or less than, not equal to, etc.
- Filtering results using WHERE, AND, OR, IN, and NOT
- Pattern Matching: Wildcard Filters
- Case Sensitivity

### Using Joins to Combine Data from Multiple Tables

#### Understanding Table Relationships

- What are Primary vs Primary Keys
- Creating ER (Entity Relationship) Diagrams to visual what’s in a database
- Database Relations: One-to-One, One-to-Many, & Many-to-Many

#### Combining Tables with JOIN

- Inner Joins
- Column & Table Aliases

## Pricing

**Tuition:** $350