The Oracle Database course is designed with beginners in mind. Learn 11g and 12c both on Windows and Linux platform and taking advantage of the virtualization technology for killer hands-on practice and  projects.

Basic computer hardware, software and networking fundamentals, to enable beginners to grasp computer  hardware, software and networking concepts. Students will be able to visually see, touch and study computer parts, understand differences between software, operating systems, hardware and applications, including RAM and other memory types. Set up Oracle virtualbox from scratch and install Operating systems. Other Installations, setting up virtual environment and installing 11g Oracle software product.

This Oracle Database SQL 12c helps you write sub-queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Oracle Database: SQL and PL/SQL Fundamentals
This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.

Learn To:
•    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.
•    Identify the major structural components of the Oracle Database 12c
•    Manage objects with data dictionary views
•    Manage schema objects
•    Retrieve row and column data from tables
•    Run data manipulation statements (DML) in Oracle Database 12c
•    Use scalar and correlated sub-queries
•    Utilize views to display data
•    Write SELECT statements that include queries
•    Write multiple-column sub-queries
•    Control database access to specific objects
•    Create reports of aggregated data
•    Create reports of sorted and restricted data
•    Create tables to store data
•    Display data from multiple tables using the ANSI SQL 99 JOIN syntax
•    Employ SQL functions to retrieve customized data

PART 3
ORACLE DATABASE 12C INSTALLATION AND ADMINISTRATION
The following topics will be covered in hands-on intensive training. Our courses are structured for maximum success as an Oracle DBA. Lots of hands on practice will be done in class and projects will be required to be completed by students.

Database Architecture, Database Instance, Oracle Network Environment, Administering User Security, manage tablespaces, auditing, undo data, backup and recovery, moving data, upgrade and patching, tuning databases and  Introduction to DBAAS, Database Cloud control architecture.