A Comprehensive Study of SQL: Practice and Implementation

ISBN-13: 9781032348407 / Angielski / Twarda / 2022 / 136 str.

Jagdish Chandra (UPES Dehradun) Patni

Opis

This book is designed as a textbook and provides a comprehensive approach to SQL - the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage SQL and Excel to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool.

Spis treści

1. Database Systems. 2. Creating and Manipulating Database. 3. Data and Integrity Constraints. 4. Query Execution and Aggregate functions. 5. SQL Server Vs. Oracle. 6. Conditional statements and Operators in SQL. 7. Nested Query and Join. 8. Views, Indexes and Sequence. 9. PL/SQL. 10. Functions and Procedures. 11. Cursors and Triggers. 12. Change Management for databases. 13. Previous year Question papers with solutions.