Learn that a relational database is organized in tables, rows, and columns. Also, learn that a unique key is used to identify individual rows in a table, and to relate one table to another.
- [Narrator] The purpose of a database is to organize…your data and to make it available in convenient forms.…SQL is the language for managing a relational database.…A relational database is organized in…two-dimensional tables, comprised of rows and columns.…A relational database has tables.…It could have one table or many tables.…In this example, the database has three tables:…customer, item, and sale.…A table has rows and columns.…
In this example, the customer table has three rows.…The columns are named "ID," "Name," "Address,"…"City," "State," and "Zip."…A row is like an individual record in a table.…In fact, some will use the term "record"…interchangeably with "row."…In this example, the highlighted row…is the record for Mary Smith in the customer table.…A column is like a field.…Again, some will use the term "field"…interchangeably with "column."…In this example, the highlighted column…is named "address," and it contains…the addresses of each row in the table.…
Each row in a table has a unique key.…The table's unique key may or may not correspond…
- 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.