Introduction to Data Extraction Using SQL

Master the basics of querying databases using SQL - The World's most popular database language

What you'll learn:

• Install Database Server
• Query all data in a table
• Query data from specific table
• Query DISTINCT Data
• Query data with various types of operators
• Filter data
• Sort Data
• Query data using aggregate function
• Query data using table joins
• Query data with subqueries

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