Introduction
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
Audience:
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
The secondary audience for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.
The secondary audience for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.
At Course Completion
After completing this course, students will be able to:
- Design and Implement Tables
- Describe advanced table designs
- Ensure Data Integrity through Constraints
- Describe indexes, including Optimized and Columnstore indexes
- Design and Implement Views
- Design and Implement Stored Procedures
- Design and Implement User Defined Functions
- Respond to data manipulation using triggers
- Design and Implement In-Memory Tables
- Implement Managed Code in SQL Server
- Store and Query XML Data
- Work with Spatial Data
- Store and Query Blobs and Text Documents
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
Professional Exam(s)
Exam 70-762: Developing SQL DatabasesCertification(s):
Private: MCSA: SQL 2016 Database Development-
MODULES
- Introduction to Database Development
- Designing and Implementing Tables
- Advanced Table Designs
- Ensuring Data Integrity through Constraints
- Introduction to Indexes
- Designing Optimized Index Strategies
- Columnstore Indexes
- Designing and Implementing Views
- Designing and Implementing Stored Procedures
- Designing and Implementing User-Defined Functions
- Responding to Data Manipulation via Triggers
- Using In-Memory Tables
- Implementing Managed Code in SQL Server
- Storing and Querying XML Data in SQL Server
- Storing and Querying Spatial Data in SQL Server
- Storing and Querying BLOBs and Text Documents in SQL Server
- SQL Server Concurrency
- Performance and Monitoring
- Nicosia
City
- Class A:
1. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 20 Louki Akrita street,
2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
- Class A:
1. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)
Location
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manual | Exam | |
| Official Course 20762 | Official - digital | 70-762 | |
| Amount | €525,00 | €205,00 | €100,00 |
| VAT * | €228,95 | €38,95 | - |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manual | Exam | |
| Official Course 20762 | Official - digital | 70-762 | |
| Amount | €600,00 | €205,00 | €100,00 |
| VAT | €114,00 | €38,95 | - |
Take advantage of our special offer by taking this course as part of a bundle of 3 courses leading to the following prestigious MCSA certification:
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manuals | Exams | |
| Courses 20761 & 20762 | Official 20761 & 20762 | 70-761 & 70-762 | |
| Amount | €340,00 | €382,00 | |
| VAT * | €323,00 | €72,58 |
.
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manuals | Exams | |
| Courses 20761 & 20762 | Official 20761 & 20762 | 70-761 & 70-762 | |
| Amount | €840,00 | €382,00 | €200,00 |
| VAT | €159,00 | €72,58 |
