2072 Administering a Microsoft SQL Server 2000 Database
Untitled Document
Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.
With the SQL Server 2000 Administration training course, network administrators will learn techniques for installing, configuring, administering and troubleshooting the client-server database management system of Microsoft SQL Server 2000.
Expert instructor Kenneth Mayer's friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you'll be prepared for successful system administration and be ready to pass exam #70-228, which provides core credit toward MCDBA certification and elective credit toward MCSE certification upon successful completion.
This exam is a requirement for the following Certification(s) :
Our reputation speaks for itself! See what others are saying... Testimonials
Package Includes:
6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Exclusive LearningZone Live Mentor Click for Details (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Free 1 Year Upgrade Policy
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:
Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
Microsoft Authorized Practice Exams
CareerAcademy.com includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform
a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
Certificate of Completion Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
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
