Learn Microsoft SQL Server from Scratch

Microsoft SQL database course for Beginners

Created by: Yasir Mehmood
Information Technology specialist and Database Architect

What Will I 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

Target audience

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