
SQL Queries for Mere Mortals 4ed
L. Viescas (author) John
Résumé
-
Part I: Relational Databases and SQL
-
Chapter 1: What Is Relational?
-
Chapter 2: Ensuring Your Database Structure Is Sound
-
Chapter 3: A Concise History of SQL
-
Part II: SQL Basics
-
Chapter 4: Creating a Simple Query
-
Chapter 5: Getting More Than Simple Columns
-
Chapter 6: Filtering Your Data
-
Part III: Working with Multiple Tables
-
Chapter 7: Thinking in Sets
-
Chapter 8: INNER JOINs
-
Chapter 9: OUTER JOINs
-
Chapter 10: UNIONs
-
Chapter 11: Subqueries
-
Part IV: Summarizing and Grouping Data
-
Chapter 12: Simple Totals
-
Chapter 13: Grouping Data
-
Chapter 14: Filtering Grouped Data
-
Part V: Modifying Sets of Data
-
Chapter 15: Updating Sets of Data
-
Chapter 16: Inserting Sets of Data
-
Chapter 17: Deleting Sets of Data
-
PART VI Introduction to Solving Tough Problems
-
Chapter 18 "NOT" And "AND" Problems
-
Chapter 19 Condition Testing
-
Chapter 20 Using Unlinked Data and "Driver" Tables
-
Chapter 21 Performing Complex Calculations on Groups
-
Chapter 22: More SQL Server Complex Problems to Solve
-
APPENDICES
-
Appendix A: SQL Standard Diagrams
-
Appendix B: Schema for the Sample Databases
-
Appendix C: Date and Time Functions
-
Appendix D: Suggested Reading
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Addison-wesley |
Auteur(s) | L. Viescas (author) John |
Parution | 27/04/2018 |
Nb. de pages | 960 |
Format | 178 x 232 |
Poids | 1502g |
EAN13 | 9780134858333 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse