This course is intended for database professionals who design and build database solutions in an organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs. Primary responsibilities may include but are not limited to:
•Design a data compression strategy
•Design a database model
•Design a Full-Text Search strategy
•Design a high-availability solution
•Design a maintenance strategy for database servers
•Design a management automation strategy
•Design a migration, consolidation, and upgrade strategy
•Design database, schema, and object security parameters
•Design for business requirements
•Design for concurrency
•Design for high availability
•Design for implicit and explicit transactions
•Design instance-level security configurations
•Design physical database and object placement
•Design policies
•Design scalable database solutions
•Applying those skills in a Windows Azure SQL Database environment
Exam # | Duration | Language | Level | Type | Classroom | Code | Fees |
70-465 | 45 | English | Professional | Course | Classroom | Cs235 | 0 LE |
Design Database Structure
Design Databases and Database Objects
Design Database Security
Design a Troubleshooting and Optimization Solution
Course 10776A: Developing Microsoft SQL Server 2012 Databases
Developing Microsoft SQL Server 2012 Databases
Microsoft Official Courseware (MOC)
This course includes several labs to ensure you will gain the targeted skills and experience.
Course 70-465: Designing Database Solutions for Microsoft SQL Server 2012: counts as credit toward the following certification(s):
•Microsoft Certified Solutions Expert (MCSE): Data Platform