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:

gfxtra__SQL_for_be.part1.rar.html

gfxtra__SQL_for_be.part2.rar.html