| Level: | Beginner/Entry |
| Medium of instruction: | English |
PHP is a general-purpose server-side scripting language originally designed for Web development to produce dynamic Web pages. It is one of the first developed server-side scripting languages to be embedded into an HTML source document rather than calling an external file to process data. MySQL is the world's most used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is a two day workshop designed for the beginners to understand the PHP Programming & its use with MySQL.
Topics to be Covered in the Workshop
1 Installation:
1.1 Introduction PHP and Mysql
1.2 PHP Installation
1.3 MySQL Installation
1.4Apache Installation.
1.5 XAMPP and WAMPP Installation
2. PHP Basics:
2.1. Embedding PHP in HTML
2.2. Embedding HTML in PHP
2.3. Introduction Variable Using variables
2.4. Understanding Data Types Using Operators
2.5. Writing Statements and Comments Using Conditional Statements
2.6. If(), else if() and else if condition Statement
3. Arrays and Custom Functions:
3.1. Creating an Array
3.2. Modifying Array Elements
3.3. Processing Arrays with Loops
3.4. Grouping Form Selections with Arrays Using Array Functions
3.5. Creating User-Defined Functions
3.6. Defining and Invoking Functions
4. Creating basic programs with PHP:
4.1. Reading and Writing Files
4.2. Reading Data from a File
4.3. Writing Data to a File
4.4. Testing File Attributes.
4.5. Managing Sessions and Using Session Variables
4.6. Creating a Session and Registering Session Variables
4.7. Destroying a Session
4.8. Storing Data in Cookies
4.9 Setting Cookies
4.10.Retrieving Cookie Data
4.11.Dealing with Dates and Times
4.12.Executing External Programs
5. Editing Records and Performing Queries:
5.1. Inserting Records
5.2. Editing and Deleting Records
5.3. Performing Queries
5.4. Retrieving Specific Columns
5.5. Filtering Records with a WHERE Clause
5.6. Using Operators
5.7. Sorting Records and Eliminating Duplicates
5.8. Limiting Results
5.9. Using Built-In Functions
5.10.Grouping Records
5.11.Joining Tables
5.12.Using Subqueries
5.13.Using Table and Column Aliases
6. Using PHP with MySQL:
6.1. Managing Database Connections
6.2. Performing Queries
6.3. Processing Result Sets
6.4. Queries Which Return Data
6.5. Queries That Alter Data
6.6. Handling Errors
6.7. Using Ancillary Functions
7. Creating Forms with HTML:
7.1. HTML Basics
7.2. Creating Forms with HTML
8. Working with Databases and Tables:
8.1. Creating Databases
8.2. Creating Tables
8.3. Specifying Field Data Types
8.4. Selecting the Most Appropriate Data Type
8.5. Adding Field Modifiers and Keys
8.6. Selecting a Table Type
8.7. Altering Tables
8.8. Altering Table and Field Names
8.9. Altering Field Properties
8.10. Adding and Removing Fields and Keys
8.11.Altering Table Types
8.12. Backing Up and Restoring Databases and Tables
8.13. Backing Up Databases and Tables
8.14. Restoring Databases and Tables from Backup
8.15. Dropping Databases and Tables
8.16. Viewing Database, Table, and Field Information
9. Hands On & Project Documentation
Duration: The duration of this workshop will be two consecutive days, with 6-7 hour session each day in a total of 12-14 hours.
Certification Policy:
-
Certificate of Merit for all the workshop participants from Innovians Technologies.
-
At the end of this workshop, a small competition will be organized among the participating students and winners will be awarded with a 'Certificate of Excellence'.
-
Certificate of Coordination for the coordinators of the campus workshops.
Eligibility: It's a basic level workshop so there are no prerequisites. Anyone interested, can join this workshop.
Fee: Rs. 1000/- (inclusive of all Taxes) per participant.
| Classroom - Regular | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified |
2 Days (Total 14 Hrs) |
All Venues | 6-7 hours session each day. |
INR 1,000 Per Course (Taxes As Applicable) |
| Price Notes: Fees (inclusive of all Taxes) per participant. | ||||
Innovians Technologies
We, Innovians Technologies (A Unit of PRATS Technologies Pvt. Ltd.), are the India’s fastest growing company in the field of Web & IT Services, Educational Workshop, Professional Training & Corporate Training with most advanced technologies & experience in hand. We majorly deal in Software Development, Web Development, Educational Workshop and Training, Corporate Training, Motivational Seminar, Consultancy & Outsourcing as well.
Innovians Technologies delivers interactive training & workshops which equip its participants with better practical understanding and preparation for jobs in industry. The hands-on sessions and lectures are designed based on current industry trends and draw on the rich experience of instructors and organizers. We focus on Android, Ethical Hacking, Embedded Systems, Robotics, Automation, Web Development, Social Networking, 3D Animation, Automobile Mechanics, Aircraft Designing, Share Market, 2G & 3G Technology and even more.
We have tied up with a number of professionals who provide us number of technologies and solutions so that we can bring out Industry ready professionals to the market, to cater their needs. We have a huge list of technologies upon which students can learn in their college itself without going anywhere outside and in the LAB they can practice anytime whenever they want. We have vast expertise in industrial training which enables us to impart good quality training with latest technology and teaching methodology which keeps the participants interested and they learn efficiently about the emerging trends and technologies.
The Corporate Training programs of Innovians Technologies encompass a wide range of skills that are integral & necessary part of everyday business, daylife or work environment. In our quest to address every organizational development need, Innovians Technologies offer a gamut of training programs, which ranges from Motivational Seminar, Faculty/Staff Development Training, 5S Training, Personality Development, Professional Skills Training & Foreign Languages.
We also specialize in web design & development, search engine optimization and web marketing, eCommerce, multimedia solutions, software development, erp, consultancy & outsourcing. We build web solutions, which evolve with the changing needs of your business.
