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