Leveling Up with SQL : Advanced Techniques for Transforming Data into Insights

Leveling Up with SQL Advanced Techniques for Transforming Data into Insights

Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL dat...

Descripción completa

Detalles Bibliográficos
Autor principal: Simon, Mark (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2023.
Edición:1st ed. 2023.
Materias:
SQL (Computer program language)
Relational databases.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009764836406719
Tabla de Contenidos:
  • Chapter 1: Getting Ready
  • Chapter 2: Working with Table Design
  • Chapter 3: Table Relationships and Working With Joins
  • Chapter 4: Working with Calculated Data
  • Chapter 5: Aggregating Data
  • Chapter 6: Creating and Using Views and Friends
  • Chapter 7: Working With Subqueries and Common Table Expressions
  • Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions
  • Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables
  • Appendix A.

Ejemplares similares