Getting started with SQL and databases managing and manipulating data with SQL

Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic...

Full description

Bibliographic Details
Main Author: Simon, Mark
Format: eBook
Language:English
Published: New York Apress 2023
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Table of Contents:
  • Chapter 1: SQL Sampler
  • Chapter 2: Database
  • Chapter 3: Filtering Data
  • Chapter 4: Ordering Results
  • Chapter 5: Calculating Column Values
  • Chapter 6: Selecting from Multiple Tables
  • Chapter 7: Aggregating Data
  • Chapter 8: Working with Tables
  • Chapter 9: SQL Techniques
  • Appendix 1: Differences Between SQL Dialects
  • Appendix 2: Working with Tables
  • Appendix 3: A Crash Course in PDO.