Description
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
If the coupon is not opening, disable Adblock, or try another browser.