Description
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 #analyticsWhy 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 informationCourse contentSection 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 HelpSection 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 ChallengesSection 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 CRUDSection 5: SQL Server Management Premier· How to use SSMS· What is GO Statement and ALIASSection 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 TOPSection 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 - NOTSection 8: Sorting Data· Sorting Data - ORDER BY· Exercise Solution - ORDER BY· Sorting Data - ORDER BY - OFFSET and FETCH· Exercise Solution - ORDER BY - OFFSET and FETCHSection 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 MAXSection 10: Grouping Data· Grouping Data - GROUP BY· Exercise Solution - Grouping Data - GROUP BY· Grouping Data - GROUP BY - HAVING· Exercise Solution - Grouping Data - GROUP BY - HAVINGSection 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 - JOINSSection 12: Combining Data with UNION· UNION· UNION - and UNION ALL· UNION - Rules· Exercise Solution - UNION-0· Exercise Solution - UNION-1Section 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-4Section 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-1Section 15: ANALYTICS Functions· ANALYTIC - LEAD· ANALYTIC - LAG· ANALYTIC - FIRST VALUE· ANALYTIC - LAST VALUESection 16: LOGICAL Functions· LOGICAL FUNCTIONS-0· LOGICAL FUNCTIONS-1· LOGICAL FUNCTIONS-2· LOGICAL FUNCTIONS-3· LOGICAL FUNCTIONS-4· LOGICAL FUNCTIONS-5Section 17: MATH Functions· MATHIMATICAL FUNCTIONS-0· MATHEMATICAL FUNCTIONS-1Section 18: STRING Functions· STRING FUNCTIONS-0· STRING FUNCTIONS-1Section 19: SYSTEM Functions· SYSTEM FUNCTIONSSection 20: DATE Functions· Date FunctionsSection 21: Store Procedures· Stored Procedures· Stored Procedures - Create and Execute· Stored Procedures - Delete· Exercise Solution Stored ProceduresSection 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
