The following slides introduce databases and SQL.
 Slide 14.ⓐ: SQL tutorial from W3Schools (reference)
Slide 14.ⓑ: DATA520 Databases (my practical database course)
Slide 14.1: Introduction to databases
Slide 14.2: SQL (Structured Query Language)
Slide 14.3: SQL syntax
Slide 14.4: SQL syntax (cont.)
Slide 14.5: SQL create table statement
Slide 14.6: SQL insert into statement
Slide 14.7: SQL insert into statement (cont.)
Slide 14.8: SQL select statement
Slide 14.9: SQL select distinct statement
Slide 14.10: SQL where clause
Slide 14.11: SQL update statement
Slide 14.12: SQL delete and drop statements
Slide 14.13: Programming Exercise IV SQL commands
|
|
|
|
