Sql Power! : Comprehensive Guide (07 Edition)

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 www.courseptr.com/downloads.

"SQL Power!: The Comprehensive Guide" is a complete reference guide to SQL, the standard programming language for relational databases. This comprehensive book is perfect for IT professionals, consultants, database administrators, and anyone else who works with relational databases. The book is clearly written with all technical topics explained in easy-to-understand language. A detailed table of contents and in-depth and well-organized index make topics easy to find. In addition, end-of-chapter projects encourage readers to program on their on using the new skills they have learned, and all code used in the book can be downloaded from the companion website.

An author has not yet been signed for this book.

1: SQL: The Language. 2: Relational Databases. 3: Database Software. 4: Data Definition Language. 5: MySQL. 6: Data Manipulation Language. 7: Data Control Language. 8: Advanced Queries. 9: Views. 10: SQL Optimization. 11: Normalization. 12: Embedded SQL. 13: Stored Procedures. 14: Data Warehousing. Appendix A: Database Administrator Utilities. Appendix B: MySQL Maintenance. Appendix C: MySQL Installation. Appendix D: Orca Installation. Appendix E: PHP Installation. Appendix F: Functions. Appendix G: Chapter Review Answers.