Do you want to begin learning SQL [Structured Query Language] from basic? Then this book will surely help you out within 10 minutes!
Introduction
Who is the Teach Yourself SQL Book For?
DBMSs Covered in This Book
Conventions Used in This Book
Chapter 1. Understanding SQL
Database Basics
What Is SQL ?
Try It Yourself
Summary
Chapter 2. Retrieving Data
The SELECT Statement
Retrieving Individual Columns
Retrieving Multiple Columns
Retrieving All Columns
Summary
Chapter 3. Sorting Retrieved Data
Sorting Data
Sorting by Multiple Columns
Sorting by Column Position
Specifying Sort Direction
Summary
Chapter 4. Filtering Data
Using the WHERE Clause
The WHERE Clause Operators
Summary
Chapter 5. Advanced Data Filtering
Combining WHERE Clauses
Using the IN Operator
Using the NOT Operator
Summary
Chapter 6. Using Wildcard Filtering
Using the LIKE Operator
Tips for Using Wildcards
Summary
Chapter 7. Creating Calculated Fields
Understanding Calculated Fields
Concatenating Fields
Performing Mathematical Calculations
Summary
Chapter 8. Using Data Manipulation Functions
Understanding Functions
Using Functions
Summary
Chapter 9. Summarizing Data
Using Aggregate Functions
Aggregates on Distinct Values
Combining Aggregate Functions
Summary
Chapter 10. Grouping Data
Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering
Summary
Chapter 11. Working with Subqueries
Understanding Subqueries
Filtering by Subquery
Using Subqueries As Calculated Fields
Summary
Chapter 12. Joining Tables
Understanding Joins
Creating a Join
Summary
Chapter 13. Creating Advanced Joins
Using Table Aliases
Using Different Join Types
Using Joins with Aggregate Functions
Using Joins and Join Conditions
Summary
Chapter 14. Combining Queries
Understanding Combined Queries
Creating Combined Queries
Summary
Chapter 15. Inserting Data
Understanding Data Insertion
Copying from One Table to Another
Summary
Chapter 16. Updating and Deleting Data
Updating Data
Deleting Data
Guidelines for Updating and Deleting Data
Summary
And many more topics covered in this book [26 Total ]
Ebook : Sams Teach Yourself Sql In 10 Minutes! >>>>> Download Now
ReplyDelete>>>>> Download Full
Ebook : Sams Teach Yourself Sql In 10 Minutes! >>>>> Download LINK
>>>>> Download Now
Ebook : Sams Teach Yourself Sql In 10 Minutes! >>>>> Download Full
>>>>> Download LINK rj