We all know how data is growing by leaps and bounds. Data coming from application, data coming from iot devices, structured data and unstructured data. Basically data is the lifeblood of today’s corporate world. and data is company’s most valueable asset The data can be stored in data lakes and hundreds of different databases. All database speaks same language called SQL. That is why, SQL is the most in-demand and hottest skill in the tech industry for roles like DBA and Business Analyst. You can use it to analyse data and get actionable insights from data. Starting salaries for DBA are over 80K and with couple of years of experience it goes over 100K. In this course I am teaching you SQL the most in demand skill used to interact and manuplate databases.
This is very comprehensive course because. We are using Microsoft WideWorldimporters and Adventureworks Transactional and data warehouse databases to mimic real world scenarios. I am going to start from beginning and teach you SQL step by step. No prior experience is necessary and no need to buy anything as we are using all the free tools from Microsoft in this course. I am explaining each concept very slowly and clearly with tons of exercises so you can master these skills.
You will write over 3600 lines of code that you won’t find in ANY other course. You will also learn Microsoft’s Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. I am going to teach you how to find the trends, patterns and get actionable insights from that data in that course. All of the exercises are designed by keeping the practical aspects of SQL in mind. All exercises are 100% hands-on.
Please sign up today and get life time access to all the contents. This course also comes with Custom Notes, homework excercises, Checklists, Templates to help get you results faster. You will also receive your certification of completion that you can post in your resume or your linkedin account to show your newly skill to new potential employers. Check the next lecture for full overivew of this course.
#microsoft #SQL #SQL Server i #data #business #intelligence #analysis #analytics
Why should you consider a career as a Business Data Analyst?
· Salary. A Business Data Analyst is a well-paid career
· Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.
· Everyone who wants to learn how to code SQL and apply their skills in practice
· Anyone willing to step into the software development career
· Anyone dreaming to get a well-paid SQL Development Job
· Anyone who wants to get you a better job or improve the one you have
· Anyone who wants to become Business Analyst, Data Analyst and Business Intelligence Professional
· Anyone who works with data, tables, or databases
· Anyone who is working in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
Course content
Section 1: Introduction
· Introduction
· Course Overview
· Welcome to this course and how to get support ( must watch )
Section 2: SQL Server Installation
· SQL Server Installation
· Connecting to Database
· Download and install sample databases
· Check Databases
· SQL Help
Section 3: Database Basics
· Data warehouse architecture
· Databases basics
· Database Objects
· Database Schema
· Data Types and Constraints
· Database Views and Store Procedures
· How to do Exercise Challenges
Section 4: CRUD Premier
· Physical and Logical query processing order
· CRUD – What is CRUD
· Creating Databases and Tables
· CRUD-Insert Data in Tables
· CRUD-Delete Databases and Tables
· Exercise Challenge CRUD
· Exercise Solution CRUD
Section 5: SQL Server Management Premier
· How to use SSMS
· What is GO Statement and ALIAS
Section 6: Reading Data
· Repeat : Physical and Logical query processing order
· Reading Data – SELECT
· Exercise Solution SELECT
· Reading Data – DISTINCT
· Exercise Solution DISTINCT
· Reading Data – TOP
· Exercise Solution TOP
Section 7: Filtering Data
· Predicates and Operators
· Filtering Data – Where Clause
· Exercise Solution – Where Clause
· Filtering Data – Where – AND
· Exercise Solution – Where – AND
· Filtering Data – Where – OR
· Exercise Solution – Where – OR
· Filtering Data – Where – IN
· Exercise Solution – Where – IN
· Filtering Data – Where – BETWEEN
· Exercise Solution – Where – BETWEEN
· Filtering Data – Where – LIKE
· Exercise Solution – Where – LIKE
· Filtering Data – Where – NOT
· Exercise Solution – Where – NOT
Section 8: Sorting Data
· Sorting Data – ORDER BY
· Exercise Solution – ORDER BY
· Sorting Data – ORDER BY – OFFSET and FETCH
· Exercise Solution – ORDER BY – OFFSET and FETCH
Section 9: Aggregating Data
· AGGREGATE – COUNT
· Exercise Solution AGGREGATE – COUNT
· AGGREGATE – SUM
· Exercise Solution AGGREGATE – SUM
· AGGREGATE – AVG
· Exercise Solution – AGGREGATE – AVG
· AGGREGATE – MIN or MAX
· Exercise Solution – AGGREGATE – MIN or MAX
Section 10: Grouping Data
· Grouping Data – GROUP BY
· Exercise Solution – Grouping Data – GROUP BY
· Grouping Data – GROUP BY – HAVING
· Exercise Solution – Grouping Data – GROUP BY – HAVING
Section 11: Combining data with JOINS
· JOINS – INNER JOIN
· Exercise Solution – INNER JOIN-0
· Exercise Solution – INNER JOIN-1
· JOINS – LEFT JOIN
· JOINS – RIGHT JOIN
· Exercise Solution – JOINS -LEFT RIGHT JOIN-0
· Exercise Solution – JOINS -LEFT RIGHT JOIN-1
· JOINS – FULL JOIN
· Exercise Solution – JOINS -FULL CROSS JOIN
· Exercise Challenges for Aggregation with Joins – Download
· resources here
· Exercise Solution – AGGREGATIONS – JOINS
Section 12: Combining Data with UNION
· UNION
· UNION – and UNION ALL
· UNION – Rules
· Exercise Solution – UNION-0
· Exercise Solution – UNION-1
Section 13: Magic of SUBQUARIES
· Subqueries
· Subqueries – IN
· Subqueries – NOT IN
· Subqueries – Expression
· Subqueries – Correlated
· Subqueries – NULL
· Exercise Solution SUBQUERIES-0
· Exercise Solution SUBQUERIES-1
· Exercise Solution SUBQUERIES-2
· Exercise Solution SUBQUERIES-3
· Exercise Solution SUBQUERIES-4
Section 14: RANKING Functions
· RANKING – ROW_NUMBER
· Exercise Solution RANKING – ROW_NUMBER
· RANKING – NTILE
· RANKING – RANK
· RANKING – DENSE_RANK
· Exercise Solutions NTILE RANK – DENSE_RANK-0
· Exercise Solutions NTILE RANK – DENSE_RANK-1
Section 15: ANALYTICS Functions
· ANALYTIC – LEAD
· ANALYTIC – LAG
· ANALYTIC – FIRST_VALUE
· ANALYTIC – LAST_VALUE
Section 16: LOGICAL Functions
· LOGICAL FUNCTIONS-0
· LOGICAL FUNCTIONS-1
· LOGICAL FUNCTIONS-2
· LOGICAL FUNCTIONS-3
· LOGICAL FUNCTIONS-4
· LOGICAL FUNCTIONS-5
Section 17: MATH Functions
· MATHIMATICAL FUNCTIONS-0
· MATHEMATICAL FUNCTIONS-1
Section 18: STRING Functions
· STRING FUNCTIONS-0
· STRING FUNCTIONS-1
Section 19: SYSTEM Functions
· SYSTEM FUNCTIONS
Section 20: DATE Functions
· Date Functions
Section 21: Store Procedures
· Stored Procedures
· Stored Procedures – Create and Execute
· Stored Procedures – Delete
· Exercise Solution Stored Procedures
Section 22: BONUS !!! Dashboard-in-a-day
· DIAD – Introduction
· DIAD – Accessing Data
· DIAD – Data Preparation-0
· DIAD – Data Preparation-1
· DIAD -Data Modeling and Exploration-0
· DIAD -Data Modeling and Exploration-1
· DIAD -Data Modeling and Exploration-2
· DIAD -Data Modeling and Exploration-3
· DIAD -Data Modeling and Exploration-4
· DIAD – Data Visualization-0
· DIAD – Data Visualization-1
· DIAD – Publishing Report
· DIAD – Creating Dashboards
· DIAD – Creating Dashboards-0
· DIAD – Creating Dashboards-1
