الوصف
Course Name: Database Developing and Administering Under ORACLE DBMS.
Course Hours: 60
Course Methodology: Practical - Online
This course covers the ORACLE database starting with database installation to database administration. "from setup to DBA".
After completing this course, you should be able to do and know the following:
- Introduction about the Database (DB) and Database Management System (DBMS).
- Install ORACLE DBMS in Windows OS.
- Structure Query Language (SQL).
- Selecting and retrieving data from the DB.
- Selecting and retrieving specific records using Conditions.
- Arithmetical and logical operators in DB.
- Calculating and Sorting Data.
- Single-Row Functions.
- Displaying data from multiple tables.
- Aggregating data using Group Functions.
- The Sub Query.
- Advanced Sub Query.
- The Substitution Variable.
- Creating a Script File.
- Data Manipulation Language DML.
- COMMIT and ROLLBACK.
- Creating and Managing Tables.
- Creating and Managing Tables Including Constraints.
- Creating and Managing Views.
- Creating and Managing Other Database Objects.
- Managing and Controlling Users.