If you're an aspiring database administrator, you need to learn SQL quickly to advance in your career. SQL Power! The Comprehensive Guide provides just the data you need to go from novice to master by immersing you in real-life database design, implementation, and administration situations. The book is equally useful for those already experienced with databases and SQL who want to increase their knowledge without having to sift through a tome.
Beginning with an overview of SQL and the concept of relational databases, the book goes on to cover all the major topics, including tables, primary keys, relationships, foreign keys, MySQL, and database software, as well as the data definition, data manipulation, and data control languages. Later chapters cover higher-level topics such as advanced queries, virtual tables, normalization, and embedded SQL. The book's examples build upon one another, with end-ofchapter exercises that test your knowledge as you go. All of the source code used in the book is available for download at courseptr.com/downloads.
In this book you'll find:
- Examples using a live database that you create
- Information on different RDBMS brands
- Instructions for and examples of embedded SQL
- An introduction to stored prodedures and data warehousing
- Step-by-Step eamples that teach how to mormalize a database
- Appendices featuring examples of almost every function available, as well as DBA commands, syntax, and instructions for installing MySQL ORCA and PHP
Chapter 1 SQL : The Language
Chapter 2 Relational Databases
Chapter 3 Database Software
Chapter 4 Data Definition Language
Chapter 5 MySQL
Chapter 6 Data Manipulation Language
Chapter 7 Data Control Language
Chapter 8 Advanced Queries
Chapter 9 Veiws
Chapter 10 SQL Optimization
Chapter 11 Normalization
Chapter 12 Embedded SQL
Chapter 13 Stored Procedures
Chapter 14 Data Warehousing
Appendix A Database Administrator Utilities
Appendix B MySQL Maintenance
Appendix C MySQL Installation
Appendix D Orca Installation
Appendix F Functions
Appendix G Answers to Chapter Review Questions