MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

CRUD Operations with PHP

Course Summary

In this course we'll delve into the full spectrum of database interactions. Whether the application is an e-commerce, or social network site, or even a todo app on your phone, the data needs to change over time. CRUD is an acronym that refers to the four main operations that you'd want to perform on data in a database: Create, Read, Update, Delete.


  • +

    Course Syllabus

    Project Setup

    In this course we'll be creating a time tracker to keep track of the time spent on projects. We'll use the PHP Data Object to give us all the attributes and actions we need to interact with the database. 5 steps
    • What is CRUD? 1:55
    • Introduction to the Project 2:20
    • Connecting to the Database 4:00
    • Handling Exceptions 4:30
    • CRUD Connections 7 questions

    Creating Records

    The first two CRUD operations are the ones we perform most often on a database. Creating the record and Reading the record. We'll examine how PDO allows us to safely complete these operation on a database and how we handle user data. 10 steps

    Reading and Writing Reports

    One of the great features of having data in a database is the ability to report on that data. Filtering data for different situations and performing calculations on that data. We'll discover how to use this feature to make our time tracker much more useful. 9 steps

    Updating and Deleting Records

    Mistakes happen. Requirements change. We'll explore ways to handle these changes when it comes to our application and databases in general. 7 steps


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top