Discover Classes. Earn Rewards.

SQL Level 1

Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.

  • Beginner
  • 18 and older
  • $350
  • Interactive Online Classroom

Start Dates (8)

  • $350
20 seats left
Book
Show all 2 sessions
  • Tue, May 14 at 6:00pm - 9:00pm
  • Thu, May 16 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Showing 15 of 8

Class Description

Description

What you'll learn in this sql class:

Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases.

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 at a Glance

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

Learn more about SQL Level 1 at Noble Desktop.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

Syllabus

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

Refund Policy

  • Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]"

Reviews of Classes at Noble Desktop (373)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Noble Desktop

Reviews of Noble Desktop at coursehorse.com

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...