This Description may be from another edition of this product.

Learn to:

• Build relational databases and pull useful information fromthem
• Create a database management system using SQL
• Secure your database and protect it from corruption
• Use all the latest SQL features

Create more powerful databases and easily access information-- the secret is SQL!

Our world runs on data -- more now than ever before. Allthat data must be stored in a logical way, secure and easilyaccessible. SQL is the language you use to create databasemanagement systems, implement database design, and manage dataaccess. This guide takes you step by step through understanding andapplying the latest version of SQL to help you take control of yourdata like a pro.

• The basic stuff -- understand the fundamentals of SQL andrelational databases
• Speaking the language -- learn the language of datadefinition, data manipulation, and data control
• Begin building -- use a RAD tool to build a simpledatabase, then move into multitable relational databases
• Do things with data -- discover how to add, update, andretrieve data, and delete what you no longer need
• Find what you want -- examine techniques for querying yourdatabase to retrieve exactly the data you're looking for
• Keep it safe -- manage user access, Read More chevron_right

This Description may be from another edition of this product.

Learn to:

• Build relational databases and pull useful information fromthem
• Create a database management system using SQL
• Secure your database and protect it from corruption
• Use all the latest SQL features

Create more powerful databases and easily access information-- the secret is SQL!

Our world runs on data -- more now than ever before. Allthat data must be stored in a logical way, secure and easilyaccessible. SQL is the language you use to create databasemanagement systems, implement database design, and manage dataaccess. This guide takes you step by step through understanding andapplying the latest version of SQL to help you take control of yourdata like a pro.

• The basic stuff -- understand the fundamentals of SQL andrelational databases
• Speaking the language -- learn the language of datadefinition, data manipulation, and data control
• Begin building -- use a RAD tool to build a simpledatabase, then move into multitable relational databases
• Do things with data -- discover how to add, update, andretrieve data, and delete what you no longer need
• Find what you want -- examine techniques for querying yourdatabase to retrieve exactly the data you're looking for
• Keep it safe -- manage user access, make your data lessvulnerable to corruption, and understand threats
• Alphabet soup -- master ODBC and JDBC access, and use SQLon XML data
• Advanced SQL -- explore adding procedural capabilities withpersistent stored modules and handling errors

Open the book and find:

• The wide array of data types
• How to use SQL on the Internet
• Tips for designing tables
• Ways to maintain data integrity
• What you should know about values and value expressions
• How to use subqueries and recursive queries
• All about using triggers
• Ten common mistakes to avoid