How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
WhatsApp:
+91 99001 13931
Email:
pragim@pragimtech.com
pragim@gmail.com
Address:
2nd Floor
Above Pick 'N' Move
Adjacent to HP Petrol Pump
Marathalli, Bangalore

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
DOT NET | MVC
Sharepoint
MSBI
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
EMC SAN
Testing Tools
Selenium Testing
HADOOP
TIBCO
Tableau
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
QlikView
IBM MQ Admin
Android
Salesforce

Interview Questions Dot Net Video Tutorials
C#
C# Programs
ASP.NET
WCF
SQL Server
MVC
HR
Oracle PL/SQL Training Course Contents
Oracle Architecture (BASIC to Modirate)
  • What is Oracle Database Server
  • Connecting to Database Instance in Dedicated Server Mode
  • Connecting to Database Instance in Shared Server Mode
  • Introduction to File Structures in Database
  • Introduction to Oracle Memory Structure(SGA, PGA , UGA)
  • Oracle Shared Pool, JAVA Pool, Large Pool, Stream Pool, etc.
  • Introduction to Oracle’s Processes(Server, backgroud, Slave)
  • Oracle Database Server Installing Scenarios
  • Hardware Consideration For Installing Oracle Database
  • What is a Transaction in Context of RDBMS(Atomicity,Durability,Consistency,Isolation)
  • Distributed Transaction
  • Autonomous Transaction
  • What is Locking?(Optimistic and Pessimistic)
  • What is Blocking in Oracle
  • Types of DDL Locks in Oracle
  • Types of Locks and Latches in Oracle
  • How Commit and Rollback Works in Oracle
  • Undo Management In Oracle
  • Common Performance Issues in Redo Log
  • Oracle Storage Terminology
  • High water mark and free lists
  • Oracle Storage Parameters(PCTFREE , PCTUSED,INITTRANS, MAXTRANS, INTIAL, NEXT, PVTINCREASE)
SQL(Beginers to advance)
  • What is SQL and Why learn SQL
  • An Introduction to Databases
  • DBMS Vs RDBMS and RDBMS Vs ORDBMS
  • An Introduction to SQL*Plus
  • The SQL Execution Environment
  • The WHERE and ORDER BY Clauses
  • System defined fuctions
  • Reading Syntax Diagrams
  • Date and Conversion Functions
  • Aggregate Functions, GROUP BY, and HAVING Clauses
  • Simple and Complex joins
  • Subqueries(Simple, Co-related, Scalar, Inline view)
  • Insert, Update, and Delete(DML)
  • Create, Alter, and Drop Tables(DDL)
  • Indexes, Sequences, and Views
  • The Data Dictionary, Scripting, and Reporting
  • Users, Privileges, Roles, and Synonyms
  • Regular Expressions and Hierarchical Queries
  • Advance SQL Concepts ( Analytic Fuction, WITH Clause, Rollup, Cube)
Oracle PL/SQL (Beginer to Advance)
  • Overview of PL/SQL
  • PL/SQL Language Fundamentals
  • PL/SQL Data Types
  • Using PL/SQL Control Structure
  • Using PL/SQL Collections and Records(Varray,Nested and Associative)
  • What is Static SQL and its use
  • What is Dynamic SQL and its use
  • PL/SQL Subprograms(Procedure, Function)
  • Concept of Triggers and there use
  • PL/SQL Package (System and User defined)
  • Handling PL/SQL Errors
  • Tuning PL/SQL Applications for Performance
  • How PL/SQL Optimizes Your Programs
  • When to Tune PL/SQL Code
  • Guidelines for Avoiding PL/SQL Performance Problems
  • Collecting Data About User-Defined Identifiers
  • Reducing Loop Overhead for DML Statements and Queries with Bulk SQL
  • Writing Computation-Intensive PL/SQL Programs
  • Tuning Dynamic SQL with EXECUTE IMMEDIATE Statements and Cursor Variables
  • Tuning PL/SQL Subprogram Calls with NOCOPY Hint
  • Compiling PL/SQL Units for Native Execution
  • Performing Multiple Transformations with Pipelined Table Functions
UNIX (Beginer to Modirate)
  • Unix Getting Started
  • Unix File Management
  • Unix Directories
  • Unix File Permission Setup
  • Unix Environment
  • Unix Pipes and Filters
  • Unix Processes Management
  • Unix Communication(ftp,telnet,finger,ping)
  • Unix – The vi Editor
  • Unix- What is Shell
  • Unix- Using Variables
  • Unix- Special Variables
  • Unix – Using Arrays
  • Unix - Basic Operators(C Shell and Korn Shell)
  • Unix – Decision Making(if..else..if,if...elif...else...fi,case,loop etc.)
  • Unix – Shell Substitutions
  • Unix – Quoting Mechanisms
  • Unix – IO Redirections
  • Unix – Shell Functions
  • Unix - Manpage Help
  • Unix - Regular Expressions
  • Unix – File System Basics
  • Unix – User Administration
  • Unix – System Performance
  • Unix – System Logging
  • Unix – Signals and Traps
  • Unix – Useful Commands
  • Unix – Builtin Functions
Interview Questions
  • Oracle Architecture Interview Question
  • SQL Interview Questions
  • PL/SQL Interview Questions
  • Unix Interview Questions
  • OCA-OCP Dump Questions details discussion and solution
Disclaimer - Terms of use - Contact Us