Learning SQL : generate, manipulate, and retrieve data
Beaulieu, Alan
Learning SQL : generate, manipulate, and retrieve data Learning Structured Query Language by Alan Beaulieu - 3rd ed. - Mumbai : O'Reilly, ©2020 - xvi, 360 p. : ill. ; 24 cm.
Includes index.
1. A Little Background 2. Creating and Populating a Database 3. Query Primer 4. Filtering 5. Querying Multiple Tables 6. Working with Sets 7. Data Generation, Manipulation, and Conversion 8. Grouping and Aggregates 9. Subqueries 10. Joins Revisited 11. Conditional Logic 12. Transactions 13. Indexes and Constraints 14. Views 15. Metadata 16. Analytic Functions 17. Working with Large Databases 18. SQL and Big Data A. ER Diagram for Example Database B. Solutions to Exercises
9789352139781
2022302006
SQL (Computer program language)
Relational databases.
Data in computer systems
Computer programming
Programs
Data
QA76.73.S67 / B43 2020
005.758 / BEA-L
Learning SQL : generate, manipulate, and retrieve data Learning Structured Query Language by Alan Beaulieu - 3rd ed. - Mumbai : O'Reilly, ©2020 - xvi, 360 p. : ill. ; 24 cm.
Includes index.
1. A Little Background 2. Creating and Populating a Database 3. Query Primer 4. Filtering 5. Querying Multiple Tables 6. Working with Sets 7. Data Generation, Manipulation, and Conversion 8. Grouping and Aggregates 9. Subqueries 10. Joins Revisited 11. Conditional Logic 12. Transactions 13. Indexes and Constraints 14. Views 15. Metadata 16. Analytic Functions 17. Working with Large Databases 18. SQL and Big Data A. ER Diagram for Example Database B. Solutions to Exercises
9789352139781
2022302006
SQL (Computer program language)
Relational databases.
Data in computer systems
Computer programming
Programs
Data
QA76.73.S67 / B43 2020
005.758 / BEA-L