Getting started with SQL and databases : managing and manipulating data with SQL / Mark Simon.

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

Saved in:
Bibliographic Details
Main Author: Simon, Mark (Author)
Format: eBook
Language:English
Published: New York : Apress, [2023]
Subjects:
Online Access:Click for online access
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.