Home‎ > ‎

Php, Database Technology

Video Course  :  Available 
ClassRoom Course  :  Available 


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
PHP/Database Technology January 19, 2012 March 15, 2012 6.00 pm to 9.00 pm Tue/Thu Proposed 
Showing 1 items from page PHP/Database Technology Upcoming batches sorted by Start Date. View more »

Ongoing Batches

CourseStart DateEnd DateTimingsDays
PHP/Database Technology   N/A N/A 
Showing 1 items from page PHP/Database Technology Ongoing batches sorted by edit time. View more »

Prerequisite

  • Knowledge of C Programming

Predecessors

Courses that can be taken before PHP/Database Technology course

C C++ DataStructures


Successors

Courses that can be taken after completing PHP/Database Technology course

Java Technology

C# Asp.net


Php Database Technology User Group (Login Required)

Php Database Technology Usre Group


Subpages (2): Duration Fee Structure