Developing Microsoft SQL Server 2012/2014 Databases Video Course

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

Your Microsoft 70-464 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-464 certification test. Ace your Microsoft 70-464 at the first attempt and obtain the Developing Microsoft SQL Server 2012/2014 Databases credential with ease.

# of Students
101
# of Lectures
140
Course Length
4 h
Course Rating
4.4
Price $32.99
Today $29.99

Curriculum for 70-464 Video Course

Developing Microsoft SQL Server 2012 Databases

  Video Name Time
  1. Course Introduction 00:30
  2. Course Modules 00:48
  Video Name Time
  1. Introduction to SQL Server 2012 Part1 00:09
  2. Introduction to SQL Server 2012 Part2 00:37
  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:17
  9. Utilizing SQL Server Tools Part1 05:40
  10. Utilizing SQL Server Tools Part2 06:12
  11. Exam Scenarios Part1 00:48
  12. Exam Scenarios Part2 01:54
  13. Module Review 00:52
  Video Name Time
  1. Introduction to Data Types and Tables Part1 00:15
  2. Introduction to Data Types and Tables Part2 02:04
  3. Introduction to Data Types and Tables Part3 01:41
  4. Collations 01:22
  5. Unicode Characters 00:45
  6. Null Values 00:51
  7. Converting Data Types 02:28
  8. Introduction to Tables Part1 00:13
  9. Introduction to Tables Part2 03:23
  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:52
  21. Exam Scenarios Part1 00:37
  22. Exam Scenarios Part2 01:14
  23. Module Review 00:40
  Video Name Time
  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:50
  7. Non Clustered Indexes Part3 03:02
  8. Non Clustered Indexes Part4 01:43
  9. Maintaining Indexes Part1 00:07
  10. Maintaining Indexes Part2 01:51
  11. Index Fragmentation 04:22
  12. Index Tuning 00:51
  13. Creating & Altering Indexes Part1 06:02
  14. Creating & Altering Indexes Part2 03:56
  15. Creating & Altering Indexes Part3 03:57
  16. Exam Scenarios Part1 00:33
  17. Exam Scenarios Part2 01:23
  18. Module Review 00:32
  Video Name Time
  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
  Video Name Time
  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:27
  5. CLR Objects 04:56
  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
  Video Name Time
  1. Transact-SQL (T-SQL) Error Handling Part1 00:13
  2. Transact-SQL (T-SQL) Error Handling Part2 02:18
  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:05
  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
  Video Name Time
  1. Views and Functions Part1 00:10
  2. Views and Functions Part2 01:01
  3. Types of Views 01:35
  4. Working with Views Part1 04:37
  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
  Video Name Time
  1. Stored Procedures and Triggers Part1 00:12
  2. Stored Procedures and Triggers Part2 02:26
  3. Working with Stored Procedures 01:27
  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:02
  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
  Video Name Time
  1. Working with XML Part1 00:08
  2. Working with XML Part2 00:31
  3. XML Concepts Part1 02:00
  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:06
  8. FOR XML Clause Part2 03:11
  9. FLOWR Queries 01:32
  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
  Video Name Time
  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:40
  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

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.4
Rating: 4.4
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address