|
|
 |
|
|
| |
Certifications Programs
Multicultural Programs
ALL COURSES
System Administration for SQL Server 2000
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system. This course will help students prepare for exam 70-228 (SQL Server 2000).
Prerequisite: Familiarity with the role of the database administrator and experience using the Microsoft Windows NT Server network operating system.
Length: 5 Days
|
Implementing and Designing Databases on SQL Server 2000
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system. This course will help students prepare for exam 70-228 (SQL Server 2000).
Prerequisite: Familiarity with the role of the database administrator and experience using the Microsoft Windows NT Server network operating system.
Length: 5 Days
|
Mastering Microsoft Visual Basic 6 Development
This course teaches Microsoft Visual Basic programmers how to create database applications using components. Students will be able to write a Microsoft Visual Basic-based application that accesses data from a database; write a Visual Basic-based application that uses component object model (COM) components; create an ActiveX control; create a COM component; and list the opportunities that Visual Basic developers have to incorporate Internet technologies into their applications. This course helps student prepare for exam number 70-176.
Prerequisite: Student must have a good working knowledge of the Visual Basic programming system.
Length: 5 Days
|
Mastering Enterprise Development Using Microsoft Visual Basic 6
This course will teach Microsoft Visual Basic programmers, who currently build desktop applications and access corporate databases, the basics of how to build three-tier client/server solutions. At the end of the course, student will be able to compare traditional client/server development with Internet development; use the application architecture model from Microsoft solutions framework; use the Visual Basic programming system to build component object model (COM) dynamic-link libraries (DLLs); use MTS to address application infrastructure issues; create COM objects; use programming techniques to increase the scalability of COM objects; and apply basic debugging, error handling, and security techniques in a three-tier application. This course helps prepare students for exam number 70-175.
Prerequisite: Course assumes student has intermediate programming competency of the Visual Basic programming system. Course 1013 - Mastering Microsoft Visual Basic 6 Development
Length: 5 Days
|
Microsoft Exchange Server 5.5 Series Concepts and Administration
This introductory course in the Microsoft Exchange Server 5.5 Series is intended to Exchange Server system administrators who administer, monitor, and maintain established Exchange Server organization. The goal of this course is to provide Exchange Server administrators with the skills required to perform day-to-day management of an established Exchange Server organization. This course will help students prepare for exam number 70-081.
Prerequisite: Course #2152 - Implementing Microsoft Windows 2000 Professional & Server or Course #803 - Administering Windows NT 4.0 or equivalent skills and knowledge.
Length: 4 Days
|
Microsoft Exchange Server 5.5 Series Design and Implementation
This course is intended for Microsoft Exchange Server system architects and designers, who plan, install, configure, customize, and troubleshoot Exchange Server deployments. The goal of this course is to provide students with the knowledge and skills required to design and implement an Exchange Server organization. Course 973 builds upon the base of knowledge that students gained in course 1026. This course will help prepare students for exam number 70-081.
Prerequisite: Course #1026 - Microsoft Exchange Server 5.5 Series Concepts & Administration.
Length: 5 Days
|
Updating Support Skills from Microsoft Windows NT 4.0 to Windows 2000
This course is to provide Microsoft Windows NT 4.0 support professionals with the knowledge and skills necessary to support Microsoft Windows 2000-based networks. This is a performance-based course; designed around the job-related tasks a support professional must perform using new or modified features in the Windows 2000 operating system. This course will help students prepare for exam number 70-240.
Prerequisite: Administering Windows NT 4.0 or equivalent skills and knowledge.
Length: 5 Days
|
Designing a Microsoft Windows 2000 Directory Services Infrastructure
This course provides students with the knowledge and skills necessary to design a Microsoft Windows 2000 directory services infrastructure in an enterprise network. Strategies are presented to assist the student in identifying the information technology needs of an organization, and then designing an Active Directory structure that meets those needs. This course will help students prepare for exam number 70-219.
Prerequisite: Course # 2154 - Implementing & Administering Windows 2000 Directory Services.
Length: 3 Days
|
Designing a Microsoft Windows 2000 Networking Services Infrastructure
This course provides students with the information and skills needed to create a networking services infrastructure design that supports the required network application. Each module provides a solution based on the needs of the organization. Some Microsoft Windows 2000 network solutions require a single technology, such as DHCP, to provide Internet Protocol (IP) address configuration support. In other situations, several technology options exist, such as Open Shortest Path First (OSPF), Routing Information Protocol (RIP), and Internet Group Management Protocol (IGMP), to design an IP routing scheme. This course will help students prepare for exam number 70-221.
Prerequisite: Course #2154 - Implementing & Administering Windows 2000 Directory Services.
Length: 4 Days
|
Gathering and Analyzing Business Requirements
This workshop teaches participants to gather, analyze, and present business processes and requirements. Participants will learn how to develop and communicate a vision document that captures the business requirements and solution goals by using the appropriate Microsoft Solutions Framework (MSF) models and processes. This course will help prepare students for exam number 70-100.
Prerequisite: This course assumes that the students has 6 months of experience in a business environment; a general understanding of a software life cycle model; and a general knowledge of Microsoft technologies.
Length: 3 Days
|
Designing Data Services and Data Models
This workshop teaches students to analyze business requirements to determine data storage and data access requirements. Participants will learn to design data models and the data layer of Microsoft Windows DNA architecture, and select the appropriate Microsoft technologies. This course will help prepare students for exam number 70-100.
Prerequisite: Course #1585 - Gathering and Analyzing Business Requirements.
Length: 2 Days
|
Building XML - Based Web Applications
This course teaches developers how to structure and validate in a document by using document type definitions (DTDs). Students also learn how to get data from a database using XML and how to present that data using XSL.
Prerequisite: Course #1013, Mastering VB 6 Development or Course #1017, Mastering Web Application Development Using Visual InterDev 6. Students should have some knowledge of HTML, relational databases and some programming experience.
Length: 5 Days
|
Exchanging and Transforming Data Using XML and XSLT
This course teaches developers techniques for exchanging and transforming data by using the Extensible Markup Language (XML) and Extensible Stylesheet Language Transformations (XSLT). This course describes best practices for XML and XSLT and gives compelling examples of the best ways to solve real-world problems.
Prerequisite: Students should have a moderate experience in HTML, XML, Visual Basic, VB Script or Javascript, COM objects, ASP pages, Visual C++ and/or taken Course 1905, 1013, or 1017.
Length: 5 Days
|
System Administration for SQL Server 2000
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system. This course will help students prepare for exam 70-228 (SQL Server 2000).
Prerequisite: Familiarity with the role of the database administrator and experience using the Microsoft Windows NT Server network operating system.
Length: 5 Days
|
Implementing and Designing Databases on SQL Server 2000
TThis course provides students with the technical skills required to implement a database solution with Microsoft SQL Server client/server database management system. This course will help students prepare for exam number 70-229 (SQL Server 2000).
Prerequisite: Course #2072 - System Administration for SQL Server 2000 and experience using the Microsoft Windows NT® Server network operating system.
Length: 5 Days
|
Building XML - Enabled Applications Using Microsoft SQL Server 2000
This course teaches client database developers techniques for building applications that exchange data with Microsoft SQL Server in Extensible Markup Language (XML) format. Students will learn how to query, insert, update and delete data from a database by using XML, and how to publish SQL data as XML.
Prerequisite: Students should have written basic Transact-SQL query, insert or update statements, have a basic understanding of XML, ADO, VB Script, HTML and ASP.
Length: 3 Days
|
Introduction to Visual C# Programming
This course will provide students with the knowledge and skills that they need to develop applications with the
Visual C# development systems for the .NET platform. The course will focus of on C# programming structure,
language syntax, and implementation details.
Prerequisite: Experienced with C, C++, Visual Basic programming.
Length: 5 Days
|
Designing a Secure Microsoft Windows 2000 Network
This course provides students with the knowledge and skills necessary to design a security framework for small, medium, and enterprise networks by using Microsoft Windows 2000 technologies. This course contains four units that describe the securing of specific areas of the network: Providing Secure Access the Local Network Users, (2) Providing Secure Access to Remote Users and Remote Offices, (3) Providing Secure Access Between Private and Public Networks, (4) Providing Secure Access to Partners. This course will help students prepare for exam number 70-220.
Prerequisite: Course #2154 - Implementing & Administering Windows 2000 Directory Services.
Length: 5 Days
|
Microsoft Windows 2000 Network and Operating System Essentials
This course is to provide individuals who are new to Microsoft Windows 2000 with the knowledge necessary to understand and identify the tasks involved in supporting Windows 2000 networks. This is an introductory course designed to provide an overview of networking concepts and how they are implemented in Windows 2000. This course will help students prepare for exam number 70-210 and 70-215.
Prerequisite: Student must have a good working knowledge of the Visual Basic programming system.
Length: 3 Days
|
Implementing Microsoft Windows 2000 Professional and Server
This course provides students with the knowledge necessary to install and configure Windows 2000 Professional on stand-alone computers and on client computers that are part of a workgroup or a domain. In addition, this course provides the skills and knowledge necessary to install and configure Windows 2000 Server to create file, print, Web, and Terminal servers. This course will help students prepare for exam number 70-210 and 70-215.
Prerequisite: Course #2151 - Windows 2000 Network & Operating System Essentials.
Length: 5 Days
|
Implementing a Microsoft Windows 2000 Network Infrastructure
This course is for support professionals who are new to Microsoft Windows 2000 and will be responsible for installing, configuring, managing, and supporting a network infrastructure that uses the Microsoft Windows 2000 Server products. This course will help students prepare for the exam number 70-216.
Prerequisite: Course #2152 - Implementing Microsoft Windows 2000 Professional & Server
Length: 5 Days
|
Implementing & Administering Windows 2000 Directory Services
This course is designed to provide students with the knowledge and skills necessary to install, configure, and administer the Microsoft Windows 2000 Active Directory™ service. The course also focuses on implementing Group Policy and understanding the Group Policy tasks required to centrally manage users and computers. This course will help students prepare for exam number 70-217.
Prerequisite: - Course #2153 - Implementing a Microsoft Windows 2000 Network Infrastructure
Length: 5 Days
|
MICROSOFT OFFICE
Microsoft ACCESS (Beginning to Intermediate)
TThis course provides an in-depth understanding of designing a database, creating a database, querying a database, maintaining a database, importing an Excel worksheet into an Access database, and creating reports and forms. This course is offered in English and/or Russian languages.
Prerequisite: Course #9001, Introduction to PC and Office 2000.
Length: 5 Days
|
MS Word (Beginning, Intermediate or Advanced)
This course covers the basic to intermediate concepts of Microsoft Word, including designing, creating, editing, and enhancing documents. This course will also include working with styles and graphics, merging documents, and sharing Word document information with other programs. This course can be customized to meet client needs.
Prerequisite: None.
Length: 1 Day
|
MS Excel (Beginning, Intermediate or Advanced)
This course covers the basic to intermediate concepts of Microsoft Excel including working with charts, formulas, and functions. This course also includes managing workbooks, automating tasks, using and analyzing data, enhancing charts and worksheets, and working with Excel and the Internet. This course can be customized to meet client needs.
Prerequisite: None.
Length: 1 Day
|
MS Outlook (Beginning, Intermediate or Advanced)
This course covers how to create and send electronic mail (e-mail), respond to -email, schedule appointments, create meeting requests, work with a directory of contracts; create tasks on an electronic to-do list; track activities, times, and ideas in an online journal; and manage your Outlook folders. This course can be customized to meet client needs.
Prerequisite: None.
Length: 1 Day
|
PROGRAMMING/INTERNET
Introduction to PC and Office 2000
This course is designed to introduce you to Windows 98, by working with programs, files, and folders. This course also includes introduction Internet Explorer 5, editing, proofing and formatting documents in WORD. Getting Started with Excel 2000 by building, editing, formatting a worksheet and working with charts. Getting Started with Access 2000 by creating and using tables, queries, forms and reports. This course is offered in English and/or Russian languages.
Prerequisite: None
Length: 4 Days
|
HTML (Beginning-Intermediate)
This course provides a solid introduction to HTML code and web page design. Topics include creating and designing a web page; adding tables; and using frames in a web design, Advanced features of HTML advanced site design techniques and discussing Win NT scripting tools and examples of different scripting languages.
Prerequisite: None
Length: 4 Days
|
Introduction to Microsoft Visual Basic 6.0 and Databases
In this class students will learn how to plan and create their own interactive Windows applications. They will know how to write IF..Then..Else.., Select Case and For …Next statements. In additional they will learn how to create executable files and how to include multiple forms in a project. They also learn the basic concepts of databases and why it is important related to programming. This course can be customized to meet client needs.
Prerequisite: Introduction to PC and Office 2000, programming concepts.
Length: 6 Days
|
WEB DEVELOPMENT and .NET
HTML/Front Page
This hands-on course will enable you to create pages for the Internet. Topics include learning the basic building blocks of Web authoring, creating your own Web pages and working with advanced features of HTML, including tables, frames, animation, server functionality, and advanced site design techniques; and discussing WinNT scripting tools and examples of different scripting languages. Students will also learn the types of Web solutions that can be created using FontPage 2000.
Prerequisite: None
Length: 5 Days
|
XML
This course explains the differences between HTML and XML. Topics include creating a well-formed XML document; identifying the components of SML documents; creating a simple DTD and validating XML documents; and applying simple CSS and XSL style sheets to XML documents to generate HTML output.
Prerequisite: Familiarity with HTML
Length: 5 Days
|
JavaScript
This hands-on course will go beyond the basics to cover such JavaScript topics as conditionals, functions, objects, properties, methods, event handlers, form and frames to give student the ability to add functionality to their web site. Students will learn the most efficient way to understand the Web page development cycle by defining the problem, analyzes it, and then develops a solution.
Prerequisite: Familiarity with HTML
Length: 2 Days
|
Building XML - Based Web Applications
This course teaches developers how to structure and validate in a document by using document type definitions (DTDs). Students also learn how to get data from a database using XML and how to present that data using XSL.
Prerequisite: Course #1013, Mastering VB 6 Development or Course #1017, Mastering Web Application Development Using Visual InterDev 6. Students should have some knowledge of HTML, relational databases and some programming experience.
Length: 5 Days
|
Exchanging and Transforming Data Using XML and XSLT
This course teaches developers techniques for exchanging and transforming data by using the Extensible Markup Language (XML) and Extensible Stylesheet Language Transformations (XSLT). This course describes best practices for XML and XSLT and gives compelling examples of the best ways to solve real-world problems.
Prerequisite: Students should have a moderate experience in HTML, XML, Visual Basic, VB Script or Javascript, COM objects, ASP pages, Visual C++ and/or taken Course 1905, 1013, or 1017.
Length: 5 Days
|
Building XML - Enabled Applications Using Microsoft SQL Server 200
This course teaches client database developers techniques for building applications that exchange data with Microsoft SQL Server in Extensible Markup Language (XML) format. Students will learn how to query, insert, update and delete data from a database by using XML, and how to publish SQL data as XML.
Prerequisite: Students should have written basic Transact-SQL query, insert or update statements, have a basic understanding of XML, ADO, VB Script, HTML and ASP.
Length: 3 Days
|
Introduction to ASP . NET Course
The goal of this course is to teach students how to create a simple ASP .NET application that delivers dynamic content to the Web.
Prerequisite: Students should have basic understanding of HTML, programming in Visual Basic or Visual Basic Script, ADO and creating ASP pages.
Length: 3 Days
|
Introduction to Visual C# Programming
This course will provide students with the knowledge and skills that they need to develop applications with the Visual C# development systems for the .NET platform. The course will focus of on C# programming structure, language syntax, and implementation details.
Prerequisite: Experienced with C, C++, Visual Basic programming.
Length: 5 Days
|
Mastering Visual Basic 6.0 plus Crystal Reports
Crystal Reports 8.5
Seagate Crystal Reports is the leading software product for creating customized reports from a database. Crystal Reports has the flexibility to create many different types of reports from a variety of databases.
MS Access, MS SQL Server, Oracle, Sybase to name a few. Crystal Reports is appropriate for end-users who are responsible for creating or modifying reports from a database, or developers who must create reports for others.
Crystal Reports 8.5 Introductory (Report Design I)
This two-day course is designed for the novice Crystal Reports user who needs to quickly become proficient in creating and modifying reports. Some of the topics include planning a report, creating a basic report, record selection, sorting, grouping and summarizing, charting, and formulas such as basic calculations and running totals.
Prerequisite: Students must have a working knowledge of Windows applications. Basic knowledge of database concepts such as tables, fields and records is also necessary.
Crystal Reports 8.5 Advanced (Report Design II)
This two-day course is designed to build on the topics learned in Report Design I to increase report design skills and discover the reporting power of Crystal Reports. Along with hands-on practice, the course covers grouping options, formulas such as variables and functions, geographical mapping, parameters, cross-tabs, and report distribution.
Prerequisite: : Learners must have taken the Report Design I course and/or understand basic report design concepts such as linking, record selection, sorting, grouping, summarizing, basic formulas, conditional reporting and section formatting.
Sub-Reports & Advanced Formulas 8.5 (Report Design III)
This one-day course is designed to further increase report design skills by concentrating on advanced topics. Along with hands-on practice, the course covers architecture, report design and Structured Query Language, advanced formula creation such as arrays and control structures, subreports, and an XML overview as it relates to Crystal Reports.
Prerequisite: : Learners must have taken Report Design I and II courses or have a minimum of six months of report design experience with Crystal Reports and understand advanced report design concepts such as formulas, parameters, sections, cross-tabs, and report distribution options. Relational database knowledge is recommended.
Length: 5 Days
|
MCSE Track 2000
The Microsoft Certified Systems Engineer credential is the premier certification for professionals, who analyze the business requirements for system architecture, design solutions, deploy, install, configure architecture components, and troubleshoot system problems.
Certification requires examinees to pass five core exams and two elective exams, which provide a valid and reliable measure of technical proficiency and expertise.
CORE REQUIREMENTS:
Installing Configuring Windows 2000 Professional.
This course prepares students for exam number 70-210. Student will be introduced to Microsoft Windows and to the networking technologies it supports.
Prerequisite: A+ and Net+ Certification Recommended
Length: 5 Days
|
Installing Configuring Windows 2000 Server
This course prepares students for exam number 70-215. It provides students with the knowledge necessary to install and configure Windows 2000 Professional on stand-alone computers and on client computers that are part of a workgroup or a domain. This course provides the skills and knowledge necessary to install and configure Windows 2000 Professional Server to create file, print, and web servers.
Prerequisite: Installing Configuring Windows 2000 Professional
Length: 5 Days
|
Supporting a Microsoft Windows 2000 Network Infrastructure
This course prepares students for exam number 70-216. It is designed for new-to- product support professionals who will be responsible for installing, configuring, managing, and supporting a network infrastructure that uses the Microsoft Windows 2000 server family of products.
Prerequisite: Installing Configuring Windows 2000 Professional Server
Length: 5 Days
|
Implementing Administering Windows 2000 Directory Services
This course prepares students for exam number 70-217. It provides students with the knowledge and skills necessary to install, configure, and administer the Microsoft Windows 2000 Active Directory™ service. The course also focuses on implementing Group Policy and understanding the Group Policy tasks required to centrally manage users and computers.
Prerequisite: Supporting a Windows 2000 Network Infrastructure
Length: 5 Days
|
Designing a Microsoft Windows 2000 Directory Services Infrastructure
This course prepares students for exam 70-219. It provides senior support professionals network architects with the knowledge and skills necessary to design a Windows 2000 directory services infrastructure. Strategies are presented to assist the student in identifying the information technology needs of the organization, and then designing the Active Directory structure that meets those needs.
Prerequisite: Implementing Administering Windows 2000 Directory Services
Length: 5 Days
|
Windows 2000 Accelerated for MCP Certified on NT 4.0
This course prepares students for exam 70-240. Until December 31, 2001, individuals who have passed the three Windows NT 4.0 exams have the option of fulfilling part of the core exam requirement by passing Exam 70-240: Microsoft Windows 2000 Accelerated Exam for MCPs Certified on Microsoft Windows NT 4.0 instead of four of the core exams in the Windows 2000 track. As a benefit to MCPs, Microsoft is offering the accelerated exam free to eligible candidates. To protect exam integrity, eligible candidates will be able to take the accelerated exam only once.
Prerequisite: NT 4.0 Core Technologies
Length: 5 Days
|
ELECTIVES (Choose Two):
Designing a Secure Microsoft Windows 2000-Based Network
This course prepares students for exam 70-220. It provides students with the knowledge and skills necessary to design a security framework for small, medium, and enterprise networks using Microsoft Windows 2000 technologies.
Prerequisite: Implementing Administering Windows 2000 Directory Services
Length: 5 Days
|
Designing a Microsoft Windows 2000 Networking Services Infrastructure
This course prepares students for exam 70-221. It provides students with the knowledge and skills necessary to create a networking services infrastructure design that supports the required network applications.
Prerequisite: Implementing Administering Windows 2000 Directory Services Services
Length: 4 Days
|
System Administration for SQL Server 7.0
This course prepares students for the exam 70-028. At the end of the course, students will be able to describe SQL Server architecture; plan for a SQL Server installation; install SQL Server; configure SQL Server; manage files and databases; configure login security; plan and implement database permissions; back up databases; restore databases; automate administrative tasks using SQL Server Agent; import, export and transform data; monitor and maintain SQL Server performance; and replicate data from one SQL Server to another.
Prerequisite: Familiarity with the role of the database administrator
Length: 5 Days
|
MCSD
The Microsoft Certified Solution Developer (MCSD) credential is the premium certification for professionals who design and develop custom business solutions with Microsoft development tools, technologies, and platforms. Certification requires examinees to pass three core exams and one elective exam.
The new track includes certification exams that test users' ability to build Web-based, distributed, and commerce applications by using Microsoft's products, such as Microsoft SQL™ Server, Microsoft Visual Studio, and Microsoft Component Services.
CORE REQUIREMENTS:
Desktop Applications with Visual Basic 6.0
This course prepares students for exam 70-176. It teaches Microsoft Visual Basic programmers how to create database applications using components. At the end of the course, students will be able to write a Microsoft Visual Basic based application that accesses data from a database; write a Visual Basic-based application that uses component object model (COM) components; create an ActiveX control; create a COM component; and list the opportunities that Visual Basic developers have to incorporate Internet technologies into their application.
Prerequisite: Student must have a good working knowledge of the Visual Basic programming system.
Length: 5 Days
|
Distributed Applications with Visual Basic 6.0
This course prepares students for exam 70-175. At the end of the course, student will be able to compare traditional client/server development with Internet development; use the application architecture model from Microsoft solutions framework; use the Visual Basic programming system to build component object model (COM) dynamic-link libraries (DLLs); use MTS to address application infrastructure issues; create COM objects; use programming techniques to increase the scalability of COM objects; and apply basic debugging, error handling, and security techniques in a three-tier application.
Prerequisite: Course assumes student has intermediate programming competency of the Visual Basic programming system.
Length: 5 Days
|
Analyzing Requirements and Defining Solution Architectures
This course prepares students for exam 70-100. It introduces developers to the opportunities and challenges of creating enterprise-level applications. Students will see how creating such flexible and scalable applications can be challenging. They will learn how to address these challenges by employing appropriate design, tools, and technology. Students will learn about key functionality provided by several development tools and technologies. Through demonstrations and animations they will learn how to use the tools. In controlled hands-on exercises, they will use the tools in the Microsoft Visual Studio development system and be guided through the creation of a sample application.
Prerequisite: This course assumes that the student has at least six months of experience in a business environment; a general understanding of a software life cycle model; and a general knowledge of Microsoft technologies.
Length: 5 Days
|
ELECTIVE:
Designing Implementing Databases on SQL Server 7.0
This course prepares students for exam 70-029. It provides students with the technical skills required to implement a database solution with Microsoft SQL Server client/server database management system version 7.0. At the end of this course students will be able to describe the elements of SQL Server 7 and the environments in which it can operate; describe the elements of the Transact-SQL language; describe and configure the data storage architecture; create manage files, file groups, databases, tables and transaction logs; create maintain indexes; write queries that summarize data; manage locking options transactions to ensure data concurrency recoverability; create vies of data; and work with distributed data..
Prerequisite: Experience using the Microsoft Windows NT® Server network operating system. System Administration on SQL Server 7
Length: 5 Days
|
MCDBA
The Microsoft® Certified Database Administrator credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases and install and configure Microsoft SQL Server.
Microsoft® Certified Database Administrators are required to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise.
CORE REQUIREMENTS:
Installing and Configuring Windows 2000 Server
This course prepares students for exam number 70-215. It provides students with the knowledge necessary to install and configure Windows 2000 Professional on stand-alone computers and on client computers that are part of a workgroup or a domain. This course provides the skills and knowledge necessary to install and configure Windows 2000 Server to create file, print, and web servers.
Prerequisite: Installing Configuring Windows 2000 Professional
Length: 5 Days
|
Implementing a Microsoft Windows 2000 Network Infrastructure
This course prepares students for exam number 70-216. It is designed for new-to-product support professionals who will be responsible for installing, configuring, managing, and supporting a network infrastructure that uses the Microsoft Windows 2000 server family of products.
Prerequisite: Installing and Configuring Windows 2000 Server
Length: 5 Days
|
System Administration for SQL Server 7.0
This course prepares students for the exam 70-028. At the end of the course, students will be able to describe SQL Server architecture; plan for a SQL Server installation; install SQL Server; configure SQL Server; manage files and databases; configure login security; plan and implement database permissions; back up databases; restore databases; automate administrative tasks using SQL Server Agent; import, export and transform data; monitor and maintain SQL Server performance; and replicate data from one SQL Server to another.
Prerequisite: Familiarity with the role of the database administrator.
Length: 5 Days
|
ELECTIVE:
Implementing a Database on SQL Server 7.0
This course prepares students for exam 70-029. At the end of this course students will be able to describe the elements of SQL Server 7 and the environments in which it can operate; describe the elements of the Transact-SQL language; describe and configure the data storage architecture; create manage files, file groups, databases, tables and transaction logs; create maintain indexes; write queries that summarize data; manage locking options transactions to ensure data concurrency recoverability; create vies of data; and work with distributed data.
Prerequisite: Experience using the Microsoft Windows NT® Server network operating system. Administering SQL Server 7
Length: 5 Days3
|
A+ Certification
Core and Dos/Windows Module
A+ Certification is a testing program, which certifies the competency of service technicians in the computer industry. A+ Certification is a way to ensure that you can provide an industry recognized standard of technical expertise. This program will give students the vocabulary and basic understanding of the PC operating environment. The two exams cover a broad range of hardware and software technologies, but are not related to any vendor-specific products and aimed at entry-level computer technicians. Successful completion of the A+ exams will give potential employers a measurement for knowing where he or she might be able to begin work.
Length: 7 Days (56 hours)
|
Core Outline:
- Basic computer service concepts
- General PC architecture
- Memory architectures
- Disk system architectures
- PC bus architectures
- Installation and upgrade issues
- Printers
- Networks
- Safety and maintenance issues
- Customer service techniques
- Troubleshooting
|
DOS/Windows Outline:
- Operating system architecture
- Operating system installation and configuration
- Preventive maintenance
- Installing and running applications
- MS-DOS and Windows networking
- Guarding against virus attacks
- Operating system management
- Application installation and configuration
- Networking
- Troubleshooting DOS and Windows
|
Net+ Certification
Net+ Certification
Candidates who earn the Network+ certification possess the knowledge needed to configure and install the TCP/IP client. The course covers a wide range of vendor and product neutral networking technologies that can also serve as a prerequisite for vendor specific IT certifications; such as, Novell, Lotus, 3Com and Cisco.
Prerequisite: A+ Certification
Length: 5 Days (40 hours)
|
|
|
| |
|
|
|
|
