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 intermediate Access skills, including how to enhance your database designs by using the principles of table relationships and lookup fields, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages. Prerequisite: Microsoft Access Level 1. 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 2. 12 hrs. 1.2 CEUs.
This course introduces students to the fundamentals of SQL using Oracle Database Technology. Students learn concepts of relational databases, write queries against single and multiple tables, manipulate data in tables, and create database objects.
This class will prepare you for the Oracle Database 11g: SQL Fundamentals Exam 1Z0-051.
Hi! We would be happy to share more information about our continuing education programs.
Please submit the form and we will be in touch shortly!