Programming Microsoft SQL Server
Intended for anyone working with Microsoft SQL server, this course covers basic syntax and statements used to create functioning Transact-SQL modules with an emphasis on reporting techniques and performance tuning.
What you can learn.
- Be able to describe the elements of SQL server and design a SQLserver enterprise application architecture
- Describe the conceptual basis of programming in Transact-SQL and create and manage databases and their related components
- Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers
- Plan for the use of indexes; create and maintain indexes; create, use, and maintain data views
- Implement user-defined functions; design, create, and use stored procedures; create and implement triggers
- Program across multiple servers by using distributed queries, distributed transactions, and partitioned views
About this course:Transact-SQL extends SQL by adding the constructs found in other procedural languages, such as variables and control structures, thus allowing for a flexible procedural extension to SQL. Intended for anyone working with or evaluating Microsoft SQL Server, this course covers the basic syntax and statements used to create functioning Transact-SQL modules with an emphasis on reporting techniques and performance tuning. Students write different types of Transact-SQL modules, including batches, transactions, stored procedures, user-defined functions, and triggers.
It is advisable that you complete the following (or equivalent) since they are prerequisites for Programming Microsoft SQL Server.
Working knowledge of basic SQL and knowledge of database concepts. Some experience with any programming language such as Visual Basic, Java, C or C++ is highly recommended.