MCSA: SQL 2016 Database Development

70-761 and 70-762 exams preparation material, which I read, learned etc. throughout the prepartion, e.g. scripts, links, books, quizs.

database

• https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
• https://github.com/Ungerfall/exam-70-761/blob/master/TSQLV4.zip

reading list

70-761

1. SQL and Relational Theory 3rd edition
2. logical-query-processing
3. lqp-joins
4. lqp-apply
5. lqp-pivot
6. lqp-unpivot
7. lqp-where
8. lqp-groupby
9. lqp-select-and-orderby
10. sequence-p1
11. sequence-p2
12. sequence-vs-identity
13. the data loading performance guide
14. merge-statement-tips
15. window-aggregate-function
16. how-to-write-window-functions
17. Run, total, run!
18. For XML
19. OPENXML
20. XQuery language
21. XML Data Type and Columns
22. XML indexes
23. JSON ECMA 404
24. Format as JSON
25. OPENJSON
26. UDF-limitations-restrictions
27. row-level-security
28. dynamic-sql
29. permissions-in-sp
30. error-handling-p1
31. error-handling-p2
32. FORMATMESSAGE
33. THE-WORLD-SEQUENCE

70-762

1. Pro SQL Server Relational Database Design and Implementation (book)
2. Using Identifiers As Object Names
3. Expert Performance Indexing in SQL Server (book)
4. Klustering keys
5. Configuring partitioned views
6. Linked servers
7. Column oriented database
8. Columnstore indexes
9. Clustered columnstore index

quizlet

1. 70-761
2. 70-461

google forms

1. 70-461