Discovering SQL a hands-on guide for beginners
Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley
2011.
|
| Edición: | 1st edition |
| Colección: | Wrox beginning guides.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628896906719 |
Tabla de Contenidos:
- Discovering SQL; CONTENTS; INTRODUCTION; CHAPTER 1: DROWNING IN DATA, DYING OF THIRST FOR KNOWLEDGE; Data Deluge and Informational Overload; Database Management Systems (DBMSs); Storage Capacity; Number of Users; Security; Performance; Scalability; Costs; Recording Data; Oral Records; Pictures; Written Records; Printed Word; All of the Above; Analog versus Digital Data; To Store or Not to Store?; Relational Database Management Systems; IBM DB2 LUW; Oracle; Microsoft SQL Server; Microsoft Access; PostgreSQL; MySQL; HSQLDB and OpenOffice BASE; What Is SQL?; The SQL Standard; Dialects of SQL
- Not the Only Game in TownLet There Be Database!; Creating a Table; Getting the Data In: INSERT Statement; Give Me the World: SELECT Statement; Good Riddance: the DELETE Statement; I Can Fix That: the UPDATE Statement; Summary; CHAPTER 2: BREAKING AND ENTERING: STRUCTURED INFORMATION; A Really Brief Introduction to Data Modeling; Conceptual Modeling; Logical Modeling; Physical Modeling; Why Can't Everything Be Text?; Character Data; Fixed Length and Variable Strings; Binary Strings; Character versus Special Files; Numeric Data; Exact Numbers; Approximate Numbers; Literals for the Number
- Once Upon a Time: Date and Time Data TypesBinary Data; It's a Bird, It's a Plane, It's ... a NULL!; Much Ado About Nothing; None of the Above: More Data Types; BOOLEAN; BIT; XML Data Type; DDL, DML, and DQL: Components of SQL; Refactoring Database TABLE; DROP TABLE; CREATE TABLE; ALTER TABLE; Populating a Table with Different Data Types; Implicit and Explicit Data Conversion; SELECT Statement Revisited; Selecting Literals, Functions, and Calculated Columns; Setting Vertical Limits; Alias: What's in a Name?; Setting Horizontal Limits; DISTINCT; Get Organized: Marching Orders; ORDER BY
- ASC and DESCTOP and LIMIT; INSERT, UPDATE, and DELETE Revisited; INSERT; SELECT INTO; UPDATE; DELETE; TRUNCATE That Table!; SQL Operators: Agents of Change; Arithmetic and String Concatenation Operators; Comparison Operators; Logical Operators; ALL; ANY | SOME; BETWEEN AND ; IN; EXISTS; LIKE; AND; NOT; OR; Assignment Operator; Bitwise Operators; Operator Precedence; Summary; CHAPTER 3: A THING YOU CAN RELATE TO - DESIGNING A RELATIONAL DATABASE; Entities and Attributes Revisited; Keys to the Kingdom: Primary and Foreign; Relationship Patterns; Domain Integrity
- Am I Normal? Basics of Relational Database DesignSpecifying Constraints; Selecting a Flavor For Your Data Model; Data Warehouses and Data Marts; Star and Snow flake Schemas; What Could and Does Go Wrong; Working with Multiple Tables; JOIN Syntax; UNION Operator; Dynamic SQL; Ultimate Flexibility, Potential Problems; Summary; CHAPTER 4: OVERCOMING THE LIMITATIONS OF SQL; In Numbers, Strength; Building Character; "X" Marks the Spot: Finding the Position of a Character in a String; CHARINDEX; CHAR; SUBSTRING; LENGTH; TRIM, LTRIM, and RTRIM; Date and Time Functions; What Time Is It?
- Date Arithmetic
