Databases

Learn to use the Oracle database management system to organize and manage data. You will create an Oracle Database and gain a basic understanding of SQL and Oracle’s SQL*Plus. After you register, please create an online account at ed2go.com/howardcc. This is where you will access the course. For more information, please call 443-518-4680.

Explore this universal database programming language and how it is used to sort and retrieve data. Explore data manipulation techniques, use aggregate functions, and gather statistics. After you register, please create an online account at ed2go.com/howardcc. This is where you will access the course. For more information, please call 443-518-4680.

Learn how to link your Access database with the SQL Server for data sharing. Create a data file, link, and manipulate the data in the Access application. Students should have a working knowledge of Access and/or SQL. Prerequisite: SQL Essentials, and/or Access Level 2.

Learn about various types of macros and how to best use them including a review of macros learned in the advanced Access class. Learn to create automated programs. Global macros, embedded macros, data entry macros, and automated macros will be covered. Prerequisite: Access Level 2. .6 CEUs.

This course provides knowledge and skills on how to set up database environments and secure oracle instances in any network environment, understanding database backup and recovery, Oracle Database Architecture, as well as configuration of security instances. This course will prepare you for the Oracle Database 11G: Administration I 1Z0-052 exam. This is the final class needed to become an Oracle Certified Associate (OCA). 1.8 CEUs.

This SQL Basics course teaches this powerful database language in easy to understand instruction. You will be able to create unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. The basics of each SQL command will be covered in this introductory tutorial. 

This course is designed for all levels of users who need to learn SQL.  Windows basic skills are required.

1.2 CEUs.

Taking SQL skills to the next level, you will learn how to perform calculations and group data. You will also learn the importance of views and how to create them. Linking to various external programs is also covered in this course. This course is designed for you if you have a basic knowledge of creating SQL Statements. SQL Basics or working knowledge of SQL is required for this course. .6 CEUs.