S P SHARMA CLASSES

PL/SQL, MYSQL, SQLSERVER
Duration: 02 Months, Fee: Rs. 6000



Content: MySql/SqlServer (01 Months - Rs. 3000)



  1. Theory, Terminology and Concepts
    • Client/Server Concepts
    • Database and Database Objects
  2. Data Definition using SQL
    • Databases
    • Data Types
    • Tables
    • Constraints and Indexes
    • Views
  3. Basic Data Manipulation using SQL
    • Recurring SQL Constructs
    • Adding data
    • Modifying data
    • Removing data
    • Searching data
  4. Advanced Data Manipulation using SQL
    • Expressions
    • Grouping and Aggregate Functions
    • Joining Tables
  5. Transactions
    • Transaction Concepts
    • SQL for working with Transaction
  6. Import/Export
    • Tools for Import/Export
    • SQL for Import/Export


Content: PL/SQL(01 Months - Rs. 3000)



  1. Part I: Programming in PL/SQL
    • Creating and Running PL/SQL Code
  2. Part II: PL/SQL Program Structure
    • Loop Basics
    • Exception Handlers
  3. Part III: PL/SQL Program Data
    • Strings
    • Numbers
    • Records
    • Collections
    • Miscellaneous Datatypes
  4. Part IV: SQL in PL/SQL
    • Data Retrieval
    • Procedures, Functions, and Parameters
    • Packages
    • Triggers
    • Managing PL/SQL Code
    • I/O and PL/SQL