Introduction to Data Extraction Using SQL - Udemy

This introductory beginners course will help you master the basics  of using SQL  to query and retrieve data from databases.

You will learn how to filter & sort data, customize output, & how you can query aggregated data from a database.

In this course, we will focus on ANSI(American National Standards Institute) SQL that works on

every database like Oracle, MySQL, Microsoft SQL Server,  PostgreSQL etc.

SQL has become a requirement for most database related  jobs that include:

Database Administrator -DBA , Data analyst, BI (Business Intelligence) developer, programmer, database programmer.

SQL will let you communicate with the database and work with your data.

What You will learn include:

• Writing SQL SELECT Statements

• Eliminating duplicate rows using DISTINCT

• Restricting and Sorting Data

• WHERE clause, wildcard like IN, LIKE

• Analysing data using various SQL Operators

• Sorting data  using ORDER BY clause

• Using LIMIT Operator

• Querying   Aggregated Data Using the Group Functions

• AVG, COUNT, MIN, MAX...

• Using GROUP BY and HAVING Clauses

• Displaying Data From Multiple Tables

• Analysing data Using Subqueries

• Filtering data