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

Oracle Sql Workshop - SQL-ST-01

By
Font size: Decrease font Enlarge font

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

  1. Students   
  2. Professionals who are looking to make career with Oracle Platform    
  3. Teachers
  4. Professional persuing a career Programmers & developers
  5. 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
 

SQLPLUS (1 day) 3 hrs

SQLPLUS COMMANDS
REPORT GENERATION USING SQLPLUS COMMAND     

  • Sqlplus Commands    
  • Basic Sql Plus Commands
  • Report Generation Using Sqlplus Command    
  • Sqlplus Command File

FOR REGISTRATION TO WORKSSHOP CONTACT Vidya Education Society

  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article

0