Comprehensive Study of SQL

Practice and Implementation

AvJagdish Chandra Patni

Häftad, Engelska, 2024

736 kr

Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

E-bok

864 kr

E-bok

864 kr

Inbunden

1 231 kr

Beskrivning

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.

Produktinformation

Utgivningsdatum:2024-12-19
Mått:178 x 254 x 13 mm
Vikt:453 g
Format:Häftad
Språk:Engelska
Antal sidor:218
Förlag:Taylor & Francis Ltd
ISBN:9781032349756

Utforska kategorier

Systemvetenskap och AI inom Data och IT
Informationsteknik: allmänt inom Data och IT
Affärsapplikationer inom Data och IT

Mer om författaren

Dr. Jagdish Chandra Patni is working as Senior Associate Professor at School of Computer Science , University of Petroleum and Energy Studies, Dehradun, Uttarakhand, India. He did his Ph.D. in the area of High Performance computing in 2016 . He competed his M. Tech. and B. Tech. in the year 2009 and 2004 respectively. Dr Patni is actively working in the research areas of Database Systems, High Performance computing, Software Engineering, Machine Learning and IoT. He has authored more than 50 research articles in the journal and conferences of repute nationally and internationally. Dr Patni have authored 5+ books and book chapter with international publishers like Springer. He is active Guest Editor/Reviewer of various referred International journals. He has delivered 15 Keynote/Guest speech in India and abroad. He has organized multiple conferences/seminars/workshops/FDP’s in India and abroad. He has been awarded by researcher Excellence award in year 2021 by Government of Uttarakhand & UCOST, Young Scientist Award 2021 by UCOST Dehradun and Divya Himgiri, Teacher of the year 2020 by Govt. of Uttarakhand, best paper award by Hosei University Tokyo, Japan in 2020 and many more. He is Senior member of IEEE, Member ACM, MIE, IEANG, IACSIT, Vigyan Bharti, etc.

Innehållsförteckning

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.