TOIT Training

70-762: Developing SQL Databases

70-762: Developing SQL Databases
  • Overview
  • Curriculum
  • Reviews

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.

 

  • 17 Sections
  • 0 Lessons
  • 0 Quizzes
  • 25h Duration
Expand All

Introduction to database development

0 Lessons 0 Quizzes

Designing and implementing tables

0 Lessons 0 Quizzes

Advanced table designs

0 Lessons 0 Quizzes

Ensuring data integrity through constraints

0 Lessons 0 Quizzes

Introduction to Indexes

0 Lessons 0 Quizzes

Designing optimized Index strategies

0 Lessons 0 Quizzes

Columnstore Indexes

0 Lessons 0 Quizzes

Designing and implementing Views

0 Lessons 0 Quizzes

Designing and implementing stored procedures

0 Lessons 0 Quizzes

Designing and implementing user-defined functions

0 Lessons 0 Quizzes

Responding to data manipulation via Triggers

0 Lessons 0 Quizzes

Using in-memory tables

0 Lessons 0 Quizzes

Implementing managed code in SQL Server

0 Lessons 0 Quizzes

Storing and querying XML data in SQL Server

0 Lessons 0 Quizzes

Storing and querying spatial data in SQL Server

0 Lessons 0 Quizzes

Storing and querying BLOBs and text documents in SQL Server

0 Lessons 0 Quizzes

Performance and monitoring

0 Lessons 0 Quizzes

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Design and implement tables.
  • Advanced table designs.
  • Ensure data integrity through constraints.
  • Indexes, including optimized and column store 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.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

70-762: Developing SQL Databases
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)