2015
CBT Nuggets
Garth Schulte
6 hours
English
This SQL Server 2014 video training course with Garth Schulte covers the latest version of developing against Microsoft’s SQL Server database server, including how to design, implement, optimize, and troubleshoot SQL Server 2014 database and programming objects.
1. Introduction to 70-464: Developing SQL Server 2014 Databases (16 min)
2. Tables (16 min)
3. Demo: Working with Tables (16 min)
4. Data Types (14 min)
5. Demo: Working with Data Types (16 min)
6. Data Integrity (10 min)
7. Demo: Domain Data Integrity (18 min)
8. Demo: Entity and Referential Data Integrity (13 min)
9. Security (13 min)
10. Demo: Implementing Security (28 min)
11. Indexes (23 min)
12. Demo: Working with Indexes (29 min)
13. Demo: Maintaining Indexes (28 min)
14. Views (10 min)
15. Demo: Working with Views (10 min)
16. Stored Procedures (13 min)
17. Demo: Working with Stored Procedures (26 min)
18. User-defined Functions (12 min)
19. Demo: Working with User-defined Functions (19 min)
20. In-Memory Features (10 min)
21. Demo: In-Memory OLTP (21 min)
22. Data Files (13 min)
23. Demo: BLOB Storage (12 min)
24. Demo: Table Partitioning (15 min)
25. XML Data (16 min)
26. Demo: Working with XML Data (24 min)
27. Query Tuning (21 min)
28. Demo: Query Tuning (24 min)
29. Concurrency (21 min)
30. Demo: Concurrency (23 min)
31. Automation (12 min)
32. Demo: Automation (18 min)
33. Managed Code (10 min)
34. Demo: Working with Managed Code (18 min)
35. Monitoring and Troubleshooting (12 min)
36. Demo: Monitoring and Troubleshooting (16 min)
www.cbtnuggets.com/it-training/microsoft-mcse-sql-server-2014-70-464
Download File Size:1.17 GB