Head first SQL
Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head Fir...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media
2007.
|
| Edición: | 1st edition |
| Colección: | Head first series
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627031906719 |
Tabla de Contenidos:
- Table of Contents; How to use this book: Intro; Who is this book for?; We know what you're thinking.; And we know what your brain is thinking.; Metacognition: thinking about thinking; Here's what WE did:; Here's what YOU can do to bend your brain into submission; Read me; The technical review team; Acknowledgments; Safari® Books Online; Chapter 1. Data and Tables: A place for everything; Defining your data; Look at your data in categories; What's in a database?; Databases contain connected data; Take command!; Setting the table: the CREATE TABLE statement; Creating a more complicated table
- Look how easy it is to write SQLCreate the my contacts table, finally; Your table is ready; Take a meeting with some data types; Your table, DESCribed; Out with the old table, in with the new; To add data to your table, you'll use the INSERT statement; Create the INSERT statement; Variations on an INSERT statement; Columns without values; Peek at your table with the SELECT statement; Controlling your inner NULL; NOT NULL appears in DESC; Fill in the blanks with DEFAULT; Tablecross; Your SQL Toolbox; DataAndTablescross Solution; Chapter 2. The SELECT Statement: Gifted data retrieval
- Date or no date?Making contact; A better SELECT; What the * is that?; How to query your data types; More punctuation problems; Unmatched single quotes; Single quotes are special characters; INSERT data with single quotes in it; SELECT specific data; SELECT specific columns to limit results; SELECT specific columns for faster results; Doughnut ask what your table can do for you...; Ask what you can do for your doughnut; Combining your queries; Finding numeric values; Once is enough; Comparison Operators; Finding numeric data with Comparison Operators; Text data roping with Comparison Operators
- Selecting your ingredientsTo be OR not to be; The difference between AND and OR; Use IS NULL to find NULLs; Meanwhile, back at Greg's place...; Saving time with a single keyword: LIKE; That's more LIKE it; Selecting ranges using AND and comparison operators; Just BETWEEN us... there's a better way; After the dates, you are either IN...; ... or you are NOT IN; More NOT; Your SQL Toolbox; Chapter 3. DELETE and UPDATE: A change will do you good; Clowns are scary; Clown tracking; How our clown data gets entered; Bonzo, we've got a problem; Getting rid of a record with DELETE
- Using our new DELETE statementDELETE rules; The INSERT-DELETE two step; Be careful with your DELETE; The trouble with imprecise DELETE; Change your data with UPDATE; UPDATE rules; UPDATE is the new INSERT-DELETE; UPDATE in action; UPDATE your prices; All we need is one UPDATE; Your SQL Toolbox; Chapter 4. Smart Table Design: Why be normal?; Two fishy tables; A table is all about relationships; Atomic data; Atomic data and your tables; Reasons to be normal; The benefits of normal tables; Clowns aren't normal; Halfway to 1NF; PRIMARY KEY rules; Fixing Greg's table; The CREATE TABLE we wrote
- Show me the table
