MS SQL Server Training and Seminars

MS SQL Server 6.5: Installation & Administration In this course, students will be presented with a task-based, real-world scenario covering the implementation, administration and troubleshooting of Microsoft SQL Server 6.5. Implementation of SQL Server includes the installation of the software and the setup of the SQL database. Administration of SQL Server includes managing storage, the setting up of user accounts and assigning permissions. The  more...

MS SQL Server 6.5: Design & Management In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for  more...

MS SQL Server 6.5: Advanced Retrieval Structures In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server  more...

MS SQL Server 6.5: Management & Optimization In this course, students will be presented with a task-based, real-world scenario covering the, administration optimization, troubleshooting of Microsoft SQL Server 6.5. Administration of SQL Server includes managing storage, the setting up user accounts, and assigning permissions. The optimization, configuration, and diagnostics of SQL Server will also be covered.  more...

Implementing MS SQL Server 7.0 This course provides the student with an introduction to the core technologies, architecture, and various features of Microsoft SQL Server 7.0. It also provides the student with the preliminary knowledge and skills required for planning and installing SQL Server 7.0. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.  more...

Managing MS SQL Server 7.0 This course provides the student with ways to configure SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.  more...

Managing MS SQL Server 7.0 Security This course enables the student to plan a backup and restoration strategy for preventing data loss. It also provides the student with an introduction to SQL security concepts and the security accounts used by SQL Server. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-028).  more...

Optimizing & Troubleshooting MS SQL Server 7.0 This course teaches the student how to monitor and optimize the SQL Server performance. The student will learn how to detect and troubleshoot various problems that occur while installing SQL Server 7.0 and when establishing client connections. The student will also learn about different replication and backup problems and how to troubleshoot the same.  more...

MS SQL Server 7.0 Basics This course teaches the student the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029.  more...

Planning an MS SQL Server 7.0 Data Warehouse This course provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0 In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...

Implementing an MS SQL Server 7.0 Data Warehouse This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL  more...

Using MS SQL Server 7.0 OLAP Services This course provides the student with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) services. It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP services. The students will be able to design and optimize an OLAP database. In addition, the course prepares students to take the  more...

Optimizing a MS SQL Server 7.0 Data Warehouse This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...

Planning an SQL 7.0 Data Warehouse The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server  more...

Implementing an SQL 7.0 Data Warehouse The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for  more...

Using SQL 7.0 OLAP Services The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP  more...

Optimizing a SQL 7.0 Data Warehouse The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the  more...

Microsoft SQL Server 7.0: System Administration - Part 1 This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: System Administration - Part 2 This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: System Administration - Part 3 This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: System Administration - Part 4 This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: System Administration - Part 5 This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Implementing a Database - Part 1 This is the first course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Implementing a Database - Part 2 This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Implementing a Database - Part 3 This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Implementing a Database - Part 4 This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Implementing a Database - Part 5 This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5 This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data  more...

Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.  more...

Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.  more...

MS SQL Server 2000: Database Administration Part 1: Installing SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 2: Managing Databases This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects.  more...

MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 4: Managing Data This course deals with transferring data managing replication services and maintaining high availability.  more...

MS SQL Server 2000: Database Administration Part 5: Maintaining SQL Server 2000 This is the last course in a five part series that deals with managing monitoring and troubleshooting SQL Server 2000.  more...

MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server the Transact-SQL language and SQL Server Databases.  more...

MS SQL Server 2000: Design and Implementation Part 2: Managing Data This is the second course in a five part series that will teach students how to work with SQL Server data.  more...

MS SQL Server 2000: Design and Implementation Part 3: Managing Objects This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view stored procedures user-defined functions and triggers.  more...

MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation how to create and manage indexes as well as learn how to optimize query performance and how to analyze queries.  more...

MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking.  more...

MS SQL Server 2000: Database Administration Part 1: Installing SQL Server 2000 This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 2: Managing Databases This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects.  more...

MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000.  more...

MS SQL Server 2000: Database Administration Part 4: Managing Data This course deals with transferring data, managing replication services, and maintaining high availability.  more...

MS SQL Server 2000: Database Administration Part 5: Maintaining SQL Server 2000 This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000.  more...

MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases.  more...

MS SQL Server 2000: Design and Implementation Part 2: Managing Data This is the second course in a five part series that will teach students how to work with SQL Server data.  more...

MS SQL Server 2000: Design and Implementation Part 3: Managing Objects This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers.  more...

MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries.  more...

MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.  more...

SQL Server 7.0 Introduction This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and  more...

SQL Server 7.0 Installing and Upgrading This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort  more...

SQL Server 7.0 Management Part I This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the  more...

SQL Server 7.0 Management Part II This course provides the skills to database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028  more...

SQL Server 7.0 Management Part III This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set  more...

SQL Server 7.0 Data Warehousing SQL Part I This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming  more...

SQL Server 7.0 Data Warehousing Part II This course is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applicaitions and making information available to a wide audience of end-users. Using the Data Transformation Services Package Designer the student will be able to define steps workflow and transformations necessary to build a data warehouse.  more...

SQL Server 7.0 Advanced Features Part I This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced  more...

SQL Server 7.0 Advanced Features Part II This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances  more...

SQL Server 7.0 Web Integration This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web  more...

SQL Server 7.0 Database Admin. Part I This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...

SQL Server 7.0 Database Admin. Part II Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...