CBT Nuggets - Microsoft MCSE SQL Server 2014 70-464 (2015)

MP4 | AVC 500kbps | English | 1280x720 | 12fps | 6 hours | AAC mono 64kbps | 3.17 GB

Genre: Video Training

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.

Related job functions:

Database designers Database developers Database administrators Database wizardry

70-464 is the first exam for the SQL Server MCSE: Data Platform certification. This course will help you prepare for the 70-464 exam and beyond by covering Microsoft's exam objectives. You'll also get up to speed on the latest features in SQL Server 2014.

The 70-464 exam and this course covers the following general topic areas: Implementing database objects; implementing programming objects; designing database objects; and optimizing and troubleshooting queries. Let's BEGIN!

Recommended skills:

2+ years of experience working with SQL Server Familiarity with writing T-SQL statements MCSA: SQL Server 2012

Recommended equipment:

Microsoft SQL Server 2014

Related certifications:

MCSE: SQL Server 2014 Data Platform

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)