SQL

Programs must be written for people to read, and only incidentally for machines to execute

SQL Courses

We have designed a syllabus which will help a student to take its first step in programming.
Our technical mentors provide a conceptual clarity to the students and encourage them to practice it on the machines. We offer three course bouquets which cater the needs of students from different educational levels and backgrounds.

Course bouquets:

SQL Training
Modules SQL
Aspects

SQL ( Writing Basic SQL SELECT Statements , Restricting and Sorting Data , Single-Row Functions , Displaying Data from Multiple Tables , Aggregating Data Using Group Functions , Subquerie , Manipulating Data , Creating and Managing Tables , Including Constraints , Creating Views , Other Database Objects , Controlling User Access , SQL Workshop , Using SET Operators , Enhancements to the GROUP BY Clause etc. )

PL/sql -

Part I: Programming in PL/SQL ( Introduction to PL/SQL , What Is PL/SQL? , The Origins of PL/SQL , About PL/SQL Versions , Resources for PL/SQL Developers ) , Creating and Running PL/SQL Code

Part II: PL/SQL Program Structure ( Conditional and Sequential Control , IF Statements , CASE Statements and Expressions , The GOTO Statement , The NULL Statement , Iterative Processing with Loops ) , Loop Basics , Exception Handlers

Part III: PL/SQL Program Data ( Working with Program Data , Naming Your Program Data , Overview of PL/SQL Datatypes , Declaring Program Data , Programmer-Defined Subtypes , Conversion Between Datatypes ) ,Strings , Numbers , Records , Collections , Miscellaneous Datatypes

Part IV: SQL in PL/SQL ( DML and Transaction Management , DML in PL/SQL , Bulk DML with the FORALL Statement , Transaction Management , Autonomous Transactions ) , Data Retrieval , Procedures, Functions, and Parameters , Packages , Triggers , Managing PL/SQL Code , I/O and PL/SQL .

Our programs are typically designed to cater the specific needs; their wide technical coverage gives an additional benefit to the students in their performance in respective undergraduate courses.

For more information on our courses, reach us at hrd@prestigepoint.in

  • blog-img-1
  • subscribe-bg
  • wowslider.com
  • counter-bg
blog-img-11 c++2 counter-bg3 subscribe-bg4
Eligibility
  • M.C.A., M.Sc(CS), M.Sc (IT), M.Tech
  • BE- CS ,Mech , IT Engg, EC, Ex
  • B.C.A, B.Sc (CS), B.Tech
  • Excellent Communication skills