Published 2/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.35 GB | Duration: 3h 0m
Quickly learn SQL programming language and how to use this to analyze and visualize data by working on a real project What you'll learn SQL Server - Bner 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 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: SQL Server Management studio and Adventureworks database Lecture 2 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: Bner 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 Bner 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:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.