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.
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.