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:
Outer Ring Road
Opposite Innovative Multiplex
3rd Floor
Above Unilet Showroom
Beside Nandas Hyderabadi Biryani
Marathahalli, Bangalore 37

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
Devops
UI Development with AngularJS and Angular 2/4

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