SQL Bootcamp for Beginners using Microsoft free tools
SQL Bootcamp for Beginners using Microsoft free tools
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 157 lectures (18h 46m) | Size: 9.48 GB
Become an expert at SQL with comprehensive and 100% hands on exercises course
What you'll learn:
Learn SQL (Structured Query Language) the programming language, a backbone and common to 100s of databases
Learn professionally Designed contents, Tip and Tricks for SQL
Learn database system that allow anyone to store and organize large amount of data
Learn how to create, delete Databases from scratch
Learn most in-demand, hottest skill, widely used and most reliable language to date
Become Job ready as Database Developer, Business Analyst and Data Analyst
Gain theoretical insights about Relational Database
Learn how to analyze and get actionable insights from data
Learn how to code Database and Practice/Implement everything you lean step-by-step
Learn how to capture, store, modify, delete and query data
Learn the ability to solve any SQL Problem
Learn top-notch coding SQL techniques and professionally tested SQL Best practices
Learn to answer specific business questions by using CRUD, Aggregate Functions, Ranking Function, Logical function, Math Functions, String functions, Data Function and much more
Learn more advance functions/topics like Sub Queries, Joins, Unions and Store Procedures
You will be writing over 3600 lines of code with me in this course
Learn how to read data with SELECT statement
Learn how to filter data with WHERE Clause
Learn how to filter groups with HAVING clause
Learn how to join data and how to use INNER JOIN, LEFT/RIGHT AND OUTER JOINS
Learn how to group data with GROUP BY clause
Learn how to sort data with ORDER BY clause
Lifetime Support from our Instructors
Requirements
You need a Windows-based computer to run Microsoft SQL Server.
Absolutely no programming experience is required, you will learn all step-by-step.
Your willingness to learn an insane amount of awesome stuff
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 #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
Who this course is for
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
Anyone who wants to become Data Analyst
Anyone who wants to become 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
Homepage
)
