|
|
|
Practicum meeting with the U of U preceptors and Weber students 9-15-23 part 1
|
|
|
|
|
|
|
|
|
|
|
|
Review the terminology and SQL commands used in this activity.
|
|
Add ON to the SQL JOIN statement to get data that makes sense from two tables at once.
|
|
Use a SQL UPDATE statement to the change values in a record.
|
|
Use a SQL DELETE statement to remove a record in the database. Be careful to not DELETE them all!
|
|
Use the SQL INSERT statement to add a record to the database.
|
|
Write a SQL SELECT statement using WHERE and ORDER BY.
|
|
In this video we write a SQL SELECT statement.
|
|
|
|
|