70-762: Developing SQL Databases eLearning
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
About This Course
Course Description
In this instructor-led, online training course, students will be given the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.
Exam Number: 70-762
Course Curriculum
Module 1: Introduction to database development
Module 2: Designing and implementing tables
Module 3: Advanced table designs
Module 4: Ensuring data integrity through constraints
Module 5: Introduction to Indexes
Module 6: Designing optimized Index strategies
Module 7: Columnstore Indexes
Module 8: Designing and implementing Views
Module 9: Designing and implementing stored procedures
Module 10: Designing and implementing user-defined functions
Module 11: Responding to data manipulation via Triggers
Module 12: Using in-memory tables
Module 13: Implementing managed code in SQL Server
Module 14: Storing and querying XML data in SQL Server
Module 15: Storing and querying spatial data in SQL Server
Module 16: Storing and querying BLOBs and text documents in SQL Server
Module 17: Performance and monitoring
Learning Objectives
Inclusions
- Accessible 24x7x365 both from your PC and Mobile Device
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
- *For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com
- NOTE: These are our Partner Delivered eLearning.
Pre-requisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
Target Audience
- This instructor-led, online training course is for IT professionals who want to become skilled on SQL Server product features and technologies for implementing a database.
Your Instructors
Course LMSBoss
See moreWrite a review
Inclusions
- Accessible 24x7x365 both from your PC and Mobile Device
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
- *For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com
- NOTE: These are our Partner Delivered eLearning.
