Developing Microsoft SQL Server 2016 Databases | Software Park Thailand

Skip to content

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 :	16 August 2021 - 20 August 2021 22 March 2021 - 26 March 2021 สำคัญ!!! กรุณารอการยืนยันเปิดการอบรมจากเจ้าหน้าที่ก่อนการชำระค่าลงทะเบียน 24 August 2020 - 28 August 2020 25 May 2020 - 29 May 2020 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.