The Oracle database environment is one of the most popular environments and programs in the world. Although the Oracle database used in large companies, Oracle has introduced new products that can support the use of the Oracle environment in smaller organizations. Therefore, the beginning is for you to learn the SQL language to lead you to the Oracle world by creating tables and objects, querying data and accessing information using the SQL command. Audience: • Administrator • Analyst • Developer • Systems Administrator
The Course Objectives • Create SQL data manipulation statements • Control access to database objects • Database Object Map Manager • Manage database objects through the data dictionary • Retrieve data columns and rows from the table • Learn Sub-Query • Querying data, collecting data and building the required report • Understand the basic concepts of relational databases ensure refined code by developers. • Create reports of sorted and restricted data. • Run data manipulation statements (DML). • Control database access to specific objects. • Manage schema objects. • Manage objects with data dictionary views. • Retrieve row and column data from tables. • Control privileges at the object and system level. • Create indexes and constraints; alter existing schema objects. • Create and query external tables.
