Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 55 Minute(s)
Language
English
Taught by
Stone River eLearning
Rating
1 views
Course Overview
Designing Database Solutions for Microsoft SQL Server 2012
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
We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
Course Content
- 10 section(s)
- 186 lecture(s)
- Section 1 Designing Database Solutions for Microsoft SQL Server 2012
- Section 2 Introduction to SQL Server 2012
- Section 3 Introduction to Databases
- Section 4 Introduction to Data Types and Tables
- Section 5 SQL Server Indexing
- Section 6 Performance Considerations
- Section 7 Backup and Restore
- Section 8 Views and Functions
- Section 9 Stored Procedures and Triggers
- Section 10 SQL Server Security
What You’ll Learn
- This course will prepare you to pass the exam Microsoft 70-465 Designing Database Solutions for Microsoft SQL Server 2012
- Passing this exam validates a candidate’s ability to create and alter tables,design, implement, and troubleshoot security, collect performance and system information and realted activities.
Skills covered in this course
Reviews
-
RRG Williams
The physicality of the sql databases is broken down, just a lot of things i took for granted over the years i'm starting to see what is REALLY involved
