Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Microsoft SQL Server 2012 – Developing Databases: Implementing Tables and Views $74.95
Microsoft SQL Server 2012 – Developing Databases: Implementing Indexes $74.95
Microsoft SQL Server 2012 – Developing Databases: Stored Procedures $74.95
Microsoft SQL Server 2012 – Developing Databases: CLR Integration $74.95

Bundle Price: $169.00
Total Savings: $130.80


Microsoft SQL Server 2012 – Developing Databases: Implementing Tables and Views

With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • recognize how different types of tables are created
  • determine the result of an implicit conversion
  • use best practices to create different table types in SQL Server 2012
  • recognize how to create partitioned tables in SQL Server 2012
  • describe the characteristics of standard views in SQL Server 2012
  • create and use different types of tables and views

Microsoft SQL Server 2012 – Developing Databases: Implementing Indexes

With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • determine the most appropriate index type to use in a given scenario
  • identify how to optimize index performance
  • describe how to manage indexes in a given scenario
  • identify how to maintain indexes in a given scenario
  • identify how to repair fragmented indexes
  • create and maintain indexes in SQL Server

Microsoft SQL Server 2012 – Developing Databases: Stored Procedures

An effective strategy that database developers often employ to interface between applications and SQL Server 2012 involves the creation of programs using the Transact-SQL language and saving them as stored procedures or functions as database objects. Subsequently the applications can execute these programs as required and process results. This course introduces this powerful database programming concept and covers the types of programs available, design issues and implementation considerations. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • identify the characteristics of stored procedures
  • identify how to manage stored procedures in a given scenario
  • recognize the advantages of using table-valued parameters
  • differentiate between table-valued and scalar functions
  • identify the considerations for using a multi-statement table-valued function
  • create and use different types of tables and views in a given scenario

Microsoft SQL Server 2012 – Developing Databases: CLR Integration

With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
  • determine the most appropriate CLR function to use in a given scenario
  • choose the most appropriate partial command to use in a given scenario
  • identify how to implement triggers
  • identify the type of transaction being used in a given scenario
  • use the CLR and maintain database integrity with transactions in SQL Server 2012
Register Now
Microsoft SQL Server 2012: Developing Databases Part 1 e-learning bundle
  • Course ID:
    252790
  • Duration:
    6 hours
  • Price:
    $169