Microsoft SQL for Masterclass: A Comprehensive MS SQL Course
4.2 (48 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,136 students enrolled

Microsoft SQL for Masterclass: A Comprehensive MS SQL Course

Learn Hands-on MicroSoft SQL Server, Operations of MS SQL, Database, RDBMS, Data Normalization, SQL Views, Procedure etc
4.2 (48 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,136 students enrolled
Last updated 10/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 12 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Concepts of databases
  • Concepts of RDBMS
  • Data Normalization
  • Installation and Configuration of SQL Server
  • Creation of User Login
  • SQL Constraints and Checks
  • Understanding different operations of SQL
  • Hands on tutorials for querying on SQL
  • Creation of SQL Views, procedures and indexes and more….
Course content
Expand all 52 lectures 11:55:46
+ Introduction
1 lecture 16:47

This lecture provides an overview of the course and the course objectives. Along with basic concepts of SQL and its importance and applications.

Preview 16:47
+ Module 1: Background Information
1 lecture 17:10

This lecture provides a description of the concepts ofRDBMS. How data is stored in RDBMS? Terminology used in databases. SQL constraints and concept of keys

i. 2-Intro to RDBMS
17:10
+ Module 2: Background Information
4 lectures 01:01:58

What is data redundancy? Difference between data redundancy and data duplication with examples. What are data anomalies and its types? What is Normalization? Why do we need to normalize our database? What are the levels of normalizations?

i. 3a-Normalization part a
14:56

Detailed description of the first 3 levels of normalization with examples.

ii. 3b-Normalization part b
16:21

In this video, a step by step tutorial is provided for the installation and configuration of Microsoft SQL server 2017 developers edition

i. 4-Installation and Configuration
19:17

In this video, a step by step tutorial is provided for creating a new user to login into SQL server and connect to the database. User rights provision is also discussed in this

ii. 7-User Login Creation
11:24
+ Module 4: Background Information
2 lectures 27:27

In this video, concepts of SQL data types is presented and their use and their storage capacity

i. 5-SQL Data types
11:58

In this lesson, the SQL operators provided by MS SQL server are discussed along with their types

ii. 6-SQL Operators
15:29
+ Module 5: Data Base
2 lectures 30:57

In this lecture both commands and GUI methods are discussed for creating, dropping, showing all the created databases and selecting a database

i. 8a-CREATE, DROP, SHOW and USE Database
09:50

In this lesson methods to take backups and restoration of the created backups is explained along with the modes of the backups.

ii. 8b-Backup and Restore database
21:07
+ Module 6: Table
4 lectures 37:19

In this video commands are explained for creation and deletion of the tables in a database

i. 9-CREATE and DROP Table
10:56

Two insert methods are discussed, with and without specifying the columns all the variations are explained step by step with help of examples

ii. 10-INSERT INTO Table
12:52

Deletion of table records is discussed and the difference between drop and deletion is explained

iii. 11-DELETE and TRUNCATE Table
05:06

ALTER TABLE command is discussed in the light of add, drop and modify column with examples

iv. 12-ALTER TABLE
08:25
+ Module 7: SQL Constraints
8 lectures 01:26:21

The SQL Constraint NOT NULL is discussed in this lesson. Its syntax with CREATE TABLE and ALTER TABLE is discussed along with examples

i. 13a-NOT NULL
07:18

The SQL Constraint UNIQUE is discussed in this lesson. Its syntax with CREATE TABLE and ALTER TABLE is discussed along with examples

ii. 13b-UNIQUE
19:09

PRIMARY KEY Constraint is taught in this lesson. Its creation with CREATE TABLE and ALTER TABLE is discussed

iii. 13c-PRIMARY KEY
13:25

FOREIGN KEY Constraint is taught in this lesson along with its concepts with the help of descriptive example. Its creation with CREATE TABLE and ALTER TABLE is discussed

iv. 13d-FOREIGN KEY
12:32

CHECK Constraint is taught in this lesson along with its concepts with the help of descriptive example. Its creation with CREATE TABLE and ALTER TABLE is discussed

v. 13e-CHECK Constraint
10:52

DEFAULT Constraints concept is taught along with its creation and deletion with CREATE TABLE and ALTER TABLE

vi. 13f-DEFAULT Constraint
10:18

The use of auto increment, its syntax with example is discussed

vii. 13g-Auto Increment
06:08

Creation and Deletion of Indexes

viii. 13h-Indexes
06:39
+ Module 8: Select Command
1 lecture 08:23

The use of SELECT and SELECT DISTINCT

Is explained with the help of examples


i. 14-SELECT and SELECT DISTINCT
08:23
+ Module 9:
1 lecture 12:44

The concept of WHERE Clause and its use

is explained with the help of examples

i. 15-WHERE Clause
12:44
+ Module 10:
1 lecture 07:39

The use of TOP Clause alone and with WHERE is explained with the help of examples

i. 16-TOP Clause
07:39
Requirements
  • General knowledge of using computer
  • No pre-requisites required for this course
Description

The magic happens when you want to find something. Usually, you’d have to look through the entire database if you didn’t have some “index” (think like the index at the back of a large textbook) to tell you where everything was. Databases index a whole bunch of metadata so that looking for stuff is really fast.

Microsoft SQL is an exceptional reason programming language that is utilized to interface with databases. It works by understanding and analyzing databases that include data fields in their tables. For example, we can take a large organization where a lot of data has to be stored and managed. The organization has to collect and store all the information from the various departments. All the gathered information is organized and stored in a database, but it has to be valuable and accessible — that’s the place where SQL comes in. In such a situation, MS SQL is a platform that associates with front-end and back-end databases (computers and databases held on servers).

The advantages of learning Microsoft SQL are expanding and significant. MS SQL had a colossal increment in utilization during the most recent couple of years. Now, this tendency proceeds because companies gather more and more information that has to be stored and comprehended afterward.

Data storage and management have always been the backbone for every field. Databases have become a vital part of many industries. The need to understand the concept and operations of databases has become critical with the evolution of big data, Data Science and Data warehouses.

The foundation of the advanced topics of data management could only be built by learning the basics of databases and querying languages. Hence this course provides an opportunity to those who want to make their position in the technical market.

Also, the world is shifting its paradigms towards computerized methods and ways of doing things. A lot of this includes data stored in databases, be it banks, stores, hospitals, e-stores, educational institutes or government operational offices all have shifted towards databases as their storage mechanism. SQL has the highest job postings and markets all over the world compared to any other programming language. Hence taking this course provides you with an edge and a better chance at scoring a job.

Who this course is for:
  • Enthusiasts about Database querying
  • Anyone who needs to understand and know about SQL development
  • Anyone who works with data, tables, or databases!
  • Euthuasts who want to learn skills that give them the potential to earn near six fugures!
  • Who work in marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
  • Employees who work in organizations where the company typically uses Microsoft databases.