SQL For Beginners With Data Analysis Project – [UDEMY]

What you'll learn
SQL Server - Beginner to Intermediate. You will install and use SQL server management studio
Write complex queries to extract data from a database - No prior experience required
Understand relational databases and entity relationship diagrams
Do a Customer profile on Adventureworks database including Google Sheets pivot tables and dual axies charts
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. I will also go over relational databases and crow's foot entity relationship diagrams. 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 have you writing complex queries in Sql Server Management Studio and extracting the data we have found to Google Sheets to create a visual chart and pivot table to help us easily identify trends. By working on a real project and getting real practice writing queries, you can fast become an expert in Sql and have something to show potential job interviewers. 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!
Overview
Section 1: Introduction and Thank you!
Lecture 1 Introduction
Section 2: Download SQL Server Management studio and Adventureworks database
Lecture 2 Download SQL Server Management studio and Adventureworks database
Section 3: What is SQL and a Relational Database?
Lecture 3 SQL, Relational Database and Entity Relationship Diagram
Section 4: Beginner SQL
Lecture 4 Select, From, Where, And, Or
Lecture 5 Select, From, Where, And, Or - Questions and Answers
Lecture 6 Upper and Lower
Lecture 7 IN and NOT IN operators
Lecture 8 Distinct, Like and Order By
Section 5: Intermediate SQL
Lecture 9 Inner Join
Lecture 10 Left and Right Join
Lecture 11 Joins - 2 Questions and Answers
Lecture 12 Union and Union All
Section 6: Aggregate Functions
Lecture 13 Sum, Round and Group by
Lecture 14 Having and Practice Question
Lecture 15 Count
Lecture 16 Max and Min
Lecture 17 Average
Lecture 18 Questions on Aggregate Functions
Section 7: Sub Query and Common Table Expression (CTE)
Lecture 19 Sub Queries
Lecture 20 Common Table Expression (CTE)
Section 8: Case Statement and Flags
Lecture 21 Case When
Lecture 22 Flags
Section 9: Date Functions
Lecture 23 Year, Month, Day and Get Date
Lecture 24 DateDiff
Lecture 25 DateAdd
Lecture 26 Date table
Lecture 27 Cast and Convert
Lecture 28 Joining tables on more than one condition
Lecture 29 Date Functions - Questions and Answers
Section 10: String Functions
Lecture 30 Concat
Lecture 31 Substring
Section 11: Google Sheets and Pivot Tables
Lecture 32 Google Sheets - Pivot Tables
Section 12: Adventureworks Analysis Project
Lecture 33 Countries' sales by Age Group
Lecture 34 Products' sales by Age Group
Lecture 35 Sales in USA and Australia compared
Lecture 36 Products First Reorder Date
Lecture 37 Products with high stock levels
Lecture 38 Sales on Promotion
Lecture 39 Change in value between a customers' first and last purchase
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


Homepage

https://www.udemy.com/course/sql-for-beginners-with-data-analysis-project/