Palium Skills - Professional Training Institute in Kolkata | Oracle | PMP Certification| ITIL Certification | Java J2EE | Web Designing | Android | iOS | Final Yr Projects | Big Data | Staad pro  | Primavera | GD PI

Our footprint on Social Media

                        

Online and Classroom Training on SQL, t-SQL, Pl-SQL, DBA and Oracle Apps EBS

Palium offers classroom training in Kolkata on SQL, Pl=SQL, t-SQL, Oracle DBA Certification, Oracle Apps R12 and other related courses.

We also guide students appearing for their Certification exams like OCA, OCP and MTA

Every participant will get -

  • Personal Attention
  • Study Materials
  • Certificate after completing the course
  • Unlimited practice hours

The details of different courses are -

Palium is pleased to offer classroom or online Training on SQL in different forms -

Palium is pleased to offer classroom or online Training on SQL Programming in different technologies like -

  • t-SQL - used for programming in SQL Server, DB2 and other RDBMS systems
  • Pl-SQL - this course covers the curriculum for Pl-SQL Certification Exam conducted by Oracle and part of OCA

Palium also offers classroom or online Training on Database Administration for different products -

  • Oracle DBA WS2 11g or 12c - those wishing to appear for OCP certification need to clear Workshop2 exam after clearing OCA Exams

Plz call 9051092035 for more details -

About the Faculties

The program will be conducted by an experienced faculty with over 15 years of domain experience in this area having worked with renowned MNCs. Over the years, he has worked with numerous corporates in this domain and is presently engaged in conducting such classes.

SQL Duration Course Outline
MS SQL 24 hours
mySQL 24 hours

Oracle SQL Fundamentals

  • First Exam to be cleared by those appearing for OCA
40 hours
Introduction
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer?
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource (HR) Schema
  • Tables used in the Course
Retrieving Data using the SQL SELECT Statement
  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command
Restricting and Sorting Data
  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command
Using Single-Row Functions to Customize Output
  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions
Using Conversion Functions and Conditional Expressions
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement
Reporting Aggregated Data Using the Group Functions
  • Group Functions
  • Creating Groups of Data
  • Restricting Group Results
Displaying Data from Multiple Tables Using Joins
  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join
Using Subqueries to Solve Queries
  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
Using the SET Operators
  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations
Managing Tables using DML statements
  • Data Manipulation Language
  • Database Transactions
Introduction to Data Definition Language
  • Data Definition Language
Introduction to Data Dictionary Views
  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
  • Querying the Data Dictionary Views
Creating Sequences, Synonyms, Indexes
  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes
Creating Views
  • Overview of views
Managing Schema Objects
  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables
Retrieving Data by Using Subqueries
  • Retrieving Data by Using a Subquery as Source
  • Working with Multiple-Column subqueries
  • Using Scalar subqueries in SQL
  • Correlated Subqueries
  • Working with the WITH clause
Manipulating Data by Using Subqueries
  • Using Subqueries to Manipulate Data
  • Inserting by Using a Subquery as a Target
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Using Correlated Subqueries to Update and Delete rows
Controlling User Access
  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges
Manipulating Data
  • Overview of the Explicit Default Feature
  • Using multitable INSERTs
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking Changes in Data
Managing Data in Different Time Zones
  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
 

Programming in SQL is primarily done using t-SQL in Microsoft or using Pl-SQL in Oracle. So the relevant courses are

Programming in SQL Duration Course Outline
 t-SQL Programming Course 40 hours

Introduction to Microsoft SQL server

  • Introductions
  • Sql server 2008 editions
  • Sql server 2008 requirements
  • Downloading sql software
  • Selecting installation options
  • Installing a named instance
  • Sql server installation center overview
  • Lunching SQL server management studio

Management Studio

  • Introduction
  • Working with queries

Keys and Constraints

  • Introduction
  • Primary Keys
  • Foreign Keys and Composite Keys
  • Understanding Constraints

Data Definition Language (DDL)

  • Creation of table
  • Modifying the structure of a table
  • Dropping a table
  • Working with different options

Data Manipulation Language (DML)

  • Inserting, updating & deleting operations
  • Operators, Built-in functions, grouping

Basic Queries

  • Introduction
  • SELECT...FROM
  • WHERE
  • GROUP BY
  • ORDER BY

Special Condition in Query

  • Introduction
  • Operators
  • Combining Conditions
  • IN
  • LIKE
  • BETWEEN
  • UNION
  • EXCEPT and INTERSECT

Working with Functions

  • Using Operators
  • ISNULL and COALESCE
  • Using Functions

Joins

  • Introduction to Joins
  • Inner join
  • Outer join
  • Cross joins
  • Unions

Working with Indexes

  • Introduction to indexes
  • Clustered & non clustered indexes
  • Creating, dropping indexes
  • Index Maintenance Concepts

Triggers

  • Introduction to Triggers
  • DML Triggers
  • DDL Triggers

Introduction to T-SQL Programming

  • Variables
  • IF-ELSE
  • WHILE
  • ERROR Handling

Using T-SQL Logic

  • Tables
  • Views
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Database Cleanup

Other Types of Data

  • XML Data
  • MAX Data
  • Spatial Data Type
  • NEW DATE and TIME

Using Complex Queries

  • CTE Queries
  • Ranking Functions
  • MERGE
  • Output Clause

Linked Server

  • Introduction
  • Creating Login
  • Using Query in Linked Server

Database Snapshot

  • Snapshot Basics

SQL Server Performance

  • System Monitor
  • Profiler
Oracle Pl-SQL Course 40 hours

Introduction to PLSQL

  • History of PL/SQL language
  • The anonymous PLSQL block
  • Variables &  Data types
  • SQL operators,  Nested blocks
  • SELECT … INTO statement

Iterative and Conditional control structures

  • Parsing cursors in procedures
  • OPEN. FETCH CLOSE construct
  • The %NOTFOUND operator
  • OR UPDATE cursors, Pl-SQL Case
  • Use of IF-THEN-ELSE statement
  • Nesting of these statements. 
  • Use of  FOR Loop &  WHILE Loop
  • Row to label a loop and how to nest a loop.

Exceptions and Exception handling

  • What are Exceptions?
  • And for handling & types of exceptions
  • The raise_application_error built-in procedure & User defined exceptions
  • Raising & Trapping Exceptions
  • Exception propagation in nested calls
  • Use of SQLCODE & SQLERRM

Creating Functions

  • Syntax of CREATE FUNCTION
  • Restrictions on function calls
  • Propping functions

Creating Procedures (Stored sub-programs)

  • Stored sub-programs (Procedure/Functions)
  • Id for Procedures – create syntax
  • Use of Parameters ( IN , OUT & IN OUT)
  • Executing procedures & trapping Exceptions

Creating Packages (PL/SQL API Development)

  • What are packages and what is an API ?
  • Package Body & Specification
  • Private and Public Package level data
  • Calling package functions, procedures
  • Conferencing package-level constants & variables

Package Features

  • Overloading package subprograms
  • Forward declaration of subprograms
  • Creating bodiless package
  • Persistent state of package variables & cursor

Using Oracle Supplied Packages

  • BMS_OUTPUT & DBMS_UTILITY
  • UTL_FILE, UTL_MAIL
  • BMS_RANDOM & EXECUTE IMMEDIATE

Oracle Utilities

  • SQL*loader (sqlldr)
  • The spool and spool append commands.
  • Profiling PL/SQL code using DBMS_HPROF supplied package

Composite data types

  • Parsing %ROWTYPE
  • SQL Records & Table of Records

Triggers

  • Describe Triggers
  • Identify the Trigger Event Types and Body
  • Business Application of Triggers
  • Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
  • Identify Trigger Event Types, Body & Firing
  • Differences in Statement & Row Level Triggers
  • Create Instead of and Disabled Triggers
  • How to Manage, Test and Remove Triggers?

Bulk Data Processing with PL/SQL

  • The PL/SQL & SQL Run Time engine
  • Intext switching between PL/SQL Run Time engine and SQL Run Time engine.
  • OR ALL operation in PL/SQL
  • Exception Handling during Bulk Data Processing.

Dynamic SQL

  • Execution Flow of SQL
  • What is Dynamic SQL? Declare Cursor Variables
  • Dynamically Executing a PL/SQL Block
  • Configure Native Dynamic SQL to Compile PL/SQL Code
  • How to invoke DBMS_SQL Package?
  • Implement DBMS_SQL with Parameterized DML Statement
  • Dynamic SQL Functional Completeness

Creating compound DDL & Event Triggers

  • What are Compound Triggers?
  • Identify Timing-Point Sections of a Table Compound Trigger
  • Compound Trigger Structure of Tables/ View
  • Implement a Compound Trigger to Resolve the Mutating Table Error
  • Database Triggers & Stored Procedures
  • Create Triggers on DDL Statements
  • Create Database & System-Events Triggers
  • System Privileges Required for Triggers

Manage Dependencies

  • Overview of Schema Object Dependencies
  • Query Direct Object Dependencies using the USER_DEPENDENCIES View
  • Query an Object’s Status
  • Invalidation of Dependent Objects
  • Display the Direct & Indirect Dependencies
  • Understand Remote Dependencies
  • Recompile a PL/SQL Program Unit

PL/SQL Compiler

  • What is the PL/SQL Compiler?
  • Initialization Parameters for compiling PlSql
  • List new PL/SQL Compile Time Warnings
  • Overview of PL/SQL Compile Time Warnings for Subprograms
  • List the benefits of Compiler Warnings
  • List the PL/SQL Compile Time Warning Messages Categories
  • Setting the Warning Messages Levels:
  • View Compiler Warnings:

Design Considerations for PL/SQL Code

  • Standardize Constants and Exceptions
  • Understand Local Subprograms
  • Write Autonomous Transactions
  • Implement the NOCOPY Compiler Hint
  • Invoke the PARALLEL_ENABLE Hint
  • Cross-Session Pl/Sql Function Result Cache
  • The Deterministic Clause with Functions
  • Usage of Bulk Binding to Improve Performanc

Certification Exam: Oracle Database 11g: Program with PL/SQL  Exam Number : 1Z0-144

Exam Product Version:

Oracle Database 11g

Exam Price:

Rs 9,604

Format:

Multiple Choice

Duration:

90 minutes

Number of Questions:

63

Passing Score

65%

This exam has been validated against Oracle Database 10g, Oracle Database 11g, & 11g Release 2,  Oracle Database 12c Release 1.

Oracle PL/SQL Developer Certified Associate Oracle Advanced PL/SQL Developer Certified Professional ,

Step 1 – Pass one of the following exam
Step 2- Pass this exam

For those aspiring for a career in Database Administration are advised to attend the following courses -

DBA Courses Duration Course Outline
Oracle DBA WS1 - Database version 11g or 12c 40 hours
Exploring the Oracle Database Architecture
  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structures
  • Logical and physical storage structures
  • ASM storage components
Installing your Oracle Software
  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install
Creating an Oracle Database
  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database
Managing the Oracle Database Instance
  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views
Manage the ASM Instance
  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups
Configuring the Oracle Network Environment
  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)
Administering User Security
  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles
Managing Data Concurrency
  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
Managing Undo Data
  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
Implementing Oracle Database Auditing
  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
Database Maintenance
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks
Performance Management
  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
Backup and Recovery Concepts
  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files
Performing Database Backups
  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
Performing Database Recovery
  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views
Moving Data
  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data
Working with Support
  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches
Oracle DBA WS2 - Database version 11g or 12c 40 hours
Core Concepts and Tools of the Oracle Database
The Oracle Database Architecture: Overview
ASM Storage Concepts
Connecting to the Database and the ASM Instance
DBA Tools Overview
Configuring for Recoverability
Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
Using the Recovery Manager (RMAN)
Configuring your Database for B&R Operations
Configuring Archivelog Mode
Configuring Backup Retention
Configuring and Using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
Tracking and Storing Backup Information
Setting up a Recovery Catalog
Recording Backups
Using RMAN Stored Scripts
Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
Configuring Backup Settings
Configuring and Managing Persistent Settings for RMAN
Configuring Autobackup of Control File
Backup optimization
Advanced Configuration Settings: Compressing Backups
Configuring Backup and Restore for Very Large Files (Multisection)
Creating Backups with RMAN
RMAN backup types
Creating and Using the following:
- Backup Sets and Image Copies
- Whole Database Backup
- Fast Incremental Backup
- Configure Backup Destinations
- Duplexed Backup Sets
- Archival Backups
Restore and Recovery Task
Restoring and Recovering
Causes of File Loss
Automatic Tempfile Recovery
Recovering from the Loss of a Redo Log Group
Recovering from a Lost Index Tablespace
Re-creating a Password Authentication File
Complete and Incomplete Recovery
Other Recovery Operations
Using RMAN to Perform Recovery
Complete Recovery after Loss of a Critical or Noncritical Data File
Recovering Image Copies and Switching Files
Restore and Recovery of a Database in NOARCHIVELOG Mode
Incomplete Recovery
Performing Recovery with a Backup Control File
Restoring from Autobackup: Server Parameter File and Control File
Restoring and Recovering the Database on a New Host
Monitoring and Tuning RMAN
Monitoring RMAN Jobs
Balance Between Speed of Backup Versus Speed of Recovery
RMAN Multiplexing
Synchronous and Asynchronous I/O
Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
Diagnosing the Database
Data Recovery Advisor (DRA)
Block Corruption
Automatic Diagnostic Repository (ADR)
Health Monitor
Copyright © 2013, Oracle. All rights reserved. Page 3
The ADR Command-Line Tool, ADRCI
Using Flashback Technology I
Flashback Technology: Overview and Setup
Using Flashback Technology to Query Data
Flashback Table
Flashback Transaction Query
Performing Flashback Transaction Backout
Using Flashback Technology II
Oracle Total Recall
Flashback Drop and the Recycle Bin
Performing Flashback Database
Configuring Flashback Database
Performing Flashback Database Operations
Monitoring Flashback Database
Managing Memory
Oracle Memory Structures
Oracle Database Memory Parameters
Using Automatic Memory Management
Automatic Shared Memory Management
Using Memory Advisors
Using Data Dictionary Views
Managing Database Performance
Tuning Activities
Using Statistic Preferences
Optimizer Statistics Collection
Monitor the Performance of Sessions and Services
Automatic Workload Repository (AWR)
Describing the Benefits of Database Replay
Managing Performance by SQL Tuning
SQL Tuning and SQL Advisors
Using SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer Overview
Managing Resources
Database Resource Manager: Overview and Concepts
Accessing and Creating Resource Plans
Creating Consumer Group
Specifying Resource Plan Directives, including:
- Limiting CPU Utilization at the Database Level
- Instance Caging
Activating a Resource Plan
Monitoring the Resource Manager
Automating Tasks with the Scheduler
Simplifying Management Tasks
Copyright © 2013, Oracle. All rights reserved. Page 4
Creating a Job, Program, and Schedule
Using Time-Based, Event-Based, and Complex Schedules
Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
Multi-Destination Jobs
Managing Space in Blocks
Free Space Management
Monitoring Space
Compressing Data
Managing Space in Segments
Segment Creation on Demand
Additional Automatic Space-Saving Functionalit
Shrinking Segments
Segment Advisor
Managing Resumable Space Allocation
Managing Space for the Database
Using 4 KB-Sector Disks
Transporting Tablespaces
Transporting Databases
Duplicating a Database
Purpose and Methods of Cloning a Database
Using RMAN to Create a Duplicate Database
Cloning a Database from a Backup
Duplicate a Database Based on a Running Instance
Targetless Duplicating a Database

SQL Server Administration

Microsoft Technology Associate (98-364)

Database Administration Fundamentals

In preparation for your MTA exam you can

now take a practice test here -->

Microsoft Official Practice Test for Exam 98-364

(Note: This is not a free test and provided by

Microsoft Associate and not Palium)

40 hours
Overview of MTA DBA Fundamentals exam (98-364)
Introduction
o  What's a Database?
o  Different types of database
Relational Database Concepts
o  Introduction
o  Concepts of DBMS
o  Relational Database Systems
o  Tables, Rows, and Columns
o  Indexes
o  Storage: Pages and Physical Files
Introduction to Microsoft SQL server
o  Introductions
o  Sql server 2008 editions
o  Sql server 2008 requirements
o  Downloading sql software
o  Selecting installation options
o  Installing a named instance
o  Sql server installation center overview
o  Lunching SQL server management studio
Management Studio
o  Introduction
o  Working with queries
Keys and Constraints
o  Introduction
o  Primary Keys
o  Foreign Keys and Composite Keys
o  Understanding Constraints
Data Definition Language (DDL)
o  Creation of table
o  Modifying the structure of a table
o  Dropping a table
o  Working with different options
Data Manipulation Language (DML)
o  Inserting, updating & deleting operations
o  Operators, Built-in functions, grouping
Basic Queries
o  Introduction
o  SELECT...FROM
o  WHERE
o  GROUP BY
o  ORDER BY
Special Condition in Query
o  Introduction
o  Operators
o  Combining Conditions
o  IN
o  LIKE
o  BETWEEN
o  UNION
o  EXCEPT and INTERSECT
Database Normalization
o  What is Normalization?
o  1NF: Eliminate Repeating Groups
o  2NF: Eliminate Redundant Data
o  3NF: Eliminate Non-Dependent Columns
o  De-normalization
Implementing Views
o  Introduction
o  Creating views
o  Altering, dropping views
o  Table vs view
Joins
o Introduction to Joins
o Inner join o  Outer join o Cross joins o Unions
Implementing stored procedures
o Introduction to stored procedures
o Creating, executing, modifying, dropping stored procedures
o Executing extended stored procedures
Working with Indexes
o Introduction to indexes
o Clustered & non clustered indexes
o Creating, dropping indexes
o Index Maintenance Concepts
Sql server security
o Introduction
o Windows vs. SQL Security
o Object Permissions
o Ownership Chains
Backup
o Introduction to backups
o Backup devices
o Recovery
Database Maintenance
o Introduction
o Backup plan

After each of the courses, participants can sit for the corresponding Certification courses as desired.

Hurry Call us today or more details !

We also conduct trainings on Primavera P6, MS Project and other Project Management related topics.

For Registration Contact:               

Barindra De:  + 91 – 90510  92035   or

Shrabana Pal: + 91 – 84205  94969

Palium Software Services Private Limited

1st Floor, ‘Sheeba Bhavan’,
1/22, Poddar Nagar
(Near South City Mall/Dominos Pizza),
Kolkata, West Bengal 700068
P: +91-842 059 4969 L: +91-33-4001 7947
E: trainings@paliumsoftware.in
www.paliumtrainings.biz
Plz call +91-9051092035 for more details -

About the Faculty

The program will be conducted by an experienced professional with many years of IT Service Management exposure and experience. He has helped numerous individuals to achieve PMP certification.

 


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save