- Duration: 5 Days
Course details
This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, highavailability, data migration, security, and scalability.
Course Outline
- Lesson 1: Designing a Database Server Infrastructure
- Lesson 2: Designing a Logical Database Schema
- Lesson 3: Designing a Physical Database Implementation
- Lesson 4: Incorporating Data Files into Databases
- Lesson 5: Tuning Database Performance
- Lesson 6: Designing Database Security
- Lesson 7: Policy Based Management
- Lesson 8: Monitoring Server Health
- Lesson 9: Designing a Database Backup Solution
- Lesson 10: Automating Multi-Server Maintenance
- Lesson 11: Managing SQL Server with PowerShell
- Lesson 12: Replicating Data
- Lesson 13: Planning High Availability
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Experience with Transact-SQL
- Familiarity with SQL Server 2012 components and tools
- Familiarity with objects in a SQL Server database
- Familiarity with enterprise Windows network and security architecture
Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Database Management StudyHubSGD 18
SGD 355Duration: Upto 3 Hours - Data Analysis with SQL & Tableau NextGen LearningSGD 74Duration: Upto 20 Hours
