SQL Queries 101: A Beginner’s Guide to Data Retrieval

Building a Strong Foundation in SQL Query Writing

If you are a student or working professional, join me in this engaging beginner course on SQL Queries. This course will teach you how to write SQL Queries for effortless data retrieval with a minimal learning curve.

What you’ll learn

  • Use of Scalar functions to manipulate or compute values for individual rows of a result set.
  • Use of Aggregation Functions allowing you to summarize and compute statistics on data, providing valuable insights into trends and patterns..
  • Joins to combine data from multiple tables, enabling to perform more complex queries and gain insights from related datasets..
  • Subqueries as a means of filtering data based on the results of another query or performing calculations.

Course Content

  • Introduction –> 5 lectures • 15min.
  • Setup without SQL Server –> 1 lecture • 3min.
  • The SELECT Statement –> 6 lectures • 15min.
  • Scalar Functions –> 5 lectures • 11min.
  • Aggregate Functions and Grouping –> 3 lectures • 9min.
  • Date and Time Functions –> 3 lectures • 4min.
  • Operators –> 6 lectures • 14min.
  • GROUPING –> 3 lectures • 7min.
  • Table Relationships –> 8 lectures • 34min.
  • SubQuery –> 3 lectures • 9min.
  • CASE SWITCH –> 2 lectures • 5min.
  • SQL View –> 2 lectures • 4min.
  • Create and Drop Table –> 2 lectures • 7min.
  • Insert and Delete Rows –> 2 lectures • 4min.
  • Update Rows –> 2 lectures • 2min.
  • SQL Queries with Power BI –> 1 lecture • 4min.

Auto Draft

Requirements

If you are a student or working professional, join me in this engaging beginner course on SQL Queries. This course will teach you how to write SQL Queries for effortless data retrieval with a minimal learning curve.

As of October 2023, I have provided in-person training to over 3,000 professionals, covering skills such as office productivity, programming, databases, analytics, and cloud computing, which enables rapid integration of newfound skill sets.

 

Course Curriculum

  • Basic SELECT Statement
  • Scalar Functions
  • Aggregates
  • GROUP BY and HAVING Clause
  • Comparison and Logical Operators
  • Table Relationships with JOINS
  • Sub Queries
  • Case Switch
  • SQL Views
  • CREATE Table
  • INSERT, UPDATE and DELETE Rows

What this course contains

  • 11 Sections with Easy-to-follow instructional videos
  • 2 Quizzes

Software and Credentials Required

  • You can install SQL Server Basic along with SQL Server Management Studio.
  • Alternatively, if you cannot install SQL Server, you may utilize the website SQLiteonline to execute the SQL queries relevant to this course.

Intended Course Outcome

  • Data Retrieval: Mastering SQL SELECT queries allows learners to efficiently access specific data from one or multiple database tables, ensuring quick and accurate information retrieval.
  • Data Filtering: Users can employ filtering conditions in SQL SELECT queries using the WHERE clause, enabling data extraction that meets particular criteria, such as date ranges, categories, or values.
  • Data Sorting: Utilizing SQL SELECT queries, retrieved data can be sorted in ascending or descending order based on one or more columns, simplifying analysis and presentation.
  • Data Aggregation: Proficiency in SQL SELECT queries empowers users to perform calculations and use aggregate functions (e.g., SUM, AVG, COUNT) on selected data, offering valuable insights and information summaries.
  • Data Joining: By mastering SQL JOIN clauses, learners can merge data from multiple related tables, promoting extensive data analysis and reporting.