Course description
Developing SQL Databases - MOC On Demand (MS-20762)
About this course:
This course provides students with 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. This course also prepares the students for the .
The average salary for a SQL Developer is $81,714 per year.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Who should attend?
Audience:
This course is intended for:
- IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.
- Individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database.
Prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
Training content
Course Objective:
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.
Quick stats about QuickStart?
98% increased workplace productivity
94% instructor and course effectiveness
Partnered with vendors including Microsoft, Cisco, and Citrix
Contact this provider
Meet your career goals with QuickStart!
QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple...