
SQL Power!
The Comprehensive Guide
Course Technology Inc (Publisher)
Published on 1. July 2006
Book
Mixed media product
496 pages
978-1-59863-212-5 (ISBN)
Description
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.
Reviews / Votes
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.More details
Language
English
Place of publication
Boston, MA
United States
Publishing group
Cengage Learning, Inc
Target group
College/higher education
Dimensions
Height: 232 mm
Width: 188 mm
Thickness: 29 mm
Weight
953 gr
ISBN-13
978-1-59863-212-5 (9781598632125)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Kenneth Hess is an avid database enthusiast and administrator. He has worked with many different types of database software over the past 20 years. Ken currently focuses his database interests and research on MySQL and SQLite. He maintains his technical edge through his day job and research with Linux, PHP, MySQL, SQLite, and other open-source applications. You can access Ken's web site at www.kenhess.com.
Content
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.