No account yet?
 
 
You are here:: Training/Seminar Training Schedule Developing Microsoft SQL Server 2016 Databases
 
 

Developing Microsoft SQL Server 2016 Databases

Categories : Software Technology
Posted by : kotchaphan | Posted On : Tuesday, 23 February 2010 10:33
Training Date : 20 August 2018 - 24 August 2018
26 March 2018 - 30 March 2018

20 November 2017 - 24 November 2017

15 May 2017 - 19 May 2017
10 October 2016 - 14 October 2016
18 April 2016 - 22 April 2016
Please Login before registering . No account ? signup here
กรุณา ล็อกอิน ก่อนลงทะเบียน หรือสร้างบัญชีผู้ใช้ใหม่ได้ ที่นี่
Time : 30 Hour(s)
Days : 5 Day(s)
Duration : 09:00 - 16:00
Fee : 15,000 THB (Excluded Vat 7%)
Language : Thai
Instructor : Asst. Prof. Dr.Walisa Romsaiyud
Objectives :

In this course provides students with the knowledge and skills to implement/management a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and in-Memory OLTP and tools related to implementing a database.

Who Should Attend :

-  Working knowledge on database management
-  Experience with database implementation
-  Basic Knowledge of Microsoft SQL Server

Benefits :

-  การทำงานของ Microsoft SQL Server 2016
-  การทำงานของ in-Memory OLTP
-  การบริหารจัดการ Microsoft SQL Server 2016 ซึ่ง support ข้อมูลชนิดเพื่อเพิ่มประสิทธิภาพในการทำงาน

Course Outline :

Module 1: Introduction to SQL Server 2016
• Engine Feature
• Dynamic Data Masking
• Database Scoped Configuration

Module 2: SQL Server Features for Developers
• Core Transact-SQL SELECT statement elements
• DDL, DML, and programmable objects
• Transactions and error handling

Module 3: SQL Server Tools
• Autosave open tabs
• Searchable options
• Live Query Statistics

Module 4: Transact-SQL Enhancements
• STRING_SPLIT
• COMPRESS
• SESSION_CONTEXT

Module 5: Json support in SQL Server 2016
• What is JSON?
• JSON4SQL
• JSON format
• Performance considerations

Module 6: Stretch Database
• Stretch Database Architecture
• Querying Stretch Databases
• Use Cases for Stretch Database

Module 7: Tightening the Security
• SQL Server security basics
• Encrypting the data
• Exploring dynamic data masking

Module 8: Implementing Functions
• Creating and Using Functions
• Working with Functions
• Controlling Execution Context

Module 9: Query Store
• Why Query Store?
• Enabling and configuring Query Store
• Query Store reports in SQL Server management studio

Module 10: Columnstore Indexes
• Analytical queries in SQL Server
• Management of in-Memory object
• Pertmon counters

Module 11: Introducing SQL Server in-Memory OLTP
• in-Memory OLTP Architecture
• Creating Service Broker Objects
• Sending and Receiving Messages

Payment Condition :
Payment can be made by:
    1. Cash or Credit Card or Bank Cheque payable to “Software Park Thailand #2” (a post-dated cheque is not accepted) on the first day of the service or within the last day of the service.
    2. Account transfer and send the proof of the payment (the deposit slip) via fax or email to fax no. 02-583-2884 or email ttd@swpark.or.th
        2.1 Siam Commercial Bank, Chaengwattana Branch
              Saving Account Number: 324-2-56262-0
             Account Name: Software Park Thailand#2
        2.2 Krungsri Bank, Chaengwattana (Software Park) Branch
              Saving Account Number: 329-1-34850-3
             Account Name: Software Park Thailand#2
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.
Contact Person :

For more information, contact our course coordinator on:

Ms. Patsorn Pornthip

Tel: +66-2583-9992 Ext. 1422

Fax: +66-2583-2884

Email:patsorn@swpark.or.th, ttd@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.