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

This course is included in our On-demand training solution.


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 2012 Databases. This exam is one of the requirements for the MCSE: Data Platform certification path.

Target Audience

Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.



Expected Duration

120 min.

Course Objectives

Designing Tables and Data Integrity in SQL Server 2012

  • recognize how different types of tables are created
  • Using Data Types in SQL Server 2012

  • determine the result of an implicit conversion
  • Creating Tables in SQL Server 2012

  • use best practices to create different table types in SQL Server 2012
  • Implementing Partitioned Tables in SQL Server 2012

  • recognize how to create partitioned tables in SQL Server 2012
  • Creating Views in SQL Server 2012

  • describe the characteristics of standard views in SQL Server 2012
  • Create Types of Tables and Views in SQL Server 2012