Facebook

Oracle 11g: Programming with SQL Intro eLearning

* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us:  sales@ccslearningacademy.com.

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us

psinghal
Last Update November 2, 2023
0 already enrolled

About This Course

Course Description:

Oracle Database 11g delivers economies of scale on easily managed low-cost grids, making it easier to reduce cost of downtime with maximum availability architecture, change IT systems faster using Real Application Testing, partition and compress data to run queries faster using less disks, securely protect and audit data, and enable total recall of data, and make productive use of standby resources with Active Data Guard.

This course addresses Oracle Database 11g Programming with SQL and is focused on:

    • Querying a Database with SQL
    • Conversion Functions, Conditional Expressions, Group Functions, and Joins
    • Manipulating Queries and Data
    • Using DDL, Views, and Schema Objects
    • Controlling User Access and Managing Objects
    • Managing Data Dictionary Views and Large Data Sets
    • Managing Time Zones and Datetime Functions
    • Subqueries and Regular Expressions

For on-demand learning, you will have access to this course for 12 months from the purchase date.

Learning Objectives

Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information
Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table
Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements
Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables
Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes
Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows
Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions
Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings

Inclusions

  • Certified Instructor-led training
  • Official Training Seminar Student Handbook
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

Target Audience

  • Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators; database administrators, database designers, developer support engineers, and technical administrators.

Your Instructors

psinghal

0/5
472 Courses
0 Reviews
0 Students
See more

Write a review

IMG1696499612.jpg

$1,295.00

Inclusions

  • Certified Instructor-led training
  • Official Training Seminar Student Handbook
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*
#edumall-wp-widget-courses-1 { display: none; } #single-course-ratings { display: none; } .tutor-single-course-lead-meta { display: none; } .lead-meta-item meta-course-total-enrolled { display: none; }