Instructor Led Microsoft SQL Training Classes

Extended Features In Microsoft SQL Server 2000 Level 3 Presents and explains advanced features, tools, and capabilities of SQL Server 2000, including Data Transformation Services, XML formatting, Replication, Automated Administration, and Data Mining. Audience:Experienced Programmers already familiar with SQL Server 2000 seeking to take advantage of advanced features and capabilities. more...

SQL Server 2005 Analysis Services ...Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. Includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system more...

SQL Language This training course is for students who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data and the SQL language differences between SQL dialects (Oracle, T-SQL, ANSI) practical more...

Microsoft SQL Server 2000 Database Development ...s and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & triggers and creating stored procedures; relational more...

Implementing SQL Server 2005 ...des students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database. Audience This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database. At more...

8814 Microsoft Dynamics GP Installation and Configuration ...e and minimizes the installation time for your customers. Microsoft SQL Server 2005 is discussed as it applies specifically to Microsoft Dynamics GP. The course covers the installation of Microsoft Dynamics GP and the installation of the related products listed in the agenda. This course does not go into the setup and use of the application as these topics are covered by other classes offered more...

Microsoft Dynamics GP Installation and Configuration 8505 ...e and minimizes the installation time for your customers. Microsoft SQL Server is discussed as it specifically applies to the optimization of Microsoft Dynamics GP. The course covers the installation of Microsoft Dynamics GP and the installation of the related products that are listed in the agenda. This course does not discuss the setup and use of the application because these topics are more...

Microsoft MCDBA ...The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server2000 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 more...

MCITP Certification Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or more...

Maintaining a Microsoft SQL Server 2005 Database ...ts with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database. At more...

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 ...ow to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.   Audience This course is intended for current professional database more...

Microsoft BizTalk Server 2004 ...ise Architect Microsoft Internet Information Services 6.0 Microsoft SQL Server 2000 Enterprise Edition Microsoft SQL Server Analysis Services Microsoft SQL Server 2000 Service Pack #3 Microsoft Visual Basic 6.0 Microsoft Office 2003 (Including Microsoft InfoPath) WinZip 8.0 Adobe Acrobat Reader 5.0 Detailed Coverage: Day I Introducing Microsoft BizTalk Server 2004 What s New in more...

Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 Module 1: Introduction to Data Warehousing and OLAP Module 2: Introducing Analysis Manager Wizards Module 3: Understanding Analysis Services Architecture Module 4: Building Dimensions Using the Dimension Editor Module 5: Using Advanced Dimension Settings Module 6: Working with Cubes and Measures Module 7: Case Study - Creating the Store Expense Cube Module 8: Managing Storage and Optimization more...

Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 ...etwork environment. Experience installing and configuring Microsoft SQL Server. Experience with a scripting language such as Microsoft Visual Basic Scripting Edition or Microsoft JScript. Familiarity with Microsoft .NET concepts and technology. No prior BizTalk experience is necessary. Course Outline Module 1: Introduction to BizTalk Server 2006 This module describes common BizTalk Server more...

Implementing a Microsoft SQL Server 2005 Database ...s with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database. Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database. At more...

Designing the Data Tier for Microsoft SQL Server 2005 ... with the knowledge and skill to design the data tier for Microsoft SQL Server 2005. The clinic focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today. Audience This course is intended for current professional database more...

Designing Microsoft SQL Server 2005 Server-Side Solutions ... knowledge and skills to design server-side solutions for Microsoft SQL Server 2005T. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a more...

Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005 THANK YOU FOR YOUR INTEREST IN COURSE 2733X! Introduction This 5-day combination, instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. Provides students with the knowledge and skills to more...

Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005 THANK YOU FOR YOUR INTEREST IN COURSE 2733X! Introduction This 5-day combination, instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. Provides students with the knowledge and skills to more...

Designing on OLAP Solutions Architecture Using Microsoft SQL Server 2005 THANK YOU FOR YOUR INTEREST IN COURSE 2796! Introduction Elements of this syllabus are subject to change. The purpose of this 3-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process from more...

Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 THANK YOU FOR YOUR INTEREST IN COURSE 2794! Introduction: Elements of this syllabus are subject to change. The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the more...

Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services THANK YOU FOR YOUR INTEREST IN COURSE 2795 Elements of this syllabus are subject to change. The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to more...

Microsoft SQL Server Microsoft SQL Server more...

Microsoft SQL Server Courses covering topics on Microsoft SQL Server. more...

Mcdba 2KO International in Cape Town offres the Microsoft MCDBA training course as a residential instructor led training program aimed at equipping students for MCDBA certification. The course runs for four weeks and covers the core modules and electives for the MCDBA more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Course 2733) Thank you for your interest in Course 2733. Introduction This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. This course is intended for experienced database administrators and database developers who are responsible for more...

Querying MS-SQL Server 2000 & Programming a MS-SQL Server 2000 Database (Course 2071/2073) ...stom class which combines the content of 2071: Querying a Microsoft SQL Server 2000 Database with Transact-SQL and 2073: Programming a Microsoft SQL Server 2000 Database. New custom practice labs have been generated to provide the student with a linear project in which to experience and partake in the creation of a real-world database solution. Course Objective: This course provides students more...

Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services more...

Querying Microsoft SQL Server 2000 with Transact-SQL The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.  more...

Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 This course provides students with the knowledge and skills necessary to design implement and deploy OLAP solutions by using Microsoft SQL Server 2000™ Analysis Services.  more...

Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services This course provides students with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server™ 2000.  more...

Implementing Business Logic with MDX in Microsoft SQL Server 2000 This course provides students with the knowledge and skills necessary to use multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to a Microsoft SQL Server™ 2000 Analysis Services cube by using SQL Server 2000.  more...

Implementing Replication Using Microsoft SQL Server 2000 This three-day instructor-led course provides students with the knowledge and skills to plan deploy administer manage and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot transactional and merge replication as well as topics related to Enterprise-level replication.  more...

Microsoft SQL Server 2000 for Experienced Database Professionals This three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server™ 2000 and how it works. The primary focus of this course is to give experienced database professionals a jump-start to better understanding SQL Server 2000. This is not an advanced course or a more...

Live Online:MCDBA +LIVE Presented online by a live instructor - Online ILT Presented online with a live expert instructor (online ilt) Our complete MCDBA 2003 packages give you the expert knowledge and hands-on experience you need to master Windows 2003 and SQL Server and pass all four Microsoft exams. For one low price, you'll tap into the most powerful learning system available anywhere. The Insider Training more...

Live Online:MCDBA +LIVE PREMIUM Presented online by a live instructor - Online ILT Presented online with a live expert instructor (online ilt) Our complete MCDBA 2003 packages give you the expert knowledge and hands-on experience you need to master Windows 2003 and SQL Server and pass all four Microsoft exams. For one low price, you'll tap into the most powerful learning system available anywhere. The Insider Training more...

SQL Database Design & Implementation ...r Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, students will be able to: Use Transact-SQL to query a SQL server. Design, create, and manage databases. Create and manage tables. Implement data integrity techniques. Design and implement indexes. Query multiple tables through the use more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 ... equivalent knowledge.   ? Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.   ? Knowledge of SQL Server 2000/7.0: ? Database and server architecture.   ? Installation and configuration.   ? Database security.   ? Database recovery (backup and restore).   ? SQL Server technologies used for database availability such as log shipping and clustering.   ? Job more...

Updating Your Database Development Skills to Microsoft SQL Server 2005 ... or equivalent knowledge.   ? Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.   ? Knowledge of SQL Server 2000/7.0: ? Database and server architecture.   ? Database Security   ? Transact SQL   ? Query Engine   ? DDL   ? DML   ? Optimization   ? Schema and Objects   ? Programming Objects   ? UDF   ? Triggers   ? Stored Procedures   ? Optimization   ? SQL XML more...

Introduction to Microsoft SQL Server Training This SQL Server training course, which generally targets developers though can be customized for new programmers, teaches students how to effectively design and develop SQL Server databases and to program in Transact-SQL. more...

Advanced Microsoft SQL Server Training This advanced SQL Server training course teaches students how to use Data Transformation Services, SQL Server Replication, SQL Server's Web publishing and XML features, and SQL Server's Analysis Services . more...

Introduction to SQL Training using SQL Server This SQL Server training course is designed for students new to writing SQL queries using SQL Server. more...

Designing & Implementing OLAP Solutions Using Microsoft SQL Server 2000 This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services. There is no MCP exam associated with this course. more...

Implementing Replication Using Microsoft SQL Server 2000 Technology Course: Implementing Replication Using Microsoft SQL Server 2000 (MSC2591) more...

Programming a Microsoft SQL Server 2000 Database This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000. This course helps you prepare for the fol-lowing Microsoft Certified Professional exams: 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. more...

Querying Microsoft SQL Server 2000 with Transact-SQL The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. more...

Microsoft Programming with ADO.NET This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server? 2000, and the Microsoft .NET Framework. more...

Administering a Microsoft SQL Server 2000 Database ...ubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product. At Course Completion At the end of the course, students will be able to: Describe SQL Server architecture.   Plan for a SQL Server more...

Programming with Microsoft ADO.NET his course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft.NET Framework. more...

Microsoft MCITP: Database Developer Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005. Database developers design and implement relational database models (logical and physical) and database storage more...

Microsoft MCITP: Database Administrator ...ays a week. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security -or server automation and monitor and troubleshoot SQL Server activity. MCITP: Database Administrator candidates should meet the following more...