Mostrando las entradas con la etiqueta DML. Mostrar todas las entradas
Mostrando las entradas con la etiqueta DML. Mostrar todas las entradas

martes, 15 de diciembre de 2015

El Libro del Día: Introducing SQL Server

El Libro del Día: 2015-12-15

Titulo: Introducing SQL Server
Autor: Mike McQuillan
Editorial: Apress
Nro Paginas: 397

Capítulos:
Chapter 1: What Is SQL Server
Chapter 2: Obtaining and Installing SQL Server
Chapter 3: Database Basics
Chapter 4: Tables
Chapter 5: Putting Good Tables Together
Chapter 6: Automating Deployment with SQLCMD
Chapter 7: NULLs and Table Constraints
Chapter 8: DML (or Inserts, Updates, and Deletes)
Chapter 9: Bulk Inserting Data
Chapter 10: Creating Data Import Scripts
Chapter 11: The SELECT Statement
Chapter 12: Joining Tables
Chapter 13: Views
Chapter 14: Indexes
Chapter 15: Transactions
Chapter 16: Functions
Chapter 17: Table-Valued Functions
Chapter 18: Stored Procedures Part 1
Chapter 19: Stored Procedures Part 2
Chapter 20: Bits and Pieces
Appendix A: SQL Data Types
Appendix B: Glossary
Appendix C: Common SQL Server System Objects
Appendix D: Exercises

Descarga:
Introducing_SQL_Server

miércoles, 16 de julio de 2014

El Libro del Día: Oracle PL/SQL Programming

El Libro del Día: 2014-07-16

Titulo: Oracle PL/SQL Programming (6th Edition)
Autor: Steven Feuerstein
Editorial: O'Reilly
Nro Paginas: 1382

Capítulos:
Part I. Programming in PL/SQL
1. Introduction to PL/SQL
2. Creating and Running PL/SQL Code
3. Language Fundamentals
Part II. PL/SQL Program Structure
4. Conditional and Sequential Control
5. Iterative Processing with Loops
6. Exception Handlers
Part III. PL/SQL Program Data
7. Working with Program Data
8. Strings
9. Numbers
10. Dates and Timestamps
11. Records
12. Collections
13. Miscellaneous Datatypes
Part IV. SQL in PL/SQL
14. DML and Transaction Management
15. Data Retrieval
16. Dynamic SQL and Dynamic PL/SQL
Part V. PL/SQL Application Construction
17. Procedures, Functions, and Parameters
18. Packages
19. Triggers
20. Managing PL/SQL Code
21. Optimizing PL/SQL Performance
22. I/O and PL/SQL
Part VI. Advanced PL/SQL Topics
23. Application Security and PL/SQL
24. PL/SQL Architecture
25. Globalization and Localization in PL/SQL
26. Object-Oriented Aspects of PL/SQL
27. Calling Java from PL/SQL
28. External Procedures
A. Regular Expression Metacharacters and Function Parameters
B. Number Format Models
C. Date Format Models

Descarga:
Oracle_PLSQL_Programming