CERTIFICATION IN ORACLE DATABASE 12 C: INTRODUCTION TO SQL 1.1

Course Detail
  • Oracle 12c maintains a scalable, highly available enterprise platform and reduces complexity by using the powerful new tools and cloud enhancements of Oracle Database 12c. Determine the way to build and populate Oracle databases, perform effective queries, design applications and secure your enterprise data. Oracle Database 12c: the whole course contains a comprehensive appendix covering commands, keywords, features and functions.You will get in-depth introduction to SQL also as important information on managing large databases and using Oracle engineered systems.The Oracle12c certification helps in validation of your understanding of the Oracle Database 12c technology and sets the stage for your future progression.

Course Module
    • Introduction to SQL
    • Retrieving the Data using SQL Statement
    • Restricting & Sorting Data
    • Using Single Row Functions
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data using the Group Functions
    • Displaying Data from Multiple Tables using Joins
    • Using subqueries to Solve Subqueries
    • Using Set Operators
    • Manipulating Data
    • Using DDL Statements to create and Manage Table
    • Creating other schema objects
    • Controlling user Access
    • Managing Schema Objects
    • Managing Objects with data Dictionary Views
    • Manipulating Large Data Sets
    • Managing Data in different Time Zones
    • Retrieving Data by using subqueries
    • Regular Expression Support

Course Description
  • The learner must have a hands-on experience with windows operating system.

  • Duration 2 Months
  • Course Type Offline