ADVANCE DIPLOMA IN COMPUTER APPLICATIONS - Contents
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS training in west delhi
Module 1 M.I.S (Management Information System)
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS training in west delhi
MS - WORD
GET 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 & PARAGRAPH
- 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 LIST
- Sort a List
- Format a List
ADDING TABLES
- Insert a Table
- Modify a Table
- Format a Table
- Convert Text to a Table
INSERTING GRAPHICS OBJECT
- 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
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 A PUBLISHED DOCUMENT
- Check Spelling, Grammar, and Readability
- Use Research Tools
- Check Accessibility
- Save a Document to Other Formats
- The Macro Recorder
- Recording Macros
- Testing Macros
- Running Macros
MS - POWERPOINT
CREATING A PRESENTATION
- 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
ADDING GRAPHICS
- Capture Images & Insert Pictures
- Photo Album
- Drawing Shapes
- Advanced Shapes
- Merge Shapes
- WordArt
- SmartArt Graphics
MODIFY OBJECTS
- Crop, Resize & Style Objects
- Formatting Objects
- Grouping Objects
- Object Ordering & Layering
- Gridlines & Guides
TABLES
- Insert & Formatting Tables
- Insert Table from Word
- Manipulating PowerPoint Tables
- Inserting a Word Table
- Inserting an Excel Spreadsheet
- Adjusting Rows, Columns, Cells
- Table Styles and Borders
CREATE & MODIFY CHARTS
- Inserting a Chart
- Working with Datasheets
- Applying a Chart Type, Style and Layout
- Displaying Chart Analysis
- Picture Charts
- Formatting Chart Background
TEMPLATES , THEMES & LAYOUTS
- Creating a Custom Layout
- Applying a Theme
- Applying a Background Style
- Saving a Custom Theme
- Arranging and Printing Section
CUSTOM DESIGN & TEMPLATES
- Slide Master
- Background Graphics
- Custom Slide Layouts
- Advanced Custom Themes
- Add Headers & Footers
- Modify Notes Master
- Edit Handout Master
- Create Custom Template
EDITING SLIDE MASTERS
- Slide Master, Title Master
- Formatting the Masters
- Adding Header and Footer Information
- Notes and Handout Masters
ANIMATION & TRANSITIONS
- Animation Schemes
- Animating Text and Objects
- Custom Animations and timing
- Inserting Sounds and Video
- Editing Media Clips
SETTING UP THE SLIDESHOW
- Setting Automatic Slide Timings
- Setting Up a Continuous Loop
- Hiding a Slide
- Rehearsing Slide Transition Timings
CUSTOM SHOWS & INTERLINKED SHOWS
- Creating a Custom Show
- Setting Up a Custom Show as the Default
- Creating a Hyperlink
- Using a Hyperlink
- Using an Action Buttons
- Jumping to Another Presentation
PACKAGING PRESENTATION
- Creating a Custom Show
- Embedding the Fonts in a Presentation
- Using the PowerPoint Viewer
- Formatting a Presentation for the Web
- Inspecting the Document
- Annotating a Presentation
- Sending in PDF Format
USING SMARTART
- Inserting a SmartArt Object
- Formatting a SmartArt Object Color
- Resizing/Repositioning a SmartArt Object
- Inserting Text into a SmartArt Object
- Formatting Text Within a SmartArt Object
- Adding Shapes to a SmartArt Object
- Grouping SmartArt Objects
INSERTING A PHOTO ALBUM
- Inserting Pictures from a File
- Adding Captions
- Applying a Theme to your Album
- Customizing the Album Layout
CUSTOMIZING PRESENTATION
- Custom Slide Shows
- Setup Slide Show & Presenter View
- Secure PowerPoint Show
- Hyperlinks
- Action Buttons & Link Actions
- Annotate
- Record Narration
- Rehearse Timings
COLLABORATING
- Merge & Compare
- Insert Comments
- Slide Library
- OneDrive & Coauthoring
SECURE & DISTRIBUTE
- Present Online
- Create Video Files
- Package Presentation
- Publish to PDF or XPS
- Document Properties
- Document Inspector
- Password Protect
- Digital Signature
- Mark as Final
- Screen Recording
- Closed Caption
- Equations & Ink
Prof. MS - Excel
AUTOMATING TASKS
- Creating an Auto Keys Macro
- Using Controls to Run a Macro
- Assigning a Macro to an Event
- Assigning a Macro to a Condition
- Testing and Debugging a Macro
Formulas
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Floor
- Round
- Round up
- Round down
- Power
- Count
- CountA
- Count
- Sum if
- Maximum
- Minimum
- Hlookup for single worksheet
- Vlookup for single worksheet
- Hlookup & Vlookup for multiple Sheet
- Index
- Show formula
- Or
- Not
- Iferror
- Lookup
- Rate
- Ppmt
- Ipmt
- Networkdays
- Roundup
- Rounddown
- Mode
- Median
- Received
- Log
- Dollar
- AverageA
- Averageif
- Averageifs
- Mina
- Maxa
- Sumifs
- Large
- Pv
- Fv
- Coupdays
- Coupnum
- Datedif
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
- Now
- Today
- Weekday
- SQRT
- Mod
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Match
- Roman
- Proper
- Pmt
- Concatenate
- IF Function & Nested IF Statements And & Or Functions
- Match and find record by VLOOKUP And HLOOKUP
- ISPMT
- SLN
- Effect
- CUMPRINC
- CUMIPMT
- EoMonth
- EDATE
- WORKDAYS
- DDB
- DB
- Approximate Match with Vlookup
- Exact match with Vlookup
- Nesting Lookup Function
- Choose Function
- Rank & Rank Average
- Rand & Rand Between
- Mod with Conditional Formatting
- Transpose
- Find & mid
- ISERR,
- OFFSET
- IIR
- NPV
- MONTH
- HOURS
- MINUTE
- NETWORKDAYS.INSTL
- Transpose with Vlookup
- ISNUM
- ISERROR
- IFERROR
- SUBSTITUTE
- INDIRECT
- SEARCH
- TRIM
- INDEX WITH SUM,COUNT,AVERAGE
Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
Create Statements According to Function
- Inserting a Hyperlink
- MIS Report
- Profit & Loss a/c statement
- Balance sheet
- Worker contribution statement
- Cash flow statement
- Debtor’s & Creditors statement
- Inventory statement
- BRS Statement
- Fixed Assets & fund statement
- Payroll Report
- P.F & E.S.I Report
WORKING WITH CHARTS
- Creating a Chart with the 2D or 3D
- Create Column Chart, Pie Chart
- Create Pateros Charts
- Create Speed- O-Meter Chart
- Moving a Chart One to another Sheet
- Resizing a Chart, Changing a Chart Type
- Editing Chart Text, Modifying Chart Options
- Formatting Category & Value Axis Data
- Formatting a Data Series
- Changing a Chart’s Source Data
FORMATS , CONDITIONAL FORMATTING & SORTING
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Conditional formatting with formulas
- Conditional formatting with Form Controls.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
FORMATTING NUMBERS
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
DATA MANAGEMENT
- Data Validation and dealing with Invalid Data.
- Group and Outline Data
- Data
- Data Consolidation.
- Data text to column.
- Custom Views
DATA ANALYSIS TOOLS
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
SUMMARIZING DATA
- Adding Subtotals to a List
- Nesting Subtotals
- Applying Advance Filters
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Text to Column
WHAT IF – DATA ANALYSIS
- Using Goal Seek
- Using Data Table
- Creating & Displaying Scenarios
WORKING WITH LISTS
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
WORKGROUP COLLABORATION
- Locking/Unlocking Cells in a worksheet
- Protecting a Worksheet
- Protecting a Workbook
- Creating a Shared Workbook
- Tracking Changes to a Workbook
- Accepting & Rejecting Changes to a Workbook
- Password Protecting a Workbook
- Merging Workbooks
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
CUSTOMIZING EXCEL
- Creating a Macro with Condition
- Running a Macro, Editing a Macro
- Adding a menu to the Menu Bar
- Adding a Commands to a Menu
- Adding Buttons to a Toolbar
PRINT SETTINGS
- Page Break
- Print Area
- Print Titles
- Background
SPECIAL OPERATIONS
- Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
- Find record by drop down list according To condition
- Dash Board
Module 2
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS training in west delhi
ADVANCE ACCOUNTING
- Accounting terminology
- Activities and user of Accounting Information
- Assumption of Accounting
- Principal of Accounting
- Accounting cycle and source/Accounting document
- Accounting equation Classification of Account
- Types of Expenditure
- Compound Entry
- Subsidiary book and types of book
- Trial balance & Objectives
- Rectification of Error
- Provision & Reserve
- Inventory & cost for Inventory Valuation
- Suspense Account
- Share capital of company
- Kind of Share, forfeiture of share
- Over Subscription & Pro-rata allotment
- Accounting voucher
- Journal, cash book, ledger and trial balance
- Bills of exchange
- Depreciation
- Bank Reconciliation Statement
- Financial Statements
- Ratio Analysis
- Cash Flow Statement
- MIS Report
- Budget & Types of Budget
- Accounting Standard
Module 3
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS training in west delhi
TAXATION
- Residential Status & Slab rate of Taxes
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit & Gains from Business & Profession
- Income under the Head Capital Gains
- Income under the head Other Sources
- Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
- Agricultural Income, Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of individual
- TDS/TCS-Types of Forms, return filing
- Tax Deduction of Source, Advance Tax,
- Interest, Refund, Penalty,
- Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
- Legal Documentation
- GST (GOODS AND SERVICE TAX)
- Legal Documentation For GST
Module 4
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS training in west delhi
TALLY. ERP 9
INTRODUCTION OF TALLY
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
BOOK KEEPING
- Entries with dr. And 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 REPORT
- Balance sheet
- Profit & loss a/c
- Ratio analysis
FUND MANAGEMENT
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
MODE OF INVOICE BILLING
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
INVENTORY MANAGEMENT
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
PURCHASE & SALES ORDER PROCESSING
- Stock group
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
MULTI – GOD CREATION
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
TAS DEDUCTED AT SOURCE (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
TAS COLLECTED AT SOURCE (TDS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
GOODS & SERVICES TAX
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
PAYROLL ACCOUNTING FUNCTION
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
MANUFACTURING VOUCHERS
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
VOUCHERS TYPES & CLASS
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 5 - E-FILLING
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
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 6. HTML
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
Introduction
- Understanding the Concept of HTTP and HTML
- Understanding Web sites and Web Browsers
- Minimum and Standard Requirements
- First HTML Program V. Text Layouts
- Headings
- Paragraphs
- Lists
- Quotations
HyperLinks
- Understanding URLs
- Absolute and Relative URLs III. Working with Anchors
Images
- Types of Images
- Adding Images to a Website
- Displaying Custom Icon – favicon
- Image Links
- Image Thumbnails
Tables
- Structure of a Table
- Header, Body and Footer
- Rows, Headings and Data
- Rowspan and Colspan
- Page Layout
Forms
- Simple Form
- Form Input Elements:
- Text, Number, Email, Date, Text area
- Buttons
- Radio, Checkbox
- Select (Lists and Menus)
- File Fields
- Field set and Legend
- Form Validation properties
- Required, read only, disabled, min, max , checked, selected
HTML Layout
- Introduction to div and span
- Exploring different Web Layouts
- Understanding Semantic Divs
- Container, header, main, section, article, footer, aside, figure
- Adding Audios and Videos
Module 7 . CSS
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
Introduction to CSS
- Understanding the structure and Rules
- Understanding div and span
- Types of CSS : Inline, Internal, External
- Adding an External CSS File to the Document
- CSS Selectors
- Background-image:
VII. Background-color:
VIII. Background-size
IX. Background-position
Advanced Formatting
- Formatting Fonts and Text: style, family, align, decoration, spacing
- Working with colors
a. Types of Color
assignment
b. Text and Background
color
c. Linear Gradient
d. Block
e. Inline-block
f. Display-inline-block
Managing Box Properties
- Units of Measurement
- Setting Padding and Margin
- Setting Borders
- Setting Width and Height
- Bos-Shadow and Text Shadow
Managing Positions
- Working with float and clear
- Working with static, relative, absolute and fixed positions
- Creating a Navigation Bar
- Creating a Sidebar
CSS Effects
- Working with Transform
- Working with Transition
- Working with Animation and Keyframes
- Working with Pseudo Classes
Introduction to Flex
- Css flex
- Flex-direction
- Justify content
- Align items
- Flex-wrap
- Flex-flow
- Order
- Align-self
- Grid layout
- Gird-direction
- Grid-justify-content
- Grid-align-content
Module 8. JAVASCRIPT
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
Introduction
- What is JavaScript
- Using JavaScript in an HTML document.
- Writing Text on a web page.
- Writing on the console and solving errors.
Data and Variables
- Data Types in JavaScript.
- Overview of variables.
- Variable declaration.
- Arithmetic Operation.
Conditions and Control Structures
- Prompt.
- Type convertion.
- Relational Operators.
- Logical Operators.
- If…Else & Else if…… Else Statement.
Loop
- For loop
- For in loop
- For of loop
- While loop
- Do while loop
Arrays & Objects
- Working with single dimensional Arrays.
- Changing an array element.
- Looping in array.
- Working with multidimensional Arrays.
- Looping in multidimensional Arrays.
Functions
- Array functions.
- String functions.
- Date function.
- Math function.
- User define function.
- Switch case statement.
- JavaScript Dom Method.
- Change HTML Elements.
- Adding and deleting elements.
Event handling through function call Events
- Onclick event.
- On input Event.
- On change Event
- Event listener
- Adding event listener and remove event listener.
- Mouse over.
- Mouse leave.
- Keyboard Event.
a. Keypress
b. Key down
c. key up - Window event
a. Scroll
b. Resize - On change event.
- Focus event.
Form Validation
Module 9. JQUERY
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
Introduction to Jquery
- First JQuery Program
- Types of Selectors
- Adding Content to a Page
- Working with tags and tag Attributes
- Event Handling
Animation & Effects
- Jquery Effects, Animations
- Jquery and CSS3 Transitions and Animations
Enhanced Functionalities with Plugins
- Photo slider
- JQuery UI
- JQuery Validation
Module 10. PHP
ADVANCE DIPLOMA IN COMPUTER APPLICATIONS
PHP Introduction
- Web Applications and their types
- Static v/s 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 / Wampp Server
- Syntax of PHP script
- Executing Hello world application of PHP
Data Types & Operators
- Integers, string, floating numbers, Booleans, arrays etc.
- PHP Variables and Constants
- Important Rules for declaring PHP variables
- User-defined Constants
- String constants, variable interpolation into strings
- Assignment Operators
- Relational Operators
- Logical Operators
- Bitwise Operators
- Operators precedence and associatively Conditional Statements
- If-else statement
- If… else if… else statement
- Nested if-else statement
- Switch case statement
- Ternary operator
- Assignment to apply conditional statements
Conditional Statements
- If-else statement
- If… else if… else statement
- Nested if-else statement
- Switch case statement
- Ternary operator
- Assignment to apply conditional statements
Loops & Control Statements
- While loop
- Do While loop
- For loop, Nested loops
- Break, Continue and Exit keywords
- Assignment to apply loops and control statements.
Loops & Control Statements Cont….
- Nested While loop
- Nested Do While loop
- Nested For loop
- Series and Patterns
Functions in PHP
- Function as reusable components
- Defining a Function
- Calling a Function
- Passing arguments to a function
- Returning a value from a function
- Use of include (), include once (), require () and require once () library function
- Assignment to apply functions
Advance Functions Concepts
- Default Arguments
- Difference b/w argument passing by value and by reference
- Defining and using Recursive functions
- Assignment to apply advance function concepts
Arrays
- Understanding array as a collection of values
- Defining an array, accessing array elements using index
- Initializing array, using array () function for creating array
- Obtaining the size of an array
- Traversing array elements using while & for loop
- Using foreach loop for traversing array elements
- Use of list () and each () functions in traversing array
- Assignment to use arrays
Two – Dimensional Arrays
- Defining a two-d array
- Accessing elements of two-d array
- Initializing a two-d array
- Traversing elements of two-d array
- Example of use of two-d array
- Assignment to use two-d arrays
Associative Arrays
- Understanding an associative array
- Defining an associative array
- Initializing an associative array
- Accessing elements of an associative array using => operator
- Traversing elements of associative array
- Creating a Multi-dimensional array
- Assignment to use associative arrays
Common Array Functions
- Sorting array using sort (), rsort (), asort (), arsort (), usort (), and uksort ()
- Use of array_key_exists (), array_keys (), array_values (), array_diff_key () functions
- Use of array_push (), array_pop (), array_shift (), array_replace (), array_slice () and array_walk () functions
- Use of in_array (), current (), next (), prev (), reset () functions
- Assignment to use array functions
String Handling
- Use of single & double quotes in representing Strings
- Use of basic string functions strlen(), substr(), strcmp(), and str_replace()
- Use of case changing functions strtolower(), strtoupper(), ucwords(), ucfirst(), and lcfirst()
- Use of position finding functions strpos(), strrpos(), and strstr()
- Use explode() and implode() functions
- Use of printf(), sprintf(), and sscanfs()
- Assignment to use String functions
Object Oriented Programming in PHP
- Classes and Objects
- Encapsulation
- Abstraction
- Inheritance
- Polymorphism and Dynamic Binding
- Assignment to implement OOP Concepts
HTML & HTTP Basics
- Request Response Model of HTTP, Type of HTTP requests
- Difference b/w Get & Post Requests
- Basic HTML elements html, head, body, title and form
- HTML Input elements text, radio, select, button, submit, textarea, and hidden
- New HTML 5 Input elements email, number, range, and url
- Use of $_GET, $_POST, and $_SERVER global variables
- Server-side Validation using isset(), empty()
- Web based assignment different type of input controls and request type
Introduction to CSS
- CSS basics, Applying inline & external CSS styles
- CSS Selectors, Layout and Wireframing of Website
State Management
- Understanding stateless nature of HTTP
- Maintaining user state using $_COOKIE global variable
- Maintaining user state using $_SESSION global variable
- Maintaining user state using hidden form fields
- Maintaining user state using parameter appending to URL
- Assignment to apply all the state management methods
Reading & Writing data from files
- Understanding need of file handling
- Creating file using touch() and fopen() functions
- Different modes of opening files r, w, a, r+, w+, a+
- Use of file read/write functions fread(), fwrite(), fgetc() fgets(), fscanf(),
- file_put_contents(), file_get_contents() functions
- Use of file utility functions fseek(), ftell(), feof(), filesize(), fclose()
- Assignment to create, append, write, and read file dateds
Interacting with the file system
- Need of File System interaction, Creating directory using mkdir() function
- Removing directory using rmdir() funciton
- Removing files using unlink() function
- Renaming files and directory rename() function
- Use of opendir(), readdir(), scandir() and closedir() functions
- Use of is_file(), is_directory() and chmod() functions
- Assignment to perform file system operations
Advance File System Concepts
- Use of basename(), realpath(), dirname() functions
- Use of __FILE__ and __DIR__ magic constants
- Reading csv files using fgetcsv() function
- File uploading & downloading
File System based Mini Project
- Creating links of directories
- Uploading files and creating their links
- Deleting & downloading files using links
- Renaming Files & Folders using their links
My SQL
- Introduction to RDBMS Package
- Use of phpMyAdmin as interface of MySql
- Creating, removing and managing user accounts
- Understanding different types of Storage engines Innodb, MyISAM, CSV etc
- Creating, altering and removing Tables
- Performing Insert, update, delete and select operations on the table
- Importing & Exporting database and tables
- Assignment to use phpMyAdmin for managing users, databases and tables
My SQL PHP Connectivity
- MySQL PHP library as means of database connectivity
- Use of mysqli_connect(), mysqli_select_db() mysqli_query(), and mysqli_fetch_array(),
- Mysqli_fetch_assoc(), mysqli_fetch_object(), mysqli_close(), mysqli_free_result() functions
- Use of Object Oriented MySQL Connection and Methods
- Executing DML (insert, update, delete, & select) queries from PHP
- Executing DDL (create, alter, & drop) queries from PH
- Assignment to perform DDL & DML operations
Advance My SQL PHP Connectivity
- Executing queries in batches for improving performance
- Executing transactions, committing and rolling back
- Using limits for selecting records
- Using joins for selecting records from multiple tables
- Assignment to perform Advance SQL operations
Advance My SQL Queries
- Use of group by, having, and order by clauses in select queries
- Use of between, in, like in select queries
- Use of aggregate functions count(), max(), min(), avg() in select queries
- Use of nested queries
- Assignment to perform use of these concepts in PHP applications
Working with MySqli & PDO
- Mysql & PDO PHP library as means of database connectivity
- Prepared statements
- Stored procedures & Functions
Obtaining database meta data in PHP
- Use of mysql_fetch_field(), mysql_num_fields(), mysql_num_rows(), mysql_field_name(), mysql_field_type(), mysql_filed_table(), mysql_field_len() functions
- Use of mysql_db_name(), mysql_list_dbs(), mysql_list_tables(), mysql_list_fields()
- Use of mysql_insert_id(), mysql_get_client_info(), mysql_get_host_info() and mysql_get_proto_info(), mysql_get_server_info() functions
- Assignment to perform use of these concepts in PHP applications
A mini project using database
- A mini web site having user registration, login, view profile, edit profile, logout in user interface
- View Users, edit user details and delete users in admin inte
