A comprehensive study of SQL practice and implementation

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...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
1. Verfasser:	Patni, Jagdish Chandra (VerfasserIn)
Format:	UnknownFormat
Sprache:	eng
Veröffentlicht:	Boca Raton, London, New York CRC Press 2023
Ausgabe:	First edition
Schlagworte:	Algorithmen und Datenstrukturen > Algorithms & data structures > Artificial intelligence > Bibliotheks- und Informationswissenschaften / Museumskunde > COMPUTERS / Computer Graphics / Game Programming & Design > COMPUTERS / Computer Science > COMPUTERS / Database Management / General > COMPUTERS / General > COMPUTERS / Information Technology > COMPUTERS / Programming Languages / General > Computer architecture & logic design > Datenbanken > Informationstechnik (IT), allgemeine Themen > Künstliche Intelligenz > Programmier- und Skriptsprachen, allgemein > Programming & scripting languages: general > Rechnerarchitektur und Logik-Entwurf > SQL Server / MS SQL > Software Engineering > Supercomputer > SQL > Relationale Datenbank
Online Zugang:	Cover Inhaltsverzeichnis
Tags:	Tag hinzufügen Keine Tags, Fügen Sie den ersten Tag hinzu!

Bestellen

Beschreibung
Zusammenfassung:	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. 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.FeaturesThe 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 examplesThis 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
Beschreibung:	Literaturangaben Interessenniveau: 05, College/higher education: For universities and colleges of further and higher education. (05)
Beschreibung:	xvii, 217 Seiten Illustrationen
ISBN:	9781032348407 978-1-032-34840-7 9781032349756 978-1-032-34975-6