Microsoft SQL from scratch - Beginner to Expert

Practical Hands-on Real World SQL Skills

4.45 (157 reviews)
Udemy
platform
English
language
Databases
category
19,588
students
8 hours
content
Jun 2021
last update
$59.99
regular price

What you will learn

Extract and Read Data Using SELECT statements

Insert new data into database

Update existing data in a database

Delete data from a database

Understand Normalization

Extract Data from multiple tables using table joins

Filter data returned from a query

Sort data returned by a query

Group data returned by a query

Summarize data using aggregate functions

Build real world queries for business intelligence

Remove Duplicate Records

Description

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media.

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.

SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.T-SQL  - Transact SQL is Microsoft's implementation of SQL.  There are a lot of similarities between them but also proprietary parts that are specific to SQL Server.

We will be using Microsoft's version of SQL  ( T-SQL )  popularly referred to as T-Sequel  with Microsoft SQL Server .

SQL Server is a relational database management system  -RDBMS  developed and owned by Microsoft.Thousands of companies all over the world use SQL Server for their data solution .


What You Will Learn include:

  • How to extract  data from multiple Database Tables using Joins

  • How to insert new data into database with SQL

  • How to update existing data inside a database

  • How to delete data from a database

  • How to filter data

  • How to sort data

  • How to create and query views

  • How to  build a stored procedure

  • How to use Aggregate functions to summarize returned data

  • How to group data



SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.

This course is a beginners guide to performing data analysis using SQL to  interrogate SQL Server to provide answers to data related questions.  You will learn to write useful SQL queries that is applicable to the Real World  production environment.

Everywhere data is being collected, every transaction, every web page visit,every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.


















Content

Microsoft SQL Server Installation

Introduction
System Requirements
Please Read
Download Microsoft SQL Server Express
What is SQL
What is T-SQL
What is SQL Server
Basic Database Concepts
Schema
Install Microsoft SQL Server
Download Sample Database
Attach sample database
Install SSMS ( SQL Server Management Studio)
Exploring SSMS
Using Intellisense
Introduction to Normalization
Using T-SQL GO command
Using T-SQL TOP command
T-SQL USE command

Extracting Data using SQL

Using SELECT to extract data
Using Aliases with SELECT
Using Case expressions
Creating and extracting data from views
Commenting your T-SQL code
Removing duplicate records
Using Stored Procedures

Modifying Data with SQL

Introduction
Inserting new data using SQL
Updating existing data using SQL
Deleting (dropping) data using SQL
Summary

Sorting Data with SQL

Introduction
Using ORDER BY
Sorting by ascending order
Sorting by descending order
Sorting by multiple columns
Summary

Filtering Data with SQL

Introduction
Filtering using basic equality filters
Filtering using basic comparison filters
Filtering using basic logical filters
Filtering using string comparison filters
Filtering using NULL comparison
Summary

Extracting Data From Multiple Tables

Introduction to Table Joins
Importance of Table Joins
Extracting with INNER Join
Extracting with LEFT OUTER Join
Extracting with RIGHT OUTER Join
Extracting with FULL OUTER Join
Conclusion

Aggregate Functions and Grouping Data

Introduction
Using COUNT Aggregate Function
Using AVG Aggregate Function
Using MAX Aggregate Function
Using MIN Aggregate Function
Using SUM Aggregate Function
Using multiple aggregate functions
Grouping Data
Summary

Real World Data Analysis and Business Intelligence using SQL

Download Nortwind Database
Attach Nortwind Database to SQL Server
Build a query to show contact titles for customers
Build query to show customers and employee count
Analysing and extracting data from multiple data
Build query to show Sales Reps
Build a query to check specific products
Build a query to check suppliers details
Build query to checck least and most expensive product
Build a query to check orders shipped
Build a query to list shippers
Build a query to show discontinued products
Build query to check first order placed.
Build query to check orders shipped to Latin America
Build query to show sales reps in a country
Build a query to check product stock
Build a query to show countries with customers

Some Exercises For You

Exercise 1
Exercise 2
Exercise 3
Excercise 4
Exercise 5
Exercise 6
Exercise 7

Screenshots

Microsoft SQL  from scratch  - Beginner to Expert - Screenshot_01Microsoft SQL  from scratch  - Beginner to Expert - Screenshot_02Microsoft SQL  from scratch  - Beginner to Expert - Screenshot_03Microsoft SQL  from scratch  - Beginner to Expert - Screenshot_04

Reviews

Joseph
February 17, 2021
The overall information of the course is presented well. However, I do feel there is a large amount of redundant information provided at the beginning of each video making it longer than necessary. Along with this there is a noticeable amount of empty time at the end of the videos that make it take longer to get "credit" for completing the video. These are all minor inconvenient quality of life complaints but I feel would make an overall smoother experience if addressed
Jecris
February 4, 2021
I like the tone or mode of the speaker, it makes things easy to understand. Also, the discussion of each topic is very clear with good emphasis.
Deruelle
February 3, 2021
Ce cours m'a semblé de bonne qualité, mais je trouve qu'il est très répetitif sur certains aspect (chaque début de video est à couper car on reprend à zéro l'explication de l'ouverture de la base, de la sélection des colonnes...). Il manque également d'après moi de pratiques concrètes un peu plus évoluées (exemple : comment joindre plus de 2 tables, comment joindre plusieurs bases, comment rédiger un script complet, comment organiser un code plus long...) Je reste un peu sur ma faim. Je suis d'accord pour le "from scratch", mais pas avec le "to expert". A la fin, on garde un niveau très débutant tout de même :-) A noté que l'anglais est très compréhensible car le prof articule bien et parle lentement (j'ai choisi d'accélérer le rythme mais certains y trouveront leur compte) et c'est agréable à écouter.
Othonas
July 6, 2019
Very good material, a little outdated but the resources were found. Very good and polite instructor. Thank you!!
Marian
May 22, 2019
It deals with beginners staffs and knowledge, but T-SQL in the name of the course indicate a higher knowledge to be learned.
Andy
May 19, 2019
This course is for beginners with absolutely zero knowledge in T-SQL. No lectures for expert level topics like sub queries, data types and conversions etc.

Coupons

DateDiscountStatus
1/30/2021100% OFF
expired

Charts

Price

Microsoft SQL  from scratch  - Beginner to Expert - Price chart

Rating

Microsoft SQL  from scratch  - Beginner to Expert - Ratings chart

Enrollment distribution

Microsoft SQL  from scratch  - Beginner to Expert - Distribution chart
1992360
udemy ID
10/27/2018
course created date
11/20/2019
course indexed date
Bot
course submited by