Learning SQL generate, manipulate, and retrieve data
As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative t...
Otros Autores: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Sebastapol, CA :
O'Reilly Media, Inc
2022.
|
Edición: | Third edition |
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631023406719 |
Tabla de Contenidos:
- A little background
- Creating and populating a database
- Query primer
- Filtering
- Querying multiple tables
- Working with sets
- Data generation, manipulation, and conversion
- Grouping and aggregates
- Subqueries
- Joins revisited
- Conditional logic
- Transactions
- Indexes and constraints
- Views
- Metadata
- Analytic functions
- Working with large databases
- SQL and Big Data.