# SQL Server Level I

Canonical URL: <https://training-nyc.com/courses/sql-level-1>

## Overview

This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will guide you through understanding the basics of database architecture and will develop your skills in writing real SQL code.

You’ll learn how to write SELECT statements to choose the specific columns you want from tables, start filtering the results using WHERE, AND/OR, IN, and NOT. You’ll learn how to use wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc. to retrieve only the data you want. Finally, you’ll combine data from multiple tables with inner JOINs.

By the end of this introductory hands-on course, you’ll be able to write basic SQL queries for Microsoft SQL Server. You’ll learn how to use the free SQL Server Management Studio app to explore the database and execute your SQL queries. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as Microsoft Access, PostgreSQL, MySQL, etc.) with minor syntax differences.

## What you'll learn

- 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

## 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

## Schedule
- Jun 10, 2026 10:00am–5:00pm — NYC
- Jul 27, 2026 10:00am–5:00pm — NYC
- Sep 22, 2026 10:00am–5:00pm — NYC
- Nov 2, 2026 10:00am–5:00pm — NYC
- Nov 2, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $350