Database Management

If you need to learn more about the design of relational database systems, this course is for you. You'll explore how the relational database approach is used in both open and closed systems and on both mainframe and client/server platforms, and learn about the design of systems of all sizes including standalone, workgroup, departmental, and enterprise-wide applications. You'll also learn how to incorporate data from legacy systems as well as how to develop entirely new systems. You'll have the opportunity to design a rational database model in class and refine it for a real-world system or case study. Topics include an overview of database systems, defining business entities, entity relationship modeling (ERM) for top-down analysis, defining relational database tables and attributes, conversion of logical design to physical design, normalization of tables, and using structured query language (SQL) to process data and generate reports.

Learn how to develop a graphical model of the information (data) that an organization uses to carry out its business functions. This course explores several methods for performing data modeling with the primary objective being to identify and document specific information, such as customer names or product codes, that an organization needs in order to carry out its business functions. Topics include performing data requirements analyses, identifying entities and attributes, determining the relationships among entities, creating an entity-relationship diagram, and implementing the diagram in the form of a relational database. The emphasis of this course is on the analysis rather than on the actual implementation of the database.

Learn how to implement relational database solutions using Oracle. The latest version of Oracle's powerful and popular database management system. This course introduces Oracle Database 10g technology along with relational database concepts and the powerful SQL programming language. The course covers essential SQL skills including querying the database, using metadata and creating database objects.

Gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You'll learn how to create an operational database and properly manage the various structures in an effective and efficient manner with emphases on performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

Expand your Oracle database administration skills. You'll learn how to configure an Oracle database for multilingual applications and practice various methods of recovering the database using RMAN, SQL, and Flashback technology. You'll also learn about tools for monitoring database performance and steps to take to improve database performance. Additional topics include the use of the Resource Manager, the Scheduler, and Automatic Storage Management (ASM). All lesson topics include structured, hands-on practices accompanied by a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

This course introduces PL/SQL and helps you understand the benefits of this powerful programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. You'll also learn how to create anonymous PL/SQL blocks, stored procedures, functions, and how to use other, standard programming techniques. Additional topics include the use of stored procedures, functions, packages and database triggers, and you'll learn how to manage PL/SQL program units dependencies, how to manipulate large objects, and how to use some of the Oracle-supplied packages. Demonstrations and hands-on practice reinforce the fundamental concepts.

Learn how to develop scalable, high performance applications for the Internet using Oracle Forms Developer. You'll learn how to design and deploy sophisticated database forms that let you use the power of Oracle to drive your business logic. This course shows you how to build, test, debug, and deploy interactive Internet applications using an intuitive graphical user interface (GUI) to design and customize your forms. You'll have the opportunity to practice what you learn by building an order entry application complete with business logic from the ground up.

This course is designed to give the student a firm foundation in the art of SQL tuning. The participant learns the necessary knowledge and skills to effectively tune SQL against the Oracle9i Server. Students gain a thorough conceptual understanding of the Rule-Based and Cost-Based Optimizer. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

Learn how to get the optimal performance from your Oracle 10g Database by applying performance tuning methods that maximize the utility of the database. You'll learn how to use Oracle's automatic tuning features as well as apply manual tuning methods using the Statspack tool. Next, you'll learn how to apply those tuning features and methods to the various tunable components of an Oracle database. This course gives you plenty of opportunities for hands-on practice through a series of practical workshops.

If you are a database administrator or developer who needs to design, maintain, and use a data warehouse, this course is for you! You'll learn about the data warehousing features of Oracle 10g and how to design and build a data warehouse. The course covers various data warehouse schemas, the ETL process (extraction, transformation, and loading), data partitioning, parallelism concepts and parallel operations, materialized views, Query Rewrite, SQL Access Advisor, and database warehousing system management including security and backup/recovery strategies.

Learn the basic functions of IBM's DB2 9, a relational database management system which may be installed under a variety of operating systems on many hardware platforms. We will learn several fundamental ways to configure DB2 9 servers, instances, and databases as well as how to manage table spaces and storage. We will practice creating tables, indexes, views, and using various tools such as Health Center, Task Center, Control Center, and Design Advisor for monitoring and improving a database's performance. We will also learn how to build, execute DDL scripts for tables and index creations, how to write SQL/X or X-Query statements (DB2 9 pure-XML) for querying XML data, and how to set up access security as well as data movement/management utilities jobs.

This two-day, interactive workshop was designed for new users of Crystal Reports XI. Some of the topics covered include a review of the software features, report design, and the creation of presentation quality reports.The course incorporates a number of hands-on exercises to reinforce the learning process. Audience: Administrators, developers and end-users who need to create dynamic reports from varying data sources.

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands-on practice. In addition, you will cover professional design, techniques, subreporting, and advanced formulas. This course incorporates a number of hands-on exercises that reinforce the learning process. Audience: Administrators, developers and end-users who need to create dynamic reports from varying data sources.

This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing, along with a lot of hands-on practice. In addition, you will cover custom function, advanced formulas, and report efficiencies techniques. This course incorporates a number of hands-on exercises that reinforce the learning process. Audience: Administrators, developers and end-users who need to create dynamic reports from varying data sources.

Gain the knowledge and skills needed to write queries for Microsoft SQL Server 2005 using Transact-SQL. Topics include writing queries, using SQL Query Analyzer, retrieving and filtering data from a database, modifying data in a database, and developing triggers, views, and stored procedures.

Gain the knowledge and skills needed to implement a Microsoft SQL Server 2005 database. You'll learn how to set up a new database and prepare it to be used by individual users or external applications that need to access or manipulate data. Topics include creating database files, creating tables and assigning data types, using XML in a database, setting up and optimizing an index, enforcing data security, implementing stored procedures and functions, ensuring data integrity (constraints, triggers, and XML schemas), and using managed code within the database.

Gain the knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. This course addresses your job as a database administrator after you have set up a database - the topics are a continuation of Microsoft Course 2779, Implementing a Microsoft SQL Server 2005 Database. You'll learn how manage database files and security, back up and restore databases, monitor SQL Server performance, and troubleshoot database problems. You'll also learn how to transfer data among various data sources and ensure that your database remains available to users.

This workshop is designed for professional database developers who have at least three years of experience developing SQL Server solutions for the enterprise. It provides the knowledge and skills needed to evaluate and improve queries and query response times. The workshop focuses on systematic identification and optimization of database factors that impact query performance.

Gain the knowledge and skills needed to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information. Topics include planning an automated system for database and server maintenance, documenting administration information in a run book, and managing SSIS packages, replication, and reporting services.

Gain the knowledge and skills needed to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes learning how to establish monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.

Gain the knowledge and skills needed to implement an Analysis Services solution using Microsoft SQL Server 2005 in a large enterprise or organization. You'll learn how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. Topics include: creating multidimensional analysis solutions, implementing dimensions, implement measures and measure groups, customizing an Analysis Services cube, and deploying and securing an Analysis Services database.

Learn how to implement an Integration Services solution in a large company or organization. You'll gain the knowledge and skills needed to develop, deploy, and manage Integration Services packages. Topics include: creating an Integration Services package, implementing control flow, implementing data flow and logging in an Integration Services package, debugging and implementing error handling procedures, deploying and managing an Integration Services package, and securing an Integration Services package.