We are now holding the Course 6231A: Maintain a Microsoft SQL Server 2008 database training from March 31 to April 4, 2010 (5 days) from Pinal Dave of sqlauthority.com fame, one of the best resources in the world on SQL Server and would like to ensure that you benefit from the next training as well. Here are the benefits for all the people that had attended the event:

· Microsoft Official Curriculum books are given to each student FREE of costs along with the course.

· Every participant also receives the exams FREE of COSTS along with the course.

· Every participant will receive a certificate of attendance signed by Bill Gates.

· Every participant also receives the SQL Server 2008 genuine software (not for resale) along with the course.

· All meals and refreshments during the training

· Microsoft bag, pen and notebook.

· Hands on labs with high-end networked computers with 19” LCD monitor, 2 GB Memory with Core2Duo processors computer

· Comfortable air-conditioned environment

Distinguish your Microsoft SQL Server 2008 skills and knowledge by earning a Microsoft Certification. Combined with hands-on experience, this course increases your understanding of specific technologies and job roles, inspires confidence in employers, and broadens your career opportunities.

At the end of the training, you have an option to sit for exam: Exam 70-432: Microsoft Certified Technical Specialist: Microsoft SQL Server 2008, Installation and Maintenance and become a Microsoft Certified Technical Specialist. The costs of the examination (worth approximately NPR 5,000) and the second shot exam (worth approximately another NPR 5,000) is FREE of COSTS to the participants and is built into the cost of the training. Challenge labs are included in the boot camp to help our participants pass the exams.

The training also includes the genuine NOT FOR RESALE Microsoft SQL Server 2008 Standard edition software free, normally worth about NPR 85,000 value. This is a great offer for organizations who needs to ensure that the software that they are using is genuine from henceforth with no costs at all, except for the number of Client Access Licenses (CALs) required.

The cost of the training is NPR 35,000. (Rupees thirty-five thousand only).

Kindly register immediately since we have very limited seated.

Best regards,

Course 6231A:
Maintaining a Microsoft SQL Server 2008 Database

Length:

5 Days

Language(s):

English

Audience(s):

IT Professionals

Level:

200

Technology:

Microsoft SQL Server 2008

Type:

Course

Delivery Method:

Instructor-led (classroom) with lots of hands-on labs

Overview

About this Course

Elements of this syllabus are subject to change.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Audience Profile

This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion

After completing this course, students will be able to:

Install and configure SQL Server 2008.
Manage database files.
Backup and restore databases.
Manage security.
Transfer data into and out of SQL Server.
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.
Monitor SQL Server.

Overview

Course OutlineModule 1: Installing and Configuring SQL Server

The students will be introduced to planning for a SQL Server installation. The students will then be introduced to installing, configuring, and managing SQL Server.

Lessons

· Preparing to Install SQL Server

· Installing SQL Server

· Configuring a SQL Server Installation

Lab : Installing and Configuring SQL Server

· (Level 200) Installing SQL Server

· (Level 200) Configuring SQL Server

After completing this module, students will be able to:

· Explain how to prepare the hardware and other resources necessary to install SQL Server.

· Install SQL Server.

· Manage and configure SQL Server.

Module 2: Managing Databases and Files

The students will be introduced to database planning and creation, and using database options to control database behavior.

Lessons

· Planning Databases

· Creating Databases

· Using Policy-Based Management

Lab : Managing Databases and Files

· (Level 200) Creating a Database

· (Level 200) Monitoring and Managing Filegroup Usage

· (Level 200) Creating a Policy

After completing this module, students will be able to:

· Plan a database implementation that meets an organization's requirements.

· Create a SQL Server database.

· Manage a SQL Server database.

Module 3: Disaster Recovery

The students will be introduced to disaster recovery techniques for SQL Server. They will learn how to perform different types of backup and restore operations, including online restores and backup and restores of system databases.

Lessons

· Planning a Backup Strategy

· Backing Up User Databases

· Restoring User Databases

· Performing Online Restore Operations

· Recovering Data from Database Snapshots

· System Databases and Disaster Recovery

Lab : Disaster Recovery

· (Level 200) Designing a Backup Strategy

· (Level 200) Implementing a Backup Strategy

· (Level 200) Restoring and Recovering a Database

· (Level 300) Performing Piecemeal Backup and Restore Operations

· (Level 200) Restoring the master Database

After completing this module, students will be able to:

· Plan a backup strategy for a database.

· Back up user databases.

· Restore user databases from backups.

· Restore data in a user database while it is online.

· Recover data for a user database from a database snapshot.

· Restore and recover system databases.

Module 4: Managing Security

The students will be introduced to protecting SQL Server. Students will learn about the SQL Server security model and how to use SQL Server security features to control access to databases and their contents.

Lessons

· Overview of SQL Server Security

· Protecting the Server Scope

· Protecting the Database Scope

· Protecting the Server Scope

· Auditing Security

Lab : Managing Security

· (Level 200) Creating Logins and Assigning Server-Scope Permissions

· (Level 200) Creating and Managing Users

· (Level 300) Using a Certificate to Protect Data

· (Level 200) Implementing SQL Server Audit

After completing this module, students will be able to:

· Describe how SQL Server manages security.

· Protect SQL Server at the server level.

· Protect SQL Server databases.

· Use keys and certificates to protect SQL Server objects.

· Audit SQL Server security.

Module 5: Transferring Data

The students will be introduced to transfer data to and from SQL Server using UI and command-line tools, and learn about transferring and transforming data with SQL Server Integration Services.

Lessons

· Overview of Data Transfer

· Introduction to SQL Server Integration Services

Lab : Transferring Data

· (Level 200) Using the Import/Export Wizard

· (Level 200) Performing a Bulk Load

· (Level 200) Creating an SSIS Solution

After completing this module, students will be able to:

· Use UI and command-line tools to import and export data.

· Describe the features of SQL Server Integration Services.

Module 6: Automating Administrative Tasks

The students will learn how to automate routine administrative tasks using jobs, operators, and alerts.

Lessons

· Automating Administrative Tasks in SQL Server

· Using SQL Server Agent

· Creating Maintenance Plans

· Implementing Alerts

· Managing Multiple Servers

· Managing SQL Server Agent security

Lab : Automating Administrative Tasks

· (Level 200) Configuring SQL Server Agent

· (Level 200) Creating Operators and Jobs

· (Level 200) Creating Alerts

After completing this module, students will be able to:

· Define SQL Server administrative tasks and schedule those tasks to run automatically.

· Configure SQL Server Agent to support automatic task scheduling.

· Script tasks by using SQL Server jobs, and define operators for managing those jobs.

· Define alerts to warn operators about events raised by SQL Server.

· Define and manage administrative tasks that span multiple servers.

· Configure SQL Server Agent security.

Module 7: Implementing Replication

The students will be introduced to techniques for configuring SQL Server replication.

Lessons

· Overview of Replication

· Managing Publications and Subscriptions

· Configuring Replication in Some Common Scenarios

Lab : Implementing Replication

· (Level 300) Implementing Snapshot Replication

· (Level 300) Implementing Peer-to-Peer Transactional Replication

· (Level 300) Implementing HTTP Merge Replication

After completing this module, students will be able to:

· Describe replication and its components.

· Configure and implement replication.

· Use replication to meet the requirements of some common scenarios.

Module 8: Maintaining High Availability

The students will be introduced to concepts and methods for maintaining high availability with SQL Server.

Lessons

· Introduction to High Availability

· Implementing Log Shipping

· Implementing Database Mirroring

· Implementing Server Clustering

· Using Distributed High Availability Solutions

Lab : Maintaining High Availability

· (Level 300) Configuring Log Shipping

· (Level 300) Configuring Database Mirroring

· (Level 300) Implementing SQL Server Clustering

After completing this module, students will be able to:

· Describe the factors affecting database availability.

· Describe how to implement log shipping to support fast recovery of a standby SQL Server database

· Describe how to use SQL Server mirroring to implement a software solution for fast failover

· Explain how to implement clustering to support fast failover of computers running SQL Server instances.

· Describe how to implement distributed high availability solutions.

Module 9: Monitoring SQL Server

The students will be introduced to monitoring SQL Server performance and activity.

Lessons

· Viewing Current Activity

· Using SQL Server Profiler

· Monitoring with DDL Triggers

· Using Event Notifications

Lab : Monitoring SQL Server

· (Level 200) Monitoring SQL Server Activity

· (Level 300) Tracing SQL Server Activity

· (Level 200) Using DDL Triggers

· (Level 200) Using Event Notifications

After completing this module, students will be able to:

· Examine the current activity in a SQL Server instance.

· Use SQL Server Profiler to trace server and database activity.

· Use DDL triggers to monitor changes to the structure of database objects.

· Use event notifications to capture and monitor significant events for a SQL Server instance.

Module 10: Troubleshooting and Performance Tuning

The students will learn how to troubleshoot a variety of common SQL Server problems. Students will also learn how to tune SQL Server for improved performance using a variety of tools.

Lessons

· Troubleshooting SQL Server

· Performance Tuning in SQL Server

· Using Resource Governor

· Using Data Collector

Lab : Troubleshooting and Performance Tuning

· (Level 300) Troubleshooting Connectivity Problems

· (Level 300) Troubleshooting Concurrency Problems

· (Level 300) Using the Database Engine Tuning Advisor

· (Level 300) Implementing Resource Governor

· (Level 300) Implementing Data Collector

After completing this module, students will be able to:

· Troubleshoot common SQL Server problems, such as connectivity, concurrency, and job and disk space problems.

· Perform basic performance tuning tasks in SQL Server using the Database Engine Tuning Advisor, index tuning, and query tuning.

· Use Resource Governor to manage SQL Server workloads and resources.

· Use Data Collector to obtain performance data about your computer and the instances of SQL Server running on your computer.

Before attending this course, students must have:

· Basic knowledge of the Microsoft Windows operating system and its core functionality.

· Working knowledge of Transact-SQL.

· Working knowledge of relational databases.

· Some experience with database design.

Pre-requisites

Before attending this course, students must have:

· Basic knowledge of the Microsoft Windows operating system and its core functionality.

· Working knowledge of Transact-SQL.

· Working knowledge of relational databases.

· Some experience with database design.

ABOUT THE INSTRUCTOR

Pinal Dave

Pinal Dave is a Microsoft SQL Server MVP actively involved in community service in India through his technology blog and website SQLAuthority.com. He proficient Principal Database Architect, Developer, Administrator and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science (Computer Networks) and has accomplished a number of certifications including MCDBA and MCAD (.NET). He is an expert in SQL Server 2008 / SQL Server 2005 technologies. At present, he leads two user groups - Gandhinagar SQL Server User Group and Ahmedabad SQL Server User Group. He has also been awarded Regional Mentor for PASS Asia.

Since his time of working as a Teaching Assistant in the University of Southern California, Los Angeles, CA, teaching has been Pinal's expertise and passion. From then on, he pursued his teaching role and taught various students groups, corporates and technology organizations as well as spoke in several SQL Server events. A profuse writer, he has authored around 1200 SQL Server articles at SQLAuthority.com and is a regular columnist for several prominent IT websites and magazines. His Blog articles range from SQL Server 2005 technologies and SQL Server 2008 to Business Intelligence.

Technology Specialties

· SQL Server 2008/2005 Architecture, Design and Tuning

· Query Optimization and Server Tuning

· Database Health Analysis and Reporting

Professional Certifications

· MCDBA – Microsoft Certified Database Administrator

· MCAD – Microsoft Certified Application Developer

Professional Affiliations

· Professional Association of SQL Server (PASS) – http://www.sqlpass.org

Education

· Univercity of Southern California

Los Angeles, CA, USA – Masters of Science – Computer Networks

· Nirma Institutes of Technology - Gujarat Univercity
Ahmedabad, India – Bachelor of Engineering (Electronics & Communication)

Professional Experience

Digicorp Information Systems Pvt. Ltd. Ahmedabad, India

Digicorp is a leading and globally accepted IT service provider, offering a wide array of software services ranging from Healthcare Solutions to Smartphone Application Development, thereby incorporating a broad range of technologies. We believe in delivering finest outcome to our customers through a combination of process, quality frameworks and service delivery innovation, enabling them to achieve substantial differential advantage over their competitors.

· Designed and implemented complex database architecture; implemented strategies for database high availability and scalability

· Introduced strategic advancements in the query optimization and performance improvement

· Communicated and represented ideas through data model documentation and ensured that documentation was current

· Established standards for SQL installations, maintenance, tuning, and coding

· Lead in the development of our OLAP data warehouse reporting initiative

· Provided training, mentoring, and feedback to team members to enhance communication and performance

· Take ownership of current operational data structures and initiate optimizations and reconfigurations as warranted

· Envisioned and presented employees’ ideas on the concepts of technologies to management to enhance staff development and boost team spirit

Excellence Infonet Ahmedabad, India

· Designed and implemented complex database architecture

· Implemented strategies for database highly availability and scalability

· Provided leadership to employees for web site production

· Researched and implemented production methodologies and documented system

· Create bug tracking database and quality assurance systems to organize project assets, reduce time and locate assets

· Design systems to collect, organize, and display electronic correspondence to increase client satisfaction and management expectations

Leading Automobile Organization Las Vegas, USA

I was part of the organization, which is the leading provider of integrated Internet Marketing technology and services to the automotive marketplace. Our fully-integrated and automated solution makes it easy to consolidate your dealership’s separate Internet marketing systems into a single, more effective solution. Dealerships using our solution experience a dramatic, measurable increase in lead generation and sales.

· Responsible for logical and physical design for application and database tuning

· Major activities included advanced performance tuning, database design, and capacity planning

· Establishing standards for SQL installations, maintenance, tuning, and coding standards

· Architected and implemented large volume of Leads Management System

· Established Data Mining Algorithms to create Self Learning Automated System

· Designed Single Page Application and implemented Database Driven navigation

· Established and wrote Performance Tuning guidelines to enhance quality of product

· Redesigned a thorough backup and recovery strategy for all major production systems

· Upgraded all SQL Server 2000 to SQL Server 2005, without service interruption

· Effectively managed outsourcing team in India

Microsoft Course 6231A: Maintaining a Microsoft SQL Server 2008 Database Technical Boot Camp Training

Date:

March 31 to April 4, 2010 (Wednesday-Sunday) 5 full days

Time:

10.00am – 6.00pm

Venue:

Brain Works Learning Solutions Center Pvt Ltd (Kathmandu Branch)

Unlimited Buidling, Khichapokhari, Opp Pashupati Plaza, Kathmandu, Nepal

Phone: 2011302, 2011303, 2010311

(includes Microsoft Official Curriculum, Exam Voucher, Certificate Signed by Bill Gates and the genuine SQL Server 2008 NFR Software)

Registration
For registration and enquiries, please call us at 2011302, 2011303, 2010311or email to brainworks@unlimit.com.

About the course:

· This course provides students with the knowledge and skills to recommend and maintain Microsoft SQL Server 2008

Participants will sit for the exam (Exam 70-432: Microsoft Certified Technical Specialist: Microsoft SQL Server 2008, Installation and Maintenance) after the training course.

WHO SHOULD ATTEND:

This course is intended for technical professionals who are maintaining Microsoft® SQL Server. The Boot Camp will be conducted in a hands-on-lab type environment in order to provide for maximum interactivity and includes technical content of Level 200 or higher.

For All Your other IT Training Needs, contact

Brain Works Learning Solutions Center Pvt Ltd

BrainWorks Learning Solutions Center Pvt Ltd

Microsoft Gold Certified Partner for Learning Solutions

Unlimited Buidling, Khichapokhari, Opp Pashupati Plaza, Kathmandu, Nepal

Email: brainworks@unlimit.com Phone: 2011302, 2011303, 2010311 URL:http://www.unlimit.com

Microsoft MDP Nepal

Unlimited Technologies Pvt Ltd

Overview

Overview

Pre-requisites