MCDBA Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of Microsoft Certified Database Administrator




Total 168 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
MCDBA
MCDBA 2003 (SQL Server 2000)
MCSE MCTS MCITP MCSA MCP MCDBA
Microsoft .NET Applications MCSD/MCAD/MCDBA
SQL Server 2000 Admin MCDBA MCSA MCSE


MCDBA (Certificate)

Course Format: Classroom
School/Trainer: Student Shelter In Computers
Training Center(s)/Venue(s): Lahore, Pakistan

A Microsoft Certified Database Administrator (MCDBA) certification enables IT professionals to demonstrate their ability to design, implement, and administer Microsoft SQL Server databases.

MCDBA (Certificate)

Course Format: Classroom
School/Trainer: Victorian Institute of Technology
Training Center(s)/Venue(s): Melbourne, Australia
  V

70-290 - Managing and Maintaining a Microsoft Windows Server 2003 Environment
70-293 - Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
70-228 - Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
70-229 - Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

MCDBA (Certificate)

Course Format: Classroom
School/Trainer: LaSalle Computer Learning Center
Training Center(s)/Venue(s): Orlando, Tampa, United States
  V



Microsoft Certified Database Administrators (MCDBAs) design, implement, and administer Microsoft SQL Server?databases.

Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server?2000 candidates need to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of SQL Server databases.

Microsoft Windows Server?2003 exams now can be used to fulfill the networking systems core exam requirement in combination with SQL Server 2000 exams.

Courses

Core Exams (3 Exams Required)

? Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

? Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

? Managing and Maintaining a Microsoft Windows Server 2003 Environment

Microsoft .NET Applications MCSD/MCAD/MCDBA (Certificate)

Course Format: Online
School/Trainer: e-Careers Limited
Training Center(s)/Venue(s): Stansted Mountfitchet, United Kingdom
  V

Windows Forms - Duration : 2 Hour(s)
Create forms and set properties using Windows Form Designer
Build graphical interface elements with System.Drawing namespace
Add controls to a Windows form and the code to handle control events
Understand control-based, keystroke-level, and field-level input validation
Understand and implement exception handling
Components, Assemblies, and Services - Duration : 2 Hour(s)
Create custom components using Component, Control and UserControl classes, and extend control functionality through visual inheritance
Understand the types of assemblies in the .NET framework
Instantiate and invoke a Web Service
Access Windows API through Platform Invoke
Use ActiveX controls and COM components
Data Binding and Data Manipulation: Online Training - Duration : 3 Hour(s)
Bind data to user interface using simple and complex data binding techniques
Understand how to transform and filter data at the server and within the client application
Access, manipulate, and consume data from file-based data storage,... [Read More]

SQL Server 2000 Admin MCDBA MCSA MCSE (Certificate)

Course Format: Online
School/Trainer: e-Careers Limited
Training Center(s)/Venue(s): Stansted Mountfitchet, United Kingdom
  V

Basic Concepts and Installation - Duration : 2 Hour(s)
Understand basic database structure and terminology Identify basic requirements for installing the various editions of SQL Server 2000 Select an installation type and desired components Understand the file path structure Identify the network libraries used for connection to an instance Install a named instance
Advanced Installation - Duration : 2 Hour(s)
Add and remove components Uninstall an instance of SQL Server 2000 Perform a remote installation Create an unattended installation file for deployment on multiple servers Add and remove nodes from a virtual server Perform SQL Server 2000 upgrades
Creating and Managing Databases - Duration : 2 Hour(s)
Plan proper data and log file placement for a new database Understand how to create and use filegroups Create and delete a database using GUI and command-line methods Restrict database access to Single-User Mode and restore normal access Perform Attach and Detach operations on a database Use the Enterprise Manager to modify existing database objects, including tables, views and stored procedures
Disaster Recovery and D... [Read More]

MCDBA (Certificate)

Course Format: Classroom
School/Trainer: Chandler-Gilbert Community College
Training Center(s)/Venue(s): Chandler, Mesa, United States
  V

Certification is done by Microsoft Corporation. Microsoft certification depends on successful completion of Microsoft certification exams, not on completion of the courses at CGCC, although successful completion of the courses helps to prepare you for the industry exams. Information about the current certification requirements can be found at Microsoft. It is always a good idea to check the Microsoft site often, as it will give you information related to current certification requirements, and expected changes. Each of the certification exams has a cost, usually over $100 per attempt. Exams must be taken at an authorized testing center.

How long will it take me to finish the courses need for a MCDBA certification?

You will need to complete all five courses in the Microsoft Database Administration Certification of Completion. The majority of Microsoft classes meet for approximately 3- 4 hours per week for 16 weeks, the length of our usual semester. Some classes may be offered in a 6 - 8 week format or a distance learning format but require students to complete more or all work outside of class. At the rate of two classes per semester, the entire sequence wo... [Read More]

MS SQL Server Administration

Course Format: Classroom
School/Trainer: New York University School of Continuing and Professional Studies
Training Center(s)/Venue(s): New York City, United States
  V

Microsoft SQL Server is a leading relational database management system for the Windows platform and an increasingly important competitor in the overall database market. This skill-based course teaches students how to design and administer SQL Server databases. Learn how to install and configure SQL Servers; create, modify, and populate databases; back up and restore data; administer database security; and monitor performance and availability. By the end of the course, students can take responsibility for assuring that system users have ready access to all data they are authorized to view or change.

SQL Server 2005 (Certificate)

Course Format: Classroom
School/Trainer: IIHT
Training Center(s)/Venue(s): Bangalore, India

Course descriptions about SQL Server 2005 is available on request. Please contact IIHT by submitting the training request form.

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in California
Training Center(s)/Venue(s): Fresno, Irvine, Los Angeles, Orange, Riverside, Sacramento, San Diego, San Francisco, San Jose, United States
  V

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Reporting Services and its components.
?Create a Reporting Services report.
?Enhance a Reporting Services report.
?Create and manipulate data sets.
?Use report models to implement reporting for business users.
?Configure report publishing and execution settings.
?Implement subscriptions for reports.
?Administer Reporting Services.
?Implement custom Reporting Services applications.

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in California
Training Center(s)/Venue(s): Fresno, Irvine, Los Angeles, Orange, Riverside, Sacramento, San Diego, San Francisco, San Jose, United States
  V

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Integration Services and its tools.
?Create an Integration Services package.
?Implement control flow in an Integration Services package.
?Implement data flow in an Integration Services package.
?Implement logging in an Integration Services package.
?Debug and implement error handling in an Integration Services package.
?Implement checkpoints and transactions in an Integration Services package.
?Deploy an Integration Services package.
?Manage and secure an Integration Services package.

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in California
Training Center(s)/Venue(s): Fresno, Irvine, Los Angeles, Orange, Riverside, Sacramento, San Diego, San Francisco, San Jose, United States
  V

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

Audience
The primary audience for this course is individuals who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.

At Course Completion
After completing this course, students will be able to:
?Describe how SQL Server Analysis Services can be used to implement analytical solutions.
?Create multidimensional analysis solutions with SQL Server Analysis Services.
?Implement dimensions and cubes in an Analysis Se... [Read More]

Implementing a Microsoft SQL Server 2008 Database

Course Format: Classroom
School/Trainer: ONLC Training Centers in California
Training Center(s)/Venue(s): Fresno, Irvine, Los Angeles, Orange, Riverside, Sacramento, San Diego, San Francisco, San Jose, United States
  V

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

Audience
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:
?Create databases and database files.
?Create data types and tables.
?Use XML-related features in Microsoft SQL Server 2008.
?Plan, create, and optimize indexes.
?Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
?Implement data integrity in Microsoft SQL Server 2008 by using triggers.
?Implement views.
?Implement stored procedures.
?Implement functions.
?Implement managed code in the database.
?Manage transactions and locks.
?Use Service Broker to build a messaging-based solution.

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Arizona
Training Center(s)/Venue(s): Phoenix, Scottsdale, Tucson, United States
  V

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Reporting Services and its components.
?Create a Reporting Services report.
?Enhance a Reporting Services report.
?Create and manipulate data sets.
?Use report models to implement reporting for business users.
?Configure report publishing and execution settings.
?Implement subscriptions for reports.
?Administer Reporting Services.
?Implement custom Reporting Services applications.

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Arizona
Training Center(s)/Venue(s): Phoenix, Scottsdale, Tucson, United States
  V

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Integration Services and its tools.
?Create an Integration Services package.
?Implement control flow in an Integration Services package.
?Implement data flow in an Integration Services package.
?Implement logging in an Integration Services package.
?Debug and implement error handling in an Integration Services package.
?Implement checkpoints and transactions in an Integration Services package.
?Deploy an Integration Services package.
?Manage and secure an Integration Services package.

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Arizona
Training Center(s)/Venue(s): Phoenix, Scottsdale, Tucson, United States
  V

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

Audience
The primary audience for this course is individuals who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.

At Course Completion
After completing this course, students will be able to:
?Describe how SQL Server Analysis Services can be used to implement analytical solutions.
?Create multidimensional analysis solutions with SQL Server Analysis Services.
?Implement dimensions and cubes in an Analysis Se... [Read More]

Implementing a Microsoft SQL Server 2008 Database

Course Format: Classroom
School/Trainer: ONLC Training Centers in Arizona
Training Center(s)/Venue(s): Phoenix, Scottsdale, Tucson, United States
  V

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

Audience
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:
?Create databases and database files.
?Create data types and tables.
?Use XML-related features in Microsoft SQL Server 2008.
?Plan, create, and optimize indexes.
?Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
?Implement data integrity in Microsoft SQL Server 2008 by using triggers.
?Implement views.
?Implement stored procedures.
?Implement functions.
?Implement managed code in the database.
?Manage transactions and locks.
?Use Service Broker to build a messaging-based solution.

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Colorado
Training Center(s)/Venue(s): Boulder, Centennial, Colorado Springs, Denver, Grand Junction, United States
  V

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Reporting Services and its components.
?Create a Reporting Services report.
?Enhance a Reporting Services report.
?Create and manipulate data sets.
?Use report models to implement reporting for business users.
?Configure report publishing and execution settings.
?Implement subscriptions for reports.
?Administer Reporting Services.
?Implement custom Reporting Services applications.

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Colorado
Training Center(s)/Venue(s): Boulder, Centennial, Colorado Springs, Denver, Grand Junction, United States
  V

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

At Course Completion
After completing this course, students will be able to:
?Describe SQL Server Integration Services and its tools.
?Create an Integration Services package.
?Implement control flow in an Integration Services package.
?Implement data flow in an Integration Services package.
?Implement logging in an Integration Services package.
?Debug and implement error handling in an Integration Services package.
?Implement checkpoints and transactions in an Integration Services package.
?Deploy an Integration Services package.
?Manage and secure an Integration Services package.

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Course Format: Classroom
School/Trainer: ONLC Training Centers in Colorado
Training Center(s)/Venue(s): Boulder, Centennial, Colorado Springs, Denver, Grand Junction, United States
  V

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

Audience
The primary audience for this course is individuals who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.

At Course Completion
After completing this course, students will be able to:
?Describe how SQL Server Analysis Services can be used to implement analytical solutions.
?Create multidimensional analysis solutions with SQL Server Analysis Services.
?Implement dimensions and cubes in an Analysis Se... [Read More]

Implementing a Microsoft SQL Server 2008 Database

Course Format: Classroom
School/Trainer: ONLC Training Centers in Colorado
Training Center(s)/Venue(s): Boulder, Centennial, Colorado Springs, Denver, Grand Junction, United States
  V

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

Audience
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:
?Create databases and database files.
?Create data types and tables.
?Use XML-related features in Microsoft SQL Server 2008.
?Plan, create, and optimize indexes.
?Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
?Implement data integrity in Microsoft SQL Server 2008 by using triggers.
?Implement views.
?Implement stored procedures.
?Implement functions.
?Implement managed code in the database.
?Manage transactions and locks.
?Use Service Broker to build a messaging-based solution.

Pages: 1 2 3 4 5 6 ...


Find MCDBA training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Facts:
This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!



- Other Topics -
- Online/E-learning -
MCDBA
Ask for Training
Add Courses