MS SQL Server Training and Seminars

Databases and SQL

MS SQL Server Training Classes Microsoft SQL Server configuration and administration, improve you DBA skills
Some important terms: administration, database, dba, microsoft, ms sql server, sql, sql server database, mssql, mysql, oracle, programming, rdbms and sql.
MS SQL Server Training Seminars and Classes
From Hands On Technology Transfer, Inc.
SQL Server 2012 Reporting Services This course introduces Microsoft's SQL Server Reporting Services 2012 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown  more...
Microsoft SQL Server 2012 Administration instructor led traininggroup study and discussioncomputer lab This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2012 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2012. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server  more...
SQL Server 2012 Business Intelligence Application Development SSRS SSIS SSAS This hands-on course introduces the SQL Server 2012 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2012 servers that support SSRS, SSIS and SSAS. Hands-on exercises will be performed where they create various types of reports, including basic table-based reports,  more...
SQL Server 2012 Business Intelligence Integration Services and Analysis Services This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2012. Students will install and configure SQL Server 2012 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/ SSAS. Students work with complex SSIS data  more...
From Wise Owl Business Solutions Ltd
SSAS Sql Server Analysis Services - Multidimensional Model instructor led traininggroup study and discussioncoursewareworkshop / seminarcomputer lab Do you have data sitting in your corporate SQL Server database, but not know how to make use of it? If you already know SQL, maybe it s time to learn about multi-dimensional reporting using cubes. Speed up your reports, analyse your KPIs and improve your data-mining with SQL Server Analysis Services. This course concentrates on practical teaching and exercises, to allow you to create and modify  more...
SSRS 2008 R2 Sql Server Reporting Services instructor led traininggroup study and discussioncoursewarecomputer lab SQL Server Reporting Services 2008 R2 is THE way to publish reports to your corporate intranet. Not only can you include tables of data, matrices (you may know these as pivot tables), charts, lists and subreports, but SSRS 2008 R2 also includes whizzy new report items like indicators, gauges and sparklines. On this three-day course you will use SQL Server 2008 R2 Business Intelligence Development  more...
From IntSol India
Microsoft SQL Server 2005 DBA Program instructor led trainingworkshop / seminarcomputer lab Objective: This course is targeted for those who have good knowledge and hands-on experience on using SQL Server 2000 database environment as it mainly focuses on database administrative tasks that an administrator generally needs to perform in a production environment for maintaining SQL Server 2005 databases and components related to the SQL Server environment. Pre-requisites: SQL Server  more...
From Sql Server Online Training
SSIS ONLINE TRAINING SQL SCHOOL WITH REALTIME SCHENARIOS instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
MICROSOFT BUSINESS INTELLIGENCE LIVE ONLINE TRAINING SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
PROJECT ORIENTED REGULAR LIVE online TRAINING ON MS BI instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
BEST PRACTICAL SQL DBA REALTIME ONLINE TRAINING PRACTICAL SQL SCHOOL instructor led trainingon-line e-learning cbt (computer based)workshop / seminar SQL School is one of the best IT Institutions providing specialized trainings SQL Server production DBA. We have been providing Online and Corporate Trainings for the last FOUR years. All Sessions are on LIVE environment with complete (100%) practical approach, examples, Practice included with Real-time Scenarios and Case Studies. Features of our Training: a Study Material a Real Time  more...
SQL DBA Online Trainings with Case Studies instructor led trainingon-line e-learning cbt (computer based)study at homegroup study and discussione-bookbookworkshop / seminarcomputer lab Realtime SQL Server and DBA Online Training is provided with LIVE databases and Case Studies. SQL SERVER Administration [SQL DBA] Course Contents: SQL Server basics and T-SQL: SQL Server Design Architecture Database Design and Table Design Principles Compression Techniques and Capacity Planning Data Integrity & Consistency Views and Data Security JOINS and Sub Queries and Query  more...
PROJECT ORIENTED WEEKEND REGULAR ON MS BI IS AS RS instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
PRACTICAL MSBI - SSIS SSASSSRS PRACTICAL TRAINING PROJECT instructor led trainingon-line e-learning cbt (computer based)workshop / seminar SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
MS BUSINESS INTELLIGENCE SSIS SSAS SSRS ONLINE TRAINING WITH PROJECT instructor led trainingon-line e-learning cbt (computer based)workshop / seminar SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
EXCELLENT PROJECT ORIENTED PRACTICAL LIVE TRAINING ON MS BI 2008 SQL School instructor led trainingon-line e-learning cbt (computer based)workshop / seminar SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
REAL-TIME MSBI(IS, AS, RS) ONLINE TRAINING WITH PROJECT instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
PROJECT ORIENTED WEEKEND REGULAR ONLINE ON MS BI IS AS RS 2008 instructor led trainingon-line e-learning cbt (computer based)workshop / seminar SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
PROJECT ORIENTED REGULAR LIVE online TRAINING ON MS BI IS AS RS instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
SQL SERVER BISSIS SSAS and SSRS ONLINE TRAINING instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
EXCELLENT MSBI ONLINE TRAINING WITH PROJECT instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
MSBI SSIS SSAS SSRS LIVE ONLINE TRAINING instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
BEST MSBI ONLINE TRAINING WITH PROJECT instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
SSAS ONLINE TRAINING SQL SCHOOL WITH REALTIME SCENARIOS instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
PRACTICAL SQL BIMSBI ONLINE TRAINING WITH PROJECT instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
MS BUSINESS INTELLIGENCE SSIS SSAS SSRS ONLINE TRAINING SQL SCHOOL instructor led trainingon-line e-learning cbt (computer based) SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
REALTIME PRACTICAL SQL DBA ONLINE TRAINING PROJECT instructor led trainingon-line e-learning cbt (computer based)workshop / seminarcomputer lab SQL School provides Interactive & Practical Online Trainings. We are specialized in SQL Server Technologies and Microsoft Business Intelligence ( MS BI ) along with Real Time Projects. All the sessions are completely PRACTICAL. No PPTs nor Screenshots during live sessions. Modules Covered : Integration Services , Analysis Services and Reporting Services. Duration of the Training : 70 hours  more...
Which is the best institute to learn SQL Server on-line e-learning cbt (computer based)workshop / seminarcomputer lab SQL School is one of the pioneers IT Institutions providing specialized in SQL Server 2012 DBA Training. We have been providing Online Training, Classroom Training and Corporate Training for the last SIX years. All our sessions are completely Practical and Real-time. SQL SERVER DBA COURSE DETAILS FOR ONLINE TRAINING SQL Server Basics a SQL Server Design Architecture a 2008 R2 & 2012 a  more...
From Serebra Learning Corporation
MS SQL Server 6.5: Installation & Administration on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...
From Wise Ltd.
SQL Server 2005 Integration Services SSIS Fundamentals This presentation provides detailed treatment of the following SQL Server 2005 Integration Services (SSIS) topics: - Creating and managing SSIS packages - Connecting to, querying and transforming disparate data sources - Scripting - Business Intelligence and data warehousing considerations - Event handling - SSIS problem determination - And the like. Prerequisites: At least six (6)  more...
Advanced SQL Server 2005 Integration Services SSIS for Developers As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more  more...
SQL Server 2005 Analysis Services SSAS This scenario-based presentation details how to use the Business Intelligence Development Studio (BIDS) to develop and deploy Analysis Services projects and to use the SQL Server Management Studio to manage the databases derived from these projects. Objectives: Upon completion of this presentation, the delegate should be competent to: - Build and deploy Analysis Services projects - Develop  more...
From NobleProg - IT training courses
Advanced SQL Stored Procedures Triggers for Microsoft SQL Server Training Course instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareworkshop / seminarcomputer lab The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. Requirements Delegates should be familiar with the Microsoft SQL Server SQL Language  more...
SQL PostgreSQL Administration instructor led trainingon-line e-learning cbt (computer based)group study and discussioncoursewareworkshop / seminarcomputer lab This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL modules such as replication, connection pooling and full text searching.  more...
From Saryx
SQL Server train the trainer Overview of the course content: Installing SQL Server 2005 a Meeting the Prerequisites a Preparing to Install a Upgrading from a Previous Version a Installing SQL Server 2005 a Installing a Second Instance a Troubleshooting the Installation Module 2: Implementing Security in SQL Server 2005 a Understanding Security Modes a Understanding SQL Server Logins a  more...
Sell MS SQL Server training?
Custom Search
tcw11-v473M-03/27/17-00:59:22-()[B]-[B]-[A]