PHP / MySQL

Upcoming Batch

Duration

2month

Starts

Anytime Admission

Ends

Within 2 months of Admission

Timings

Scheduled given by Institute

Days

Scheduled given by Institute

📞 phone

+91-022-28809398

Fees

₹15,000 + GST ₹ 2700

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

PHP

    1. Variable ,Operators and Expressions
    2. Loops and Conditional Constructs
    3. Functions
    4. Class and Objects
    5. Interaction with MySql Database

Projects

  1. SCRUM
  2. KANBAN