This five-day instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.
Below are some of the new featrues of SQL Server that have been discussed in this course:
• Use of SC collations
• Use of TRY_PARSE, TRY_CONVERT
• Detailed discussion on IDENTITY constraints
• Working with SEQUENCES
• Use of THROW and comparisons to RAISERROR
• Full-globe and arc support in spatial
• Customizable nearness in full-text
Read more: http://www.intertech.com/Courses/Course.aspx?CourseID=99657#ixzz27mKPH9l8
Official Website: http://www.intertech.com/Courses/Course.aspx?CourseID=99657
Added by cheryldubbels on September 28, 2012