Rating 4.71 out of 5 (287 ratings in Udemy)
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 …
Rating 4.71 out of 5 (287 ratings in Udemy)
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
- Develop Tableau worksheets to incorporate into dashboards
- Create your own dashboard based on your own learning from the course
- Showcase a project dashboard based on your ideas and show this to anyone including prospective employers
- Approaching interviews and their inherent catch and scenario questions
- 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
Description
Knowledge is power , right ?
Not quite !, it's potential power, like a battery , electrical charge waiting to be used in a device.
The same applies to your knowledge!
Do you think database design, SQLKnowledge and data visualisation is important in our age of big data and analytics ?
Well it is ! in fact SQL accounts for 90% of the requirements to perform data analysis and then how do we present the data ?
100%of the time us analysts present data graphically using software for example Tableau, QlikSense, Python, R, SAS and more
Are there enough people to fill the current job market in the data analysis world ?
No, the demand is growing ! And until relational databases die off then we will always need SQLSkills !
For the most part Data Analysts can command 6 figure salaries and more if you are top of the game. My pay for 2019 was the top end of 6 figures!
Are you concerned that you have no experience in this area, yet !?
Don't be ! everyone heading into Data Analysis and Visualisation has to start somewhere !
So why buy this course as there is a lot to choose from !?
Because this course is comprehensive , in other words it is detailed enough to get started and gradually work up to the advanced concepts
Yes all courses say theirs is the best ! But I will leave it to you to look at the sections and see just how much learning material is here for you to absorb and build your knowledge.
In summary this course ...
Is very comprehensive at every level
Starts with easy topics and builds up to complex topics
Tons of practice assignments after each lecture to reinforce your knowledge and skills
Includes large sample data sets for download used during the course (and after for you to research more)
Learn to develop data visualisations with Tableau and assignments for you to participate in
Section quizzes to further test how you think you would go at interviews and job reviews
Achievement awards based on your Quiz results
In my humble opinion
This course is the most comprehensive and practical that you can buy.
It is a culmination of my real world work experience in the data analysis and visualisation world.
It will get you going with your career expectations
I have helped 85,000+ students achieve their skills requirements through my courses here on Udemy.
Here is a quote from one of my QlikView students back in March 2020 ...
I just wanted to let you know that thanks to your training, I've got a new job in Zurich as a Business Intelligence and Qlikview Developer.
I was working as BI Specialist and Data Scientist before but I was learning QlikView thanks to your course.
Are you keen to enrol ?
Well, check out the other courses first to compare to and you will see the difference , you be the judge
If you buy this course and it turns out is not for you there is the 30 day money back guarantee, a win win for you.
Looking forward to seeing you in the course.
Paul
Data Analyst and Visualisation Engineer
Paid
Self paced
All Levels
English (US)
2356
Rating 4.71 out of 5 (287 ratings in Udemy)
Go to the Course