Learn Microsoft SQL Server from Scratch

Name: Learn Microsoft SQL Server from Scratch
Rating: 4.1 (975 reviews)

Microsoft SQL database course for Beginners

Created byYasir Mehmood

Last updated 7/2022

English

What you'll learn

Introduction to Database Management System (DBMS)
Microsoft SQL Server development and administration
Installation Guide of Microsoft SQL Server
How to Create database
How to create and modify tables
Primary Key
Foreign Key
Composite Key
How to drop a Table
Insert data into table
Select data from a table
Update/modify existing data of a table
Delete data from a table
Substring function
Group By Clause
Average function
Inner join
Left join
Right join
Full join
Distinct function
Database Views
Stored procedures
How to execute the stored procedure
SQL jobs
How to use Like Operator
Taking Database Backup
Restoring the database backup

Course content

9 sections • 33 lectures • 1h 46m total length

What we are going to learn ?2:59

Create Database in Microsoft SQL Server4:35
This lecture will guide the students that how they can create a Database in Microsoft SQL Server.
Create Tables6:38
Students will learn that how to Create New Tables in SQL Server through Query as well as Wizard
Alter Tables7:00
Alter Tables
Add Columns in a Table
Alter Columns in a table
Drop Columns from a table
Drop Tables
Primary Key (part 1)1:18
Explore how tables organize data in columns and rows and how a primary key uniquely identifies each record, illustrated by a student id example.
Primary Key (part 2)3:28
Define a primary key by converting a nullable integer column to non-null, then apply a primary key constraint on grade_id in the employee grades table.
Composite Key (Part 1)0:43
Composite Key (Part 2)3:16
Foreign_Key (Part 1)0:42
Explore foreign keys, keys that reference another table's primary key. See how a foreign key in one table points to the primary key in the other.
Create Foreign Key Relationship between Tables8:25
This lecture is about creation of Foreign Keys in a table
Drop Foreign Key1:18
This lecture will guide you that how to Drop a Foreign Key Relationship
Keys Quiz

Inner Join5:21
Inner join is used to select the data from both tables which are common in each.
Left Outer Join2:48
Left Outer Join selects all records from Base table where only Common Records of secondary table
Right Outer Join1:12
Right Join selects the complete data set of secondary table whereas only common records from Primary tables are selected.
Full Join1:43
Student will Learn that how to use the Full Join operation on tables.
Join Quiz

Requirements

Student must be aware of basic database concepts.
must have a computer where Microsoft SQL Server could be installed

Description

This Course is designed for those students who want to get detailed knowledge of Microsoft SQL Server in short time by learning the sql fundamentals for beginners , These skills are also applicable to any other major SQL database, such as MySQL, Oracle,DB2 etc.

SQL is one of the most in demand tech skills due to which Technology firms are in dire need for SQL experts . Learning SQL is one of the fastest ways to improve your career prospects and to get SQL developer job.

This SQL weekender course requires only 1 week to learn SQL Server online and Mastering SQL Server course is the right place for you to learn SQL on fast pace to become SQL Developer in very short time.

you will get insights that how to Create the Sequel database as well as how to Drop an existing database.

We will also go through that how to Take the Backup of SQL Server database and how to restore the backup on a new location.

You will find lot of sql database online courses as well as online computer courses but here you will learn lot database concepts in very easy way.

We will also take you through that how to download SQL Server database and how to perform a fresh installation

We are hopeful that you will find this SQL Tutorial very beneficial for your future,

Students will learn in this course:

Installation of Microsoft SQL Server
Installation of Microsoft SQL Server Management Studio
How to create a database
How to Drop a database
Database Backup
Restoration of database
Data Definition operations like Create ,Alter and drop the Tables
Creation of Primary Key, Foreign Key, Composite Key
Data Manipulation options like Insert , Update , Delete the records
SQL Joins ( Inner Join, Left Outer Join, Full Join, Right Join)
Database Views
Stored Procedures
Database Functions ( User defined functions ,aggregate functions , SQL Provided functions like substring etc)
Distinct
Group By
Little on SQL Server administration and SQL Jobs
and many more things......

Upgrade your skill set quickly and add SQL in your resume by joining today! you will find lot of sql server tutorials on internet however this course is the Best online sql server tutorial which is actually step by step guide to Query Writing.

Who this course is for:

Students who want to have solid grip over Microsoft SQL Server
Who wants to get database knowledge

Learn Microsoft SQL Server from Scratch

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Installation2 lectures • 13min

Database Operations10 lectures • 37min

Data Manipulation OR CRUD Operations4 lectures • 9min

Miscellaneous Queries3 lectures • 7min

SQL Joins4 lectures • 11min

Advanced Topics3 lectures • 12min

SQL Server Programming3 lectures • 10min

Database Administration3 lectures • 5min

Requirements

Description

Who this course is for: