Corso Developing Microsoft SQL Server 2012 Databases 2012 Specialist

Nessun prerequisito richiesto Module 1: Introduction to SQL Server 2012 and its Toolset This module stresses on the fact that before beginning to work with SQL Server in either a development or an administration role, it is important to understand the overall SQL Server platform. In particular, it is useful to understand that SQL Server is not just a database engine but it is a complete platform for managing enterprise data. Lessons •Introduction to the SQL Server Platform •Working with SQL Server Tools •Configuring SQL Server Services Lab : Introduction to SQL Server and its Toolset •Verifying SQL Server Component Installation •Altering Service Accounts for New Instance •Enabling Named Pipes Protocol for Both Instances •Creating an Alias for AdvDev •Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port (Only if time permits) After completing this lesson, you will be able to: •Describe the SQL Server Platform. •Work with SQL Server Tools. •Configure SQL Server Services. Module 2: Working with Data Types This module explains how to use and convert data types. Also it focusses on how to work with specialized data types, and character data types. Lessons •Using Data Types •Working with Character Data •Converting Data Types •Specialized Data Types Lab : Working with Data Types •Choosing Appropriate Data Types •Writing Queries With Data Type Conversions •Designing and Creating Alias Data Types (Only if time permits) After completing this module, students will be able to: •Work with data types. •Work with character data. •Convert between data types. •Use specialized data types. Module 3: Designing and Implementing Tables This module explains how to design, create, and alter tables. Also it focusses on working with schemas. Lessons •Designing Tables •Working with Schemas •Creating and Altering Tables Lab : Designing and Implementing Tables •Improving the Design of Tables •Creating a Schema •Creating the Tables After completing this module, students will be able to: •Design Tables. •Work with Schemas. •Create and Alter Tables. Module 4: Ensuring Data Integrity through Constraints This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focusses on implementing Entity and Referential Integrity. Lessons •Enforcing Data Integrity •Implementing Domain Integrity •Implementing Entity and Referential Integrity Lab : Ensuring Data Integrity through Constraints •Designing Constraints •Testing the constraints After completing this module, students will be able to: •Explain the available options for enforcing data integrity and the levels at which they should be applied. •Implement domain integrity. •Implement entity and referential integrity. Module 5: Planning for SQL Server 2012 Indexing This module explains the core indexing concepts and effectiveness of each data type commonly used in indexes. Lessons •Core Indexing Concepts •Data Types and Indexes •Single Column and Composite Indexes Lab : Planning for SQL Server Indexing •Exploring existing index statistics •Designing column orders for indexes After completing this module, students will be able to: •Explain core indexing concepts. •Describe the effectiveness of each data type common used in indexes. •Plan for single column and composite indexes. Module 6: Implementing Table Structures in SQL Server 2012 This module explains how tables can be structured in SQL Server databases. Also it focusses on designing and working with clustered indexes. Lessons •SQL Server Table Structures •Working with Clustered Indexes •Designing Effective Clustered Indexes Lab : Implementing Table Structures in SQL Server •Creating Tables as Heaps •Creating Tables with Clustered Indexes •Comparing the Performance of Clustered Indexes vs. Heaps After completing