Overview/Description A database is used by organizations to store their data, and allow their employees to access, update, and manage it. Organizations use a Database Management System, also known as a DBMS to control, store, organization and retrieve that data for the users through end-user applications. There are multiple types of database, such as flat-file, network, and hierarchical. The most widely used database is the relational database, which is based on a mathematical theory. A relational database stores data in relations, which are tables, that store data in rows or tuples and...

Overview/Description This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview of the package deployment options available, the preparations of packages for deployment using package configurations, and the creation of a deployment utility. It also covers the methods used to install packages once deployed to the server, including the use of the Package Installation Wizard. The course also discusses the methods for running packages from within...

Overview/Description To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata...

Overview/Description SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional...