Day
1-Working with Files
- Overview of the Structured Query Language
- SQL: Retrieving records from a database
- SQL: Inserting Records into a database
- SQL: Deleting Records from a database
- SQL: Updating records in a database
- SQL: Sorting, retrieving specific records e.t.c
Day 2-MYSQL
- Introduction to MySQL Server
- Downloading and Installing the MYSQL
- Research Project
- Structured Query Language and MYSQL
- Starting MYSQL
- Displaying the MYSQL Version
- Displaying the current datae
- Common commands
- Resolving errors e.g. "Error 1044: Access denied
for users"
- Connecting to the Server
- Disconnecting from the server
- Course lab exercises
- Course homework assignment
Day 3- Retrieving records from MYSQL
with PHP
- Connecting to a database on the server
- Handling error messages
- Retrieving database records with SQL
- Displaying records query results
- Overview of mysql_fetch_row() Function
- Overview of mysql_fetch_assoc() Function
- Overview of mysql_fetch_array() Function
- Overview of mysql_result() Function
- Lab Exercises
- Course Homework Assignment
Day 4-Searching for Records in a MYSQL database with PHP
- Preparing the search form
- Coding the search form
- Retrieving the form input
- Connecting to the database
- Building SQL Statements
- Executing SQL Statements
- Displaying the search results
- Handling "no record
found" searches
Day 5-Inserting Records into a MYSQL database with PHP
- Preparing the input form
- Coding the input form
- Retrieving the form input
- Connecting to the database
- Building SQL insert statements
- Executing SQL statements
- Verifying the inserted
record
Day 6- Updating and Deleting records in a MYSQL database
with PHP
- Locating the exact record
- Using querystrings
- Displaying the record in an HTML
form
- Processing the update
- Displaying the updated database
- Deleting records
Day7-14 FINAL
PROJECT
Benefits Explained:
Instructor-led Training: Students can choose either our
Instructor-led self-paced training or our Instructor-led
one-on-one training. Both training choices guarantee
students instructor feedback, evaluation and course concept
clarification. Students registering for the Instructor-led
one-on-one training will have telephone, instant messenger/net
conferencing, and email access to their instructor. Students
registering for the Instructor-led self-paced training will
have email access to their instructor.
Live server space: We provide students access to Web
servers running PHP, ASP, and ColdFusion MX. These servers
are available to all registered students for the duration of
the course at no additional cost. All students are
required to upload their homework assignments to the school
server. Instructions on how to upload homework assignments are
provided by the school.
Convenient Schedule: Our training requires no time and
place commitments. Students can access course lectures,
projects, homework assignments, and other course resources at
any time. Access is granted 24 hours a day, 7 days a week.
Instructor Support: Our instructors are available to
answer questions on course topics, homework assignments,
projects and other course related issues. Instructor
Support is available on weekdays between 9am and 4pm Eastern
Standard time. Instructors usually respond with in a
2-6hour time frame.
Course/Program Certificate: The Internet Learning
Institute issues a certificate of completion to
students who successfully complete their course. Completion of
the course is based on the completion of the final project.
The final project usually includes all concepts covered in the
course lectures.
Grade Report: We maintain a grade reporting system.
Students are generally graded for homework assignments and
final projects. Students are emailed updated reports as
homework assignments and projects are evaluated by
instructors.
Instructor Homework Evaluation and Final Project Evaluation: Our
Instructors evaluate, grade and provide feedback on all
homework assignments and projects. Evaluation, grading and
feedback is generally based
on coding techniques, presentation, mastery, comprehension,
utilization and application of course lecture concepts. We
always encourage our students to go above and beyond the
project requirements.
|
Got
Questions?
Click
Here
Ready to
Register?
Click
Here
*Prerequisite:
*Students
are strongly encouraged to review prerequisite course
requirements. Adequate knowledge of prerequisite courses
provide a solid foundation for successful
participation in this course.
Benefits:
- Instructor-led
Online Training
- Live
server space
- Convenient
Schedule (No place or time commitment)
- Instructor
Support
- Course/Program
Certificate
- Grade
Report
- Official
Transcript
- Instructor Homework
Evaluation
- Instructor Final
Project Evaluation
About Complete
Certificate Courses
Complete certificate courses are detailed courses.
Instructors use extensive homework assignments and
projects to reinforce lecture topics.
Students must meet homework, lab,
and final project requirements before the course
certificate is issued.
Homework assignments and projects are evaluated based
on coding techniques, presentation, mastery,
comprehension, utilization and application of course
lecture concepts.
Multiple Registrations:
Note that multiple registrations are only
allowed with company purchase orders. School policy
generally requires that students register for one
course at a time.
How
to use your personal project as a basis for your
final course project: The school allows the use
of a personal project as a basis for a final
project. This option is excellent for students
working on related projects. Students are required
to submit a project proposal to their instructor for
approval. Instructors review project proposals to
ensure that they are within the course limits and to
ensure that the incorporate all concepts learned in
the class.
Note:
All students registered for complete certificate
courses have two months to complete their course
load. Students who take longer than two months will
be considered dormant. A dormant student is a
student who has failed to complete the required
course work within the allowed period. Dormant
students are required pay a course reactivation fee
of half (50%) of the current tuition. |
|