| “这本书不是让SQL变得容易，而是让SQL变得有挑战性，变得有趣，变得好玩。本书甚至回答了那个老问题：如何讲解无关联子查询而不会因此失去活下去的愿望？本书是正确的学习途径——快速、活泼、而且看上去很酷。” ——Andrew Cumming，《SQL Hacks》的作者，sqlzoo.net的管理员 “有些书你会买，有些你会保存，有些你会放在案头，感谢O’Reilly和Head First团队开创了终极的Head First（深入浅出）系列。这个系列的书籍会被逐页翻阅，变得皱皱巴巴并被随身携带。《深入浅出SQL》在我的书堆的顶端。” ——Bill Sawyer，ATG培训经理，Oracle 作者介绍：Lynn is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. After going back to school to get a Masters in computer science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. |
| Lynn is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. . After going back to school to get a Masters in computer science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. A victim of bad timing, she moved to Silicon Valley just before the great crash. She spent several .. << 查看详细 |
| intro who is this book for? we know what you’re thinking metacognition bend your brain into submission readmc the technical review team acknowledgments 1 data and tables: a place for everything defining your data look at your data in categories what's in a database? your database viewed through x-ray specs databases contain connected data tables up close take command! setting the table: the create table statement creating a more complicated table look how easy it is to write sql create the mycontacts table, finally . your table is ready take a meeting with some data types your table, described you can't recreate an existing table or database! 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 sql exposed: confessions of a null controlling your inner null not null appears in desc fill in the blanks with default your sql toolbox 2 the select statement: gifted data retrieval date or no date? 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 columns to limit results select specific columns for faster results combining your queries finding numeric values smcomparison operators finding numeric data with comparison operators text data roping with comparison operators to be or not to be the difference between and and or use is null to find nulls saving time with a single keyword: like the call of the wild(card) 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 3 delete and update: a change will do you good clowns are scary clown tracking the clowns are on the move how our clown data gets entered bonzo, we've got a problem getting rid of a record with delete using our new delete statement delete 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 updating the clowns' movements update your prices all we need is one update your sql tbolbox 4 smart table design: why be normal? two fishy tables a table is all about relationships atomic data atomic data and your tables atomic data rules reasons to be normal the benefits of normal tables clowns aren't normal halfway to 1nf primary key rules getting to normal fixing greg's table the create table we wrote show me the time-saving command the create table with a primary key 1, 2, 3... auto incrementally adding a primary key to an existing table alter table and add a primary key your sql toolbox 5 alter: rewriting the past 6 advanced select: seeing your data with new eyes 7 multi-table database design: outgrowing your table 8 joins and multi-table operations: can’t we all just get along? 9 subqueries: queries within queries 10 outer joins, self joins, and unions: new maneuvers 11 constraints, views, and transactions: too many cooks spoil the database 12 security: protecting your assets |
内容加载中，请稍后...
商品评论（0条）