Mastering SQL Server | Passage to become Database Developer
Microsoft SQL database course for Beginners
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
Requirements
-
Student must be aware of basic database concepts.
-
must have a computer where Microsoft SQL Server could be installed
Who this course is for:
- Students who want to have solid grip over Microsoft SQL Server
- Who wants to get database knowledge