Learning SQL : generate, manipulate, and retrieve data / Alan Beaulieu.
Tipo de material:
TextoProductor: California : Distribuidor: O'Reilly Media, Fecha de copyright: ©2020Edición: tercera ediciónDescripción: xvi, 360 paginas : ilustraciones, tablas ; 24 x 17 cmTipo de contenido: - texto
- sin medio
- volume
- 9781492057611
- QA 76.73.S67 B43 2020
| Tipo de ítem | Biblioteca actual | Biblioteca de origen | Colección | Signatura topográfica | Copia número | Estado | Notas | Fecha de vencimiento | Código de barras | Reserva de ítems | |
|---|---|---|---|---|---|---|---|---|---|---|---|
Libros para consulta en sala
|
Biblioteca Antonio Enriquez Savignac | Biblioteca Antonio Enriquez Savignac | COLECCIÓN RESERVA | QA 76.73.S67 B43 2020 (Navegar estantería(Abre debajo)) | Ejem. 1 | No para préstamo (Préstamo interno) | Ingeniería en Datos e Inteligencia Organizacional | 042645 | |||
Libros
|
Biblioteca Antonio Enriquez Savignac | Biblioteca Antonio Enriquez Savignac | Colección General | QA 76.73.S67 B43 2020 (Navegar estantería(Abre debajo)) | Ejem. 2 | Disponible | Ingeniería en Datos e Inteligencia Organizacional | 042646 |
Incluye tabla de contenido (iii-xvi)
Incluye indice [p. 349-360]
Preface xi.--1. A Little Background.--2. Creating and Populating a Database.--3. Query Primer.--4. Filtering.--5. Querying Multiple Tables.--6. Working with Sets.--7. Data Generation, Manipulation, and Conversion.--8. Grouping and Aggregates.--9. Subqueries.--10. Joins Revisited.--11. Conditional Logic.--12. Transactions.--13. Index and Constraints.--14. Views.--15. Metadata.--16. Analytic Functions.-- 17. Working with Large Databases.--18. SQL and Big 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 tasks, and generating reports. You’ll find new chapters on analytic functions, strategies for working with large databases, and SQL and big data.
Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work.
Move quickly through SQL basics and several advanced features, use SQL data statements to generate, manipulate, and retrieve data, create database objects such as tables, indexes, and constraints with SQL schema statements, learn how data sets interact with queries; understand the importance of subqueries, convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements.
Haga clic en una imagen para verla en el visor de imágenes
