- الموقع: Bukit Merah - Central
- مدة الدورة التدريبية: 5 Days
تفاصيل الدورة
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
نبذة عن معهد 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
عرض الجميع دورات New Horizons Singapore- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- 18 SGD
349 SGDمدة الدورة التدريبية: Upto 8 Hours - Microsoft SQL Server Development Apex Learning33 SGD
322 SGDمدة الدورة التدريبية: Upto 6 Hours