SQL Foundation for data engineer | ETL | Testing | Analytics

Name: SQL Foundation for data engineer | ETL | Testing | Analytics
Rating: 4.2 (83 reviews)

A comprehensive course to teach you how to complete SQL queries

Created byAkash Sunil Pawar

Last updated 1/2023

English

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

Course content

2 sections • 42 lectures • 1h 31m total length

SQL introduction1:07
Learn the fundamentals of structured query language (sql), the standard for creating, maintaining, and retrieving relational databases, with guidelines on case usage, keywords, and comments.
Relational database1:42

Using SELECT statement to retrieve entire Table data1:31
Use the select statement to retrieve all data from a table, as demonstrated with the marks table containing student, course, and scores.
Using the SELECT Statement to Retrieve Columns from a Table0:46
Using Distinct to remove duplicate records2:08
Explore using distinct to remove duplicates, retrieve a unique set of enrolled students, and obtain distinct student–course pairs when selecting multiple columns.
Filter Records based on Single Criteria using the WHERE Clause1:48
Filtering with SQL AND Operator2:10
Filtering with SQL OR Operator3:12
Filtering with SQL NOT Operator2:04
Sort SQL Data Ascending/Descending using the ORDER BY Keyword1:55
Use the order by keyword to sort data by a column, such as score, in ascending order by default, or specify descending to arrange results from high to low.
INSERT INTO: Inserting Data into Every Column of a Table2:35
IS NULL: Handling nulls and blanks6:27
DELETE: Delete a row in table using conditions2:21
UPDATE: update values in rows or columns1:49
LIMIT: Top rows of a table0:58
LIMIT: Select Top rows conditionally0:41
Learn how to fetch the top two records by score using order by score desc and limit, enabling conditional selection of the highest scores from the marks table.
MIN/MAX values of a column2:42
Learn how to use aggregate statements with mean and max functions to obtain minimum and maximum scores from marks, replacing blanks with zero and aliasing columns.
COUNT of records1:02
Explore how the count and average functions measure rows that meet a criterion, including counting all rows versus counting distinct values, with examples using select statements.
COUNT DISTINCT records in the table/column2:49
count distinct records in a table column by contrasting total rows with unique students, using a distinct subquery with count(*) and the count(distinct student) method to reveal four unique students.
AVG(): Average of the numeric values1:14
SUM(): Sum of the numeric values1:07
Learn how the sum() function calculates the total of a numeric column using a marks example that yields 300 and see how the average becomes 50 from dividing by six.
Conditional Average1:13
Filter using LIKE operator in SQL4:45
Filtering using IN operator in SQL2:58
Learn how to use the in operator in sql to filter by multiple values, replacing long or conditions with a single in clause for numeric and string columns.
Filtering using BETWEEN operator in SQL1:38
Renaming a column using AS1:08
Renaming a column in SQL with AS by aliasing a selected column, such as student score, to a new name and viewing updated results.
GROUPBY and SUM1:50
GROUPBY and Average1:13
GROUPBY and WHERE2:11
GROUPBY and COUNT1:00
Filtering Grouped Data with the SQL Having Clause1:11
Learn how to filter grouped data using the SQL having clause, since where can't be used with group by; apply having to filter aggregates like average scores.
CREATE TABLE: SCHEMA1:24
INSERT values in table created1:33
DROP a table1:24
Drop a table using the drop command, verify removal by attempting to select from the table, and observe the no such table error when the table no longer exists.
Introduction to JOINS2:40
SQL INNER JOIN5:35
SQL LEFT/RIGHT JOIN5:50
SQL OUTER JOIN4:21
UNION vs UNION ALL4:26
Learn how the union operator combines result sets from multiple selects with matching column counts, data types, and order. Compare union and union all to see how duplicates are handled.
CREATE A VIEW1:45
DELETE A VIEW0:35
Learn how to delete a view in sql, mirroring how to delete a table, with a simple example of naming the view and executing the deletion.
Conclusion0:30

Requirements

A PC (Windows or Linux) or Mac is required
No prior knowledge of Databases, SQL is needed.

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

SQL Foundation for data engineer | ETL | Testing | Analytics

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

Working with SQL40 lectures • 1hr 28min

Requirements

Description

Who this course is for: