§ Class Slides 6: SQL (Structured Query Language)

Class Slides 5: PHP (Cont.)
Class Slides 7: PHP and MySQL
Home

The following slides introduce SQL.

Slide 6.1: Relational databases and SQL
Slide 6.2: SQL (Structured Query Language)
Slide 6.3: SQL naming conventions
Slide 6.4: SQL commands
Slide 6.5: MySQL built-in datatypes
Slide 6.6: SQL CREATE TABLE statement
Slide 6.7: SQL CREATE TABLE statement (cont.)
Slide 6.8: SQL INSERT INTO statement
Slide 6.9: SQL INSERT INTO statement (cont.)
Slide 6.10: SQL DELETE FROM statement
Slide 6.11: SQL UPDATE statement
Slide 6.12: SQL ALTER TABLE statement
Slide 6.13: SQL ALTER TABLE statement (cont.)
Slide 6.14: SQL DROP TABLE and TRUNCATE TABLE statements
Slide 6.15: SQL SELECT statement
Slide 6.16: SQL SELECT DISTINCT statement
Slide 6.17: SQL SELECT WHERE clause

  ☂ References

Slide 6.ⓐ: MySQL tutorial from W3Schools
Slide 6.ⓑ: SQL tutorial from W3Schools
Slide 6.ⓒ: DATA 520 Databases (my practical database course)






      By three methods we may learn wisdom:    
      First, by reflection, which is noblest;    
      Second, by imitation, which is easiest; and    
      third by experience, which is the bitterest.    
      ― Confucious