SQL: Data Analytics Applications in the Real World
Applying SQL / Data Analytics to real world scenarios, to see how it is leveraged by companies
4.43 (67 reviews)
402
students
8.5 hours
content
Jan 2021
last update
$69.99
regular price
What you will learn
Understanding the importance schemas and how they can be utilised when managing table relationships
Using statements such as ‘CREATE’, ‘ALTER’ and ‘INSERT’ to manipulate tables
Creating tables by defining column properties
Inserting data into tables
Defining primary and foreign keys to highlight the relationship and ensure tables have a strong structural integrity
Understanding the factors associated to primary and foreign keys and how to manipulate them to ensure they satisfy the requirements of the table schema
Defining column constraints by using ‘NOT NULL’ and ‘UNIQUE’
Creating virtual tables by utilising 'VIEWS' and understand the benefits which they hold
Defining relationships of multiple tables and how to optimise the data analysis carried out
Understanding and applying complex joins which consist of more than two tables
Altering tables to ensure that they complement the table schema
Going through four unique case studies along with a bonus case study to enhance the understanding of how to utilise data analytic techniques in the real world
Quizzes to test your knowledge as you progress through the course!
Screenshots
Related Topics
2587818
udemy ID
10/2/2019
course created date
2/8/2020
course indexed date
Bot
course submited by