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


  • You should have access to internet
  • You should access to a computer ,Laptop or mac


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


  • Using GROUP BY and HAVING Clauses

  • Displaying Data From Multiple Tables

  • Analysing data Using Subqueries

  • Filtering data

Author(s): Bluelime Learning Solutions

Deal Score+8
Coupon Scorpion