Đang chuẩn bị liên kết để tải về tài liệu:
The Language of SQL- P3

The Language of SQL- P3:Research has shown that, being pressed for time, most readers tend to skip the introduction of any book they happen to read and then proceed immediately to the first real chapter. With that fact firmly in mind, we will only cover relatively unimportant material in the introduction, such as an explanation of what you will and will not learn by reading this book. | x Contents Correlated Subquery Updates.181 Looking Ahead.183 Chapter 18 Maintaining Tables.185 Data Definition Language.185 Table Attributes.186 Table Columns.187 Primary Keys and Indexes.188 Foreign Keys.189 Creating Tables.190 Creating Indexes.192 Looking Ahead.192 Chapter 19 Principles of Database Design.195 Goals of Normalization.196 How to Normalize Data.198 The Art of Database Design.202 Alternatives to Normalization.203 Looking Ahead.205 Chapter 20 Strategies for Displaying Data.207 Beyond SQL.207 Reporting Tools and Crosstab Reports.208 Spreadsheets and Pivot Tables.210 Looking Ahead.212 Appendix A Getting Started with Microsoft SQL Server.215 Overview.215 Installing SQL Server Express 2008 . 215 Installing SQL Server Management Studio.216 Using SQL Server Management Studio.217 Appendix B Getting Started with MySQL.219 Overview.219 Installing MySQL Community Server.220 Installing MySQL Workbench.221 Using MySQL Workbench.222 Contents xi Appendix C Getting Started with Oracle.225 Overview.225 Installing Oracle Database Express Edition.225 Using Oracle Database Express Edition.227 Appendix D Listing of All SQL Statements.229 Index.231 Introduction Research has shown that being pressed for time most readers tend to skip the introduction of any book they happen to read and then proceed immediately to the first real chapter. With that fact firmly in mind we will only cover relatively unimportant material in the introduction such as an explanation of what you will and will not learn by reading this book. On second thought perhaps the introduction really is relevant so you might as well stick with it. We ll make it brief. Even if you re not yet familiar with SQL suffice it to say that it is a complex language with many components and features. In this book we re going to focus on one main topic How to use SQL to retrieve data from a database To a lesser extent we will also cover How to update data in a database How to build and maintain databases How to design .