Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network (including the Internet).
Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
MS SQL Server provides drag and drop features by which you can easily work with database. MS SQL is used mostly for large application where data size is very large and data mining needs to be performed on data to derive intelligent information.
This course covers essential of MS SQL Server. Topics covered in this course are mostly for those who want to start basic learning of MS SQL Server. We have covered Basic Introduction, Various editions of MS SQL Server, SSMS Introduction, Creating attach and de attach things, creating tables, creating relationships between tables, you will also learn how to fill table with data and entering data into table, features like functions, stored procedures, triggers, string functions, date functions is also covered. We have also covered one advanced topic which is business intelligence. So after learning this course you will get brief idea about how MS SQL Works.
There are many advanced things, after learning this course if you want to study more and do certification programs of Microsoft then you can refer following links,