.png)
6 weeks Live Bootcamp: SQL for Analytics and Reporting
in Data analyticsWhat 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
This live-instructor-led Bootcamp is designed to provide you with a strong foundation in SQL and to query Microsoft SQL Server Database using T-SQL. Starting from the basics, you will learn how to install SQL Server Management Studio (SSMS) and Azure Data Studio, and gain an understanding of SQL constraints, creating databases and tables, and data manipulation language.
You will delve into the intricacies of SQL statements, such as the SELECT, INSERT, UPDATE, and DELETE statements, and gain proficiency in working with WHERE operators, NULLS, and aggregate functions. Additionally, you will explore the concepts of grouping and filtering data, and the importance of case statements in SQL.
As you progress through the course, you will acquire valuable knowledge of SQL Joins, including INNER JOIN, LEFT JOIN, FULL JOIN, and CROSS JOIN. You will also master subqueries and gain an understanding of the order of execution in SQL. Finally, you will learn about SQL functions and views, rounding out your proficiency in SQL and database fundamentals.
By the end of this course, you will be equipped with the knowledge and skills necessary to confidently work with databases and SQL.
Requirements
Basic knowledge of Excel and any spreadsheet is required.
FAQ
Comments (0)
Watch this video and learn how to download and install Microsoft Server Server and SSMS.
Installing SSMS and Azure Data Studio
SQL constraints
Creating Databases and Tables
SQL SELECT Statement
The INSERT statement
The UPDATE statement
The DELETE Statement
SELECT
SELECT statement with Expressions
SELECT Top N
Aliases
SELELCT with WHERE
WHERE operators
Working with NULLS
Apply your skills in creating and modifying database objects such as tables, columns and records.
Introduction to Aggregate functions
SUM
AVG
MIN
MAX
GROUP BY with one column
GROUP BY with multiple columns
HAVING CLAUSE
Apply your skills to summarize and aggregate large dataset.
HAVING CLAUSE
WHERE CLAUSE
ORDER BY
Case Statement
Joins
Apply your skills to help International breweries company
.png){kind=small}
.png){kind=small}
