70-464: Developing Microsoft SQL Server 2012/2014 Databases Exam

Curriculum For This Course

Developing Microsoft SQL Server 2012 Databases

2Lectures

Time 00:01:17

Module 1

13Lectures

Time 00:34:07

Module 2

23Lectures

Time 00:51:30

Module 3

18Lectures

Time 00:41:53

Module 4

11Lectures

Time 00:27:33

Module 5

9Lectures

Time 00:18:46

Module 6

12Lectures

Time 00:21:41

Module 7

14Lectures

Time 00:28:59

Module 8

12Lectures

Time 00:26:04

Module 9

14Lectures

Time 00:26:04

Module 10

12Lectures

Time 00:21:41

Developing Microsoft SQL Server 2012 Databases
	1. Course Introduction	00:29
	2. Course Modules	00:48

Module 1
	1. Introduction to SQL Server 2012 Part1	00:09
	2. Introduction to SQL Server 2012 Part2	00:36
	3. SQL Instances	04:05
	4. SQL Editions	05:31
	5. SQL Server Tools	00:19
	6. SQL Server Management Studio	06:10
	7. SQL Data Tools	00:37
	8. SQL Command	01:16
	9. Utilizing SQL Server Tools Part1	05:40
	10. Utilizing SQL Server Tools Part2	06:11
	11. Exam Scenarios Part1	00:48
	12. Exam Scenarios Part2	01:54
	13. Module Review	00:51

Module 2
	1. Introduction to Data Types and Tables Part1	00:15
	2. Introduction to Data Types and Tables Part2	02:03
	3. Introduction to Data Types and Tables Part3	01:40
	4. Collations	01:22
	5. Unicode Characters	00:45
	6. Null Values	00:51
	7. Converting Data Types	02:27
	8. Introduction to Tables Part1	00:13
	9. Introduction to Tables Part2	03:22
	10. Normalization	02:22
	11. Temporary Tables	01:49
	12. Working with Tables	01:41
	13. Schemas	01:59
	14. Primary and Foreign Keys Part1	00:07
	15. Primary and Foreign Keys Part2	05:37
	16. UNIQUE Constraint/Index	00:42
	17. In Depth Look Part1	03:55
	18. In Depth Look Part2	05:54
	19. In Depth Look Part3	06:04
	20. In Depth Look Part4	05:51
	21. Exam Scenarios Part1	00:37
	22. Exam Scenarios Part2	01:14
	23. Module Review	00:40

Module 3
	1. SQL Server Indexing Part1	00:10
	2. SQL Server Indexing Part2	00:45
	3. Introduction to Indexing	03:08
	4. Clustered Indexes	05:33
	5. Non Clustered Indexes Part1	02:14
	6. Non Clustered Indexes Part2	01:49
	7. Non Clustered Indexes Part3	03:01
	8. Non Clustered Indexes Part4	01:43
	9. Maintaining Indexes Part1	00:06
	10. Maintaining Indexes Part2	01:51
	11. Index Fragmentation	04:22
	12. Index Tuning	00:51
	13. Creating & Altering Indexes Part1	06:01
	14. Creating & Altering Indexes Part2	03:55
	15. Creating & Altering Indexes Part3	03:57
	16. Exam Scenarios Part1	00:33
	17. Exam Scenarios Part2	01:23
	18. Module Review	00:31

Module 4
	1. Query Performance Part1	00:14
	2. Query Performance Part2	02:05
	3. Execution Plans	03:08
	4. Reading Execution Plans	01:17
	5. Execution Plan Operators	01:22
	6. Plan Reuse	02:06
	7. Query Performance Part1	04:28
	8. Query Performance Part2	04:25
	9. Query Performance Part3	06:02
	10. Exam Scenarios	01:25
	11. Module Review	01:01

Module 5
	1. Common Language Runtime (CLR) Integration Part1	00:12
	2. Common Language Runtime (CLR) Integration Part2	02:52
	3. Assemblies	01:41
	4. Permissions	01:26
	5. CLR Objects	04:55
	6. Integrating the CLR within SQL Server	04:17
	7. Exam Scenarios Part1	01:17
	8. Exam Scenarios Part2	01:19
	9. Module Review	00:47

Module 6
	1. Transact-SQL (T-SQL) Error Handling Part1	00:13
	2. Transact-SQL (T-SQL) Error Handling Part2	02:17
	3. Error Severity	03:20
	4. TRY CATCH Error Handling	01:24
	5. TRY PARSE and TRY CONVERT	00:45
	6. @@ ERROR	00:44
	7. Alerts	01:04
	8. Error Handling in T-SQL Part1	04:02
	9. Error Handling in T-SQL Part2	05:04
	10. Exam Scenarios Part1	00:38
	11. Exam Scenarios Part2	01:23
	12. Module Review	00:47

Module 7
	1. Views and Functions Part1	00:10
	2. Views and Functions Part2	01:00
	3. Types of Views	01:35
	4. Working with Views Part1	04:36
	5. Working with Views Part2	03:03
	6. Introduction to Functions Part1	00:11
	7. Introduction to Functions Part2	01:20
	8. Working with Functions	01:49
	9. Working with Views and Functions Part1	04:41
	10. Working with Views and Functions Part2	03:47
	11. Working with Views and Functions Part3	03:06
	12. Exam Scenarios Part1	01:47
	13. Exam Scenarios Part2	01:18
	14. Module Review	00:36

Module 8
	1. Stored Procedures and Triggers Part1	00:12
	2. Stored Procedures and Triggers Part2	02:26
	3. Working with Stored Procedures	01:26
	4. Introduction to Triggers Part1	00:07
	5. Introduction to Triggers Part2	02:48
	6. Working with Triggers	02:34
	7. Stored Procedures & Triggers Demo Part1	05:01
	8. Stored Procedures & Triggers Demo Part2	03:26
	9. Stored Procedures & Triggers Demo Part3	03:32
	10. Exam Scenarios Part1	01:08
	11. Exam Scenarios Part2	01:45
	12. Module Review	01:39

Module 9
	1. Working with XML Part1	00:08
	2. Working with XML Part2	00:31
	3. XML Concepts Part1	01:59
	4. XML Concepts Part2	01:20
	5. Schemas & Schema Collections Part1	03:56
	6. Schemas & Schema Collections Part2	01:12
	7. FOR XML Clause Part1	00:05
	8. FOR XML Clause Part2	03:11
	9. FLOWR Queries	01:31
	10. Working with XML in SQL Server Part1	05:17
	11. Working with XML in SQL Server Part2	03:57
	12. Exam Scenarios Part1	01:04
	13. Exam Scenarios Part2	01:13
	14. Module Review	00:40

Module 10
	1. Introduction to Transactions	00:10
	2. Transactions	01:45
	3. Implicit Transactions	00:36
	4. Explicit Transactions	02:21
	5. Locking	04:03
	6. Deadlocks	01:36
	7. Transactions in Locking Within SQL Server Part 1	03:37
	8. Transactions in Locking Within SQL Server Part 1	02:70
	9. What Do You Need to Know for the Exam?	00:34
	10. Example Questions	01:26
	11. Module Review	01:07
	12. Course review	01:16

Free 70-464 Exam Questions & Microsoft 70-464 Dumps
Microsoft.Test-inside.70-464.v2017-12-29.by.johanna.113qs.ete	Views: 781 Downloads: 640	Size: 4.19 MB Votes: 6

Student Feedback

4.5

Good

60%

29 %

11%

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

70-464: Developing Microsoft SQL Server 2012/2014 Databases

Curriculum For This Course

Free 70-464 Exam Questions & Microsoft 70-464 Dumps

Student Feedback

Add Comments

Get 40% Discount on All Your Purchases

This is ONE TIME OFFER

Enter your email address to receive your 40% off discount code:

70-464: Developing Microsoft SQL Server 2012/2014 Databases

Curriculum For This Course

Free 70-464 Exam Questions & Microsoft 70-464 Dumps

Student Feedback

Add Comments

Get Premium Membership

Enter your email address to receive your 40% off discount code: