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...

Descripción completa

Detalles Bibliográficos
Otros Autores: Simon, Mark, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2023.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009790339406719
Tabla de Contenidos:
  • SQL Sampler
  • Database
  • Filtering Data
  • Ordering Results
  • Calculating Column Values
  • Selecting from Multiple Tables
  • Aggregating Data
  • Working with Tables
  • SQL Techniques
  • Appendix 1: Differences Between SQL Dialects
  • Appendix 2: Working with Tables
  • Appendix 3: A Crash Course in PDO.