Developing SQL Databases - MOC On Demand (MS-20762)
Self-Paced LearningLearning Style
2 DaysCourse Duration
2 DaysSATV Value
Select A Class Schedule
| Master Subscription |
7-Day FREE Trial
Now Only $1,999.00 Regular Price $3,499.00/ Year
Now Only $550.00 Regular Price $1,195.00/ Each
About this course
This four-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.
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 audiences 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.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
Self-Paced Learning Outline
- How To Access MOC On-Demand Course
|Learning Style||Self-Paced Learning|
|Course Duration||2 Days|
|SATV Value||2 Days|
|VPA Eligible||VPA Eligible|
Turn Training Into A Personalized Learning Experience
- Project Problem Solving through ExpertConnect & Peer-To-Peer Learning
- Career Paths - Find The Quickest Path To What You Need To Learn
- One Subscription, All Access - Take Multiple Courses & Become An Expert
- Manage Your Organization Through Learner & Manager Analytics
- Virtual Instructor-Led Training Supplemented With Self-Paced Learning
- Integrate With Your LMS Through API's
Sales (866) 991-3924
Mon-Fri. 8am-6pm CST
Chat Live With Us
Mon-Fri. 8am-6pm CST