The first 14 days of this book show you how to use SQL to incorporate the power of modern relational databases into your code. By the end of Week 1, you will be able to use basic SQL commands to retrieve selected data.At the end of Week 2, you will be able to use the more advanced features of SQL, such as stored procedures and triggers, to make your programs more powerful. Week 3 teaches you how to streamline SQL code; use the data dictionary; use SQL to generate more SQL code; work with PL/SQL, Transact-SQL, and SQL*Plus; and handle common SQL mistakes and errors.
The syntax of SQL is explained and then brought to life in examples using Personal Oracle7, Microsoft Query, and other database tools. You don't need access to any of these products to use this book--it can stand alone as an SQL syntax reference. However, using one of these platforms and walking though the examples will help you understand the nuances.
This book uses the following typeface conventions:
- Menu names are separated from menu options by a vertical bar (|). For example, File | Open means "select the Open option from the File menu."
- New terms appear in italic.
- All code in the listings that you type in (input) appears in boldface monospace. Output appears in standard monospace.
- The input label and output label also identify the nature of the code.
- Many code-related terms within the text also appear in monospace.
- Paragraphs that begin with the analysis label explain the preceding code sample.
- The syntax label identifies syntax statements.
The following special design features enhance the text:
Không có nhận xét nào:
Đăng nhận xét