Advance Diploma in Computer Application

Course Description

Advance Diploma in Computer Application (ADCA) is a diploma course in the field of Computer Applications that involves the study of numerous computer software applications such as MS Office, Internet Applications, Computer Accounting, Web Design & Development, and other subjects.

The course curriculum ensures that students gain in-depth knowledge of computer applications while becoming technology-friendly and professionally skilled.

Module 1: Advanced MS Word

Getting Started with Word

Getting Started with Word
Navigate in Microsoft Word
Create and Save Word Documents
Manage Your Workspace
Edit Documents
Preview and Print Documents
Customize the Word Environment

Formatting Text and Paragraphs

Apply Character Formatting
Control Paragraph Layout
Align Text Using Tabs
Display Text in Bulleted or Numbered Lists
Apply Borders and Shading

Working More Efficiently

Make Repetitive Edits
Apply Repetitive Formatting
Use Styles to Streamline Repetitive Formatting Tasks

Managing Lists

Sort a List
Format a List

Adding Tables

Insert a Table
Modify a Table
Format a Table
Convert Text to a Table

Inserting Graphic Objects

Insert Symbols and Special Characters
Add Images to a Document

Controlling Page Appearance

Apply a Page Border and Color
Add Headers and Footers
Control Page Layout
Add a Watermark
Set the Page Orientation (Portrait or Landscape)
Set the Print Size of the Paper
Split Text into Multiple Columns
Add Page Breaks
Add Section Breaks

Advanced Mail Merge

Beginning a Mail Merge
Using Excel for Mail Merge Data
Previewing Merge Letters
Selective Merge Records
Filtering
IF Then Else Fields
Include Text Fields
Mail Merge to Email

Preparing to Publish a Document

Check Spelling, Grammar, and Readability
Use Research Tools
Check Accessibility
Save a Document in Other Formats

Macros

The Macro Recorder
Recording Macros
Testing Macros
Running Macros

Keyboard Shortcuts

Microsoft Word Keyboard Shortcuts

Module 2: Professional MS Excel

Mathematical & Statistical Functions

Sum
Product
Average
Ceiling
Floor
Round
Round Up
Round Down
Power
Count
CountA
Maximum
Minimum
Mode
Median
Log
Dollar
AverageA
MinA
MaxA
Large
SQRT
Mod
Roman
Rank
Rank Average
Rand
Rand Between

Logical Functions

IF
Nested IF
SUMIF
SUMIFS
AVERAGEIF
AVERAGEIFS
COUNTIF
COUNTIFS
OR
NOT
AND
IFERROR
IF Function & Nested IF Statements
AND & OR Functions
MAXIFS
MINIFS

Text Functions

Upper
Lower
Left
Right
Exact
LEN
MID
Concatenate
Proper
Trim
Substitute
Search
Find

Date & Time Functions

DAYS360
Date
Network Days
NOW
TODAY
WEEKDAY
EFFECT
EOMONTH
EDATE
WORKDAY
DATEDIF

Lookup & Reference Functions

INDEX
MATCH
LOOKUP
CHOOSE
OFFSET
OFFSET with MATCH
XLOOKUP
TRANSPOSE
HLOOKUP for Single Worksheet
VLOOKUP for Single Worksheet
HLOOKUP & VLOOKUP for Multiple Sheets
Match and Find Records using VLOOKUP & HLOOKUP
Approximate Match with VLOOKUP
Exact Match with VLOOKUP
Nesting Lookup Functions
Show Formula
CHOOSE Function with VLOOKUP
INDIRECT

Financial Functions

PMT
RATE
PPMT
IPMT
FV
PV
COUPDAYS
COUPNUM
ISPMT
SLN
CUMPRINC
CUMIPMT
DDB
DB
RECEIVED

Database Functions

DAVERAGE
DPRODUCT
DMIN
DMAX
DCOUNT
DSUM
DGET

Working with Charts

Creating 2D & 3D Charts
Create Column Chart
Create Pie Chart
Create Pareto Charts
Create Speedometer Chart
Move Charts to Another Sheet
Resize Charts
Change Chart Type
Edit Chart Text
Modify Chart Options
Format Category & Value Axis
Format Data Series
Change Chart Source Data

Cell Formatting

Cell Format
Data Bars
Color Scales
Icon Sets
Basic Sorting
Sorting Using Customized Lists
Advanced Sorting

Conditional Formatting

Using Conditional Formatting
Removing Conditional Formatting
Format as Table
Create Custom Styles
Conditional Formatting with Formulas
Conditional Formatting with Form Controls

Data Management & Validation

Data Validation
Handling Invalid Data
Group & Outline Data
Data Consolidation
Text to Columns
Custom Views

Data Analysis

Trace Formula Precedents
Trace Cell Dependents
Error Checking

Subtotals & Grouping

Add Subtotals
Nest Subtotals
Group & Outline Data
Data Validation
Text to Columns

What-If Analysis

Goal Seek
Data Tables
Create & Display Scenarios

Sorting & Filtering

Sort Records
AutoFilter
Filter & Advanced Filter
Apply Advanced Filters

Workbook Protection

Lock & Unlock Cells
Protect Worksheet
Protect Workbook
Create Shared Workbook
Track Workbook Changes
Accept & Reject Changes
Password Protection
Merge Workbooks

Workgroup Collaboration

Web Page Preview
Convert Worksheets into Web Pages
Insert Hyperlinks
View & Edit Comments

Macros

Customize Macro with Action Buttons
Create Conditional Macros
Run & Edit Macros
Add Menus to Menu Bar
Add Commands to Menu
Add Toolbar Buttons

Pivot Table & Pivot Chart

Create Pivot Table
Rearrange Pivot Table
Filter Pivot Table Data
Create Pivot Chart

MIS & Financial Reports

MIS Report
Profit & Loss A/c Statement
Balance Sheet
Worker Contribution Statement
Cash Flow Statement
Debtors & Creditors Statement
Inventory Statement
BRS Statement
Fixed Assets & Fund Statement
Payroll Report
P.F. & E.S.I. Report

Advanced Paste Special Techniques

Paste Formulas
Paste Formats
Paste Validation
Transpose Tables
Paste Data

Special Operations

Find Records Using Drop-down Lists
Dashboard
Working with Web & External Data
Insert Hyperlinks
Import Data from Access Database
Import Data from Text File
Import Data from Web
Existing Data Connections
Speedometer Dashboard

Print Settings

Page Break
Print Area
Print Titles
Background

Module 3: Professional MS PowerPoint

Creating Presentations

Creating Presentations
Blank & Sample Templates
Adding Text Boxes
Edit, Copy, Cut & Move Text
Format Text Boxes
Add Slides & Change Layouts
Import or Reuse Slides
Arranging Slides
Themes & Backgrounds
Slide Navigation
Presentation Views

Formatting Text

Formatting Text
Formatting Paragraphs
Bulleted & Numbered Lists

Adding Graphics

Capture Images & Insert Pictures
Photo Album
Drawing Shapes
Advanced Shapes
Merge Shapes
WordArt
SmartArt Graphics

Modifying Objects

Crop, Resize & Style Objects
Formatting Objects
Grouping Objects
Object Ordering & Layering
Gridlines & Guides

Working with Tables

Insert & Format Tables
Insert Table from Word
Manipulate PowerPoint Tables
Insert a Word Table
Insert an Excel Spreadsheet
Adjust Rows, Columns & Cells
Table Styles & Borders

Working with Charts

Create & Modify Charts
Insert a Chart
Working with Datasheets
Apply Chart Type, Style & Layout
Display Chart Analysis
Picture Charts
Format Chart Background

Templates, Themes & Layouts

Create a Custom Layout
Apply a Theme
Apply a Background Style
Save a Custom Theme
Arrange & Print Sections
Custom Design Templates
Slide Master
Background Graphics
Custom Slide Layouts
Advanced Custom Themes
Add Headers & Footers
Modify Notes Master
Edit Handout Master
Create Custom Templates

Editing Slide Masters

Slide Master
Title Master
Formatting the Masters
Adding Header & Footer Information
Notes & Handout Masters

Animations & Transitions

Animation Schemes
Animate Text & Objects
Custom Animations & Timing
Insert Sounds & Videos
Edit Media Clips
Set Up the Slide Show
Automatic Slide Timings
Continuous Loop
Hide Slides
Rehearse Slide Transition Timings

Custom Shows

Create a Custom Show
Set a Custom Show as Default
Create Hyperlinks
Use Hyperlinks
Use Action Buttons
Jump to Another Presentation

Packaging Presentations

Embed Fonts in a Presentation
Use the PowerPoint Viewer
Format Presentation for the Web
Inspect the Document
Annotate a Presentation
Send in PDF Format

Working with SmartArt

Insert a SmartArt Object
Format SmartArt Colors
Resize & Reposition SmartArt
Insert Text into SmartArt
Format Text Within SmartArt
Add Shapes to SmartArt
Group SmartArt Objects

Photo Album

Insert a Photo Album
Insert Pictures from a File
Add Captions
Apply a Theme to the Album
Customize the Album Layout

Special Effects

Insert, Trim, Fade & Bookmark Audio
Insert, Trim, Fade & Bookmark Videos
Advanced Animation
Motion Paths

Customizing Presentations

Custom Slide Shows
Setup Slide Show & Presenter View
Secure PowerPoint Show
Hyperlinks
Action Buttons & Link Actions
Annotate
Record Narration
Rehearse Timings

Collaboration

Merge & Compare
Insert Comments
Slide Library
OneDrive & Co-authoring

Secure & Distribute

Present Online
Create Video Files
Package Presentation
Publish to PDF or XPS
Document Properties
Document Inspector
Password Protection
Digital Signature
Mark as Final
Screen Recording
Closed Caption
Equations & Ink

Module 4: Advance Manual Accounting

Fundamentals of Accounting

Activities and Users of Accounting Information
Accounting Terminology
Assumptions of Accounting
Principles of Accounting
Accounting Cycle
Source Documents / Accounting Documents
Accounting Equation
Classification of Accounts
Types of Expenditure

Book Keeping

Compound Entries
Subsidiary Books & Types of Books
Trial Balance & Objectives
Transfer Entries

Rectification of Errors

Rectification
Rectification of Errors

Banking & Reconciliation

Bank Reconciliation Statement (BRS)

Provisions & Depreciation

Provision & Reserve
Depreciation

Inventory Accounting

Inventories
Cost for Inventory Valuation

Financial Statements

Financial Statements
Suspense Account

Company Accounts

Share Capital of a Company
Kinds of Shares
Forfeiture of Shares
Over Subscription & Pro-rata Allotment

Financial Analysis

Ratio Analysis
Cash Flow Statements
MIS Report
Budget & Types of Budgets
Accounting Standards

Module 5: Taxation

Introduction to Taxation

Introduction to Income Tax
Residential Status and Incidence of Tax
Certain Incomes Exempt from Tax

Heads of Income

Income under the Head Salary
Income under the Head House Property
Profits & Gains from Business or Profession
Income under the Head Capital Gains
Income under the Head Other Sources

Computation of Income

Clubbing of Income
Set-off & Carry Forward of Losses
Deductions from Gross Total Income
Agricultural Income
Illustration on Computation of Total Income & Tax Liability

Assessment & Tax Compliance

Assessment of Firms
Return of Income
Assessment of Individuals

Tax Payments

Tax Deducted at Source (TDS)
Advance Tax
Interest
Refund
Penalty

Indirect Taxation

Goods and Services Tax (GST)
Tax Deducted at Source (TDS)
Tax Collected at Source (TCS)

Return Filing

Return Filing (Manually)

Module 6: Tally ERP 9

Introduction to Tally

Introduction to Tally
Company Information
Create a New Company
Current Period & Current Date
Company Creation (Accounts Maintain, Financial Year, Security Control, Tally Vault)

Accounts Information

Group Ledger
Ledger
Book Keeping
Entries with Dr. & Cr.
Using Cash Account in Journal
Debit & Credit Note
Voucher Types
Select Company
Shut Company
Alter Company
Delete Company
Group Company
Change Tally Vault

Financial Reports & Consolidated Ledger Accounts

Balance Sheet
Profit & Loss A/c
Ratio Analysis
Fund Management with List of Accounts
Trial Balance
Accounts Book
Statement of Accounts
Cash/Fund Flow
Day Book
List of Accounts

Invoice & Billing

Mode of Invoice Punching/Billing
Bill-wise Details (New Reference, Against Reference, Advance, On Account)
Display Statement of Account
Bills Payable
Bills Receivable
Outstanding Ledger
Outstanding Group

Inventory Management

Stock Group
Stock Item
Unit of Measure
Voucher Entries – Goods In & Goods Out
Alternate Unit & Standard Rate
Opening Balance
Stock Summary

Purchase & Sales Order Processing

Purchase Order
Sales Order
Create Purchase Order
Alter Purchase Order
Delete Purchase Order
Create Sales Order
Alter Sales Order
Delete Sales Order
Reject Entries
Delivery Note
Receipt Note
Challan Number in Items

Internal Financial Reports

Display Inventory Books
Day Book
List of Accounts
Accounts with Inventory
Balance Sheet
Profit & Loss A/c
Stock Summary
Ratio Analysis

Cost Centre & Cost Categories

Cost Centre
Create Cost Centre
Alter Cost Centre
Cost Categories
Create Cost Categories
Alter Cost Categories

Multi Godown Management

Godown/Location
Create Godown
Alter Godown
Remove Companies
Copy Company

Tax Deducted at Source (TDS)

TDS
TDS Transactions
TDS Ledger
Payment Voucher
Preparing TDS Challan
Deposit of TDS to Government

Tax Collected at Source (TCS)

Understanding TCS
Creating TCS Masters
Practical Examples
TCS Payment
Reports & Forms

Goods & Services Tax (GST)

GST
GST Ledger
GST Transactions
GST Adjustment
GST Payment

Budgets & Controls

Budget
Types of Budget

Scenarios & Optional Vouchers

Creation of Scenario
Alter or Display Scenario Information

Export, Backup & Company Data

Splitting Company Data
Steps of Splitting
Export from Tally to Excel
Import into MS Excel
Remove Companies
Copy Companies

Printing Reports

Print Balance Sheet
Print Profit & Loss A/c
Print Ledger
Print Different Reports
Print Sales Invoice

Multi-Currency

Currency Creation
Create New Currency
Set Price Lists

Point of Sale (POS)

POS (Point of Sale)

Payroll Accounting

Payroll Information
Employee & Salary Details
Attendance Register
Employee Groups
Attendance Types
Unit of Leave (Payroll)

Manufacturing Vouchers

BOM (Bill of Material)
Create BOM Item
Create Voucher
BOM Ledger
BOM Transactions
Alter BOM
Excise Duty Ledger
Batch-wise Details
Batch-wise Inventory

Interest Calculation

Interest Calculations

Price List Management

Credit Limit Price List
Create Price Level
Create Price Group
Maintain Price List on Items

Voucher Types & Classes

Voucher Type
Voucher Class – Sales
Inclusive Tax Class
Customer Payment
Create Voucher with Discount & Freight Charges

GST Forms

GSTR-1
GSTR-2
GSTR-3
GSTR-4
GSTR-5
GSTR-6
GSTR-7
GSTR-8

Income Tax Return Forms

ITR-1
ITR-2
ITR-3
ITR-4
ITR-5

TDS/TCS Forms

TDS/TCS Challan
TDS 24Q
TDS 26Q
TCS 27EQ

Module 7: Adobe Dreamweaver

Introduction

Introduction to Dreamweaver IDE
Understanding the Significance of IDE
Understanding the Layout, Views & Windows
Creating the First Web Page
Writing Headings, Paragraphs & Lists
Giving a Title to the Page
Running the Web Page in the Browser

Tables

Inserting a Table
Adding & Removing Rows
Adding & Removing Columns
Spanning Rows & Columns

Images

Inserting Images from Local Folder
Adjusting Image Dimensions
Understanding Relative & Absolute Address
Inserting Images from Web URL
Creating a Photo Gallery

Hyperlinks & Page Navigation

Creating Hyperlinks
Linking Multiple Pages
Creating Hyperlinks to Web URLs
Creating Named Links for Same Page Navigation
Creating a Photo Gallery – Version 2

Forms

Understanding Forms & Their Attributes
Understanding Form Elements & Their Attributes
Working with:
- Text
- Password
- Radio Button
- Checkbox
- Select
- Textarea
- Buttons

Forms (Advanced)

Creating a Login Form
Creating a Registration Form
Understanding Form Validation Properties

Managing a Site

Understanding Sites
Creating Sites
Managing Sites
Creating Asset Folders

CSS Integration

Adding Styles to Your Page (CSS)
Understanding CSS Designer Window
Adding a CSS Source
Understanding CSS Selectors
Adding Properties to a Selector
CSS Selectors & Properties
Working with Different CSS Selectors
Working with Layout, Text, Border & Background Properties

Additional Features

Understanding the DOM Window
Working with Snippets
Changing the Design Window Size
Understanding Live View

Module 8: HTML5

Introduction

Introduction
Understanding the Concept of HTTP and HTML
Understanding Websites and Web Browsers
Minimum and Standard Requirements
First HTML Program

Text Layouts

Headings
Paragraphs
Lists
Quotations

Hyperlinks

Understanding URLs
Absolute and Relative URLs
Working with Anchors

Images

Types of Images
Adding Images to a Website
Displaying Custom Icon (Favicon)
Image Links
Image Thumbnails

Tables

Parts of a Table
Header, Body & Footer
Rows, Headings & Data
Rowspan & Colspan

Forms

Simple Form
Form Input Elements:
- Text
- Number
- Email
- Date
- Textarea
Buttons
Radio Buttons
Checkboxes
Select (Lists & Menus)
File Fields
Fieldset & Legend
Form Validation Properties:
- Required
- Readonly
- Disabled
- Min
- Max
- Checked
- Selected

HTML Layout

Introduction to Div & Span
Exploring Different Web Layouts
Understanding Semantic Elements:
- Container
- Header
- Main
- Section
- Article
- Footer
- Aside
- Figure

Multimedia

Adding Videos

Module 9: CSS3

Introduction

Introduction to CSS
Understanding the Structure & Rules
Understanding Div & Span
Types of CSS:
- Inline
- Internal
- External
Adding an External CSS File to the Document

CSS Selectors

CSS Selectors

Advanced Formatting

Formatting Fonts & Text
- Font Style
- Font Family
- Text Alignment
- Text Decoration
- Letter & Word Spacing

Working with Colors

Types of Color Assignment
Text Color
Background Color
Linear Gradient

Box Model

Units of Measurement
Padding
Margin
Borders
Width & Height
Box Shadow
Text Shadow

Positioning

Float & Clear
Static Position
Relative Position
Absolute Position
Fixed Position

Navigation

Navigation Bar
Sidebar

Animation

Animation Effects

Project

Project Work – A Static Website

Module 10: JavaScript

Introduction

Introduction
Client-Side Programming
First JavaScript Program
Writing Text on a Web Page
Writing on the Console
Solving Errors
Working with External JavaScript Files

Data & Variables

Declaring Variables
Assigning Values
Data Types
Strings
Arithmetic Operations

Conditions & Control Structures

Relational Operators
Logical Operators
If...Else Statements
If...Else If...Else Statements
While Loop
For Loop
Do-While Loop

Functions

User-Defined Functions
Defining Functions
Calling Functions
Event Handling Through Function Calls

Form Validation

Form Validation

Arrays

Single-Dimensional Arrays
Multi-Dimensional Arrays
Iterating Array Elements
Array Functions

Objects

User-Defined Objects (JSON)
JSON Functions

Module 11: jQuery

Introduction

Introduction to jQuery
First jQuery Program
Types of Selectors

DOM Manipulation

Adding Content to a Page
Working with Tags & Attributes

Events & Effects

Event Handling
jQuery Effects
Animations
CSS3 Transitions & Animations

Advanced jQuery

Enhanced Functionalities
jQuery Plug-ins
jQuery UI
Photo Gallery
Form Validation
AJAX
JSON
Traversing the DOM
Troubleshooting & Debugging

Project

Project Work – A Static Website

Module 12: Bootstrap

Getting Started

Installation
Understanding the Starter Template
Using Fundamental HTML Tags

Basic HTML Elements

Headings
Paragraph
Lists
Tables
Images

Layout

Containers
Grid System
Layout Utilities

Components

Alerts
Badge
Breadcrumbs
Buttons & Button Groups
Card
Carousel
Dropdowns
Forms & Input Groups
Jumbotron
List Group
Modal
Navbar
Pagination
Popover
Scrollspy

Utilities

Borders
Display
Position
Sizing
Visibility
Text

Module 13: PHP & MySQL

Module 1: PHP Introduction

Introduction

PHP Introduction
Web Applications and Their Types
Static vs Dynamic Websites
Server-Side Programming
3-Tier Architecture
Introduction to PHP
History and Features
Changes and Current Version
Interpreter-Based Execution Model of PHP
Installation of XAMPP/WAMP Server
Syntax of PHP Script
Executing Hello World Application in PHP

Module 2: Data Types & Operators

Data Types

Integers
Strings
Floating Numbers
Booleans
Arrays

Variables & Constants

PHP Variables
PHP Constants
Rules for Declaring PHP Variables
User-Defined Constants
String Constants
Variable Interpolation into Strings

Operators

Assignment Operators
Relational Operators
Logical Operators
Bitwise Operators
Operator Precedence & Associativity

Module 3: Conditional Statements

If Statement
If...Else Statement
If...Else If...Else Statement
Nested If...Else Statement
Switch Case Statement
Ternary Operator
Assignment on Conditional Statements

Module 4: Loops & Control Statements

While Loop
Do...While Loop
For Loop
Nested Loops
Break
Continue
Exit
Assignment on Loops & Control Statements

Module 5: Advanced Loops

Nested While Loop
Nested Do...While Loop
Nested For Loop
Series
Patterns

Module 6: Functions in PHP

Functions as Reusable Components
Defining Functions
Calling Functions
Passing Arguments
Returning Values
include()
include_once()
require()
require_once()
Assignment on Functions

Module 7: Advanced Function Concepts

Default Arguments
Pass by Value
Pass by Reference
Recursive Functions
Assignment on Advanced Functions

Module 8: Arrays

Understanding Arrays
Defining Arrays
Accessing Array Elements
Initializing Arrays
array() Function
Obtaining Array Size
Traversing Arrays using While & For Loop
Traversing Arrays using foreach()
list() Function
each() Function
Assignment on Arrays

Module 9: Two-Dimensional Arrays

Defining Two-Dimensional Arrays
Accessing Array Elements
Initializing Arrays
Traversing Arrays
Examples of Two-Dimensional Arrays
Assignment on Two-Dimensional Arrays

Module 10: Associative Arrays

Understanding Associative Arrays
Defining Associative Arrays
Initializing Associative Arrays
Accessing Elements using => Operator
Traversing Associative Arrays
Multi-Dimensional Arrays
Assignment on Associative Arrays

Module 11: Common Array Functions

sort()
rsort()
asort()
arsort()
usort()
uksort()
array_key_exists()
array_keys()
array_values()
array_diff_key()
array_push()
array_pop()
array_shift()
array_replace()
array_slice()
array_walk()
in_array()
current()
next()
prev()
reset()
Assignment on Array Functions

Module 12: String Handling

Single & Double Quotes
strlen()
substr()
strcmp()
str_replace()
trim()
ltrim()
rtrim()
strtolower()
strtoupper()
ucwords()
ucfirst()
lcfirst()
strpos()
strrpos()
strstr()
explode()
implode()
printf()
sprintf()
sscanf()
Assignment on String Functions

Module 13: Object-Oriented Programming (OOP)

Classes & Objects
Encapsulation
Abstraction
Inheritance
Polymorphism
Dynamic Binding
Assignment on OOP Concepts

Module 14: HTML & HTTP Basics

Request-Response Model of HTTP
Types of HTTP Requests
GET & POST Requests
HTML Elements
- html
- head
- body
- title
- form
HTML Input Elements
- Text
- Radio
- Select
- Button
- Submit
- Textarea
- Hidden
HTML5 Input Elements
- Email
- Number
- Range
- URL
$_GET
$_POST
$_SERVER
Server-Side Validation
isset()
empty()
Web-Based Assignments

Module 15: CSS Basics

Introduction to CSS
CSS Basics
Inline CSS
External CSS
CSS Selectors
Website Layout
Website Wireframing

Module 16: State Management

Stateless Nature of HTTP
Cookies ($_COOKIE)
Sessions ($_SESSION)
Hidden Form Fields
URL Parameter Passing
Assignment on State Management

Module 17: File Handling

File Handling Concepts
touch()
fopen()
File Modes
- r
- w
- a
- r+
- w+
- a+
fread()
fwrite()
fgetc()
fgets()
fscanf()
file_put_contents()
file_get_contents()
fseek()
ftell()
feof()
filesize()
fclose()
Assignment on File Handling

Module 18: File System Operations

File System Interaction
mkdir()
rmdir()
unlink()
rename()
opendir()
readdir()
scandir()
closedir()
is_file()
is_directory()
chmod()
Assignment on File System Operations

Module 19: Advanced File System

basename()
realpath()
dirname()
FILE
DIR
Reading CSV Files
File Uploading
File Downloading

Module 20: File System Mini Project

Directory Links
Upload Files
Create File Links
Delete Files
Download Files
Rename Files & Folders

Module 21: MySQL Basics

Introduction to RDBMS
phpMyAdmin
User Management
Database Management
Storage Engines
Creating Tables
Altering Tables
Deleting Tables
INSERT
UPDATE
DELETE
SELECT
Import & Export Databases
Assignment on phpMyAdmin

Module 22: PHP–MySQL Connectivity

MySQLi Functions
mysqli_connect()
mysqli_select_db()
mysqli_query()
mysqli_fetch_array()
mysqli_fetch_assoc()
mysqli_fetch_object()
mysqli_close()
mysqli_free_result()
Object-Oriented MySQLi
Executing DML Queries
Executing DDL Queries
Assignment on MySQL Connectivity

Module 23: Advanced MySQL Connectivity

Batch Queries
Transactions
Commit
Rollback
LIMIT
JOINS
Assignment on Advanced SQL Operations

Module 24: Advanced MySQL Queries

GROUP BY
HAVING
ORDER BY
BETWEEN
IN
LIKE
COUNT()
MAX()
MIN()
AVG()
Nested Queries
Assignment on Advanced SQL Queries

Module 25: Working with MySQLi & PDO

MySQLi
PDO
Prepared Statements
Stored Procedures
Functions

Module 26: Database Mini Project

User Panel

User Registration
User Login
View Profile
Edit Profile
Logout

Admin Panel

View Users
Edit User Details
Delete Users

Module 27: Database Mini Project

User Registration
Login
View Profile
Edit Profile
Logout
Admin Panel (View, Edit & Delete Users)

Advance Diploma in Computer Application Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.