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.

In this course you will learn how to develop data models which are used to publish the information that organizations rely on for their day-to-day decision making processes. Basic data modeling techniques will be explored including capturing data requirements, analyzing data elements, identifying entities and attributes, and determining relationships between entities. Data models will be developed using the entity/relationship graphical model. Once a basic data model has been developed, students will be instructed on how to enhance the data model to manage and enhance the value of the data it contains. This will directly affect the quality of the information produced from the data, and provide an organization with the knowledge necessary to optimally perform its business functions. The emphasis of this course is on analysis and design rather than on the actual implementation of a database.

In this course, students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL.

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Topics in this course include: Oracle database architecture, Oracle Net services, database storage structures, backup and recovery, data and concurrency, undo data, performance and database diagnostic. The lesson topics are reinforced with structured hands-on practices.

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various Application Express components and wizards to build applications and database objects that are easy to deploy. The students learn how to build forms and reports and incorporate different types of items and shared components. Creating and utilizing various navigation components as well as session management and debugging are discussed. In addition, students incorporate access control, and session protection to enforce application security. Once the application is complete, students learn how to define their packaged application and export the application. Students will also use all the Utilities and Report capabilities that Oracle Application Express provides to build a robust application. The audience for this course includes: Forms Developer, Reports Developer, Application Developers, PL/SQL Developer.

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.

This course provides students with the concepts of relational databases and the powerful Transact-SQL queries for Microsoft SQL Server 2008. In this class students will learn the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata. In addition, the advanced features of Transact-SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Topics in this course include: group and summarize data, join data from multiple tables, write queries that retrieve and modify data by using subqueries, learn data manipulation language, query text fields with full-text search, use various techniques when working with complex queries.

This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. Upon completion of this course, students will be able to describe new features of SQL Server 2008, manage SQL Server 2008, optimize SQL Server 2008, secure a SQL Server 2008 Database, create and maintain highly available SQL Server 2008 databases, create and use a SQL Server 2008 data warehouse, use SQL Server 2008 Analysis Services, use SQL Server 2008 Report Services.

Gain the knowledge and skills needed to maintain a Microsoft SQL Server 2008 database. This course addresses your job as a database administrator after you have set up a database. You'll learn how to 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. Topics in this course include: manage database files, backup and restore databases, manage security, transfer data into and out of SQL Server, automate administrative tasks, automate administrative tasks, replicate data between SQL Server instances, maintain high availability, monitor SQL Server.

Gain the knowledge and skills needed to implement a Microsoft SQL Server 2008 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), manage transactions and locks, and using managed code within the database.

This course provides students with the knowledge and skills to successfully implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. This course covers the following topics: create an Integration Services package, implement control flow implement data flow and logging in an Integration Services, debug and implement error handling, deploy, manage and secure an Integration Services package.

This course provides students with the knowledge and skills required how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. This course covers the following topics: create a Reporting Services report, enhance a Reporting Services report, configure report publishing and execution settings, implement subscriptions for reports, administer Reporting Services, implement custom Reporting Services applications.

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses 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.