Oracle-PL/SQL

10000 Learners


Course Objective:

After completion of this course, student will get an idea of working with databases


Course Content:

Concept of Rdbms
  • DBMS vs RDBMS
  • Data Models
  • Concept of Keys
  • Functional Dependency
  • Normalization
Introduction to SQL
  • DCL, DML, DDL, DQL
  • Introduction to Oracle
  • Oracle SQL structure
  • SQL basics
  • Creating database, tables, modifying tables
  • Adding keys-column level, table level
SQL Continued…
  • SQL operators
  • Insert, Update, Delete, Select
  • SQL clause, ordering data, grouping similar data
  • Summary report
SQL Continued…
  • Subquery
  • SQL Functions
  • Basic wild card operations
Introduction to PL/SQL
  • What is PL/SQL?
  • PL/SQL architecture
  • Advantages of PL/SQL
  • Features of PL/SQL
  • Basic Syntax
PL/SQL Basics
  • PL/SQL data types
  • Variables, Identifiers
  • Constants, Literals
  • Operators
PL/SQL Statements
  • Variable declaration
  • Decision Making
  • Loops
PL/SQL Arrays
  • Advantages of arrays
  • Types of arrays
  • Using array in a batch
PL/SQL Functions
  • Defining functions
  • Function parameters
  • Function return values
  • Working with functions
  • Function and arrays
PL/SQL Procedures
  • Oracle procedures
  • Advantages of procedures
  • Working with procedures
  • Executing procedure
  • Procedures and functions
  • Procedures with input parameters
  • Procedures with output parameters
PL/SQL Transactions
  • Concept of Transactions
  • Characteristics of transactions
  • Locking and deadlock
  • Inconsistency problems
  • Creating transactions
PL/SQL Triggers
  • What is Trigger?
  • Advantages of triggers
  • Mode of using triggers
  • Types of triggers
  • Magic tables
  • Modifying triggers
  • Creating triggers
  • Deleting triggers
DBMS_OUTPUT
  • Use of DBMS_OUTPUT package
  • Functions with DBMS_OUTPUT
  • Concatenation operator
Packages
  • What is package
  • Benefits of package
  • Oracle pre-defined packages
  • Creating and using packages in Oracle
Doubt session & Revision
Q & A

Key Features

  • Gain skills and competencies required in Industry by Experts.
  • Work on Real-time Projects depending upon the course you select.
  • Students work in a professional corporate environment.
  • Get a globally recognized Certificate form WebTek with our partner logos.
  • Global Brand recognition for Placements.
Best Oracle DBA Training Institute in Kolkata

Includes

  • Course Duration: 4 – 6 Weeks
  • Regular Batches: Online / Offline
Copyright © 2019 webteklabs.com
Webteklabs
Webteklabs
Webteklabs
Webteklabs
Free Demo
Call now