Pluralsight Playlist for MS 70-762

Last year I passed the Microsoft Developing SQL Databases exam (MS 70-762 - https://www.microsoft.com/en-us/learning/exam-70-762.aspx). I've previously passed the Microsoft Querying Data with Transact-SQL exam (MS 70-761 - https://www.microsoft.com/en-us/learning/exam-70-761.aspx) but found some of the concepts in the MS 70-762 exam a little more difficult to understand. Probably because I've previously never had to maintain and optimise SQL databases. Whereas, with the MS 70-761 exam I had at least had experience querying data in SQL prior to preparing for the exam.

I'm a huge fan of Pluralsight and the courses authors publish on the platform and there were some Pluralsight courses that really helped me out with my preparation for the MS 70-762 exam. So I thought it would be helpful for others preparing for this exam if I put these courses together into a playlist.

The MS 70-762 Exam

The MS 70-762 Developing SQL Databases exam is about the setting up, managing and optimisation of databases in day-to-day use. Topics in the exam can be divided into 4 categories (see original link for a more detailed list, the list below summarises the contents - taken from the exam details page):

 1) Design and implement database objects
  • Design and implement a relational database schema
  • Design and implement indexes
  • Design and implement views
  • Implement columnstore indexes

2) Implement programmability scripts
  • Ensure data integrity with constraints
  • Create stored procedures
  • Create triggers and user-defined functions

3) Manage database concurrency
  • Implement transactions
  • Manage isolation levels
  • Optimise concurrency and locking behaviour
  • Implement memory-optimised tables and native stored procedures

4) Optimise database objects and SQL infrastructure
  • Optimise statistics and indexes
  • Analyse and troubleshoot query plans
  • Manage performance for database instances
  • Monitor and trace SQL Server baseline performance metrics

The Pluralsight Playlist

The following table details the Pluralsight playlist that I've put together for the MS 70-762 exam, based on the preparation I did. I've divided the Pluralsight courses in this playlist into the 4 topic categories listed above.

Category Course Title Link
1) Design and implement database objects Designing and Implementing SQL Server Tables and Views Link
SQL Server 2012: Nonclustered Columnstore Indexes Link
2) Implement programmability scripts Programming SQL Server Database Triggers and Functions Link
3) Manage database concurrency Managing SQL Server Database Concurrency Link
SQL Server: Deadlock Analysis and Prevention Link
Practical SQL Server In-Memory OLTP Tables and Objects Link
4) Optimise database objects and SQL infrastructure SQL Server: Introduction to Extended Events Link
SQL Server: Performance Troubleshooting Using Wait Statistics Link
SQL Server: Indexing for Performance Link
SQL Server: Query Plan Analysis Link
SQL Server: Introduction to Query Store Link
SQL Server: Collecting and Analyzing Trace Data Link

The End

Comments

  1. Erick Ortega9 June 2020 at 15:46

    Hi! Thanks a lot for sharing your preparation tips!! what others preparation material do you recommend?

    ReplyDelete
    Replies
    1. Tom19 June 2020 at 23:24

      The official 70-762 is a good place to start, also I'd definitely recommend just trying these concepts out for yourself - one of the best ways of learning is doing.

      Delete

Post a Comment

Popular posts from this blog

My First Year as a Data Scientist

Image
I was very fortunate to be given the opportunity by my employer to change role from a full-stack software developer to data scientist with the in-house Data Team. I've now spent over a year in this new data science role and thoroughly enjoy the different challenges it brings over software development. I wanted to write this blog post to firstly help me reflect on what I've been doing over the past year: what changes I had to undergo, what I did well, what I could improve on. And, secondly to help others in a similar situation to me - either thinking about transitioning or already transitioning by writing about some of the pitfalls and challenges I've had. Before I start, to elaborate on my background a little bit more: I haven't always been a software developer. I have completed both a Masters and PhD in Computer Science. So I didn't go into the move completely blind, I did have some previous experience of tools, models and methodologies to rely on. But I have a
Read more

PIVOT and UNPIVOT in T-SQL

Image
I recently passed my 70-761 Querying Data with Transact-SQL exam as part of mt revision I created the following diagram to help me remember how PIVOT and UNPIVOT work. I thought it would be good to share. For completeness, the following gives the syntax to use when using PIVOT and UNPIVOT. WITH PivotData AS ( SELECT <grouping column> , <spreading column> , <aggregation column> FROM <source table> ) SELECT <grouping column>, <distinct spreading values> FROM PivotData PIVOT (<aggregation function>(<aggregation column>) FOR <spreading column> IN <distinct spreading values>)); SELECT <grouping column>, <target names column>, <target values column> FROM <pivoted source table> UNPIVOT(<target values column> FOR <target names column> IN (<distinct spreading values>)); The End
Read more

My First Retro

Introduction A few days ago the opportunity came up for me to run a sprint retrospective for our sprint team. So I took the chance to try my hand at doing something a bit different. To give a quick bit of background to our sprint team. We have been trying to adopt agile practices for a while now but for one reason and another we have been quite slow in adoption of all the sprint practices we want to use. As such even though we have been "using agile" for over a year now, we have only had one sprint retro prior to the one I volunteered to run. Before I hosted the retro I read up (probably reading the same articles that everyone else reads after googling "sprint retrospective") and got the usual things about you cover "what we should start doing", "what we should stop doing" and "what we should continue doing". Rather than this being a rehash of these articles I wanted to talk about something different - the actual practicalities of
Read more