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

About This Course

This Microsoft preparation course comes with a single requirement that the candidate should have a basic understanding regarding databases. The training is well-designed to help you prepare and cope with the 70-464 exam and assist you carry out designing and implementation of procedures and performance of the system. The exam preparation will help the students show basic skills in creating and keeping up SQL Server, including questioning and directing SQL Server databases, and also actualizing information distribution centers. The 70-464 test is associated with the MCSE: Data Management and Analytics credential that is necessary if you want to be qualified for jobs, such as a business intelligence analyst, a database analyst, or a database designer.

Description

This Microsoft course is intended for those database engineers who assemble and actualize databases over the association while guaranteeing abnormal amounts of information accessibility. They perform assignments, including making database documents and information types, planning to create and upgrade files, executing information trustworthiness, overseeing exchanges and bolts.

Prerequisites

The MCSE: Data Management and Analytics certification is possible to earn after obtaining the MCSA certificate. You should always keep up-to-date if you want to enhance your career chances and not to stay at one level. It is imperative to take note of a Microsoft s new certification structure, and winning the high-level MCSE credential can be cultivated by taking only one extra exam based on your personal preference from a pool of exam choices.

The objectives of the course include

Implementation of database objects
Implementation of programming objects
Designing of database objects
Optimizing and troubleshooting queries

The primary responsibilities of the course involve

Streamlining and tuning questions
Making and adjusting records and putting away methods
Keeping up database respectability
Enhancing ordering methodologies
Making and modifying tables
Keeping up records
Making and changing imperatives

The course helps in measuring skills, such as

Implementation of tables and views
Implementation of indexes
Stored procedures
Integration of CRL
Working with data
Working with XML data
Tuning and optimization of queries
Management and troubleshooting

Exam details

The exam usually involves around 40-60 questions.
The candidates have 90 or 120 minutes to complete their test.
The passing score of the exam is 700 points out of 1000.
The languages you can select from include Chinese, English, German, French, Portuguese, and Japanese.

Exam focus areas

Making and modifying tables
Structuring, actualizing, and investigating security
Structuring the locking granularity level
Keeping up lists
Executing information types
Making and adjusting imperatives
Working with XML Data
Composing robotization contents
Structuring and executing put away systems
Structuring T-SQL table-esteemed and scalar capacities
Making, utilizing, and changing client characterized capacities
Making and adjusting sees
Structuring tables
Structuring for simultaneousness
Making and adjusting lists
Structuring information honesty
Structuring for express exchanges
Streamlining and tuning inquiries
Investigating and settling execution issues
Streamlining ordering procedures
Catching and investigating execution designs
Gathering execution and framework data

Target Audience

The 70-464 exam is intended for the database experts who construct and work with databases crosswise over associations and who ensure large amounts of information accessibility. Their duties incorporate making tables, database files, data types; creating and planning indexes; guaranteeing data integrity; implementing stored procedures, views, and functions; and managing locks and transactions.

Conclusion

MCSE: Data Management and Analytics is a sought-after certification. It is a great opportunity for the students hoping to advance their professional abilities in creating and keeping up SQL Server and databases, as well as prove their SQL administration skills. This credential will probably open up new expert chances.

Career path:

Database Designers
Database Developers
Database Administrators
IT Managers
IT Directors
Systems Administrators
Sr. System Engineers

This Microsoft MCSE certification provides the holder with an average salary from around $43,088 to $137,560 on annual basis.

Pass Microsoft MCSE 70-464 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

$23.33

Get Unlimited Access to ALL Premium Files Not Convinced?

Free 70-464 Exam Questions & Microsoft 70-464 Dumps
Microsoft.testkings.70-464.v2019-07-26.by.heidi.120q.ete	Views: 76 Downloads: 20	Size: 4.36 MB Votes: 2
Microsoft.selftesttraining.70-464.v2018-11-25.by.arikti.113q.ete	Views: 454 Downloads: 163	Size: 4.01 MB Votes: 1
Microsoft.Test-inside.70-464.v2017-12-29.by.johanna.113qs.ete	Views: 1164 Downloads: 864	Size: 4.19 MB Votes: 6

Student Feedback

4.5

Good

61%

28 %

11%

Comments * The most recent comment are at the top

derek

India

Jan 19, 2019

The content is amazing and great. Good job. Begin to prepare for the exam.

desean

Saudi Arabia

Jan 13, 2019

Nobody can understand what the very late planning for the exam is. And then, being in his situation, I went over the Microsoft 70-464 exam dumps. I had just a night to get ready for my test. The online lectures helped me to a great extent in preparing for the exams. Besides, the quizzes added to the preparation gave me right answers. What's more, you won't believe that I passed my exam and with great scores. The dumps are remarkably great.

marcell dareus

Nepal

Jan 06, 2019

The first occasion when I ran over these dumps, I didn't trust them much. However, I chose to utilize them. The course really turned out to be effective. Imagine how I was astounded that they were exact and substantial. Try it.

chris harris jr

Switzerland

Jan 02, 2019

This is an incredible top-notch course that gives an extraordinary learning opportunity. Prop up, folks.

travis

Russian Federation

Dec 30, 2018

This is my first course in learning SQL, and I am extremely content with the outcomes up until this point. The material is introduced in a reasonable and straightforward form without being exhausting. The examples are anything but difficult to repeat in your very own condition making discovering substantially more fun. The course helped me conclude the material and allow me to check myself. A genuinely incredible instruction encounter.

julius

Uganda

Dec 23, 2018

As a full stack engineer, I can say that there is a considerable measure of things about SQL Server that I don't think about, and this course gives an incredible review of those secrets. Truly, this course is intended for the goals of the Microsoft certification, which is essential to all database improvement. A large portion of the tests were very useful for me and could make differences. It was great to run with.

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:^*

Limited Time Discount Offer
40% Off - Ends in 02:00:00

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

Curriculum For This Course