Courses‎ > ‎

Php, Database Technology

Syllabus

  1. Introduction to Database
    1. Anatomy of Database Systems
    2. Application of Database Systems
    3. Stake Holders
      1. Users
      2. Administrators
      3. Programmers
    4. Client/Server Architectures
    5. Distributed Databases
    6. History
  2. Modelling
    1. Semantic
    2. Logical
    3. Physical
  3. File System
    1. Organization of File System
    2. Database System v/s File System
  4. Types of Database Systems
    1. Hierarchical
    2. Network
    3. Relational
    4. Object-Relational
    5. Object-Oriented
    6. No-SQL
  5. ER Modelling
    1. Entity
    2. Relationships
    3. Types of Entities and their Relations
    4. Design Considerations
    5. Applications
  6. Relational Modelling
    1. Introduction to Relational Algebra
    2. Anatomy of Relational Model
    3. Design Issues
    4. Normalization
    5. Applications
  7. Principles of Data-Storage and Querying
    1. Storage & File Structures
    2. Indexing
    3. Query Processing
    4. Query Optimization
  8. Structured Query Language
    1. Introduction to SQL
    2. Data Definition
    3. Data Types
    4. Creating , Manipulating and Dropping Databases
    5. Creating , Manipulating and Dropping Tables
    6. Creating , Manipulating and Dropping Views
    7. Working with Indexes
    8. Working with Constraints
  9. Data Manipulation
    1. Recurring SQL constructs
      1. Select
      2. Insert
      3. Update
      4. Delete
    2. Expressions
    3. Grouping and Aggregate Functions
    4. Different types of Joins
    5. Sub-Queries and Co-related Queries
    6. Set Operations
  10. PL/SQL
    1. Blocks, types , variables and operators
    2. Loops and conditional constructs
    3. Functions and Procedures
    4. Different types of Cursors
    5. Packages
    6. Stored Procedures
    7. Triggers
  11. User Management
    1. Creating Users
    2. Granting Privileges
    3. Revoking Privileges
    4. Different types of Privileges and Roles
    5. Resource Quota Management
  12. Transaction Management
    1. Transactions
      1. ACID properties
      2. Commit
      3. Rollback
      4. SavePoints
    2. Locking
      1. Optimistic
      2. Pessimistic
    3. Logs and Recovery
  13. Oracle Database Architecture
    1. Responsibilities of Client
    2. Responsibilities of Server
    3. Physical Layer
      1. Control Files
      2. Log Files
      3. Data Files
    4. Logical Layer
      1. TableSpaces
      2. Segments
      3. Extents
      4. DataBlocks
      5. Schema
      6. Database Objects
    5. Oracle Instance
      1. SGA (System Global Area)
      2. PGA (Program Global Area)
      3. Roles and Responsibilities of Processes
    6. Distributed Databases
    7. Grid Computing
    8. Oracle Enterprise Manager
    9. SQL Developer
  14. Php Programming
    1. Variable ,Operators and Expressions
    2. Loops and Conditional Constructs
    3. Functions
    4. Class and Objects
    5. Interaction with MySql Database
  15. Project Work
    1. ER diagram for datamodel of SCRUM Engine
    2. Relational Model for SCRUM engine
    3. Writing Queries and Procedures for SCRUM Engine
    4. Webification using PHP
Upcoming Batches
CourseStart DateEnd DateTimingsDaysStatus
Showing 0 items from page PHP/Database Technology Upcoming batches sorted by edit time. View more »

Ongoing Batches
CourseStart DateEnd DateTimingsDaysStatus
Showing 0 items from page PHP/Database Technology Ongoing batches sorted by edit time. View more »

Fees and Duration
Terms and Conditions
Course TypeCourse FeesDuration
Class Room Rs. 15,000 12 weeks 
Video Course Rs. 15,000 12 weeks 
Online Rs. 12,000 16 weeks 
Showing 3 items from page Fee Structure & Duration - Php Database sorted by id. View more »

Prerequisite
  • Computer User
  • No prior programming language skills expected.

Predecessor Courses

Successor Courses
Courses you can enroll after completing Php, Database Course

Testimonials
  • Anita Yadav
    It was a very good experience to learn PHP/DB from Rajesh Patkar Institute of Software Engineering. It was very easy to understand and grasped all its aspects. Students also got innovative ideas and guidance about their carriers.

    Anita Yadav,
    MSC Geomatics, CEPT University
    Posted May 28, 2015, 10:11 PM by Rajesh Patkar
Showing posts 1 - 1 of 5. View more »