Originally posted by Lynn Beighley:
No stored procedures, but yes, all the crucial things you need to learn about SQL. Here's the table of contents, hopefully that will be helpful:
1 Data and Tables: A place for everything
2 The SELECT Statement: Gifted data retrieval
3 DELETE and UPDATE: A change will do you good
4 Smart Table Design: Why be normal?
5 ALTER: Rewriting the past
6 Advanced SELECT: Seeing your data with new eyes
7 Multi-table Database Design: Outgrowing your table
8 Joins and Multi-table Operations: Can�t we all just get along?
9 Subqueries: Queries Within Queries
10 Outer Joins, Self Joins, and Unions: New maneuvers
11 Constraints, Views, and Transactions: Too many cooks spoil the database
12 Security: Protecting your assets
Originally posted by Lynn Beighley:
That is correct, Jenson.
Originally posted by Lynn Beighley:
This book strictly covers SQL syntax and database design. It goes into great depth, but is not for the developer who knows SQL and wants to create connections into his applications. It IS for the developer who has never written a query or designed a table.