Introduction to SQL: Mastering the Relational Database Language

1. to SQL Section 1.1. Section 1.2. Database, Database Server, and Database Language Section 1.3. The Relational Model...

2. The Tennis Club Sample Database Section 2.1. Section 2.2. Description of the Tennis Club Section 2.3. The Contents of the Tables...

3. Installing the Software Section 3.1. Section 3.2. Installation of MySQL Section 3.3. Installation of ODBC Section 3.4...

4. SQL in a Nutshell Section 4.1. Section 4.2. Logging On to the MySQL Database Server Section 4.3. Creating New SQL Users...

5. SELECT Statement: Common Elements Section 5.1. Section 5.2. Literals and Their Data Types Section 5.3. Expressions Se...

6. SELECT Statements, Table Expressions, and Subqueries Section 6.1. Section 6.2. The Definition of the SELECT Statement Section 6.3....

7. SELECT Statement: The FROM Clause Section 7.1. Section 7.2. Table Specifications in the FROM Clause Section 7.3. Again, the Column...

8. SELECT Statement: The WHERE Clause Section 8.1. Section 8.2. Conditions Using Comparison Operators Section 8.3. Comparison Operator...

9. SELECT Statement: SELECT Clause and Aggregation Functions Section 9.1. Section 9.2. Selecting All Columns (*) Section 9.3. Expressi...

10. SELECT Statement: The GROUP BY Clause Section 10.1. Section 10.2. Grouping on One Column Section 10.3. Grouping on Two or More Col...

11. SELECT Statement: The HAVING Clause Section 11.1. Section 11.2. Examples of the HAVING Clause Section 11.3. General Rule for the H...

12. SELECT Statement: The ORDER BY Clause Section 12.1. Section 12.2. Sorting on Column Names Section 12.3. Sorting on Expressions...

13. Combining Table Expressions Section 13.1. Section 13.2. Combining with UNION Section 13.3. Rules for Using UNION Sec...

14. Updating Tables Section 14.1. Section 14.2. Inserting New Rows Section 14.3. Populating a Table with Rows from Another Table...

15. Creating Tables Section 15.1. Section 15.2. Creating New Tables Section 15.3. Data Types of Columns Section 15.3.2....

16. Specifying Integrity Constraints Section 16.1. Section 16.2. Primary Keys Section 16.3. Alternate Keys Section 16.4....

17. Character Sets and Collating Sequences Section 17.1. Section 17.2. Available Character Sets and Collating Sequences Section 17.3....

18. Changing and Dropping Tables Section 18.1. Section 18.2. Deleting Entire Tables Section 18.3. Renaming Tables Sectio...

19. Designing Tables Section 19.1. Section 19.2. Which Tables and Columns? Section 19.3. Adding Redundant Data Section 1...

20. Using Indexes Section 20.1. Section 20.2. Rows, Tables, and Files Section 20.3. How Does an Index Work? Section 20.4...

21. Views Section 21.1. Section 21.2. Creating Views Section 21.3. The Column Names of Views Section 21.4....

22. Creating Databases Section 22.1. Section 22.2. Databases and the Catalog Section 22.3. Creating Databases Section 22...

23. Users and Data Security Section 23.1. Section 23.2. Adding and Removing Users Section 23.3. Granting Table and Column Privileges...

24. Creating Sequences Section 24.1. Section 24.2. Why Do We Need Sequences? Section 24.3. Options of the Sequences Sect...

25. Creating Schemas Section 25.1. What Is a Schema? Section 25.2. Creating a Schema Section 25.3. Removing a Schema Sect...

26. to Embedded SQL Section 26.1. Section 26.2. The Pseudo Programming Language Section 26.3. DDL and DCL Statements and Embedded SQL...

27. Transactions and Multi-User Usage Section 27.1. Section 27.2. What Is a Transaction? Section 27.3. Starting Transactions...

28. to ODBC Section 28.1. Section 28.2. The History of ODBC Section 28.3. How Does ODBC Work? Section 28.4....

29. Optimization of Statements Section 29.1. Section 29.2. Avoid the OR Operator Section 29.3. Avoid Unnecessary Use of the UNION Oper...

30. Stored Procedures Section 30.1. Section 30.2. An Example of a Stored Procedure Section 30.3. The Parameters of a Stored Procedure...

31. Stored Functions Section 31.1. Section 31.2. Examples of Stored Functions Section 31.3. Removing Stored Functions...

32. Triggers Section 32.1. Section 32.2. An Example of a Trigger Section 32.3. More Complex Examples Section 32.4....

33. User-Defined Data Types, Functions, and Operators Section 33.1. Section 33.2. Creating User-Defined Data Types Section 33.3. Acces...

34. Inheritance, References, and Collections Section 34.1. Inheritance of Data Types Section 34.2. Linking Tables via Row Identifications Section 34...

35. The Future of SQL quot;SQL was, is, and will stay for the foreseeable future the database language for relational database servers.quot; That is how we started this book. We know exactly what SQL used to look like a...