SQL Level 1
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
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 specific columns from tables, filter the results using WHERE, AND/OR, IN, and NOT. You’ll also learn how to use wildcard filters and mathematical comparisons like equals, greater than, and less than, 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 in SQL Server can be applied to other flavors of SQL (such as Microsoft Access, PostgreSQL, MySQL, etc.) with minor syntax differences.
Curriculum
What you'll learn
- Understand core database concepts, including tables, rows, columns, and various types of SQL
- Connect to databases and navigate SQL Server Management Studio using tools such as 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 more control
- Learn how to join tables using INNER JOIN and understand relational database concepts with ER diagrams and table aliases
Course 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
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $350
- Course length
- 6 hours
- Schedule
- On your schedule
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.
Who the self-paced course is for
Perfect for beginners, this course provides essential skills in data analysis and database management, setting you up for success in working with SQL.
Self-paced curriculum
What you'll learn self-paced
- 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
Self-paced 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