Certificate in SQL Expertise in Microsoft SQL Server 2012 (CSQL)

Certificate in SQL Expertise in Microsoft SQL Server 2012 (CSQL)

This is an instructor led course which provides participants 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. The course also helps participants to prepare for MS SQL Server Certification Exam 70-461.

• Describe the architecture and editions of SQL Server 2012.
• Work with SQL Server Management Studio.
• Describe the elements of T-SQL and their role in writing queries
• Describe the use of sets in SQL Server
• Describe the use of predicate logic in SQL Server
• Describe the logical order of operations in SELECT statements
• Write simple SELECT statements.
• Describe how multiple tables may be queried in a SELECT statement using joins.
• Filter and Sort data with predicates in the WHERE clause and Order by clause
• Describe components of well-performing queries.
• Create and Modify Database Objects
• Work with Data Using SELECT Statements, Sub-queries,  Data types and Aggregate queries
• Modify Data Using INSERT, UPDATE, and DELETE Statements and Combine datasets.
• Stored Procedures and Transactions.
• Troubleshoot & Optimize; Query Optimization, Manage transactions, Implement error handling.