Book description
In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.
This Seventh Edition is thoroughly revised and reorganized for faster learning and a deeper understanding of modern SQL development. Based on standardized SQL throughout, it teaches using new sample code based on the free, easy-to-use Oracle Database Express (XE). You’ll find more hands-on examples than ever, culminating in an all-new Bonus Exercises Workshop with even more real-world practice.
This guide’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, from transactions and joins to complex data retrieval using views and subqueries.
Step-by-step instructions carefully walk you through the most common SQL tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Notes and tips point out shortcuts and solutions.
Learn how to...
* Master core relational database concepts, SQL concepts, and language components
* Clearly understand your data
* Set up databases and plan efficient database designs
* Define entities and relationships, establish data structures, and create database objects
* “Normalize” raw databases into logically organized tables
* Edit relational data and tables and manage 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
* Optimize performance with indexes and other techniques
* Administer databases and manage users
* Secure databases and data
Table of contents
- Cover Page
- About This eBook
- Title Page
- Copyright Page
- Pearson’s Commitment to Diversity, Equity, and Inclusion
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- What This Book Is About
- What You Need for This Book
- Author’s Website
- Hour 1: Understanding the Relational Database and SQL
- Hour 2: Exploring the Components of the SQL Language
- Hour 3: Getting to Know Your Data
- Hour 4: Setting Up Your Database
- Hour 5: Understanding the Basics of Relational (SQL) Database Design
- Hour 6: Defining Entities and Relationships
- Hour 7: Normalizing Your Database
- Hour 8: Defining Data Structures
- Hour 9: Creating and Managing Database Objects
- Hour 10: Manipulating Data
- Hour 11: Managing Database Transactions
- Hour 12: Introduction to Database Queries
- Hour 13: Using Operators to Categorize Data
- Hour 14: Joining Tables in Queries
- Hour 15: Restructuring the Appearance of Data
- Hour 16: Understanding Dates and Times
- Hour 17: Summarizing Data Results from a Query
- Hour 18: Using Subqueries to Define Unknown Data
- Hour 19: Combining Multiple Queries into One
- Hour 20: Creating and Using Views and Synonyms
- Hour 21: Managing Database Users and Security
- Hour 22: Using Indexes to Improve Performance
- Hour 23: Improving Database Performance
- Hour 24: Working with the System Catalog
-
Hour 25: Bonus Workshop for the Road
- The BIRDS Database
- Predators of Birds
- Photographers of Birds
- Creating the New Tables
- Workshop: Describing Your Tables
- Workshop: Basic Queries
- Workshop: Adding Tables
- Workshop: Manipulating Data
- Workshop: Joining Tables
- Workshop: Comparison Operators
- Workshop: Logical Operators
- Workshop: Conjunctive Operators
- Workshop: Arithmetic Operators
- Workshop: Character Functions
- Workshop: Aggregating Data
- Workshop: GROUP BY and HAVING
- Workshop: Composite Queries
- Workshop: Creating Tables from Existing Tables
- Workshop: Inserting Data into a Table from Another Table
- Workshop: Creating Views
- Workshop: Embedding Subqueries
- Workshop: Creating Views from Subqueries
- Workshop: Generating SQL Code from a SQL Statement
- Summary
- Workshop
-
Appendixes
- Appendix A: Common SQL Commands
- Appendix B: Popular Vendor RDBMS Implementations
-
Appendix C: Answers to Quizzes and Exercises
- Hour 1, “Understanding the Relational Database and SQL”
- Hour 2, “Exploring the Components of the SQL Language”
- Hour 3, “Getting to Know Your Data”
- Hour 4, “Setting Up Your Database”
- Hour 5, “Understanding the Basics of Relational (SQL) Database Design”
- Hour 6, “Defining Entities and Relationships”
- Hour 7, “Normalizing Your Database”
- Hour 8, “Defining Data Structures”
- Hour 9, “Creating and Managing Database Objects”
- Hour 10, “Manipulating Data”
- Hour 11, “Managing Database Transactions”
- Hour 12, “Introduction to Database Queries”
- Hour 13, “Using Operators to Categorize Data”
- Hour 14, “Joining Tables in Queries”
- Hour 15, “Restructuring the Appearance of Data”
- Hour 16, “Understanding Dates and Times”
- Hour 17, “Summarizing Data Results from a Query”
- Hour 18, “Using Subqueries to Define Unknown Data”
- Hour 19, “Combining Multiple Queries into One”
- Hour 20, “Creating and Using Views and Synonyms”
- Hour 21, “Managing Database Users and Security”
- Hour 22, “Using Indexes to Improve Performance”
- Hour 23, “Improving Database Performance”
- Hour 24, “Working with the System Catalog”
- Hour 25, “Bonus Workshop for the Road”
- Index
- Code Snippets
Product information
- Title: SQL in 24 Hours, Sams Teach Yourself, 7th Edition
- Author(s):
- Release date: September 2021
- Publisher(s): Sams
- ISBN: 9780137543168
You might also like
book
Intro to Python for Computer Science and Data Science: Learning to Program with AI, Big Data and The Cloud
This is the eBook of the printed book and may not include any media, website access …
book
Clean Code: A Handbook of Agile Software Craftsmanship
Even bad code can function. But if code isn't clean, it can bring a development organization …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
book
Python for Programmers, First Edition
The professional programmer's Deitel® guide to Python® with introductory artificial intelligence case studies Written for programmers …