|
Course Description :
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
o Foundations of Querying
o Getting Started with the SELECT Statement
o Filtering and Sorting Data
o Combining Sets
o Grouping and Windowing
o Querying Full-Text Data
o Querying and Managing XML Data
o Creating Tables and Enforcing Data Integrity
o Designing and Creating Views, Inline Functions, and Synonyms
o Inserting, Updating, and Deleting Data
o Other Data Modification Aspects
o Implementing Transactions, Error handling, and Dynamic SQL
o Designing and Implementing T-SQL Routines
o Using Tools to analyze Query performance
o Implementing Indexes and Statistics
o Understanding Cursors, Sets, and Temporary Tables
o Understanding Further Optimization aspects
Enquiry Form
|