Quickly learn basic SQL and Tableau and do a piece of data analysis using SQL Server Management Studio and Google Sheets
- Free tutorial
- Rating: 4.6 out of 54.6 (74 ratings)
- 2,918 students
- 57min of on-demand video
- Created by Graeme Gordon
- English
What you’ll learn
- Beginner SQL Server – You will install and use SQL server management studio
- Write basic queries to extract data for analysis from the Adventureworks database on SQL server management studio
- Do a quick piece of analysis on Google sheets using data we extract with a query
- Understand SELECT, FROM, WHERE and aggregate functions like SUM and COUNT by writing real queries
Requirements
- No experience required. You need a windows computer or laptop to install Sql Server Management Studio
Description
Since data analytics has become such an in demand still worldwide, there has never been a better time to learn how to work with data and become a data analyst.
I have been working with data for over 4 years and I use SQL every day in my job. I want to pass this knowledge on to you by going through each topic and working with real examples.
SQL, or Structured Query Language, is the main tool used for any data analyst and is used to execute queries and retrieve data stored in a relational database.
This course will go over basic topics used to write a SQL query used to extract data from a database for analysis including SELECT, FROM, WHERE, SUM, COUNT and more.
You can follow along by using the SQL Server Management Studio and Google Sheets and will have something to show for it at the end.
We will also create a one page dashboard on Tableau Public using the same data and publish it online.
If you like the course and want to learn more advanced topics and do much more analysis please check my other course.
No experience is required and you will be guided through every step to help you understand the process of exploratory data analysis.
Enroll now to kickstart your career in data analytics!
Who this course is for:
- Beginner data analyst who is keen to learn sql and methods used to retrieve data from a database.
- Anyone who is interested in working with data and becoming an analyst
Show less
Course content
8 sections • 17 lectures • 56m total lengthCollapse all sections
Introduction1 lecture • 1min
- Introduction01:16
Download and Install Sql Server Management Studio and Adventureworks Database1 lecture • 5min
- Download Sql Server Management studio and Adventureworks database05:02
What is SQL and Relational Databases2 lectures • 6min
- SQL, Relational Databases and Entity Relationship Diagrams02:45
- Quick SSMS overview02:45
Select, From and Where2 lectures • 9min
- Select, From and Where05:06
- Select From Where Q and A03:36
- Coding Exercise: Show all Customers from Australia1 question
Basic Aggregate functions2 lectures • 5min
- Sum, Round, Count and Group by05:06
- Any Questions?00:12
Analysis – Sales and Average sales value for December 20121 lecture • 9min
- Analysis in Sql Server and Google Sheets08:57
Tableau Dashboard7 lectures • 21min
- Introduction – What you will do in this section00:55
- Get data for dashboard01:27
- Download Tableau Public and connect to data source02:35
- Sales and Sales value dual axies chart03:19
- Build Cost and Net Profit charts03:04
- Create Sales and Net Profit cards02:40
- Put Dashboard together and Publish it06:48
Congratulations and Thank You1 lecture • 1min
- Thank you!01:01
