SQL - Robert Dwight.pdf

(612 KB) Pobierz
SQL:
Learn SQL in 24 Hours Or Less
A Beginner’s Guide To Learning SQL
Programming Now
Table Of Contents
Introduction
Chapter 1: Fundamental Concepts Regarding SQL and Databases
Relational Databases
The SQL Language
The SQL Statements
The Different Execution Types
Chapter 2: The Environment of the SQL Language
SQL’s Environment – The Basics
More Details About SQL Catalogs
The Schemas
How to Name Database Objects
How to Generate a Schema
Creating a New Database
Chapter 3: How to Generate and Modify Tables
Generating an SQL Table
Specifying the Data Type of a Column
How to Specify the Default Value of a Column
How to Alter an SQL Table
How to Delete an SQL Table
Chapter 4: How to Ensure Data Integrity
Integrity Constraints – The Basics
The Not Null Constraint
The Unique Constraint
The PRIMARY KEY Constraint
The FOREIGN KEY Constraints
The CHECK Constraint
Chapter 5: How to Create an SQL View
How to Add a View to a Database
How to Create an Updateable View
How to Drop a View
Chapter 6: Database Security
The Security Model of SQL
Creating and Deleting a Role
Granting and Revoking a Privilege
Conclusion
Bonus: Preview Of “PHP: Learn PHP In 24 Hours Or Less – A Beginner’s Guide To
Learning PHP Programming Now”
Conditional Structures
The Loop Structures
Zgłoś jeśli naruszono regulamin