Advanced Data Analytics with SQL: Working with Big Data

Big Data Analytics (6 weeks)

SQL (Structured Query Language):

·       Concepts and basics of SQL

·       Data Types, Languages that guides SQL Hint .on Database design

·       Data Importation and Modification of data types.

·       SELECT statements (WHERE Clause, ORDER BY & TOP/Limit)

·       Operators (=, >, <, >=, <=, !=), Conditions ( OR & AND)

·       Data Cleaning & Data Manipulation using UPDATE & ALTER

·       Data Enrichment using CASE Statements

·       Aggregations (COUNT, MIN, MAX, SUM, AVG)

·       Aggregations using GROUP BY and HAVING Clause

·       SUBQUERY

·       STRINGS FUNCTIONS (LEFT, RIGHT, CONCAT, SUBSTRINGS)

·       DATE FUNCTIONS (WEEKDAY, MONTH, YEAR, DATENAME, DATEDIFF, GETDATE)

·       JOINS (LEFT JOIN, RIGHT JOIN, INNER JOIN, FULL JOIN)

·       Data Modelling & Relationships Concepts (PK, FK& Unique key)

·       Common Table Expressions (CTE) and Partitions

·       Introduction to Azure Data Studio