|
|
|
|
|
|
|
|
|
|
Course Criteria
Add courses to your favorites to save, share, and find your best transfer school.
-
3.00 Credits
You will learn to use the PL/SQL programming language effectively beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. Additionally, you will write Dynamic SQL and learn methods of code tuning for efficiency. This class is ideal for anyone preparing for the new Oracle Certification exam or simply looking to master the PL/SQL programming language with Oracle. Prerequisites: SQL Queries Level 2 or equivalent experience. 2.100 Continuing Education Units 21.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
1.00 Credits
Business analysts and systems professionals will benefit from this beginning and thorough introduction to Oracle SQL in the 10g R2 environment. In this thorough introduction to SQL*Plus commands, you will learn to leverage the power of Oracle for select statements, common sort sequences, functions, regular expressions, pseudo-columns, inner joins, outer joins, reflexive joins, unions, intersects, and minus commands. Additionally, you will learn to isolate extreme values, use subqueries, and run top-n queries. Finally, you will be introduced to the SQL Data Definition Language (DDL) for controlling table schemas by creating, altering, dropping, and modifying. Finally, you will learn Data Manipulation Language (DML) for inserting, updating and also managing updates by setting rollback points, committing transactions, setting transactions, and implementing savepoints. This course is the first in a two part series that will help those who are preparing to certify for the Oracle Developer Certified Associate (OCA) Exam 1Z0-001 or the Oracle 10g Certified Associate (OCA) database administrator Exam 1Z1-042 Oracle Database 10g: Administration 1. Prerequisites: While this course has no specific prerequisites, it is assumed that students will have a basic level of database literacy. 2.100 Continuing Education Units 21.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
2.00 Credits
This class will help those who have experience in SQL and want to learn the unique and advanced features of Oracle SQL. In this class, you will learn SQL99 join techniques including cross joins, natural joins, full outer joins, enhanced group processing with rollup and cube, and the case expression. Plus, you will learn SQL functions for formatting, ascii codes, padding and trimming, string comparisons, phonetic searches, processing null values, and manipulating dates, times, and other numbers. You will learn to write efficient queries, improve query maintenance, and control query security by using data dictionary storage, creating indexes, using table comments, defining sequences, creating and using synonyms, setting user passwords, and granting and revoking privileges. You will control data integrity by using constraints such as not null, unique, check, primary key, and reference. Finally, you will create SQL*Plus reports and scripts. This course is the second in a two part series that will help those who are preparing to certify for the Oracle Developer Certified Associate (OCA) Exam 1Z0-001 or the Oracle 10g Certified Associate (OCA) database administrator Exam 1Z1-042 Oracle Database 10g: Administration 1. Prerequisites: Oracle SQL Level 1 or equivalent experience. 2.100 Continuing Education Units 21.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
7.00 Credits
This class is designed for students who want to learn how to touch-type to increase their speed and efficiency on the keyboard. We will go at a slower pace in this course and with more one-on-one assistance from the instructor. The class is filled with interactive exercises that will allow students to learn touch-typing using the popular KAZ typing program. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
1.00 Credits
This class is designed for students where English is a Second Language (ESL). Through instructor-led activities, you will learn basic computer skills. The book used in this class is well-illustrated and designed for students with at least a low-intermediate ESL reading proficiency (as defined by CASAS Skill Level Descriptors for ESL). Pre-requisite(s): Low to intermediate reading proficiency, which is equivalent to CASAS level B descriptions for either 'Beginning Basic Skills or 'Intermediate Basic Skills . 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
2.00 Credits
Learn more essential computer skills in this class designed for students for whom English is a Second Language (ESL). You will learn more essential computer skills such as copy and paste. Additionally, you will learn to use the World Wide Web and to Email. Pre-requisite(s): Computers for ESL Students Level 1 or equivalent experience. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
1.00 Credits
This class will acquaint you with hardware and software and will familiarize you with the terminology and concepts related to computers. You will be introduced to operating systems, the Internet, and some software packages such as Word and Excel. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Career Development, Supplemental Course
-
7.00 Credits
This class is a slower-paced class designed especially for the senior student. Students will learn to operate the mouse, the purpose of special keys on the keyboard, and to navigate the Windows desktop. Additionally, students will create, edit and print simple files. Finally, students will be introduced to the Internet and email. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Personal Enrichment, Supplemental Course
-
7.00 Credits
This class is designed especially for the senior student. Facebook is a social network where people who share interests like family, friends, or business contacts can connect. In this class, you will learn to use Facebook as a central sharing place for your vacation memories, memoirs, thoughts about your busy week, or a discussion about your favorite recipe! In this class, you will learn to create your profile and connect with family, friends, and acquaintances who are also in Facebook. Plus, you will learn to receive automatic notifications from friends who post new content to his/her Facebook page. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Personal Enrichment, Supplemental Course
-
3.00 Credits
This hands-on course is designed for seniors (55 years of age and up). Students will learn the basics of using a digital camera. Students will learn to take, print, save, and e-mail pictures. Students will also experiment with editing techniques, such as those used to remove "red eye . Through the generosity of the H.W. Durham Foundation, Kodak EasyShare cameras will be provided for in-class use. Prerequisite(s): Computer Basics for Seniors. 0.700 Continuing Education Units 7.000 Lecture hours Levels: Continuing Education Schedule Types: Lecture Continuing Education College Continuing Education Department Course Attributes: CEU Personal Enrichment, Supplemental Course
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Privacy Statement
|
Terms of Use
|
Institutional Membership Information
|
About AcademyOne
Copyright 2006 - 2024 AcademyOne, Inc.
|
|
|