A Comprehensive Study of SQL
eBook - ePub

A Comprehensive Study of SQL

Practice and Implementation

  1. 214 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

A Comprehensive Study of SQL

Practice and Implementation

Book details
Table of contents
Citations

About This Book

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.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access A Comprehensive Study of SQL by Jagdish Chandra Patni in PDF and/or ePUB format, as well as other popular books in Computer Science & Computer Science General. We have over one million books available in our catalogue for you to explore.

Information

Publisher
CRC Press
Year
2022
ISBN
9781000798630
Edition
1
Topic
Computer Science
Subtopic
Computer Science General
Index
Computer Science

Table of contents

  1. Cover Page
  2. Half Title page
  3. Title Page
  4. Copyright Page
  5. Dedication
  6. Contents
  7. Preface
  8. Biography
  9. Acknowledgement
  10. 1 Database Systems
  11. 2 Creating and Manipulating Database
  12. 3 Data and Integrity Constraints
  13. 4 Query Execution and Aggregate Functions
  14. 5 SQL Server vs. Oracle
  15. 6 Conditional Statements and Operators in SQL
  16. 7 Nested Query and Join
  17. 8 Views, Indexes, and Sequence
  18. 9 PL/SQL
  19. 10 Procedures and Functions
  20. 11 Cursors and Triggers
  21. 12 Database Change Management
  22. 13 Sample Questions and Answers
  23. Index