Skip to main content

Microsoft 70-464: Developing Microsoft SQL Server Databases

Intermediate10 Hours 41 Minutes59 Course Videos59 Test Questions

$99.00

Microsoft 70-464: Developing Microsoft SQL Server Databases is an online course for developers who build SQL Server 2012 databases. It covers tables, indexes, procedures and XML in 10 hours 41 minutes over 59 videos.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft 70-464: Developing Microsoft SQL Server Databases is an online course for database developers who build tables, indexes, stored procedures and other objects in SQL Server 2012. It follows the Microsoft 70-464 exam, part of the MCSE: Data Platform certification. The course lasts 10 hours 41 minutes over 59 videos, with 59 test questions.

The 20 modules start with tables and data types, then build up through indexes, views, procedures and functions. Later modules cover harder topics such as concurrency, error handling, managed code, XML, spatial data and full-text search.

What you will learn

  • Pick the right data types and create tables
  • Protect data quality with constraints
  • Plan indexes and design clustered and non-clustered indexes
  • Read execution plans to speed up queries
  • Build views, stored procedures and user-defined functions
  • Merge data and pass tables into procedures
  • Write code that copes with many users at once, and handle errors in T-SQL
  • Use triggers, managed code, XML, spatial data and full-text search

Course outline

  1. SQL 2012 and the 464 test: SQL Server 2012, Management Studio and other tools
  2. Working with data types: choosing the right types
  3. Tables: creating tables
  4. Data constraints: keeping data valid
  5. Planning indexing: index strategy
  6. Table structures: clustered indexes and how to design them
  7. Non-clustered indexes: improving performance
  8. Indexes and execution plans: reading and using plans
  9. Working with views: building views
  10. Stored procedures: design and build
  11. Merging data and passing tables: MERGE and table inputs
  12. User functions: design and build
  13. Highly concurrent applications: handling many users at once
  14. Handling errors in T-SQL: catching and managing errors
  15. Triggers: running code on data changes
  16. Managed code: using .NET code in SQL Server
  17. Storing XML in SQL: saving XML data
  18. Querying XML: reading XML data
  19. Spatial data: working with location data
  20. Full-text indexes and queries: searching large text fields

Who this course is for

  • Database developers who want to deepen their SQL Server skills
  • IT staff who manage and tune databases
  • Software developers who build apps on SQL Server
  • Students and graduates starting a career in databases

Before you start

No formal prerequisites are listed, but you should be able to write basic T-SQL queries before you start. Microsoft 70-461: Querying SQL Server is a good first course if you are new to T-SQL.

About the 70-464 exam

Microsoft 70-464 checked your ability to build and put in place database objects in SQL Server 2012 and 2014, such as tables, indexes, views, procedures and functions, and to tune them for speed. Microsoft issued it as one of the exams for the MCSE: Data Platform certification.

Microsoft retired 70-464 on 31 January 2021 along with the other MCSE exams. The development skills here still apply to SQL Server work today.

Jobs this course supports

  • Database Developer
  • SQL Server Developer
  • Database Administrator
  • Data Analyst
  • Business Intelligence Developer
  • Application Developer

Skill level

Intermediate
Duration

10 Hours 41 Minutes
Videos

59 Course Videos
Questions

59 Test Questions
Certification

MCSE: Data Platform (retired)
Exam code

70-464
Certification body

Microsoft
Prerequisites

Able to write basic T-SQL queries.
Best for

Database developers, SQL Server developers, database administrators, BI developers
Topics covered

Data types and tables, constraints, indexing and execution plans, views, stored procedures, functions, concurrency, error handling and triggers, XML, spatial and full-text data
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

20 modules and 59 lessons. Here is the full outline.

Module 1: SQL 2012 And The 464 Test7 lessons
  1. Introduction
  2. Intro To SQL Server 2012-Part1
  3. Intro To SQL Server 2012-Part2
  4. Management Studio Demo-Part1
  5. Management Studio Demo-Part2
  6. Management Studio Demo-Part3
  7. Other SQL Server Tools
Module 2: Working With Data Types4 lessons
  1. Working With Data Types-Part1
  2. Working With Data Types-Part2
  3. Working With Data Types-Part3
  4. Other Data Types
Module 3: Tables2 lessons
  1. Tables
  2. Creating Tables
Module 4: Data Constraints2 lessons
  1. Data Constraints-Part1
  2. Data Constraints-Part2
Module 5: Planning In Indexing4 lessons
  1. Planning In Indexing-Part1
  2. Planning In Indexing-Part2
  3. Planning In Indexing-Part3
  4. Planning In Indexing-Part4
Module 6: Table Structures4 lessons
  1. Table Structures
  2. Working With Clustered Indexes
  3. Clustered Indexes
  4. Designing Effective Clustered Indexes
Module 7: Improving Performance with Non-Clustered Indexes3 lessons
  1. Improving Performance With Non-Clustered Indexes-Part1
  2. Improving Performance With Non-Clustered Indexes-Part2
  3. Improving Performance With Non-Clustered Indexes-Part3
Module 8: Using Indexes And Execution Plans4 lessons
  1. Using Indexes
  2. Execution Plans-Part1
  3. Execution Plans Demo
  4. Execution Plans-Part2
Module 9: Working with Views2 lessons
  1. Working With Views-Part1
  2. Working With Views-Part2
Module 10: Designing and Implementing Stored Procedures3 lessons
  1. Designing And Implementing Stored Procedures-Part1
  2. Designing And Implementing Stored Procedures-Part2
  3. Designing And Implementing Stored Procedures-Part3
Module 11: Merging Data and Passing Tables3 lessons
  1. Merging Data And Passing Tables-Part1
  2. Merging Data And Passing Tables-Part2
  3. Merging Data And Passing Tables-Part3
Module 12: Designing and Implementing User Functions1 lessons
  1. Designing And Implementing User Functions
Module 13: Creating Highly Concurrent SQL Server Applications3 lessons
  1. Creating Highly Concurrent SQL Server Applications-Part1
  2. Creating Highly Concurrent SQL Server Applications-Part2
  3. Creating Highly Concurrent SQL Server Applications-Part3
Module 14: Handling Errors in T-SQL2 lessons
  1. Handling Error InT-SQL-Part1
  2. Handling Error InT-SQL-Part2
Module 15: Triggers1 lessons
  1. Triggers
Module 16: Implementing Managed Code4 lessons
  1. Implementing Managed Code-Part1
  2. Implementing Managed Code-Part2
  3. Implementing Managed Code-Part3
  4. Implementing Managed Code-Part4
Module 17: Storing XML in SQL2 lessons
  1. Storing XML In SQL-Part1
  2. Storing XML In SQL-Part2
Module 18: Querying XML2 lessons
  1. Querying XML-Part1
  2. Querying XML-Part2
Module 19: Working with the Spatial Data3 lessons
  1. Working With Spatial Data-Part1
  2. Working With Spatial Data-Part2
  3. Working With Spatial Data-Part3
Module 20: Working With Full-Text Indexes and Queries3 lessons
  1. Working With Full-Text Indexes And Queries-Part1
  2. Working With Full-Text Indexes And Queries-Part2
  3. Working With Full-Text Indexes And Queries-Part3

Your learning path

Where Microsoft 70-464: Developing Microsoft SQL Server Databases fits. Build your skills one step at a time.

Take firstLearn SQL Server 2019 - Querying SQL Server
You are hereMicrosoft 70-464: Developing Microsoft SQL Server Databases
Next stepMicrosoft 70-465: Designing Database Solutions for Microsoft SQL Server

Frequently asked questions

Can I still take the Microsoft 70-464 exam?

No. Microsoft retired 70-464 on 31 January 2021. The course still teaches how to build and tune SQL Server databases.

How is 70-464 different from 70-462?

70-462 is about running and securing SQL Server. 70-464 is about building database objects such as tables, indexes, procedures and functions.

Does the course cover query tuning?

Yes. Several modules cover planning indexes, clustered and non-clustered index design, and reading execution plans.

Will I learn to work with XML?

Yes. Two modules cover storing XML in SQL Server and querying it.

Is spatial data covered?

Yes. One module covers spatial data, and another covers full-text indexes and queries.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course