|
You can find a copy of the slides using the link below. https://bit.ly/3VAfDjD
|
|
|
|
Content Review of SQL query types INSERT query Requirements for INSERT query DELETE query UPDATE query UPDATE problem 1 Evaluation of query for problem 1 UPDATE problem 2 Problem 2 output evaluation…
|
|
Content SELECT query clauses: syntax and execution sequence Bike Scotland scenario introduction SELECT query execution for N5 PK and FK roles in equi-join Matching rows from related tables Cartesian…
|
|
Content SQL errors and causes from research Classroom experience of SQL errors Data, tables and DBMS Table essentials DDD vocabulary N5-H Multiple tables Physical entities Entity relationships…
|
|
|
|
|
|
|
|
|
|
Learn good practices using Blackboard Ally to ensure online accessibility.
|