SQL quickstart guide : the simplified beginner's guide to managing, analyzing, and manipulating data with SQL / Walter Shields
Book | Clydebank Media | 2019
Not Available at Gateway-Racine Campus New Books Display (DUE 12-18-20)

Additional actions:

More Details

Description
249 pages : illustrations ; 23 cm.
Series
Note
Includes index.
Contents
INTRODUCTION
My Story -- Why I Wrote This Book -- A Word of Encouragement for the Pure Beginner -- The Scope and Focus of This Book -- SQL and Your Career -- Chapter by Chapter
PART I: CREATING YOUR SQL LEARNING ENVIRONMENT
1. UNDERSTANDING DATABASE STRUCTURE
Fundamental Terminology -- Fundamental Elements of Relational Databases -- Types of Data -- Relational Database Management Systems -- The SELECT Statement -- Queries, Statements, Clauses, and Keywords -- Introducing SQLite
2. SQL TOOLS AND STRATEGIES
Introducing the sTunes Database -- Introducing DB Browser for SQLite -- Installing DB Browser for SQLite -- How to Test Your SQL Knowledge -- Strategies for Success
3. EXPLORING A DATABASE IN SQLITE
Environment Orientation -- Opening the sTunes Database -- Investigating the Structure of the Database -- Viewing the Individual Records -- The Execute SQL Tab -- Data Analysis Checkpoint
PART II: WRITING SQL STATEMENTS
4. GETTING STARTED WITH QUERIES
Adding Comments to Queries -- The Structure of a Basic Query -- Start Writing Your Query -- Coding Syntax Versus Coding Convention -- Adding an Alias to Your Columns -- Using the 'ORDER BY' Clause -- Selecting the Top Ten Records Using LIMIT -- Data Analysis Checkpoint
5. TURNING DATA INTO INFORMATION
Comparison, Logical, and Arithmetic Operators -- Filtering Records by Numbers with the WHERE Clause -- Filtering Records by Text -- Using the LIKE Operator to Search for Wildcards -- Filtering Records by Date -- The DATE () Function -- Using the AND and OR Operators with Two Separate Fields -- The OR Operator -- Using Parentheses with AND and OR to Specify the Order of Operations -- The CASE Statement -- Data Analysis Checkpoint
6. WORKING WITH MULTIPLE TABLES
What Are Joins? -- How Joins Interact with Relational Database Structure -- Using Joins with an Alias -- Join Types and Their Differences -- Inner Joins with More Than Two Tables -- Using Left Outer Joins with NULL, IS, and NOT -- Turning a Right Join into a Left Join -- Data Analysis Checkpoint
7. USING FUNCTIONS
Adding Calculations to Your Queries -- Types of Functions in SQL -- Manipulating Text Data with String Functions -- Concatenating Strings of Text -- Truncating Text -- Additional String Functions -- Date Functions -- Aggregate Functions -- Nesting Functions with the ROUND () Function -- Using Aggregate Functions with the GROUP BY Clause -- Using the WHERE and HAVING Clauses with Grouped Queries -- The WHERE Clause Versus the HAVING Clause -- Using GROUP BY with Multiple Fields -- A Final Word on Functions -- Data Analysis Checkpoint
PART III: MORE ADVANCED SQL TOPICS
8. SUBQUERIES
Introduction to Subqueries Using Aggregate Functions -- Using a Subquery in the SELECT Statement -- Using a WHERE Clause in a Subquery -- Subqueries without Aggregate Functions -- Returning Multiple Values from a Subquery -- Subqueries and the DISTINCT Clause -- Data Analysis Checkpoint
9. VIEWS
Turning Previous Queries into Views -- Why We Use Views -- How to Modify a View -- Creating a View from Joins -- Removing a View Using the DROP Statement -- Data Analysis Checkpoint
10. DATA MANIPULATION LANGUAGE (DML)
Data Analysis Versus Database Management -- Inserting Data into a Database -- Updating Data and the SET Keyword -- Deleting Data -- Data Analysis Checkpoint
CONCLUSION
It Is All About Asking Good Questions -- Finding Your Niche -- Choosing the Right Database Occupation -- Is It All About the Money? -- Is SQL Knowledge Universal? -- Switching Careers -- Selling Your New Skills to Your Company -- Beyond SQL: Data Visualization Software -- Interview Advice -- SQL Certifications -- Final Thoughts and Parting Words
Summary
What does an overwhelming wealth of data and information have in common with one of today's fastest-growing career paths? Structured Query Language (SQL) is the answer. Pronounced "sequel" by many, SQL is the workhorse programming language that forms the backbone of modern data management and interpretation. With more data being produced every second than you could interpret in your lifetime, the ability of businesses to warehouse, access, and, most importantly, understand and interpret this data has never been more critical. Despite trendy data management languages that come and go, SQL remains the most widely used and most reliable to date. In 'SQL QuickStart Guide', experienced mentor and SQL expert Walter Shields draws on his considerable knowledge to make the topic of relational database management accessible, easy to understand, and actionable. This book is ideal for those seeking to increase their job prospects and enhance their careers, for developers looking to expand their programming capabilities, or for anyone who wants to take advantage of our data-driven future - even with no prior coding experience!
24.00 (10-156-3)
Subject
Other Sources:
View in classic catalog View MARC display
Back to top