SQL: Data Analytics Applications in the Real World

Applying SQL / Data Analytics to real world scenarios, to see how it is leveraged by companies

Created by: Data Civilisation
Technology-based analytics company

What Will I 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!

Requirements

• Either completed the ‘SQL & Power BI: Your Data Analytics & Visualisation Journey’ course, or have previous experience and knowledge using Microsoft SQL Server
• It is essential to know how to carry out the following operations in SQL: ‘WHERE’ clause filtering, aggregations, joins, categorisation by using ‘CASE’, stored procedures, converting data types and window functions.
• No need to even have SQL Server downloaded in advance, as we'll show you how to get it installed for free!
• Note that SSMS (SQL Server Management Studio) cannot be installed on Mac OS. To install it on your Mac, the "Parallels Desktop" software is required, or the dual-boot to Windows method
• Why not check the reviews & curriculum to see what's in it for you?

Target audience

• Experienced SQL users, looking to develop and apply new data analysis skills on real world scenarios