Database school training courses in Chandler, AZ (public, in-house or online)

Professionals that work with Oracle databases continue to be in high demand. These individuals may perform any of the following job tasks such as storing, retrieving, and manipulating data utilizing SQL; creating and maintaining the database; database planning and design; creating PL/SQL or Java application code that can be shared by multiple forms and reports; and providing application and user support. The level of involvement in any of these activities will depend on the size of the company a...

Full archival course description>>

A Microsoft Certified Database Administrator (MCDBA) is a professional who has the knowledge and skills to design, implement and administer Microsoft SQL Server databases. This is an industry certification from Microsoft, and is earned when an individual passes the required certification exams from Microsoft. The courses in the Microsoft Database Administration programs at Chandler-Gilbert Community College prepare students for certification.

Oracle professionals demonstrate the complete set of skills that are required for working independently as an Applications Database Administrator Certified Professional. Not only does an Oracle Applications Database Administrator assume the role of a database administer, but also focuses on administering many of the components for the Oracle Applications Release R12 as well as database versions Oracle10g and Oracle11g. Effectively managing Oracle Applications requires an understanding of the und...

Full archival course description>>

This database design training class considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous "real-world" problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to ...

Full archival course description>>

In this DDL training class, you will learn to the basic principles of normalization and to create and modify database tables, views and stored procedures using SQL. Syntax will be shown in SQL Server, Oracle, and MySQL.

Class Goals
Understand the basics of database design.
Learn to create a simple database using SQL DDL
Learn to create tables, views, and stored procedures using SQL DDL
Class Outline
DDL Overview
Principles of Normalization
Creating and Modifying Ta...

Full archival course description>>