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...
Main Author: | |
---|---|
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.