Online Database Management Courses

$190 + HST

Upcoming start dates: June 19, July 17, Aug 21, Sept 18, Oct 16, Nov 13, Dec 11 2013

Access
Crystal Reports
- Introduction to Crystal Reports
- Introduction to Crystal Reports 10
Oracle
- Introduction to Oracle
- Intermediate Oracle
SQL
- Introduction to SQL
- Intermediate SQL
Introduction to Database Development

Introduction to Crystal Reports

Discover the techniques the pros use to produce attractive, reader-friendly reports for any audience. Designed for Crystal Reports X11, Crystal Reports 2008, and Crystal Reports 2011, this course will teach you how to transform the information that lies buried in your database or accounting program into clear, easy-to-understand documents. With the help of hands-on activities and step-by-step instructions, you'll learn the secrets for extracting, sorting, and grouping your data. In addition, you'll find out how to include totals for groups of figures or for the entire report. Next, you'll master the art of building your reports and formatting your material to create a polished, professional look. By the time you're done, you'll be able to produce anything from a quick meeting handout to an elaborate annual report--and you'll never be intimidated by report-writing tasks again!

Introduction to Crystal Reports 10

Learn how to use Crystal Reports to convert raw database or accounting data into meaningful and readable reports. Impress your peers, clients, and superiors by discovering new ways to convey information. By the time you finish this course, you’ll be able to create a wide variety of handsome and sophisticated reports that communicate more—much more—than mere facts. You’ll also be able to use charts and maps to present information visually, and cross-tabs to show correlations between loosely related data items. You’ll even find out how to save yourself time and effort by creating a library of custom functions you can use over and over in report after report.

Introduction to Database Development

Many projects bog down or are never completed for lack of a disciplined approach to development. Don’t let yours! Get a step-by-step guide through all phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also truly responds to user needs.

Introduction to Microsoft Access 2003

Learn how to use this powerful and award-winning database to store, locate, print, and automate access to just about any type of important information.

Introduction to Microsoft Access 2007

Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important business, personal, or scientific data. You'll gain practical, hands-on experience with tables, relationships, custom data entry forms, queries, mailing labels, macros, and more. Increase productivity, reduce data entry errors, conduct comprehensive searches, and produce handsome and professionally formatted reports.

Introduction to Oracle

Learn how to use the Oracle database management system to plan, organize, and manage your data. This course will introduce you to the Structured Query Language (SQL), Oracle’s SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database. You will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database.

Introduction to SQL

Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language. You’ll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.

Intermediate Microsoft Access 2003

Learn how to create real-world business databases using Microsoft Access 2003. Master the secrets of making the computer — not people — do all the work. Create tables, queries, forms, reports, and macros for managing contacts, products, orders, invoices, and receipts. Pull all the pieces together with a single, easy-to-use switchboard.

Intermediate Microsoft Access 2007

Take your Microsoft Access 2007 skills to new heights! In this course, you'll learn the tools and techniques you need to create user-friendly Access 2007 databases. We'll work with multiple tables, one-to-many forms and reports, macros, and much more.

Intermediate Oracle

Gain hands-on experience with Oracle’s PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle’s procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You’ll learn the building blocks and core features of PL/SQL, and you’ll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing.

Intermediate SQL

Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. In this course, you’ll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. You’ll explore how to write and implement complex queries on multiple tables simultaneously, and you’ll discover advanced filtering, update, and insertion techniques. You’ll also find out how to create queries that accept input from users and queries that perform complicated searches on strings and dates. By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.

Last updated by Webmaster on June 13, 2013