Learning SQL
SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media
2005.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626955006719 |
Tabla de Contenidos:
- Learning SQL; Why Use This Book to Do It?; Structure of This Book; Conventions Used in This Book; How to Contact Us; Using Code Examples; Safari Enabled; Acknowledgments; 1. A Little Background; 1.1.2. The Relational Model; 1.1.3. Some Terminology; 1.2. What Is SQL?; 1.2.2. SQL: A Nonprocedural Language; 1.2.3. SQL Examples; 1.3. What Is MySQL?; 1.4. What&s in Store; 2. Creating and Populating a Database; 2.2. Using the mysql Command-Line Tool; 2.3. MySQL Data Types; 2.3.1.2. Text data; 2.3.2. Numeric Data; 2.3.3. Temporal Data; 2.4. Table Creation; 2.4.2. Step 2: Refinement
- 2.4.3. Step 3: Building SQL Schema Statements2.5. Populating and Modifying Tables; 2.5.1.2. The insert statement; 2.5.2. Updating Data; 2.5.3. Deleting Data; 2.6. When Good Statements Go Bad; 2.6.2. Nonexistent Foreign Key; 2.6.3. Column Value Violations; 2.6.4. Invalid Date Conversions; 2.7. The Bank Schema; 3. Query Primer; 3.2. Query Clauses; 3.3. The select Clause; 3.3.2. Removing Duplicates; 3.4. The from Clause; 3.4.1.2. Views; 3.4.2. Table Links; 3.4.3. Defining Table Aliases; 3.5. The where Clause; 3.6. The group by and having Clauses; 3.7. The order by Clause
- 3.7.2. Sorting via Expressions3.7.3. Sorting via Numeric Placeholders; 3.8. Exercises; 3.8.2. 3-2; 3.8.3. 3-3; 3.8.4. 3-4; 4. Filtering; 4.1.2. Using the not Operator; 4.2. Building a Condition; 4.3. Condition Types; 4.3.1.2. Data modification using equality conditions; 4.3.2. Range Conditions; 4.3.2.2. String ranges; 4.3.3. Membership Conditions; 4.3.3.2. Using not in; 4.3.4. Matching Conditions; 4.3.4.2. Using regular expressions; 4.4. NULL: That Four-Letter Word; 4.5. Exercises; 4.5.2. 4-2; 4.5.3. 4-3; 4.5.4. 4-4; 5. Querying Multiple Tables; 5.1.2. Inner Joins; 5.1.3. The ANSI Join Syntax
- 5.2. Joining Three or More Tables5.2.2. Using the Same Table Twice; 5.3. Self-Joins; 5.4. Equi-Joins Versus Non-Equi-Joins; 5.5. Join Conditions Versus Filter Conditions; 5.6. Exercises; 5.6.2. 5-2; 5.6.3. 5-3; 6. Working with Sets; 6.2. Set Theory in Practice; 6.3. Set Operators; 6.3.2. The intersect Operator; 6.3.3. The except Operator; 6.4. Set Operation Rules; 6.4.2. Set Operation Precedence; 6.5. Exercises; 6.5.2. 6-2; 6.5.3. 6-3; 7. Data Generation, Conversion, and Manipulation; 7.1.1.2. Including special characters; 7.1.2. String Manipulation
- 7.1.2.2. String functions that return strings7.2. Working with Numeric Data; 7.2.2. Controlling Number Precision; 7.2.3. Handling Signed Data; 7.3. Working with Temporal Data; 7.3.2. Temporal Data Generation; 7.3.2.2. String-to-date conversions; 7.3.2.3. Functions for generating dates; 7.3.3. Temporal Data Manipulation; 7.3.3.2. Temporal functions that return strings; 7.3.3.3. Temporal functions that return numbers; 7.4. Conversion Functions; 7.5. Exercises; 7.5.2. 7-2; 7.5.3. 7-3; 8. Grouping and Aggregates; 8.2. Aggregate Functions; 8.2.2. Counting Distinct Values; 8.2.3. Using Expressions
- 8.2.4. How Nulls Are Handled
