About
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). By learning this course, you will get knowledge about how to write programmable logic in SQL using Microsoft SQL Server and the T-SQL language. This course totally focuses on programmable objects of SQL like User Defined functions, Stored Procedures, Triggers etc. and you will learn how to write programs in SQL, how to manage local variables, how to control execution flow of an program using If and While statements, what is dynamic SQL and how to design it, and how to use Cursors in SQL programming. You will also learn how to SSMS utilities like Backup-Restore, Online-Offline, Attach-Detach, Shrink, Script Generation, Bulk Insert, etc. and SQL query optimization using Index. Since PLSQL is an most important skill for any DBA or Developer, this is a good starting point to learn PLSQL using T-SQL.