PHP/SQL 1: Introduction to Database Programming
In this course, you will learn basic SQL database creation and manipulation, as well as how to search databases and how to incorporate them into PHP-based programs and applications. SQL (Structured Query Language) is the language for databases such as Oracle, MySQL, MS Access, etc. Knowing SQL is paramount in using these databases.
Upon completion of this course, you will be able to:
- Create, search, and manage SQL tables and entries.
- Perform basic SQL queries and joins, and manage the results.
- Demonstrate understanding of advanced SQL syntax for date, time, math, and string functions.
- Implement SQL database programming into a PHP-based web application.
- Build a full-fledged online address/phone book using PHP and MySQL.
From beginning to end, you will learn by doing SQL-based projects and submitting them for instructor feedback. These projects, as well as the final project, will add to your portfolio and contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O’Reilly School of Technology.
90 Clock-hours 6 CEUs
Course Details and Syllabus
|Course:||PHP/SQL 1: Introduction to Database Programming|
|Time Frame:||This course is online and self-paced. You can expect to work approximately 90 hours on this course.|
|Technical Requirements:||As long as you have a web browser and internet connection, you can take this course from anywhere in the world.|
|CEUs:||6 Continuing Education Units with official letter from O’Reilly Media.|
|Software:||The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you’ll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.|
|Instructor:||You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.|
|Certificates:||Completion of this course counts toward the Open Source Programming Certificate Series and the PHP/SQL Programming Certificate Series.|
|Prerequisites:||Introduction to HTML and CSS and Introduction to PHP, or equivalent skills in HTML and PHP. This course is meant for the beginning or intermediate programmer.|
|Topics:||Creating Databases and Tables, Inserting Information, Retrieving Information, Searching, Summarizing, Application Development using PHP, etc.|