Learning SQL from scratch, is a key source to develop skills in database programming, the course will cover from installation of SQL Server till advance query writing and relationship management between data.

below are the topics covered in this course:

1. Microsoft SQL Server Installation and Introduction

2. What is data and information?

3. Create very first database and table

4. Introduction to T-SQL Statements

5. Clauses

6. What is primary key and foreign key? (Relationships)

7. What are SQL Constraints?

8. What areSQL Joins?

9. What are SQL Views?

10. What are SQL Stored procedures?

SQL server installation is one one of the most technical and mind boggling process, this course will help you installing MS SQL Server with mandatory features that are required to kick start. Furthermore, in this course you'll learn database terminologies and there usages in different areas. In this course our focus is on relational databases where data is split in to multiple locations called "TABLES". The reason of doing so is to have unique and non repetitive data without redundancy. After this course, you will be able to create and design your own databases. This course will also help you to understand different concepts of data handling like DDL, DML & DCL statement, that are used for inserting, updating, retrieving and deletion of data in database. After this course , you'll be able to retrieve data from database from different table all together using simple queries.