Package Includes:

  • 11 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Exclusive LearningZone Live Mentor (Value at $195)
    Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
  • Microsoft Authorized MeasureUp Exam Simulation
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy


OURexpertText
Ken Mayer

Kenneth Mayer - Certified CEH Trainer (CCSI, MCT, CCNP, CCDA)
Ken Mayer is a Microsoft Certified Trainer as well as a Certified Ethical Hacker Trainer and Security consultant. He started his career in computer technology in 1980s. He has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies across the United States and Western Europe. He has achieved the Certified Cisco Systems Instructor certification. The CCSI certification involved a two-day lab and observation event held on Cisco in Paris, France Facility. This gave Ken the accreditation to be able to deliver Cisco Authorized Courses as a CCSI. He has taught the full line of Cisco CCNA, CCDA, CCNP, CCDP and CCIP course curriculums, including Cisco's security appliances such as PIX and IDS.

Course Features:
Course Outline TXT
Module 1
SQL Server Overview
1.1 What is SQL Server?
1.2 Login, User Accounts & Roles
Module 2
Planning to Install SQL Server
2.1 Hardware requirements and Installation
2.2 Review of the Installation
2.3 Testing Our Connections
2.4 Troubleshooting Your Connection
Review Quiz
Module 3
Managing Database Files
1.1 How is Data Stored
1.2 Creating Databases
1.3 Managing Databases
1.4 Creating Filegroups
1.5 Filegroup Performance & Fault Tolerance
Module 4
Managing Security
2.1 Authentication Processing
2.2 User Accounts and Roles
2.3 Adding Roles & Types of Permissions
2.4 Managing Security within SQL Server
Module 5
Performing Administrative Tasks
1.1 Configuration Tasks
1.2 SQL Agent Mail vs SQL Mail
1.3 Routine Tasks & Creating Jobs
1.4 Alerts
1.5 Troubleshooting Alerts
Review Quiz
Module 6
Backing Up Databases
1.1 Having a Backup Strategy
1.2 Different Ways to Perform Backups
Module 7
Restoring Databases
2.1 SQL Server Recovery Process
2.2 Restoring or Rebuilding Master Database
Review Quiz
Module 8
Monitoring SQL Server Performance
1.1 Performance Monitoring of SQL Server
1.2 Memory Use, Indexes, Locks & Queries
Module 9
Transferring Data
2.1 Importing & Exporting Data
2.2 DTS (Data Transformation Services)
2.3 Tasks
Review Quiz
Module 10
Maintaining High Availability
1.1 Availability
1.2 Clustering
Module 11
Introducing Replication
2.1 Considerations for Distributing Data
2.2 Replication
2.3 Physical replication Models
Review Quiz