Home | Courses | Oracle Sql Workshop - SQL-ST-01

Oracle Sql Workshop - SQL-ST-01

By siteadmin 05/08/2012 23:53:00

Font size:

BASIC JUMP START ORACLE TRAINING O Level Certificate Courses For SQL Language

Course Duration 6 Days

Oracle Sql Wokshop is an certifiaction workshop provided by Go4oracle.com which is an community of professional with vast industrial experiance on live projects The content of the workshop is designed by industrial professionals and conducts workshops for students in various professional colleges and instituts. The workshop provides hand on experiance on SQLPLUS

SQLPLUS SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBA and Developers to interact with the Oracle database.

Who can Avail This Course

Students
Professionals who are looking to make career with Oracle Platform
Teachers
Professional persuing a career Programmers & developers
Professional persuing a career DBA's

WORKSHOP BATCH STRENGHT

MINUMUM ATTENDEES 50
MAXIMUM ATTENDEES 50

Course Overview : This is a custom designed course specially for a beginner. Various other training modules on oracle are only provided after a candidate has undergone the elementary O level training course. we spend most of the time with practical examples with an inclination towards projects development and this is possible as we have vast industrial experience in developing and implementing projects on oracle platform.

Objectives The aim of this course is to provide the delegate with the necessary skills to understand and perform simple and complex queries using SQL*Plus. On completion of this course the student will be:

Aware of various Objects Used In Oracle
Various Datatypes and domain constraints available when defining Oracle columns
Sql Statements and various operations
Importance of an Index for certain queries
use SQL*Plus
Working With Relational database Using Multiple Tables/Views
Join Operations
Query Writing
Understanding and use of oracle Functions,
Operators and sql expressions
Ad Hoc report Generation Using SQLPLUS Commands and Query

Prerequisites : persuing graduate,undergraduate courses. Management students

Prerequisite Courses N/A

Course Code: SQL-ST01

Course FEES: RS-2500

COURSE STRUCTURE

ORACLE OBJECTS (1 Day 3 Hours)

TABLES : Whats is Table ,Create Tables, Modifying Tables, Dropping Tables, Domain Constraints, Integrity Constraints, Table Constraints, Copying Tables, Renaming Columns In tables, various data types, Limitation with data types.

VIEWS What is a view Creating Views, Altering views, Advantages of View, Limitation Of Views, Implicit View, Dropping a view, Creating Forced View.
The Views will be covered again while working with Queries.

INDEXES Whats are index, Advantages of Indexes, Disadvantages of index, Create Index, Drop Index

SYNONYMS What are synonym, Create Synonym, Different types of Synonym, Dropping a synonym

SEQUENCE What are sequences, when are sequence used, how to use a sequence, create sequence, drop sequence, alter sequence.

SQL COMMAND COVERING DDL,DML,DCL,TCL,QUERY (2 Days 3 Hours)

DDL : this is covered while working with oracle objects.

DML : Writing DML (Data Manipulation Language) Statements. Delete single records, Delete all records, Conditional delete for multiple records, Delete records using a query, Insert Statement, Different ways of writing insert statement, Insert Single Records, Insert Multiple Records, Update all records, Conditional update, Update using multiple values, Updating multiple columns.

DCL : Data Control Language working with covering grant and revoke statements

TCL : transaction Control Language, Transactions, Commit Statement, Rollback Statement, generating single Savepoint, Using Rollback with savepoint, generating multiple savepoint.

QUERY : Query Writing, Join Operation, Different types of Join Operation, Simple Query, Nested Query, Creating an Inline View with query,

SQL: FUNCTION , OPERATORS & EXPRESSIONS (2 days 6 hrs)

Character Function Character Functions are studies if two different categories
(a) Character function which returns character value to be covered practically with examples Chr, Concat, Initcap, Lower, Lpad, Ltrim, Rpad, Rtrim, Substr, Upper
(b) Character function which returns number value to be covered practically with examples Ascii, Instr, Length

Number Function : Some of the number function to be covered practically with examples Abs, Ceil, Exp, Floor, Log, Mod, Power, Round, Sqrt, Trunc number functions

Date Functions Some of the date functions to be covered practically with examples Add_Months, Last_Day, Months_Between , Next_Day,Round ,Sysdate

Conversion Functions Some of the conversion functions to be covered with practical examples are TO_char (date conversion), To_Char (number conversion)
To_Date ,To_Number

Other Functions Some of the functions which are not categorized in number, date, character functions and is covered with practical examples are GREATEST, LEAST , NVL, UID, USER,DECODE

Aggregate Functions : Covering all Group Functions, Min ,Max, Avg, Sum, Count, Var, Stddev

OPERATORS : All these operators to be covered with practical examples Arithmetic, Operators, Character Operation, Comparison Operator, Concatenation operators, Logical operators, Assignment Operator(this is covered with PLSQL),Set Operator

EXPRESSION
Creating expression, Working with different expression in select statement