Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions. Use functions to calculate data before it’s presented on screen. In SQL Level 1, you’ll learn everything you need to write SQL queries on your own.

If you’re committed to learning SQL, check out our three-day SQL bootcamp, which includes our beginner, intermediate and advanced classes at a 15% discount!

More on SQL Level 1

This course provides essential training in the basics of three core components:

  • Relational DBMSs: Gain a solid understanding of Relational Database Management Systems (RDBMSs) and how they are structured.
  • SQL: Begin writing SQL code, including SELECT statements. Learn to sort, filter, and produce analysis based on your data and queries.
  • Microsoft SQL Server: Launch SQL Server and learn how to use SQL within one of the most popular DBMSs used worldwide.

You will work through practical hands-on exercises, writing real SQL code and reinforcing your knowledge of database architecture along the way. At the end of this course, you’ll understand how to write SQL queries in Microsoft SQL Server and apply your skills to other DBMSs that are compatible with SQL, such as MySQL. The course includes our custom manual as well as a free retake within months. 

Continue reading angle-line

What You'll Learn

  • Fundamentals of Relational Databases
  • What is SQL and SQL Server?
  • Major clauses including SELECT and FROM
  • Sort data with ORDER BY clause
  • Filter and group data with WHERE, GROUP BY, HAVING
  • Simplify queries with aliases
  • Extract data with queries
  • Use inner joins to pull data from multiple tables
  • Summarize data with aggregate functions: SUM, AVERAGE, MIN, MAX, COUNT

Upgrade & Save - Master SQL in just 3 days with our SQL Bootcamp