Introduction to Oracle and SQL in Oracle Database 10g

To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements

Familiarity with RDBMS technologies and programming techniques

Database administrators, application developers, and database operators

WEB

Relational database fundamentals| - identify the basic principles of the relational model for databases.|Designing a relational database| - identify how to use an entity relationship model to design a relational database.|Features of Oracle Database 10g| - list the main features and functions of the Oracle Database 10g release.|Retrieving data from an Oracle 10g database| - write basic SELECT statements for extracting data from a database.|Enhancing SQL statements in an Oracle 10g database| - enhance SQL statements to refine query results.|Writing basic SELECT statements in Oracle 10g| - retrieve data from an Oracle 10g database using the SQL SELECT statement.|The Oracle 10g iSQL* Plus environment| - interact with script files in iSQL*Plus.|Using iSQL*Plus in an Oracle 10g database| - use iSQL* Plus in an Oracle 10g database to execute SQL statements and interact with script files.|The WHERE clause in Oracle Database 10g| - use the WHERE clause to restrict the data returned by a SQL statement.|Sorting query results and using substitution variables| - use the ORDER BY clause and substitution variables in SQL statements.|Restricting and sorting output in Oracle 10g| - restrict and sort data using WHERE and ORDER BY clauses and substitution variables.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...