Developing Microsoft SQL Databases (MS-20762)

QuickStart
Training overview
2 days
Professional Course

Course description

Developing Microsoft SQL Databases (MS-20762)

About this course:

This five-day instructor-led 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.

Who should attend?

Audience:

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 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 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 Objectives:

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.

Why choose QuickStart?

98% increased workplace productivity

94% instructor and course effectiveness

Partnered with vendors including Microsoft, Cisco, and Citrix

About QuickStart

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...


Read more and show all training delivered by this supplier

Contact info

QuickStart

1101 S Capital of Texas Hwy - Building J, Suite 202
78746 Austin Texas

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available