$895.00

Understanding and Building SQL Queries

In this course, you don’t need to grasp the entire universe of SQL to master writing great queries. We’ll guide you on a journey towards understanding and confidently building queries. The course focuses on three major categories, each essential for your SQL proficiency.

We dive right into the basics of navigating a SQL database and writing fundamental query statements. You’ll gain a solid foundation in constructing queries and navigating the database effectively.

Next, we explore writing more advanced query statements that incorporate functions like case statements and handle aggregated data sets. These techniques allow you to manipulate and analyze data in powerful ways.

Lastly, we delve into the intricacies of writing queries involving multiple tables and different join types. Understanding how to bring data together from various tables is a crucial skill for extracting meaningful insights.

Join us on this course as we break down the complexities of SQL into manageable steps, empowering you to write exceptional queries and unlock the potential of your data.

What You Will Learn In This Course

Basic Statements

  • Selecting a whole table
  • Selecting only certain rows from a table
  • Creating simple queries

Views

  • Finding and using Views
  • How and Why we create Views
  • Querying views and multiple tables together

Data Manipulation

  • Performing math and text functions
  • Aggregating data
  • Using Case statements for complex logic

The Design Window

  • Accessing the query design window
  • Finding and establishing table connections using Joins
  • Creating more complex queries