Font size:

SQL Server 2012 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2012 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to create them using Transact-SQL statements. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Learning Objectives
  • Choose the appropriate data type to use, in a given scenario
  • Create a basic table
  • Modify a basic table
  • Implement a constraint in a table
  • Create and modify tables and constraints
  • Create an index
  • Modify an index
  • Create a view
  • Create indexes and views
Register Now
Microsoft SQL Server 2012: Creating Database Objects Online course
  • Course ID:
  • Duration:
    120 minutes
  • Price: