SQL Course And Training

Program Name: Oracle 11g : SQLFundamentals

Program Details

Oracle 11g : SQL Fundamentals course is designed to teach the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Course Objective List  
» Identify the major components of Oracle Database 11g 
» Retrieve row and column data from tables with the SELECT statement 
» Create reports of sorted and restricted data 
» Employ SQL functions to generate and retrieve customized data 
» Execute complex queries, DDL statements, and DML statements 
» Control database access to specific objects and add new users with different levels of access privileges 
» Manage schema objects and objects with data dictionary views 
» Manipulate large data sets in the Oracle database by using subqueries 
» Manage data in different time zones 
» Write multiple-column, scalar, and correlated subqueries 
» Use the regular expression support in SQL


Duration: 48 hrs

-------------------------

This program provides the learner with prereqisite of: SQL Fundamentals

 

Program Name: Oracle Database 11g: PL SQL Fundamentals

Program Details

In this course, students learn the fundamentals of SQL and PL/SQL and understand the benefits of the programming languages. Students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data.

Course Objective List  
» Identify the programming extensions that PL/SQL provides to SQL
» Write PL/SQL code to interface with the database
» Design PL/SQL anonymous blocks that execute efficiently
» Use PL/SQL programming constructs and conditional control statements
» Handle run-time errors
» Describe stored procedures and functions
» Create, execute, and maintain procedures, functions, package constructs and triggers:
» Use a subset of Oracle-supplied packages to generate screen and file output
» Identify various techniques that impact your PL/SQL code design considerations
» Use the PL/SQL compiler, manage PL/SQL code, and manage dependencies


Duration: 48 hrs

 

Marathahalli Office:

Real Time Signals Technologies Private Limited

#102, Krishna Grand, Over Marathahalli Bridge,

Bangalore, Karnataka, India 560037

BTM office:

Real Time Signals Technologies Private Limited,

#4, 2nd Floor, 1st phase, 2nd Stage, BTM Layout,

Opposite to Udupi Garden,

Bangalore-76, bengaluru, Karnataka, 560076

Whitefield office:

Real Time Signals Technologies Private Limited,

#1906, Brigade Metropolis,

Mahadevpura,

Bengaluru, Karnataka, 560048

Belgium Europe office:

Real Time Signals Technologies,

Hemelstraat 42, 2018 Antwerpen

Belgium, Europe

Thane Office:

Real Time Signals Technologies Private Limited,

#202, GARDEN ENCLAVES BLDG NO1,

VASANT VIHAR,

THANE 400607, MAHARASHTRA, India 

 

 © 2014-2018 by Real Time Signals Technologies. All Rights Reserved.