The item you selected is unavailable, but we found something similar.

Sams Teach Yourself SQL in 24 Hours (Sams Teach Yourself in 24 Hours) - Picture 1 of 1

Sams Teach Yourself Ser.: Sams Teach Yourself SQL in 24 Hours by Ron D. Plew, Ryan Stephens and Arie D. Jones (2011, Trade Paperback, Revised edition)

Be the first towrite a review.

READ HEAR NOW (15961)
98.9% positive feedback

Price:

$22.62

+ US $5.13 shipping

Estimated delivery Mon, Apr 29 - Wed, May 1

Returns:

30 days returns. Buyer pays for return shipping.

Condition:

Brand New

Publisher: Sams. Condition: New. Author: Stephens, Ryan K.; Plew, Ronald R.; Jones, Arie. Qty Available: 1.

About this product

Product Information

In just 24 sessions of one hour or less, you'll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you'll learn hands-on through practical examples. Each lesson builds on what you've already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server! Step-by-step instructions carefully walk you through the most common SQL tasks. Quizzes and Exercises at the end of each chapter help you test your knowledge. By the Way notes present interesting information related to the discussion. Did You Know? tips offer advice or show you easier ways to perform tasks. Watch Out! cautions alert you to possible problems and give you advice on how to avoid them. Learn how to... Understand what SQL is, how it works, and what it does Define efficient database structures and objects "Normalize" raw databases into logically organized tables Edit relational data and tables with DML Manage database transactions Write effective, well-performing queries Categorize, summarize, sort, group, and restructure data Work with dates and times Join tables in queries, use subqueries, and combine multiple queries Master powerful query optimization techniques Administer databases and manage users Implement effective database security Use views, synonyms, and the system catalog Extend SQL to the enterprise and Internet Master important Oracle and Microsoft SQL Server extensions to ANSI SQL

Product Identifiers

Publisher
Pearson Education
ISBN-10
0672335417
ISBN-13
9780672335419
eBay Product ID (ePID)
99675588

Product Key Features

Author
Arie D. Jones, Ron D. Plew, Ryan Stephens
Publication Name
Sams Teach Yourself Sql in 24h
Format
Trade Paperback
Language
English
Features
Revised
Publication Year
2011
Series
Sams Teach Yourself Ser.
Type
Textbook
Number of Pages
99998 Pages

Dimensions

Item Length
9in
Item Height
1.2in
Item Width
6.9in
Item Weight
26.9 Oz

Additional Product Features

Lc Classification Number
Qa76.73.S67p554 2011
Edition Description
Revised Edition
Edition Number
5
Table of Content
Part I: An SQL Concepts Overview HOUR 1: Welcome to the World of SQL 1 SQL Definition and History 1 SQL Sessions 8 Types of SQL Commands 9 The Database Used in This Book 12 Summary 17 Q&A 17 Workshop 18 Part II: Building Your Database HOUR 2: Defining Data Structures 21 What Is Data? 21 Basic Data Types 22 Summary 31 Q&A 31 Workshop 32 HOUR 3: Managing Database Objects 37 What Are Database Objects? 37 What Is a Schema? 37 Tables: The Primary Storage for Data 39 Integrity Constraints 49 Summary 54 Q&A 55 Workshop 55 HOUR 4: The Normalization Process 61 Normalizing a Database 61 Denormalizing a Database 69 Summary 70 Q&A 70 Workshop 71 HOUR 5: Manipulating Data 73 Overview of Data Manipulation 73 Populating Tables with New Data 74 Updating Existing Data 80 Deleting Data from Tables 82 Summary 83 Q&A 83 Workshop 84 HOUR 6: Managing Database Transactions 87 What Is a Transaction? 87 Controlling Transactions 88 Transactional Control and Database Performance 95 Summary 96 Q&A 96 Workshop 97 Part III: Getting Effective Results from Queries HOUR 7: Introduction to the Database Query 99 What Is a Query? 99 Introduction to the SELECT Statement 99 Examples of Simple Queries 108 Summary 112 Q&A 112 Workshop 113 HOUR 8: Using Operators to Categorize Data 115 What Is an Operator in SQL? 115 Comparison Operators 116 Logical Operators 119 Conjunctive Operators 126 Negative Operators 129 Arithmetic Operators 133 Summary 136 Q&A 137 Workshop 137 HOUR 9: Summarizing Data Results from a Query 141 What Are Aggregate Functions? 141 Summary 150 Q&A 150 Workshop 150 HOUR 10: Sorting and Grouping Data 153 Why Group Data? 153 The GROUP BY Clause 154 GROUP BY Versus ORDER BY 159 CUBE and ROLLUP Expressions 161 The HAVING Clause 164 Summary 165 Q&A 166 Workshop 166 HOUR 11: Restructuring the Appearance of Data 169 ANSI Character Functions 169 Common Character Functions 170 Miscellaneous Character Functions 179 Mathematical Functions 183 Conversion Functions 183 Combining Character Functions 186 Summary 187 Q&A 188 Workshop 188 HOUR 12: Understanding Dates and Times 191 How Is a Date Stored? 191 Date Functions 193 Date Conversions 198 Summary 204 Q&A 204 Workshop 205 Part IV: Building Sophisticated Database Queries HOUR 13: Joining Tables in Queries 207 Selecting Data from Multiple Tables 207 Understanding Joins 208 Join Considerations 217 Summary 221 Q&A 222 Workshop 222 HOUR 14: Using Subqueries to Define Unknown Data 225 What Is a Subquery? 225 Embedded Subqueries 231 Correlated Subqueries 233 Subquery Performance 234 Summary 235 Q&A 235 Workshop 236 HOUR 15: Combining Multiple Queries into One 239 Single Queries Versus Compound Queries 239 Compound Query Operators 240 Using ORDER BY with a Compound Query 246 Using GROUP BY with a Compound Query 248 Retrieving Accurate Data 250 Summary 250 Q&A 250 Workshop 251 Part V: SQL Performance Tuning HOUR 16: Using Indexes to Improve Performance 255 What Is an Index? 255 How Do Indexes Work? 256 The CREATE INDEX Command 257 Types of Indexes 258 When Should Indexes Be Considered? 260 When Should Indexes Be Avoided? 261 Altering an Index 263 Dropping an Index 263 Summary 264 Q&A 264 Workshop 265 HOUR 17: Improving Database Performance 267
Copyright Date
2011
Target Audience
Trade
Topic
Programming Languages / Sql, Databases / General
Lccn
2011-011148
Dewey Decimal
005.75/65
Dewey Edition
22
Illustrated
Yes
Genre
Computers

All listings for this product

item 1 Sams Teach Yourself SQL in 24 Hours; Sam- paperback, 0672335417, Ryan K Stephens
$4.47
Free shipping
item 2 Sams Teach Yourself SQL in 24 Hours (5th Edition) - Paperback - GOOD
$4.48
Last oneFree shipping
item 3 Sams Teach Yourself SQL in 24 Hours (5th Edition) - Paperback - VERY GOOD
$4.48
Free shipping
item 4 Sams Teach Yourself SQL in 24 Hours Ron D., Stephens, Ryan, Jones
$6.03
Free shipping
item 5 Sams Teach Yourself SQL in 24 Hours Ron D., Stephens, Ryan, Jones
$6.03
Free shipping
item 6 Sams Teach Yourself SQL in 24 Hours by Stephens, Ryan; Plew, Ron; Jones, Arie D.
$6.18
Free shipping
item 7 Sams Teach Yourself SQL in 24 Hours by Stephens, Ryan; Plew, Ron; Jones, Arie D.
$6.18
Free shipping

See all 13

Best Selling in Textbooks

See all

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
5.0 out of 5 stars based on 6 product ratings
$11.86 New
---- Used
Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)
5.0 out of 5 stars based on 14 product ratings
$33.00 New
---- Used
Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
4.6 out of 5 stars based on 15 product ratings
$34.89 New
$34.00 Used
PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)
4.9 out of 5 stars based on 7 product ratings
$17.42 New
$14.99 Used
Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)
5.0 out of 5 stars based on 4 product ratings
$18.95 New
$17.66 Used
Applications of Motivational Interviewing Ser.: Motivational Interviewing : Helping People Change and Grow by Stephen Rollnick and William R. Miller (2023, Hardcover)
4.0 out of 5 stars based on 1 product rating
$26.25 New
$17.89 Used
NFPA 70® Handbook with Tabs : 2023 Edition by National Fire Protection Association (NFPA) (2022, Hardcover)
No ratings or reviews yet
$59.50 New
---- Used

Save on Textbooks

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR w/ PAGE TABLE
$30.00
Trending at $39.07
PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov
$17.42
Trending at $34.20
usa stock Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)
$19.90
Trending at $21.00
NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA
$59.50
Trending at $67.45
Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New
$15.00
Trending at $18.95
Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...
$41.45
Trending at $43.95

Shop by category

Sams Teach Yourself Ser.: Sams Teach Yourself SQL in 24 Hours by Ron D. Plew, Ryan Stephens and Arie D. Jones (2011, Trade Paperback, Revised edition)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

All listings for this product

item 1 Sams Teach Yourself SQL in 24 Hours; Sam- paperback, 0672335417, Ryan K Stephens

item 2 Sams Teach Yourself SQL in 24 Hours (5th Edition) - Paperback - GOOD

item 3 Sams Teach Yourself SQL in 24 Hours (5th Edition) - Paperback - VERY GOOD

item 4 Sams Teach Yourself SQL in 24 Hours Ron D., Stephens, Ryan, Jones

item 5 Sams Teach Yourself SQL in 24 Hours Ron D., Stephens, Ryan, Jones

item 6 Sams Teach Yourself SQL in 24 Hours by Stephens, Ryan; Plew, Ron; Jones, Arie D.

item 7 Sams Teach Yourself SQL in 24 Hours by Stephens, Ryan; Plew, Ron; Jones, Arie D.

Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)

Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)

Applications of Motivational Interviewing Ser.: Motivational Interviewing : Helping People Change and Grow by Stephen Rollnick and William R. Miller (2023, Hardcover)

NFPA 70® Handbook with Tabs : 2023 Edition by National Fire Protection Association (NFPA) (2022, Hardcover)

Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR w/ PAGE TABLE

PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov

usa stock Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)

NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA

Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New

Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...

You may also like

Teaching Paperback Textbooks

Nonfiction Teaching Paperbacks Books

Nonfiction Do-It-Yourself Paperbacks Books

Nonfiction Do-It-Yourself Illustrated Paperbacks Books

Teaching Textbooks

Teaching Textbook Textbooks