The course assumes a prior knowledge of SQL Data Manipulation Language. If you’re an advanced user there may be little need for this class for you at the start of the course.

2 week

1. Create reports of sorted and restricted data.
2. Run data manipulation statements (DML).
3. Control database access to specific objects.
4. Manage schema objects.
5. Manage objects with data dictionary views.
6. Retrieve data from tables.
7. Create indexes and constraints and alter existing schema objects.
8. Create and query external tables.
9. Use the regular expression support in SQL

See Full course outline as per Oracle here.

1. Those aspiring for a career in Database Administration
2. SQL Developers and Administrators
3. Database professionals.

1. Introduction to SQL Course
2. Knowledge of relational database

• You’ll also learn to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered.
• Data and its manipulation affect every area of business in the world today. All companies and stakeholders in all spheres of business rely on the collection, storage, and manipulation of data to drive successful decision making and hence profitability. SQL is the most vital tool in getting optimal results out of the each company’s data and making profitable decisions. SQL is a Must Know to all IT professionals.
• To Obtain the OCA certificate