Oracle school training courses in Charleston, SC (public, in-house or online)

The Structured Query Language (SQL) is the standard data access language used by Oracle and every relational database management product. This course deals with the basics of SQL needed by application developers for the retrieval of sets of data. The structure of the SELECT statement and more advanced clauses are discussed along with Oracle’s standard functions. Various types of subqueries are constructed to support complex data extraction. The maintenance of table data with standard SQL Data Ma...

Full archival course description>>

In this course, students will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Objective :
Upon successful completion of this course, students will be able to: - install Oracle Database 10g. - describe the basics of the Oracle Database 10g architecture. - create a database. - configure Oracle Net services. - use SQL and P...

Full archival course description>>

In this course, students learn about relational database principles and SQL queries using Oracle.

Objective :
- A summation of relational database principles and an introduction to the Oracle relational database server. - Using the iSQL*Plus web-based database interface and other traditional interfaces. - Writing simple SQL queries and moderately complex SQL queries using various join techniques. - Summarizing, grouping and sorting data. - Advanced query techniques such as correlated...

Full archival course description>>

In this course, students will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Objective :
Upon successful completion of this course, students will be able to: - install Oracle Database 10g. - describe the basics of the Oracle Database 10g architecture. - create a database. - configure Oracle Net services. - use SQL and P...

Full archival course description>>

In this course, students learn about relational database principles and SQL queries using Oracle.

Objective :
- A summation of relational database principles and an introduction to the Oracle relational database server. - Using the iSQL*Plus web-based database interface and other traditional interfaces. - Writing simple SQL queries and moderately complex SQL queries using various join techniques. - Summarizing, grouping and sorting data. - Advanced query techniques such as correlated...

Full archival course description>>