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

Focused View

Sunil Nair

2:23:02

14 View

1 - Introduction

1 - Getting Ready.mp4

00:37

2 - Install SQL Server.mp4

02:00

3 - Install SQL Server Management Studio.mp4

01:21

4 - Load Sample Database.mp4

03:14

5 - FlatFiles-SSMS.zip

5 - Load Flat Files.mp4

07:20

2 - Setup without SQL Server

6 - FlatFiles-SQLLiteOnline.zip

6 - SQLiteOnline.mp4

03:28

3 - The SELECT Statement

7 - SELECT All Columns.mp4

01:56

8 - SELECT Specific Columns.mp4

02:56

9 - SELECT Top and Bottom Rows.mp4

01:56

10 - SELECT Distinct Column Values.mp4

02:23

11 - ORDER BY Clause.mp4

04:46

12 - Query Summary.html

4 - Scalar Functions

13 - Concatenate.mp4

03:20

14 - RIGHT and LEFT.mp4

01:40

15 - LEN.mp4

01:30

16 - Format.mp4

04:24

17 - Query Summary.html

5 - Aggregate Functions and Grouping

18 - Aggregates.mp4

04:57

19 - Group By Clause.mp4

03:19

20 - Query Summary.html

6 - Date and Time Functions

21 - DATEDIFF.mp4

01:36

22 - Other Date Functions.mp4

01:59

23 - Query Summary.html

7 - Operators

24 - Comparison Operators.mp4

06:12

25 - AND or BETWEEN.mp4

02:15

26 - LIKE.mp4

02:14

27 - IN and OR.mp4

02:45

28 - Logical Operators Wrap Up.mp4

00:47

29 - Query Summary.html

8 - GROUPING

30 - HAVING Clause.mp4

02:36

31 - Partition By.mp4

03:50

32 - Query Summary.html

9 - Table Relationships

33 - Inner Join Video Chapter.mp4

10:05

34 - More with INNER JOINS.mp4

04:55

35 - LEFT and RIGHT JOIN.mp4

05:36

36 - JOIN Three Tables.mp4

04:09

37 - JOIN Four Tables.mp4

03:54

38 - FULL OUTER JOIN.mp4

02:08

39 - EXCEPT.mp4

02:26

40 - Query Summary.html

10 - SubQuery

41 - EXISTS.mp4

04:08

42 - ALL.mp4

04:47

43 - Query Summary.html

11 - CASE SWITCH

44 - CASE SWITCH.mp4

04:25

45 - Query Summary.html

12 - SQL View

46 - Create and Query a SQL View.mp4

03:45

47 - Query Summary.html

13 - Create and Drop Table

48 - Create and Drop Table.mp4

06:59

49 - Query Summary.html

14 - Insert and Delete Rows

50 - Insert and Delete Rows.mp4

04:22

51 - Query Summary.html

15 - Update Rows

52 - Update Statement.mp4

02:01

53 - Query Summary.html

16 - SQL Queries with Power BI

54 - SQL Queries and Power BI.mp4

04:01

Description

Building a Strong Foundation in SQL Query Writing

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

Who is this for?

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

What You Need to Know?

A basic understanding of mathematical concepts like arithmetic, comparisons, and logical operations can be beneficial when constructing SQL queries involving calculations or conditional statements.

More details

Description
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.
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Sunil Nair is an Edupreneur based in Dubai. With a will to educate, Sunil Nair moved from his 13-year career as an IT Professional to a full-time Educator. Since 2017, he has been mentoring both Children and Professionals alike with a focus on achieving rapid implementation of skills.For Professionals, he has developed and delivered high-in-demand IT courses in Programming, Office Applications, Databases, Analytics, Cloud Computing and New Technologies. Sunil's interactive style of teaching Professionals using custom-built Web Apps has helped working professionals implement new skills with ease.As of Feb 2023, Sunil Nair has designed content for 20+ courses and delivered over 700+ Training hours (ILT & VILT'S) to professionals across 50+ institutions primarily the Government sector, Banking, Insurance, Real Estate, FMCG & Media.For children, he has developed courses in Programming covering Web Design, Python, JavaScript and Web App Development. He revels as a mentor and helps children achieve their aspirations of joining top universities for Computer Science.Vinith Ramaswamy, Dubai International Academy, Dubai, UAE"I have heard back from 4 universities so far and have gotten accepted to all of them: Purdue, UIUC, Wisconsin-madison, and WPI, everything you taught me was definitely a huge part in it so thank you so much"Prateeti Saran, Dubai International Academy, Dubai, UAE"I just recently got into Columbia University for Computer Science and wanted to thank you for being the one who helped me get interested in and get started with CS. Your teaching was amazing, and really really developed my passion for CS, thank you so so much!"Josh Killa, Dubai College, Dubai"My top choices for receiving offers were from Imperial College London and Warwick university to study computer science. Thanks, Sunil your teaching has had a massive impact"When Sunil is not busy Educating, his keen interest is in practising classical hatha yoga or simply reading a book.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.