Learn how to write a fully functional database application that provides the basic functions of a database management system.
- [Instructor] For this chapter we're going…to examine this simple CRUD application.…CRUD is an acronym that stands for…Create, Read, Update and Delete.…These are the four basic functions of a database system.…This CRUD application is a demonstration of how these…functions work in a relational and scripted context.…This applications demonstrates the use of two tables…that are related, it uses the same album.db database…we've been using for examples in the rest of the course.…
This is basically what the application…looks like in its default state.…So here it's listed all of the albums.…I can edit them, I can delete them or I can add an album.…In this case I'm just gonna add a simple album.…New Album I'll title it, I'll use title case and the artist…is Me Of Course and the label is My Wonderful Label,…and it was released on say the 4th of May in 2018,…and so I'll add the album and now the album…has been added and we're gonna add tracks.…
So I'll say track number one is This is track one…and it's got a duration of four minutes…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.