Mastering Database

Mastering Database Queries [Bridge Course for Business Analytics]

a.    Course Duration :         40 Hours

b.    Course Fees:  Rs. 5520/-

c.    Participant Profile:          

  • Graduate with Statistics / Mathematics
  • Understanding of Relational Databases
  1. End Objective
    • Design complex queries based on Relational Database
    • Ready to attend courses on Business Analytics
  2. Course Outline
    • Structure of a Database [Flat Files, Hierarchical, Network, and Relational Database]
    • Codd’s Rules and Application to RDBMS
    • RDBMS Database Objects
    • Transact SQL [DDL, DML]
    • Basic Query Structure
    • Checkpoints
    • Update / Rollback
    • Sub queries
    • Joins [Inner, Outer, Equijoins]
    • Correlated Sub queries
    • Using Views in queries
    • Application of Rules using Triggers
    • Calling Store Procedures
    • Using Cursors
    • Database Structures in Different Application Scenarios
      • ERP
      • CRM
      • Analytics
      • Big Data Support