SQL QuickStart Guide, Edition 2019 (PDF)

✔️Immediate download 

✔️Highlighting, editing, saving and printing are available 

✔️The same content as in a hardcover book 

✔️Search for words within the text 

✔️For any PDF file viewers and devices 

How to download

Register on this website and pay for your selected book.

After you have paid, go to "My Account"-"Downloads" section. There you will see a PDF file. Download and open it. It contains a link to download your book. Click on the link and download your book.

You can send us a message that you want to receive the book to your e-mail, and a link to download the book will also be sent to your e-mail.

About the book:

Publisher: ClydeBank Media LLC

Author (s): Walter Shields

Pages: 350

Edition: 2019

Language: English

Size: 16Mb

Content:

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

APPENDIX I

Chapter 3 Data Analysis Checkpoint

Chapter 4 Data Analysis Checkpoint

Chapter 5 Data Analysis Checkpoint

Chapter 6 Data Analysis Checkpoint

Chapter 7 Data Analysis Checkpoint

Chapter 8 Data Analysis Checkpoint

Chapter 9 Data Analysis Checkpoint

Chapter 10 Data Analysis Checkpoint

APPENDIX II

Chapter 4 Keywords

Chapter 5 Keywords

Chapter 6 Keywords

Chapter 7 Keywords

Chapter 8 Keywords

Chapter 9 Keywords

Chapter 10 Keywords

WHAT DID YOU THINK?

ABOUT THE AUTHOR

ABOUT CLYDEBANK MEDIA

GLOSSARY

REFERENCES

Tags: SQL QuickStart Guide pdf download, SQL QuickStart Guide online pdf, SQL QuickStart Guide for beginners