Online Sql Server Data eLearning

ONLINE MSBI - SSIS SSAS and SSRS training with Project Hi Everyone! Are you looking for the best PRACTICAL Online Training & Projects in Microsoft Business Intelligence(MSBI)? Here you are. You reached the right place. We at SQL School, provide you in depth training on SSIS, SSAS and SSRS modules of MS BI process. Furthermore, we will also provide you one Real time Project along with documentation and implementation (solution) so that you can  more...

Java Server Pages JSP This four-day course develops skills in JavaServer Pages, or JSP, which is the standard means of authoring dynamic content for Web applications under the Java Enterprise platform. It treats JSP 2.0, including older features such as scriptlets but focusing on newer features and techniques, including JSP expressions and the JSTL. At the end of the course, students will be well prepared to author  more...

ADO NET for Windows Applications Using C This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.  more...

ADO NET for Web Applications Using C This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications for the Web. The course includes a major case study demonstrating the use of ADO.NET and ASP.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and  more...

ADO NET Using C This intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The course  more...

ADO NET Using VB NET This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The  more...

Visual Basic 6 0 Database Access Part I This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing  more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition  more...

Transferring and Transforming Data in SQL Server 2000 To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition  more...

Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course  more...

Data Integration with C 2005 and ASP NET 2 0 To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam  more...

Data Integration with Visual Basic 2005 and ASP NET 2 0 To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam  more...

XML Data Access in VB NET To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework  more...

Small Business Server 2000 To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000  more...

Troubleshooting and Disaster Recovery of SharePoint 2003 To describe troubleshooting and the implementation of a disaster recovery strategy for SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies  more...

Project Server 2003 Planning Security Operations To plan and implement the Project Server 2003 security structure and operations Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams  more...

Maintaining and Securing Data in SharePoint 2003 To describe how to configure and maintain databases and implement security measures in SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies  more...

Cisco CallManager Fundamentals To explain how to deploy a Cisco CallManager server in a cluster using a supported IP telephony deployment model IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)  more...

Fundamentals of Cisco CallManager To deploy a Cisco CallManager server in a cluster using a supported IP Telephony deployment model. IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)  more...

Using PL SQL with an Oracle Server To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators  more...

Restoring SQL Server 2000 Databases To describe the process involved in restoring SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition  more...

SQL Server 2000 Replication To describe how to implement the SQL 2000 replication models Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition  more...

Advanced Database Features in Access 2002 To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level  more...

Microsoft Visual InterDev 6.0: Accessing Remote Data This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services  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...

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...

MCSD Solutions Architecture IV This course explains how to implement data services with SQL Server and how to create service components user interfaces and user services with Visual Basic 6.0.  more...

SQL Server 7.0 Introduction ...efits 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 installation system management database administration data  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 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 Developing SQL Client/Server Part I This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server  more...

SQL Server 7.0 Developing SQL Client/Server Part II This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server  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...

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: 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 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...

Microsoft Commerce Server 2000 Design and Implementation Part 5: Infrastructure, Security, & Admin. This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and  more...

Oracle9i SQL: DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...

Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.  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...

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: 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 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...

Oracle SQL for End Users Part 1 Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product  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...

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...

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...

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...

Basic SQL Programming This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.  more...

Advanced SQL Programming This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-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...