SQL: Learn SQL in 24 Hours or Less - A Beginner's Guide To Learning SQL Programming Now (SQL, SQL Programming, SQL Course)

Introduction......Page 6
Chapter 1: Fundamental Concepts Regarding SQL and Databases......Page 8
 Relational Databases......Page 9
 The SQL Language......Page 10
 The SQL Statements......Page 11
 The Different Execution Types......Page 12
Chapter 2: The Environment of the SQL Language......Page 14
 SQL's Environment – The Basics......Page 15
 More Details About SQL Catalogs......Page 16
 The Schemas......Page 17
 How to Name Database Objects......Page 19
 How to Generate a Schema......Page 21
 Creating a New Database......Page 23
Chapter 3: How to Generate and Modify Tables......Page 25
 Generating an SQL Table......Page 26
 Specifying the Data Type of a Column......Page 30
 How to Specify the Default Value of a Column......Page 36
 How to Alter an SQL Table......Page 37
 How to Delete an SQL Table......Page 39
Chapter 4: How to Ensure Data Integrity......Page 41
 Integrity Constraints – The Basics......Page 42
 The Not Null Constraint......Page 43
 The Unique Constraint......Page 44
 The PRIMARY KEY Constraint......Page 47
 The FOREIGN KEY Constraints......Page 50
 The CHECK Constraint......Page 58
Chapter 5: How to Create an SQL View......Page 65
 How to Add a View to a Database......Page 66
 How to Create an Updateable View......Page 71
 How to Drop a View......Page 72
Chapter 6: Database Security......Page 74
 The Security Model of SQL......Page 75
 Creating and Deleting a Role......Page 76
 Granting and Revoking a Privilege......Page 77
Conclusion......Page 78
Bonus: Preview Of “PHP: Learn PHP In 24 Hours Or Less – A Beginner’s Guide To Learning PHP Programming Now”......Page 79
 Conditional Structures......Page 80
 The Loop Structures......Page 84