Courses > Database Management & Programming

Click any title below to view a complete course description including a syllabus, instructor biography, prerequisites, and requirements.

Introduction to Database Development
Instructor: Allen Taylor

A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.

Introduction to SQL
Instructor: Cecelia Allison

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.

Introduction to Oracle
Instructor: Cindy Delia

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.

Intermediate Oracle
Instructor: Cindy Delia

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.

Introduction to Microsoft Access 2003
Instructor: Craig Power

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.

Intermediate Microsoft Access 2003
Instructor: Alan Simpson

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.

Introduction to Crystal Reports 10
Instructor: Allen Taylor

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.

Creating User Requirements Documents
Instructor: Nidhi Misra

Your success as a developer depends almost entirely on your ability to meet or exceed your customers' every expectation. This course will show you, step by step, how to discover and document precisely what your customer wants. You will learn how to gather, manage, and document user requirements for any type of project in any industry.

C++ for the Absolute Beginner
Instructor: Jeffrey Kent

Learn how to program in C++, even if you have no prior programming experience! Create programs for Microsoft Windows using Microsoft Visual C++ 2005 Express Edition. Learn Object-Oriented techniques, how to create windows and forms, and how to program in a step-by-step nature. This course is ideal whether you're an enthusiast, a business person hoping to advance your career, or someone who already knows how to program but wants to move ahead to C++ and Object-Oriented Programming.

Introduction to C# Programming
Instructor: Mike Orsega

Learn the fundamentals of computer programming with C#, the in-demand and incredibly useful programming language that incorporates the best features of Visual Basic, C++, and Java. You'll begin with an exploration of input/output operations, decision making, looping, and object oriented programming principles. Then, you'll gain hands-on experience using sequential data files, and you'll build your very own Graphical User Interface (GUI) application. Learn to program the right way: by using a state-of-the-art language to build impressive and professional-looking applications on your schedule and on your very own computer.

Intermediate C# Programming
Instructor: Mike Orsega

Build upon your current knowledge of programming logic by writing Graphical User Interface applications in the C# programming language. Learn how to write applications with menus, toolbars, and files, and find out how to interact with databases and write SQL queries.

Introduction to Perl Programming
Instructor: Nathan Meyers

Learn Perl, a powerful and easy-to-use scripting language used on PCs, servers, and on the Internet for a wide range of programming problems. Perl is as capable - and often as fast - as C, C++, and Java, but is easier to learn and does not require the sort of software development tools and environments required by those languages. Perl is also more portable and supported on a greater variety of computers than many other computing languages. Perl programming skills are especially valuable for Web developers, software developers, and system administrators.

Introduction to Visual Basic 2005
Instructor: Jeffrey Kent

Visual Basic is the most widely used programming language and development tool for creating Windows applications. The Visual Basic programming language is very easy to learn, and the Visual Basic 2005 development environment enables you to rapidly build Windows applications. In six short weeks, you'll learn how to write Windows applications using the Visual Basic programming language and the Visual Basic 2005 development environment. You'll also learn principles of object-oriented and event-driven programming that you can use, not only with Visual Basic, but also with other programming languages you may want to learn.

High Speed Project Management
Instructor: Tom Myers

With accelerated schedules driving many technology projects today, the smart project manager must rapidly retool their skill set. This course offers a breakthrough model for dealing with the realities of managing projects at supersonic speeds. Learn to meet and win the challenges of truncated timelines, short-staffed project teams, skimpy budgets and crippling risks.