Databases

Learn to use the Oracle database management system to organize and manage data. Students will create an Oracle Database and gain 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 3.

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 3. .6 CEUs.

Learn the fundamentals of database processing. Learn to create a database structure using Access and to edit and use the tools for data retrieval such as queries, forms, reports, and labels. Prerequisite: Working with Windows or equivalent. 1.2 CEUs. 

Learn how to design database applications, use the performance analyzer, and subform controls. Also create macro groups, dialog boxes to filter records, create switchboards, and control tips. Finally, learn to protect databases with passwords, assign user permissions, and replicate databases. Prerequisite: Microsoft Access Level 1. 12 hrs. 1.2 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.

In this course you will learn the fundamentals of SQL using Oracle Database Technology. The course provides knowledge and skills in manipulating, restricting, and sorting data; using single, group and conversion functions; using set operators; using subqueries; controlling user access; managing
schema objects; and many more. This course will prepare you for the Oracle Database SQL 1Z0-071 exam to earn Oracle Database SQL Certified Associate Certification, which is the first step to other Oracle Certification. 2.4 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, students 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 students who have a basic knowledge of creating SQL Statements. SQL Basics or working knowledge of SQL is required for this course. .6 CEUs.