SQL Foundation for data engineer | ETL | Testing | Analytics

Focused View

Akash Sunil Pawar

1:31:18

70 View

1 - Introduction

1 - SQL introduction.mp4

01:07

2 - Relational database.mp4

01:42

2 - Working with SQL

3 - Using SELECT statement to retrieve entire Table data.mp4

01:31

4 - Using the SELECT Statement to Retrieve Columns from a Table.mp4

00:46

5 - Using Distinct to remove duplicate records.mp4

02:08

6 - Filter Records based on Single Criteria using the WHERE Clause.mp4

01:48

7 - Filtering with SQL AND Operator.mp4

02:10

8 - Filtering with SQL OR Operator.mp4

03:12

9 - Filtering with SQL NOT Operator.mp4

02:04

10 - Sort SQL Data AscendingDescending using the ORDER BY Keyword.mp4

01:55

11 - INSERT INTO Inserting Data into Every Column of a Table.mp4

02:35

12 - IS NULL Handling nulls and blanks.mp4

06:27

13 - DELETE Delete a row in table using conditions.mp4

02:21

14 - UPDATE update values in rows or columns.mp4

01:49

15 - LIMIT Top rows of a table.mp4

00:58

16 - LIMIT Select Top rows conditionally.mp4

00:41

17 - MINMAX values of a column.mp4

02:42

18 - COUNT of records.mp4

01:02

19 - COUNT DISTINCT records in the tablecolumn.mp4

02:49

20 - AVG Average of the numeric values.mp4

01:14

21 - SUM Sum of the numeric values.mp4

01:07

22 - Conditional Average.mp4

01:13

23 - Filter using LIKE operator in SQL.mp4

04:45

24 - Filtering using IN operator in SQL.mp4

02:58

25 - Filtering using BETWEEN operator in SQL.mp4

01:38

26 - Renaming a column using AS.mp4

01:08

27 - GROUPBY and SUM.mp4

01:50

28 - GROUPBY and Average.mp4

01:13

29 - GROUPBY and WHERE.mp4

02:11

30 - GROUPBY and COUNT.mp4

01:00

31 - Filtering Grouped Data with the SQL Having Clause.mp4

01:11

32 - CREATE TABLE SCHEMA.mp4

01:24

33 - INSERT values in table created.mp4

01:33

34 - DROP a table.mp4

01:24

35 - Introduction to JOINS.mp4

02:40

36 - SQL INNER JOIN.mp4

05:35

37 - SQL LEFTRIGHT JOIN.mp4

05:50

38 - SQL OUTER JOIN.mp4

04:21

39 - UNION vs UNION ALL.mp4

04:26

40 - CREATE A VIEW.mp4

01:45

41 - DELETE A VIEW.mp4

00:35

42 - Conclusion.mp4

00:30

Description

A comprehensive course to teach you how to complete SQL queries

What You'll Learn?

Manage and Interact with Datasets with SQL
Provide Data in Order to Answer Top Questions for Meetings
Write Complex SQL Queries Using Table Joins
Retrieve Proper Data from a Database Using a SQL WHERE Clause with Criteria
Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
Have a detailed knowledge and understanding of using SQL, one of the most widely used databases in the world.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Filter groups of data using the HAVING clause
Group data together using the GROUP BY clause

Who is this for?

Anyone who wants to learn how to use SQL

More details

Description
Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!
SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.
This course will teach you how to use the SQL language.
You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems with proper explainations. On completion of the course you will be able to query and extract insights from any dataset.

LEARN SQL WITH MySQL
In order to make intelligent business decisions you need the proper data. In order to get the proper data you will need to communicate with and query data within a database. This is where SQL comes into play. SQL stands for Structured Query Language. It's the language used to communicate with a database and more importantly the data needed to make intelligent decisions that will save time and money.

WHY THIS COURSE
This SQL course starts with the absolute basic building blocks necessary to communicate effectively with any database. You'll learn how to query and manage a database using MySQL. MySQL is a free open-source relational database management system (RDBMS), used by many of the world's largest organizations.
Each section of the course will focus on a key topic of working with SQL. The video lectures have been created so you can follow along as the instructor demonstrates each concept. At the end of each section you can test your understanding through a section quiz and exercise. Once you complete a section the next section will build on the topics of the previous section. This encourages your learning as you build upon the knowledge you learn as you move from one section to the next.
This course is not just a sit back and watch the instructor type on the screen kind of course. The lectures and course flow has been designed to help you engage in the topic and participate by writing your own SQL. The TRUE LEARNING happens when you apply what you're learning and try it yourself.
The course also contains downloadable resources you can use away from the course as you continue to learn SQL. The QA board found within the course offers you the opportunity to ask questions and get answers from the instructor and interact with the other students enrolled in the course.

COURSE OBJECTIVES
In this SQL course you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.
Learn Proper SQL Syntax Using the MySQL Workbench
Learn Relational Database Design Concepts
Use the SQL SELECT Statement in Order to Query Data from a Database
Use Column Alias to Give additional Context and Meaning to the Data
Learn How to Filtering Database Query Results Using the SQL Where Clause
Create Advanced Queries by Using the Proper Filter Operators
Use the SQL ORDER BY Keyword to Sort the Results of a Query
Learn How to Properly Group Data and Create Calculations for Reporting
Use the SQL HAVING Clause to Filter within Data Groups
Create a MySQL Database from Scratch
Learn How to Create Tables and Manage Records within the Tables
And Much More...

Who this course is for:
Anyone who wants to learn how to use SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Akash Pawar is a Certified Google cloud Associate engineer. He has completed Bachelor of Technology in Electronics Engineering from National Institute of Technology (NIT, Rourkela) and has years of experience as a professional data engineer and trainer for ETL operations using PySpark. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data engineering to help other people learn the power of programming, the ability to analyze data, and the skills needed to present the data in clear and beautiful visualizations. Currently he works as the Data Engineer in Fractal Analytics.

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.