Looking for S.Y.BCA in Ahmedabad?

Course: S.Y.BCA – Sem 2

(1) Introduction to SQL

  • Introduction to SQL
  • Data Definition Commands
    • Data Types
    • Creating Table Structures
    • SQL Constraints
  • Data Manipulation Commands
    • Adding Table Rows
    • Saving Table Changes
    • Listing Table Rows
    • Updating Table Rows
    • Restoring Table Contents
    • Deleting Table Row
  • Select Query
    • With Conditional Restrictions
    • Arithmetic Operators
    • Logical Operators
    • Special Operators


  • Advanced Data Definition Commands
    • Changing a Column�s Data Type
    • Changing a Column�s Data Characteristic
    • Adding a column
    • Dropping a column
    • Advanced Data Update
    • Copying Parts of Table
    • Adding Primary and Foreign Key Designations
    • Deleting Table From The Database
  • Aggregate Functions
  • View

(2) Business Intelligence and Data Warehouse

  • The need for data analysis
  • Business Intelligence
    • Business Intelligence Architecture
    • Decision Support Data
      • Operational Data Vs. Decision Support Data
      • Decision Support Database Requirements
  • The Data Warehouse
  • Online Analytical Processing
    • Multidimensional Data Analysis Techniques
    • Advanced Database Support
    • Easy-To-Use End-User Interface
    • Client/Server Architecture
  • Data Mining


(3) Distributed Database Management System

  • Distributed Database Management Systems
    • Evolution of DDBMS
    • Distributed Processing and Distributed Database
    • DDBMS Advantages and Disadvantages
    • Characteristics of DDBMS
    • Components of DDBMS


  • Levels of Data and Process Distribution
    • Single-Site Processing, Single-Site Data(SPSD)
    • Multiple-Site Processing, Single-Site Data(MPSD)
    • Multiple-Site Processing, Multiple-Site Data(MPSD)
  • Distributed Database Transparency Features
  • Distributed Transparency
  • Transaction Transparency
    • Distributed Requests and Distributed Transactions
    • Distributed Concurrency Control
    • Two-Phase Commit Protocol
  • Performance Transparency and Query Optimization


(4) Advanced SQL

  • Set Operators
    • Union
    • Union All
    • Intersect
    • Minus


  • SQL Join
    • Cross Join
    • Natural Join
    • Join Using Clause
    • Join On Clause
    • Outer Join


  • SQL Functions
    • Date and Time
    • Numeric
    • String
    • Conversion


  • Subqueries
    • Where Subqueries
    • In Sub queries
    • Multirow Subquery Operators: Any and All
    • From Subqueries
    • Attribute list Subqueries
    • Correlated Subqueries
  • Sequence