A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage the two most vital tools for data query and analysis - SQL and Excel - to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool or application.
Features
The book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studiesIt explains how to build, populate, and administer high-performance databases and develop robust SQL-based applicationsIt also gives a solid foundation in best practices and relational theoryThe book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examples
This book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.
Features
The book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studiesIt explains how to build, populate, and administer high-performance databases and develop robust SQL-based applicationsIt also gives a solid foundation in best practices and relational theoryThe book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examples
This book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.