In this course, introduce the entire SQL Server platform and its major tools on Microsoft SQL Server 2012. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.  Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.

Module 1: Introduction to SQL Server 2012 and its Toolset.

• Introduction to the SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services

Module 2: Working with Data 

• Using Data Types
• Working with Character Data
• Converting Data Types
• Speciallized Data Types

Module 3: Designing and Implementing Tables

• Designing Tables
• Working with Schemas
• Creating and altering Tables

Module 4: Ensuring Data Integrity through Constraints

• Enforcing Data Integrity
• Implementing Domain Integrity
• Implementing Entity and Referential Integrity

Module 5: Planning for SQL Server 2012 Indexig

• Core Indexing Concepts
• Data Types and Indexes
• Single Column and Composite Indexes

Module 6: Implementing Table Structures in SQL Server 2012

• SQL Server Table Structures
• Working with C;lustered Indexes
• Desinging Effective Clustered Indexes

Module 7: Reading SQL Server 2012 Execution Plans

• Execution Plan Core Concepts
• Common Executive Plan Elements
• Working with Executive Plans

Module 8: Improving Performance through Nonclustered Indexes

• Designing Effective Nonclustered Indexes
• Implementing Nondustered Indexes
• Using the Database Engine Tuning Advisor

Module 9: Designing and Implementing Views

• Introduction to Views
• Creating and Managing Views
• Performance Considerations for Views

Module 10: Designing and Implementing Stored Procedures 

• Introduction to Stored Procedures
• Working with Stored Procedures
• Implementing Parameterized Stored Procedures
• Controlling Execution Context

Module 11: Merging Data and Passing Tables

• Using the MERGE Statement
• Implementing Table Types
• Using TABLE Types As Parameters

Module 12: Creating Highly Concurrent SQL Server 2012 Applications

• Introduction to Transactions
• Introduction to Locks
• Management of Loding
• Transaction Isodation Levels

Module 13: Implementing Managed Code in SQL Server 2012

• Introduction to SQL CLR Integration
• Importing and Configuring Assemblies
• Implementing SQL CLR Integration

Module 14: Storing XML Data in SQL Server 2011

• Introduction to XML and XML Schemas
• Storing XML Data and Schemas in SQL Server
• Implementing the XML Data Type

Module 15: Working with SQL Server 2012 Spatial Data

• Introduction to Spatial Data
• Working with SQL Server Spatial Data Types
• Using Spatial Data in Applications

Payment must be paid in full at least 7 days prior to the start of the class. The payment can be made:

1. Cheque should be made payable to "Software Park Thailand#2"

Or

2. Account transfer to "Software Park Thailand #2" Saving account no. 324-2-56262-0, Siam Commercial Bank, Chaengwattana Branch. Then, fax the deposit slip to +66 2 583 2884.

Notes:

• Withholding tax (3%) is exempt.
• Should you need to withdraw, you must send the notice of the withdrawal in writing no later than 7 working days before the commencement date. The cancellation less than 7 days will be subject to a fine of 40% of the fee.
• Software Park Thailand reserves the rights to cancel courses due to unforeseen circumstances.

For more information, contact our course coordinator on:

Tel: +66-2583-9992 Ext. 1423

Fax: +66-2583-2884

Email: training@swpark.or.th

You are encouraged to use the course schedule as a guide to plan your training. The schedule is accessible at www.swpark.or.th for more information.