SQL Level 1
via Noble Desktop
Affiliated with Course Report
Learn the fundamentals of SQL and relational databases, including SQL syntax, database tables, and writing SQL queries. This course will also cover topics such as filtering results, using joins to combine data from multiple tables, and exploring databases...
What's included with live classes
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
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 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.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
- Live tuition
- $350
- Course length
- 6 hours
All class times are Eastern (ET).
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
Live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced tuition & enrollment
Learn through recorded lessons on your own schedule.
- Tuition
- $350
- Course length
- 6 hours
- Format
- Self-paced online
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.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
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 Foreign Keys
- Creating ER (Entity Relationship) Diagrams to visualize 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
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.
View self-paced tuition & enrollmentIn 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 visualize 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