A Comprehensive Study of SQL: Practice and Implementation

Book Description

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 studies.
• It explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.
• It also gives a solid foundation in best practices and relational theory.
• The 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.

中文：

书名：SQL的综合研究: 实践与实现

对SQL-实践和实现的全面研究被设计为教科书，并提供了SQL (结构化查询语言) 的全面方法，SQL是定义，组织和探索关系数据库中数据的标准编程语言。它演示了如何利用数据查询和分析的两个最重要的工具-SQL和Excel-来执行全面的数据分析，而不需要复杂而昂贵的数据挖掘工具或应用程序。

特征

• 本书提供了完整的建模技术集合，从基础知识开始，并通过日益复杂的现实案例研究逐步发展。
• 介绍了如何构建、填充和管理高性能数据库，以及如何开发基于SQL的强大应用程序。
• 它还为最佳实践和关系理论奠定了坚实的基础。
• 本书在每一章的末尾提供了有关关键SQL概念或技术的独立课程，并使用大量插图和注释示例。

本书主要面向具有计算机科学和信息技术背景的高级本科生和毕业生。研究人员和专业人士也会发现这本书很有用。