Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Super Skilz
Summary
Overview
This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012.
This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to designing:
- Data compression strategies
- Database models
- Full-Text Search strategies
- High-availability solutions
- Maintenance strategy for database servers
- Management automation strategies
- Migration, consolidation, and upgrade strategies
- Database, schema, and object security parameters
This training course on designing database solutions for Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-465:
- Creating and altering tables (complex statements)
- Designing, implementing, and troubleshooting security
- Designing the locking granularity level
- Maintaining indexes
- Implementing data types
- Creating and modifying constraints (complex statements)
- Working with XML Data
- Writing automation scripts
- Designing and implementing stored procedures
- Designing T-SQL table-valued and scalar functions
- Creating, using, and altering user-defined functions (UDFs)
- Creating and altering views (complex statements)
- Designing tables
- Designing for concurrency
- Creating and altering indexes
- Designing data integrity
- Designing for implicit and explicit transactions
- Optimizing and tuning queries
- Troubleshooting and resolving performance problems
- Optimizing indexing strategies
- Capturing and analyzing execution plans
- Collecting performance and system information
Description
Syllabus:
Module 1
- Course Introduction
- Course Modules
- Introduction to SQL Server 2012
- SQL Server Instances
- SQL Server Editions and Licensing
- SQL Server Objects
- System Databases
- SQL Server Management Studio
- SSMS Components
- SQL Server Data Tools
- SQLCMD
- Working with SSMS
- Working with SQLCMD
- Exam Scenarios
- Module Review
Module 2
- Introduction to Databases
- Database Files
- Temp db
- Working with Databases
- Introduction to Filegroups and Files
- Introduction to Log Files
- Transactions
- Moving Databases
- Detaching and Attaching Databases
- Backing Up and Restoring Databases
- Copy Database Wizard
- Database Catalog View
- Creating and Configuring Databases
- Exam Scenarios
- Module Review
Module 3
- Introduction to Data Types and Tables
- Supported Data Types
- Collations and Unicode Characters
- Introduction to NULLS
- Converting Data Types
- Introduction to Tables
- Normalization
- Temporary Tables
- Working with Tables
- Schemas
- Primary and Foreign Keys
- UNIQUE Constraint/Index
- Data Types in SQL Server Demonstration
- Working with Tables Demonstration
- Exam Scenarios
- Module Review
Module 4
- SQL Server Indexing
- Introduction to Indexing
- Heaps
- Clustered Indexes
- Non-Clustered Indexes
- Maintaining Indexes
- Index Fragmentation
- SQL Server Profiler
- Index Tuning
- Working with Indexes Demonstration
- SQL Server Tuning Advisor Demonstration
- Module Review
Module 5
- Performance Considerations
- Partitioning Function
- Partition Scheme
- Partitioned Table or Index
- Introduction to Transaction
- Implicit and Explicit Transactions
- Locking
- Working with Partition Tables, Transaction and Locks
- Exam Scenarios
- Module Review
Module 6
- Backup and Restore
- Database Data and Log Files
- Recovery Model
- Database Backups Types
- Backup Compression and Mirrored Media Sets
- Verifying Backups
- Restoration Process
- Restoring Backup Types
- Restoring to a Point in Time
- WITH STANDBY
- Restoring a Database
- Restoring System Databases
- Restoring the Master Database
- Backing Up and Restoring SQL Server
- Exam Scenarios
- Module Review
Module 7
- Views and Functions
- Types Of Views
- Creating and Altering Views
- Updatable and Indexed Views
- Partitioned Views
- Introduction to Functions
- Function Types
- Scalar and Table Valued Functions
- Working with Views and Functions
- Exam Scenarios
- Module Review
Module 8
- Stored Procedures and Triggers
- Types of Stored Procedures
- Parameters
- Stored Procedure Compilation
- Execution Context
- Introduction to Triggers
- Types of Triggers
- Nested and Recursive Triggers
- Trigger Firing Order
- Working with Stored Procedures and Triggers
- Exam Scenarios
- Module Review
Module 9
- SQL Server Security
- SQL Authentication
- SQL Logins
- Accessing a Database
- Authorization Across Servers
- Server Roles
- Database Roles
- Application Roles
- Authorizing Access
- Configuring Access Using Schemas
- Working with SQL Security
- Exam Scenarios
- Module Review
Module 10
- Installing and Upgrading SQL
- Server Resources
- 32 vs. 64 Bit
- SQL Requirements
- Software Requirements
- Collations
- Service Accounts
- Installing SQL Server
- Troubleshooting Installation
- Upgrading SQL Server
- Unattended Installations
- Exam Scenarios
- Module Review
- Course Review
How is each course taught?
All courses are online and self-paced, meaning you do it in your own home, in your own time, at your own pace. Each lesson is pre-recorded allowing you to pause, fast-forward, skip sections, or go back to another lesson if you need to. The lessons are multi-media based, which means video and audio are used to teach the lessons. Most lessons are also interactive, prompting the learner to participate. This might involve answering on-screen questions, participating in tasks, and using simulators as if you were using the real software program.
How long will it take me to complete each course?
As mentioned above, our courses are self-paced. Some people finish their course faster than others. If you choose to only do one of the certification courses from this bundle, then it will take you less time than if you do two or three or all of them. No matter what though, you will always have 12 months to complete your course.
What do I need?
All you need is an internet connection and a PC. While most of the lessons work on MACs, we recommend you use a PC for the best performance. Certain parts of the course may not display properly on older MACs. Once you’ve logged into your course, you may be prompted to down certain free plugins such as Java. Just follow the on-screen prompts.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
