| SQL (Oracle10g): Introduction |
|
|
|
|
| Overview: |
Oracle is the most widely used database in the world. It turns on virtually every kind of computer. It functions virtually identically on all these machines, so when you learn it on one, you can use it on any other. This fact makes knowledgeable Oracle users and developers very much in demand, and makes your Oracle knowledge and skills very portable.
This course covers the objectives of Exam 1Z0-007, Instruction to Oracle9i: SQL and the SQL portions of 1Z0-042 Oracle Database 10g: Administration. After taking this course, students will have knowledge on database concepts, and how to interact with database in context of a hypothetical "real world" business.
The syntax of command to access and manipulate information stored in database will be presented in a real-world environment. The topics will be covered are: Data Query Language (DQL), Data Definition Language (DDL), Data Manipulate Language (DML) and Data Control Language (DCL). By taking this class, students will obtain full knowledge and skills to manipulate and modify data stored in database, control the output of information to meet business criteria, create and modify different database objects, such as tables, indexes, views, users, and etc. Students should be able to proficient in writing and understating SQL queries. The foundation will be build up for the further development as Oracle developers or Oracle database administrators for the future. Also, student should be able to take Exam 1Z0-007 and 1Z0-042. |
| Prerequisites: |
| Familiarity with DMS or any major database language. |
| Additional Information: |
Have a question? - See our Evening Programs FAQ
Go to the Evening Programs webpage
Online Bookstore |
| Objectives: |
| Complex queries and subqueries with Oracle commandsSorting and restricting access to dataSelect, insert, merge and update dataComplex joinsOracle scriptsOutput reporting using iSQLoPlus commandsSingle row and group functions |
|
|
