Designing Database Solutions for Microsoft SQL Server 2012 Video Course

70-465: Designing Database Solutions for Microsoft SQL Server 2012

Your Microsoft 70-465 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-465 certification test. Ace your Microsoft 70-465 at the first attempt and obtain the Designing Database Solutions for Microsoft SQL Server 2012 credential with ease.

# of Students
124
# of Lectures
185
Course Length
6 h
Course Rating
4.5
Price $32.99
Today $29.99

Curriculum for 70-465 Video Course

Designing Database Solutions for Microsoft SQL Server 2012

  Video Name Time
  1. Course Modules 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. SQL Server Instances 6:00
  4. SQL Server Editions and Licensing 3:00
  5. SQL Server Objects 1:00
  6. System Databases 3:00
  7. SQL Server Management Studio 1:00
  8. SSMS Components Part1 5:00
  9. SSMS Components Part2 2:00
  10. SQL Server Data Tools 1:00
  11. SQLCMD 3:00
  12. Working with SSMS Part1 4:00
  13. Working with SSMS Part2 2:00
  14. Working with SQLCMD 4:00
  15. Exam Scenarios 4:00
  16. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 3:00
  3. Database Files Part1 2:00
  4. Database Files Part2 2:00
  5. Temp db 2:00
  6. Working with Databases 4:00
  7. Introduction to Filegroups and Files Part1 1:00
  8. Introduction to Filegroups and Files Part2 3:00
  9. Introduction to Log Files 2:00
  10. Transactions 2:00
  11. Moving Databases 2:00
  12. Detaching and Attaching Databases 2:00
  13. Backing Up and Restoring Databases 1:00
  14. Copy Database Wizard 1:00
  15. Database Catalog View 2:00
  16. Creating and Configuring Databases Part1 6:00
  17. Creating and Configuring Databases Part2 5:00
  18. Exam Scenarios 2:00
  19. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Supported Data Types 7:00
  4. Collations and Unicode Characters Part1 2:00
  5. Collations and Unicode Characters Part2 1:00
  6. Introduction to NULLS 1:00
  7. Converting Data Types 2:00
  8. Introduction to Tables Part1 1:00
  9. Introduction to Tables Part2 4:00
  10. Normalization 3:00
  11. Temporary Tables 2:00
  12. Working with Tables 2:00
  13. Schemas 2:00
  14. Primary and Foreign Keys Part1 1:00
  15. Primary and Foreign Keys Part2 2:00
  16. Primary and Foreign Keys Part3 1:00
  17. UNIQUE Constraint/Index 1:00
  18. Data Types in SQL Server Demonstration Part1 6:00
  19. Data Types in SQL Server Demonstration Part2 2:00
  20. Working with Tables Demonstration Part1 5:00
  21. Working with Tables Demonstration Part2 3:00
  22. Exam Scenarios Part1 1:00
  23. Exam Scenarios Part2 1:00
  24. Module Review 2:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Introduction to Indexing 2:00
  4. Heaps 1:00
  5. Clustered Indexes 5:00
  6. Non-Clustered Indexes Part1 2:00
  7. Non-Clustered Indexes Part2 3:00
  8. Non-Clustered Indexes Part3 2:00
  9. Maintaining Indexes Part1 1:00
  10. Maintaining Indexes Part2 3:00
  11. Index Fragmentation 3:00
  12. SQL Server Profiler 1:00
  13. Index Tuning 1:00
  14. Working with Indexes Demonstration Part1 5:00
  15. Working with Indexes Demonstration Part2 2:00
  16. Working with Indexes Demonstration Part3 3:00
  17. SQL Server Tuning Advisor Demonstration Part1 5:00
  18. SQL Server Tuning Advisor Demonstration Part2 1:00
  19. Exam Scenarios 2:00
  20. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Partitioning Function 1:00
  4. Partition Scheme 1:00
  5. Partitioned Table or Index 2:00
  6. Introduction to Transaction 1:00
  7. Implicit and Explicit Transactions 3:00
  8. Locking 4:00
  9. Working with Partition Tables, Transaction & Locks Part1 5:00
  10. Working with Partition Tables, Transaction & Locks Part2 2:00
  11. Working with Partition Tables, Transaction & Locks Part3 4:00
  12. Exam Scenarios 2:00
  13. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Database Data and Log Files Part1 1:00
  4. Database Data and Log Files Part2 1:00
  5. Recovery Model 2:00
  6. Database Backups Types Part1 1:00
  7. Database Backups Types Part2 1:00
  8. Database Backups Types Part3 1:00
  9. Database Backups Types Part4 1:00
  10. Database Backups Types Part5 1:00
  11. Backup Compression and Mirrored Media Sets 1:00
  12. Verifying Backups 1:00
  13. Restoration Process 1:00
  14. Restoring Backup Types Part1 1:00
  15. Restoring Backup Types Part2 1:00
  16. Restoring Backup Types Part3 1:00
  17. Restoring to a Point in Time 1:00
  18. WITH STANDBY 1:00
  19. Restoring a Database 1:00
  20. Restoring System Databases 2:00
  21. Restoring the Master Database 1:00
  22. Backing Up and Restoring SQL Server Part1 5:00
  23. Backing Up and Restoring SQL Server Part2 3:00
  24. Backing Up and Restoring SQL Server Part3 3:00
  25. Backing Up and Restoring SQL Server Part4 3:00
  26. Exam Scenarios 3:00
  27. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Introduction Part3 1:00
  4. Types Of Views 1:00
  5. Creating and Altering Views 4:00
  6. Updatable and Indexed Views 4:00
  7. Partitioned Views 1:00
  8. Introduction to Functions 1:00
  9. Function Types 1:00
  10. Scalar and Table Valued Functions 2:00
  11. Working with Views and Functions Part1 6:00
  12. Working with Views and Functions Part2 4:00
  13. Working with Views and Functions Part3 3:00
  14. Exam Scenarios 3:00
  15. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Introduction Part3 1:00
  4. Types of Stored Procedures 1:00
  5. Parameters 1:00
  6. Stored Procedure Compilation 3:00
  7. Execution Context Part1 2:00
  8. Execution Context Part2 1:00
  9. Introduction to Triggers Part1 1:00
  10. Introduction to Triggers Part2 1:00
  11. Types of Triggers 2:00
  12. Nested and Recursive Triggers 1:00
  13. Trigger Firing Order 1:00
  14. Working with Stored Procedures & Triggers Part1 5:00
  15. Working with Stored Procedures & Triggers Part2 6:00
  16. Exam Scenarios 3:00
  17. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 2:00
  3. SQL Authentication 1:00
  4. SQL Logins 1:00
  5. Accessing a Database 1:00
  6. Authorization Across Servers 2:00
  7. Server Roles 2:00
  8. Database Roles 1:00
  9. Application Roles 1:00
  10. Authorizing Access Part1 3:00
  11. Authorizing Access Part2 3:00
  12. Configuring Access Using Schemas 1:00
  13. Working with SQL Security Part1 4:00
  14. Working with SQL Security Part2 4:00
  15. Exam Scenarios 3:00
  16. Module Review 1:00
  Video Name Time
  1. Introduction Part1 1:00
  2. Introduction Part2 1:00
  3. Server Resources Part1 2:00
  4. Server Resources Part2 2:00
  5. 32 vs. 64 Bit 1:00
  6. SQL Requirements 3:00
  7. Software Requirements 1:00
  8. Collations 1:00
  9. Service Accounts 1:00
  10. Installing SQL Server 1:00
  11. Troubleshooting Installation 1:00
  12. Upgrading SQL Server Part1 1:00
  13. Upgrading SQL Server Part2 2:00
  14. Unattended Installations 1:00
  15. Exam Scenarios 2:00
  16. Module Review 1:00
  17. Course Review 1:00

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
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
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • 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
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • 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
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • 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