Oracle DBA Basic 11g

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 Manipulation Language commands: INSERT, UPDATE, MERGE and DELETE are covered, showing the various constructions of each statement. Workshops use a command line processor for the generation and presentation of SQL statements. The participant also learns the fundamentals of database design and how to create tables and build views upon them. The implementation of business rules, with declarative constraints, is also covered. In addition, the student is also exposed to Oracle’s database language, PL/SQL (Procedural Language extensions for SQL). Application developers use it for stored procedures, functions, triggers, and even front-end code environments such as Oracle Developer Suite (FORMS, REPORTS). This course lays the foundation for implementing applications that properly utilize the capabilities of the Oracle 11g database.

Prerequisites…

Knowledge of relational theory is a plus.