 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|||||||
|
|
|
|
|
|||
 |
|||
 |
Course Title:
Introduction to Oracle®
Course Code: STL-0R1 |
||
| Course Description: | The
lifeblood of the Oracle database is SQL which is the language that
end users and applications use to communicate with the database. This
course introduces delegates to the nuances of SQL and leaves them
with a comfort in knowing how to use it to interrogate and update
an Oracle database. SQL is an acronym for "Structured Query Language"
and is sometimes pronounced as "sequel". This language does
more than just Query though, it is used to alter the fabric of databases
as well as create and update and delete records stored within that fabric. |
||
| What You Will Achieve: | A settled comfort in using the SQLPlus tool to interrogate an Oracle database along with rudimentary database object creation commands. The course also engenders an awareness of the multi-user and transactional aspects of databases in general and Oracle in particular. | ||
| Who Should Attend: | Delegates embarking on their first exposure to a Relational Database ought to attend this course. Also, those that know some SQL from a Personal Computer database package would learn about SQL in the bigger world. | ||
| Pre-Requisites: | Comfort with using a computer is all that is required for this course. | ||
| Course Content: | This
course will cover the following topics: Introduction to Databases Components inside a Database (tables, views, users, sequences, constraints) Simple Select from one table Ordering the Output Columns, Literals Functional alteration of data displayed Restricting the Output Summary Functions Clustering the data using Group By The Having Clause Simple reporting using SQLPlus Introduction to DML Insert, Update and Delete Transactions including statement-level rollback Table Creation and Deletion Integrity Constraints Sequence Numbers Synonyms The "Lottery" application Course Material: Each delegate receives their own personal textbook which includes material for the course and may include material beyond the course. The present textbook of choice is by Nilesh Shah but the right to substitute better material is reserved if such text becomes available. |
||
| Follow-on Courses: | Introduction
to PL/SQL Advanced PL/SQL Oracle Reports Oracle Forms |
||
| Course Duration: | 3 Days | ||
| Course Price: | P.O.A. | ||
| Contact: | Sentia Training Limited t: 0141-955-0370 e: courses@sentiatraining.com |
||
