Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | VTT | Size: 5.04 GB | Duration: 6 section | 52 lectures | (8h 35m)
What you'll learn
Core SQL - the SQL interface, navigation, importing data for analysis
Core SQL - retrieving, filtering, and aggregating data using the SELECT, FROM, WHERE, IN, LIKE, GROUP BY, HAVING statements
Core SQL - the INTO statement for creating new tables and using the CASE statement to compute new columns based on conditions
Core SQL - joining tables together using various JOIN statements to enrich data analysis
Intermediate SQL - dealing with NULLs, converting data types, and data cleansing using the ISNULL, COALESCE, CAST, CONVERT, and REPLACE statements
Intermediate SQL - using window functions such as ROW_NUMBER, RANK, PARTITION, and learning running totals to increase the functionality of datasets
Intermediate SQL - understanding the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures
Power BI - understand the importance, concepts and power of data visualisation
Power BI - learning how to directly import data from SQL and relate tables in the back-end of Power BI
Power BI - creating meaningful dashboards using Power BI visualisation objects for in-depth data insights
The skills to analyse different types of data sets!
Quizzes to test your knowledge as you progress through the course
None - we will walk you through from an absolute beginner level! No prior knowledge of SQL or PowerBI required
An inquisitive mind and motivation to learn about data!
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?
"Excellent course, principles are explained clearly and then demonstrated..." - Mike Pease
"The trainer was very comprehensive" - Lyra Aitolya
"I just saw the course once in SQL section, then practiced it. Just follow his directions and you will learn the concepts very clearly" - Shital Parikh
"Useful Power BI lessons - Helped me make my dashboards. Enjoying SQL sessions as well" - Dan Pearson
"They really take you from a beginner to advanced. I am now able to freely use SQL to analyze data and Power BI to visualize it" - Naufil Arshad
"The course structure is amazing, the guide is very clear and to the point" - Shuheb Khan
"Yes it is a good learning for me and I can relate to it in the work that I do" - Sheldon Pais
Join this course and start gaining the key data analytic skills you've always wanted in your tool-belt!
This course will walk you through fundamental data concepts, with practical exercises, in order to build you from an absolute beginner to a skilled user, in both analysis and visualisation, working through the examples together to give you live practice.
Upon enrolling, you'll gain instant, lifetime access to all sections of the course for Microsoft SQL Server and Power BI, as well as the data files and scripts necessary for the exercises.
Our approach is a stepped approach, meaning that you will keep gaining more and more building blocks as you work through the lectures. This means you will be equipped with the necessary knowledge to conduct data analytics and visualise your data to a professional standard.
You'll get access to all sections of the course that will teach you the fundamentals from the ground up, supported with over 8 hours of clear, structured content to start your data journey.
The course starts with