Contact Us On

+91-8149926026

Mail Us On

swatid@anexpertise.com

SQL PL-SQL

SQL

Duration :  1 Month

Pre-requisite : C Prog

  • Introduction to DBMS and RDBMS Database design and Normalization
  • Writing Basic SQL Statements Restricting and Sorting Data
  • Using Single Row Function to Customize output
  • Reporting Aggregated Data Using Group Functions, Displaying data from Multiple Tables
  • Using Sub queries, Using Set Operators, Manipulating Data
  • Using DDL statements to create and manage tables, Creating other schema objects
  • Managing objects with data dictionary views, Controlling user access, Managing schema objects
  • Manipulating large data sets, Generating reports by Grouping related data, Managing data in different time zones
  • Retrieving data using sub queries, Hierarchical Retrieval, Regular expression support

PL SQL

Duration: 1 Month

Pre-requisite: SQL

  • Data Types
  • Variables
  • Constants
  • Operators
  • Conditions
  • Loops
  • Strings
  • Arrays
  • Procedures
  • Functions
  • Cursors

 

 

 

 

  • Records
  • Exceptions
  • Triggers
  • Packages
  • Collections
  • Transactions
  • Date & Time
  • DBMS Output
  • Object Oriented
  • RDBMS Concepts
  • Primary key
Message Us on WhatsApp
About US

Anexpertise is an earnest attempt by a few young entrepreneurs & technical persons. Who inspect the education framework & felt that it was all-important

Useful Links




Our Courses
Job Oriented Programs
Programming Basics
Database
Java Technology
Full Stack Courses
Data Science
Cloud Technology
Testing
Our Office

Office No 6, First floor, Laxmi Balvant Chamber, Above Surbhi Hotel, JM Road, Shivaji Nagar Pune, Maharashtra, India 411005.
Phone:(+91) 8149926026
Email:swatid@anexpertise.com