Learn Microsoft SQL Server from scratch
- 4.1
Brief Introduction
Microsoft SQL TrainingDescription
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 are SQL Joins?
9. What are SQL Views?
10. What are SQL Stored procedures?
Requirements
- Requirements
- Be able to write SQL queries efficiently and become a query master
- Should have basic knowledge of database.
- Be able to create RDBMS and get knowledge of how to store data into parts