6 weeks Live Bootcamp: SQL for Analytics and Reportingin Data analytics
What you will learn?
Apply SQL constraints to ensure data integrity.
Create and manage databases and tables using SQL.
Write and execute SQL statements such as SELECT, INSERT, UPDATE, and DELETE to manipulate data in a database.
Utilize WHERE operators to filter and sort data, and work with NULL values.
Compute aggregate functions such as SUM, AVG, MIN, and MAX to analyze data.
Group and filter data using GROUP BY and HAVING clauses.
Implement case statements to perform conditional operations in SQL.
Understand SQL joins, including INNER JOIN, LEFT JOIN, FULL JOIN, and CROSS JOIN, and apply them to combine data from multiple tables.
Employ SQL functions and views to organize and manipulate data more efficiently.
About this course
Basic knowledge of Excel and any spreadsheet is required.
Watch this video and learn how to download and install Microsoft Server Server and SSMS.
Installing SSMS and Azure Data Studio
Creating Databases and Tables
SQL SELECT Statement
The INSERT statement
The UPDATE statement
The DELETE Statement
SELECT statement with Expressions
SELECT Top N
SELELCT with WHERE
Working with NULLS
Apply your skills in creating and modifying database objects such as tables, columns and records.
Introduction to Aggregate functions
GROUP BY with one column
GROUP BY with multiple columns
Apply your skills to summarize and aggregate large dataset.
Apply your skills to help International breweries company