SQL Queries 101- A Beginner Guide to Data Retrieval

SQL Queries 101: A Beginners Guide to Data Retrieval, available at $19.99, has an average rating of 5, with 54 lectures, 2 quizzes, based on 1 reviews, and has 96 subscribers.

You will learn about 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 This course is ideal for individuals who are Data and Business Analysts or Software Developers or Data Scientists or Quality Assurance/Testers or IT Professionals or Entrepreneurs and Small Business Owners or Students and Aspiring Data Professionals or Anyone interested in Data It is particularly useful for Data and Business Analysts or Software Developers or Data Scientists or Quality Assurance/Testers or IT Professionals or Entrepreneurs and Small Business Owners or Students and Aspiring Data Professionals or Anyone interested in Data.

Enroll now: SQL Queries 101: A Beginners Guide to Data Retrieval

Summary

Title: SQL Queries 101: A Beginners Guide to Data Retrieval

Price: $19.99

Average Rating: 5

Number of Lectures: 54

Number of Quizzes: 2

Number of Published Lectures: 54

Number of Published Quizzes: 2

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 56

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Data and Business Analysts

Software Developers

Data Scientists

Quality Assurance/Testers

IT Professionals

Entrepreneurs and Small Business Owners

Students and Aspiring Data Professionals

Anyone interested in Data

Target Audiences

Data and Business Analysts

Software Developers

Data Scientists

Quality Assurance/Testers

IT Professionals

Entrepreneurs and Small Business Owners

Students and Aspiring Data Professionals

Anyone interested in Data

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

2Quizzes

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Getting Ready

Lecture 2: Install SQL Server

Lecture 3: Install SQL Server Management Studio

Lecture 4: Load Sample Database

Lecture 5: Load Flat Files

Chapter 2: Setup without SQL Server

Lecture 1: SQLiteOnline

Chapter 3: The SELECT Statement

Lecture 1: SELECT All Columns

Lecture 2: SELECT Specific Columns

Lecture 3: SELECT Top and Bottom Rows

Lecture 4: SELECT Distinct Column Values

Lecture 5: ORDER BY Clause

Lecture 6: Query Summary

Chapter 4: Scalar Functions

Lecture 1: Concatenate

Lecture 2: RIGHT and LEFT

Lecture 3: LEN

Lecture 4: Format

Lecture 5: Query Summary

Chapter 5: Aggregate Functions and Grouping

Lecture 1: Aggregates

Lecture 2: Group By Clause

Lecture 3: Query Summary

Chapter 6: Date and Time Functions

Lecture 1: DATEDIFF

Lecture 2: Other Date Functions

Lecture 3: Query Summary

Chapter 7: Operators

Lecture 1: Comparison Operators

Lecture 2: AND or BETWEEN

Lecture 3: LIKE

Lecture 4: IN and OR

Lecture 5: Logical Operators – Wrap Up

Lecture 6: Query Summary

Chapter 8: GROUPING

Lecture 1: HAVING Clause

Lecture 2: Partition By

Lecture 3: Query Summary

Chapter 9: Table Relationships

Lecture 1: Inner Join – Video Chapter

Lecture 2: More with INNER JOINS

Lecture 3: LEFT and RIGHT JOIN

Lecture 4: JOIN Three Tables

Lecture 5: JOIN Four Tables

Lecture 6: FULL OUTER JOIN

Lecture 7: EXCEPT

Lecture 8: Query Summary

Chapter 10: SubQuery

Lecture 1: EXISTS

Lecture 2: ALL

Lecture 3: Query Summary

Chapter 11: CASE SWITCH

Lecture 1: CASE SWITCH

Lecture 2: Query Summary

Chapter 12: SQL View

Lecture 1: Create and Query a SQL View

Lecture 2: Query Summary

Chapter 13: Create and Drop Table

Lecture 1: Create and Drop Table

Lecture 2: Query Summary

Chapter 14: Insert and Delete Rows

Lecture 1: Insert and Delete Rows

Lecture 2: Query Summary

Chapter 15: Update Rows

Lecture 1: Update Statement

Lecture 2: Query Summary

Chapter 16: SQL Queries with Power BI

Lecture 1: SQL Queries and Power BI

Instructors

Sunil Nair (MCT)
Educator | Microsoft Certified Trainer | BI Consultant

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!