SQL Foundation for data engineer - ETL - Testing - Analytics

SQL Foundation for data engineer | ETL | Testing | Analytics, available at $19.99, has an average rating of 4.2, with 42 lectures, based on 75 reviews, and has 3330 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to learn how to use SQL It is particularly useful for Anyone who wants to learn how to use SQL.

Enroll now: SQL Foundation for data engineer | ETL | Testing | Analytics

Summary

Title: SQL Foundation for data engineer | ETL | Testing | Analytics

Price: $19.99

Average Rating: 4.2

Number of Lectures: 42

Number of Published Lectures: 42

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: ?1,199

Quality Status: approved

Status: Live

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

Anyone who wants to learn how to use SQL

Target Audiences

Anyone who wants to learn how to use SQL

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: SQL introduction

Lecture 2: Relational database

Chapter 2: Working with SQL

Lecture 1: Using SELECT statement to retrieve entire Table data

Lecture 2: Using the SELECT Statement to Retrieve Columns from a Table

Lecture 3: Using Distinct to remove duplicate records

Lecture 4: Filter Records based on Single Criteria using the WHERE Clause

Lecture 5: Filtering with SQL AND Operator

Lecture 6: Filtering with SQL OR Operator

Lecture 7: Filtering with SQL NOT Operator

Lecture 8: Sort SQL Data Ascending/Descending using the ORDER BY Keyword

Lecture 9: INSERT INTO: Inserting Data into Every Column of a Table

Lecture 10: IS NULL: Handling nulls and blanks

Lecture 11: DELETE: Delete a row in table using conditions

Lecture 12: UPDATE: update values in rows or columns

Lecture 13: LIMIT: Top rows of a table

Lecture 14: LIMIT: Select Top rows conditionally

Lecture 15: MIN/MAX values of a column

Lecture 16: COUNT of records

Lecture 17: COUNT DISTINCT records in the table/column

Lecture 18: AVG(): Average of the numeric values

Lecture 19: SUM(): Sum of the numeric values

Lecture 20: Conditional Average

Lecture 21: Filter using LIKE operator in SQL

Lecture 22: Filtering using IN operator in SQL

Lecture 23: Filtering using BETWEEN operator in SQL

Lecture 24: Renaming a column using AS

Lecture 25: GROUPBY and SUM

Lecture 26: GROUPBY and Average

Lecture 27: GROUPBY and WHERE

Lecture 28: GROUPBY and COUNT

Lecture 29: Filtering Grouped Data with the SQL Having Clause

Lecture 30: CREATE TABLE: SCHEMA

Lecture 31: INSERT values in table created

Lecture 32: DROP a table

Lecture 33: Introduction to JOINS

Lecture 34: SQL INNER JOIN

Lecture 35: SQL LEFT/RIGHT JOIN

Lecture 36: SQL OUTER JOIN

Lecture 37: UNION vs UNION ALL

Lecture 38: CREATE A VIEW

Lecture 39: DELETE A VIEW

Lecture 40: Conclusion

Instructors

Akash Sunil Pawar
Data Engineer at Fractal Analytics

Rating Distribution

1 stars: 1 votes

2 stars: 2 votes

3 stars: 7 votes

4 stars: 18 votes

5 stars: 47 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!