Beginning SQL
|
Contents
| 1 | |
| 7 | |
Chapter 2 Entering Information | 41 |
Chapter 3 Extracting Information | 53 |
Chapter 4 Advanced Database Design | 117 |
Chapter 5 Manipulating Data | 157 |
Chapter 6 Grouping and Aggregating Data | 189 |
Chapter 7 Selecting Data from Different Tables | 207 |
Chapter 10 Views | 287 |
Chapter 11 Transactions | 301 |
Chapter 12 SQL Security | 327 |
Chapter 13 Database Tuning | 349 |
Appendix A Exercise Answers | 367 |
Appendix B Setting Up and Using the Five Database Systems | 391 |
Appendix C Initial Data Setup | 451 |
| 475 | |
Other editions - View all
Common terms and phrases
Access allows ALTER TABLE Attendance table AvailableOnDVD Big City cache Category table Category.CategoryId CategoryId chapter characters CHECK constraint column CREATE TABLE Daphne Moon data type database system DateOfBirth DateOfJoining DBMS DBMSs delete DVDPrice Email example Executing FavCategory table FavCategory.CategoryId field Film Club database FilmId Films table following SQL foreign key Frasier Crane function Golden IBM DB2 INNER JOIN INNER JOIN Category INSERT INSERT INSERT integer Jamie Hills Jenny Jones Katie Smith Location table LocationId locks MeetingDate MemberAttended MemberDetails table MemberDetails.MemberId MemberId MySQL MyTable NULL NULL NULL operator option Oracle Orange Town OrderItems(OrderId,FilmId outer join primary key privileges query RDBMS records results set returns rows salesperson Sandra Hugson Sci-fi SELECT FirstName SELECT statement specify SQL Server SQL statement Steve Gee Street Stuart Dales subquery Susie Simons syntax TABLE Films there’s Thriller Townsville UPDATE user ID Windy Village YearReleased ZipCode