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.
Learn how to design a better and more secure database. Students will learn about creating switchboards, macros, and front-end and back-end databases. Prerequisite: Access Level 3 .6 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.
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.