Descriptions
SQL Data Analytics with Tableau Data Visualisation, SQL Data Analytics with Tableau Data Visualisation is a comprehensive course designed to take you from beginner to advanced in SQL and data visualization. You will learn to write all types of SQL queries, from simple to complex, and extract data from any relational database including Oracle, PostgreSQL, MySQL, and more. The course covers SQL Server Management Studio, DDL, DCL, TCL, table joins, primary and foreign key constraints, aggregation functions, window functions, triggers, stored procedures, indexes, CTEs, user-defined functions, cross joins, and set theory. You will also learn to visualize data using Tableau, build dashboards, and showcase your projects to employers. Each lecture is followed by practical exercises and quizzes to reinforce your learning, and you will gain hands-on experience with real-world scenarios and business intelligence solutions.
What you’ll learn
- Become highly competent in writing all types of SQL (simple to complex) preparing you for your BI Projects
- With SQL skills learned here you can extract data from any Relational Database including Oracle,PostgreSQL,MySQL and many more
- How to visualise the data using Tableau the most popular data visualisation & business intelligence tool out there
- Write DDL, DCL, TCL code so you can create and manage your own database(s) from scratch
- Be proficient in using SQL Server Management Studio to develop your data analysis solutions
- Work with scenarios that prepare you for the questions that users will ask of their data, including gnarly & complex questions
- Code table Joins from simple to complex so you will never be stuck in this again, a common stumbling block for SQL coders
- Learn to create Primary and Foreign key constraints for data integrity
- Learn the aggregation functions in SQL preparing data for visualisation
- Write powerful Window functions such as LAG()
- Every lecture is followed with an exercise for you to practice what you have learned in the previous lecture
- Quizzes at the end of each section to test your knowledge
- Data Visualisation via Tableau (Public) worksheets to incorporate into dashboards
- Showcase a project dashboard based on your ideas and show this to anyone including prospective employers
- Did I mention Triggers and Stored procedures ? Yes learn these too!
- Understand the difference between old style dated SQL and ANSI SQL best practice
- Learn how to make queries work better with Indexes for query performance enhancement
- What are Common Table Expressions (CTE) find out how to code these and exploit them.
- User defined functions and Table functions are very useful, you will learn to create and use these as well
- Learn to code Cross Joins and how to leverage these in analysis
- Learn about the SQL Server Architecture and SET Theory
- How to Insert , Update and Delete data
- Learning SQL also means you are becoming proficient in T-SQL
- Data wrangling like you would do in the corporate environment
- And many more topics
Who this course is for
- Anyone looking to learn SQL from scratch to becoming highly competent
- Anyone looking to refresh or enhance existing skills
Specificatoin of SQL Data Analytics with Tableau Data Visualisation
- Publisher : Udemy
- Teacher : Paul Scotchford
- Language : English
- Level : All Levels
- Number of Course : 313
- Duration : 1 hours and 32 minutes
Content of SQL Data Analytics with Tableau Data Visualisation
Requirements
- No prior experience is required as we will start with the basics.
- Some resources maybe located on Dropbox or GitHub due to file size constraints
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : English
Quality: 720
Download Links
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
File size
5.53 GB
