A Deep Dive into SQL Server for Data Analytics
COURSE REVIEWS
"It's not just a course it's a one type of hands on real time project. Mentor explained every topic with a pupose why we are doing these ? In every requirement of client we follows a same process which is expleined in data analyst life cycle." Prasad
"Personally, It was a great experience to learn as well as code side by side, and hoping to see more such courses from Paul. Thanks" Asditya
"The course is detailed and well-explained." Miroslav
"Paul is an excellent teacher and, in this course, provides a great balance between theory and coding. He talks us through the background fundamentals of databases and key terms and concepts then walks us through the terms and keywords we need to use to pull data from a real-world database environment. Excellent value and learning all the essentials!" Juttiga
SQL Data Analytics with Tableau Data Visualisation
Learn advanced T-SQL, DDL, DML, SQL Server Architecture and more!
๐ Course Highlights: What Youโll Learn๏ปฟ
๐ง Core SQL Development Skills ๐ ๏ธ Become highly competent in writing all types of SQL (simple to complex) ๐ Write powerful Window Functions such as LAG() ๐งฎ Learn aggregation functions for data summarization ๐ Code table Joins from simple to complex ๐ Learn to create Primary and Foreign Key constraints ๐งฉ Learn to code Cross Joins and leverage them in analysis ๐ท๏ธ Understand and apply DDL, DCL, TCL statements ๐ Learn to Insert, Update, and Delete data (DML) ๐งฑ Database Architecture & Design ๐๏ธ Create and manage your own databases from scratch ๐ง Understand SQL Server Architecture and Set Theory ๐งฌ Understand the difference between old-style SQL and ANSI SQL best practices โ๏ธ Learn about User Defined Functions and Table Functions ๐งต What are Common Table Expressions (CTE)? Learn how to code and use them ๐ฏ Use Indexes to improve query performance ๐ป SQL Server Management & Tools ๐ฅ๏ธ Be proficient in using SQL Server Management Studio (SSMS) for analysis ๐งช Work with realistic business scenarios and solve complex questions ๐ Data Visualization with Tableau ๐ Learn to visualise the data using Tableau Public ๐งพ Use downloadable worksheets to create dashboards ๐งโ๐ผ Showcase a project dashboard you can share with prospective employers ๐งฉ Learning Support Features ๐ Every lecture is followed by exercises to apply what youโve learned โ Quizzes at the end of each section to test your knowledge ๐ข Business Intelligence Readiness ๐๏ธ Use SQL to extract data from any relational database (SQL Server, Oracle, PostgreSQL, MySQL, etc.) ๐งน Learn data wrangling skills used in real corporate environments ๐ Start building solutions immediately after course completion๏ปฟ
๏ปฟ
๐ง Core SQL Development Skills ๐ ๏ธ Become highly competent in writing all types of SQL (simple to complex) ๐ Write powerful Window Functions such as LAG() ๐งฎ Learn aggregation functions for data summarization ๐ Code table Joins from simple to complex ๐ Learn to create Primary and Foreign Key constraints ๐งฉ Learn to code Cross Joins and leverage them in analysis ๐ท๏ธ Understand and apply DDL, DCL, TCL statements ๐ Learn to Insert, Update, and Delete data (DML) ๐งฑ Database Architecture & Design ๐๏ธ Create and manage your own databases from scratch ๐ง Understand SQL Server Architecture and Set Theory ๐งฌ Understand the difference between old-style SQL and ANSI SQL best practices โ๏ธ Learn about User Defined Functions and Table Functions ๐งต What are Common Table Expressions (CTE)? Learn how to code and use them ๐ฏ Use Indexes to improve query performance ๐ป SQL Server Management & Tools ๐ฅ๏ธ Be proficient in using SQL Server Management Studio (SSMS) for analysis ๐งช Work with realistic business scenarios and solve complex questions ๐ Data Visualization with Tableau ๐ Learn to visualise the data using Tableau Public ๐งพ Use downloadable worksheets to create dashboards ๐งโ๐ผ Showcase a project dashboard you can share with prospective employers ๐งฉ Learning Support Features ๐ Every lecture is followed by exercises to apply what youโve learned โ Quizzes at the end of each section to test your knowledge ๐ข Business Intelligence Readiness ๐๏ธ Use SQL to extract data from any relational database (SQL Server, Oracle, PostgreSQL, MySQL, etc.) ๐งน Learn data wrangling skills used in real corporate environments ๐ Start building solutions immediately after course completion๏ปฟ
๏ปฟ
๐บ For best viewing, select HD in the YouTube player settings.
