Learn how to create Dynamic, Online Applications – like Shopping Carts, Customer Databases, Online Stores, Accounting Systems, Membership Systems, all using PHP programming language, and the SQL Relational Database.
PHP is a scripting language used to create dynamic, complex and robust Web pages. It can seamlessly integrate with a wide range of SQL database servers, including Oracle, MySQL and Microsoft SQL Server.
In this Introductory course on PHP programming, you gain a solid foundation for incorporating PHP techniques in your online, web based applications, and learn how to interface it with any SQL database.
UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.
Practical, Hands-On Exercises & Techniques to Gain a Solid Understanding of:
- Creating a User Login & Authentication System
- Sending Form Data to the SQL Database
- Using Sessions & Cookies in PHP pages
- Insert, Update, Delete, Select and Display data from SQL Database into the Web
- Search the Database and Display only Matching Results using PHP
- Use Pagination to Control Results Per Page
- Advanced Features & Structured Code Writing Tips
Course Duration: 3 Full Days – on PHP & SQL
Extensive hands-on exercises provide you with the skills to produce dynamic Web pages, retrieve and manipulate data, track user navigation, and integrate database content.
Recommended Reading: Choosing A Career in IT Industry
Thinking of starting a career in IT? Love to play with Computers and Mobile Phones, and thinking of making IT a career choice? Like to develop new IT products and services and be the next generation whiz-kid?
You are not alone. Thousands of people are moving to IT for continuous and long term job prospects with great salaries. To read more, pls visit Choosing A Career in IT Industry
In this course, you will develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.
Exercises include:
- Creating A SQL Database, Creating Tables, Fields, and Inserting Records in the SQL Database tables
- Selecting Data from the SQL database using various filtering criteria techniques.
- Sort, Format and Convert SQL data using specific SQL Functions and features.
- Generating Web pages dynamically using PHP
- Retrieving and manipulating form data
- Personalizing Web site content using cookies
- Tracking user navigation on your Web site
- Integrating database content to generate dynamic Web pages
- Building modular scripts to enable code re-usability
Introduction to PHP
PHP language building blocks
Writing PHP scripts
Writing Web Pages with PHP
Interacting with the server
Manipulating user input
Applying Advanced Scripting Techniques
Exploiting the built-in functionality of PHP
|
Structuring PHP code
Building Complete Web Applications
Managing errors
Handling problematic situations
Establishing database connectivity
|
You Will Learn How To:
- Install, Setup and Create a database using SQL Commands
- Insert, Update, Delete Records in SQL database tables
- Write Queries against the SQL database & Retrieve data using specific criteria
- Write effective, efficient PHP scripts
- Embed PHP scripts in HTML pages to create dynamic Web pages
- Manipulate data from Web page forms
- Track users as they navigate your site with cookies and other PHP features
- Structure PHP code using user-defined functions and external libraries
- Develop database-enabled Web applications using SQL ( You can also get an Introduction to SQL database, and Oracle Database SQL Expertise in a separate training class too)
Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.
Participants who are interested in creating dynamic, database-driven Web sites.
You Will Learn How To:
- Install, Setup and Create a database using SQL Commands
- Insert, Update, Delete Records in SQL database tables
- Write Queries against the SQL database & Retrieve data using specific criteria
- Write effective, efficient PHP scripts
- Embed PHP scripts in HTML pages to create dynamic Web pages
- Manipulate data from Web page forms
- Track users as they navigate your site with cookies and other PHP features
- Structure PHP code using user-defined functions and external libraries
- Develop database-enabled Web applications using SQL ( You can also get an Introduction to SQL database, and Oracle Database SQL Expertise in a separate training class too)
Participants who are interested in creating dynamic, database-driven Web sites.
In this course, you will develop PHP scripts to perform a variety of tasks, culminating in the development of a full database-driven Web application.
Exercises include:
- Creating A SQL Database, Creating Tables, Fields, and Inserting Records in the SQL Database tables
- Selecting Data from the SQL database using various filtering criteria techniques.
- Sort, Format and Convert SQL data using specific SQL Functions and features.
- Generating Web pages dynamically using PHP
- Retrieving and manipulating form data
- Personalizing Web site content using cookies
- Tracking user navigation on your Web site
- Integrating database content to generate dynamic Web pages
- Building modular scripts to enable code re-usability
Introduction to PHP
PHP language building blocks
Writing PHP scripts
Writing Web Pages with PHP
Interacting with the server
Manipulating user input
Applying Advanced Scripting Techniques
Exploiting the built-in functionality of PHP
|
Structuring PHP code
Building Complete Web Applications
Managing errors
Handling problematic situations
Establishing database connectivity
|
Those creating dynamic, database-driven Web sites. Basic experience with HTML is assumed. Prior Programming or PHP experience is helpful but not required.
Claim SDF Grant
Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.
Applicable for Company Sponsored Singaporeans & PRs.
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
Do You Have a Question or Need a Quotation?
Simple. Just tell us what you need here. We’ll be glad to help you!
Some of the companies that experienced our trainings
How To Register
Register for the 3 Days of PHP & SQL Training today by simply clicking on the chosen course date available at the top of this page.
Learn to Create DB Apps PHP & SQL
Need Help?
- Call us at +65 6250-3575, SMS / WhatsApp: +65 9066 – 9991
- Send an email to training@intellisoft.com.sg OR
- Submit an online enquiry if you have any questions regarding PHP & SQL training.
We also offer Customized Corporate Training for PHP with SQL or Oracle Database. If you have a group of 10 or more participants, we can conduct this training at your office too. Contact us for details.