Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learn SQL Database Programming

By : Josephine Bush

4.2 (6)

Learn SQL Database Programming

4.2 (6)

By: Josephine Bush

Overview of this book

SQL is a powerful querying language that's used to store, manipulate, and retrieve data, and it is one of the most popular languages used by developers to query and analyze data efficiently. If you're looking for a comprehensive introduction to SQL, Learn SQL Database Programming will help you to get up to speed with using SQL to streamline your work in no time. Starting with an overview of relational database management systems, this book will show you how to set up and use MySQL Workbench and design a database using practical examples. You'll also discover how to query and manipulate data with SQL programming using MySQL Workbench. As you advance, you’ll create a database, query single and multiple tables, and modify data using SQL querying. This SQL book covers advanced SQL techniques, including aggregate functions, flow control statements, error handling, and subqueries, and helps you process your data to present your findings. Finally, you’ll implement best practices for writing SQL and designing indexes and tables. By the end of this SQL programming book, you’ll have gained the confidence to use SQL queries to retrieve and manipulate data.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Section 1: Database Fundamentals

Section 1: Database Fundamentals

Free Chapter

Introduction to Relational Database Management Systems

Introduction to Relational Database Management Systems

Understanding SQL

Understanding databases

Understanding data integrity

Database normalization

Types of RDMS

Summary

Questions

Installing and Using MySQL Workbench

Installing and Using MySQL Workbench

Technical requirements

Installing MySQL Workbench

Using MySQL Workbench

Restoring a database

Summary

Questions

Understanding Data Types

Understanding Data Types

Understanding string data types

Understanding numeric data types

Understanding date and time data types

Understanding other data types

Choosing the right data type

Summary

Questions

Designing and Creating a Database

Designing and Creating a Database

Technical requirements

Creating a database

Understanding table relationships

Creating a table in the database

Understanding indexes

Summary

Further reading

Questions

Importing and Exporting Data

Importing and Exporting Data

Technical requirements

Understanding table data import and export

Understanding SQL data import and export

Understanding result data export

Understanding SQL syntax for importing and exporting data

Summary

Further reading

Questions

Section 2: Basic SQL Querying

Section 2: Basic SQL Querying

Querying a Single Table

Querying a Single Table

Technical requirements

Using the SELECT statement and FROM clause

Using the WHERE clause

Using the ORDER BY clause

Using indexes with your queries

Summary

Questions

Further reading

Querying Multiple Tables

Querying Multiple Tables

Technical requirements

Understanding joins

Using INNER JOIN

Using OUTER JOIN

Using advanced joins

Understanding set theory

Using indexes with your queries

Summary

Questions

Further reading

Modifying Data and Table Structures

Modifying Data and Table Structures

Technical requirements

Inserting data into tables

Deleting data from tables

Updating data in tables

Using transactions to save or revert changes

Modifying the table structure

Summary

Questions

Further reading

Section 3: Advanced SQL Querying

Section 3: Advanced SQL Querying

Working with Expressions

Working with Expressions

Technical requirements

Using expressions

Using statistical functions

Using generated columns

Summary

Questions

Further reading

Grouping and Summarizing Data

Grouping and Summarizing Data

Technical requirements

Understanding aggregate functions

Using the GROUP BY clause

Using the HAVING clause

Understanding SQL query order of execution

Summary

Questions

Advanced Querying Techniques

Advanced Querying Techniques

Technical requirements

Using subqueries

Using common table expressions

Using query hints and transaction isolation levels

Summary

Questions

Further reading

Programmable Objects

Programmable Objects

Technical requirements

Creating and using views

Creating and using variables

Creating and using stored procedures

Creating and using functions

Creating and using triggers

Creating and using temporary tables

Summary

Questions

Further reading

Section 4: Presenting Your Findings

Section 4: Presenting Your Findings

Exploring and Processing Your Data

Exploring and Processing Your Data

Technical requirements

Exploring your dataset

Processing your dataset

Summary

Questions

Telling a Story with Your Data

Telling a Story with Your Data

Technical requirements

Finding a narrative

Knowing your audience

Determining a presentation framework

Using visualizations

Summary

Questions

Section 5: SQL Best Practices

Section 5: SQL Best Practices

Best Practices for Designing and Querying

Best Practices for Designing and Querying

Technical requirements

Best practices for database design

Best practices for indexing

Best practices for querying and modifying data

Summary

Questions

SQL Appendix

SQL Appendix

SQL for designing databases

SQL for selecting data

SQL for modifying data

SQL expressions

Advanced query techniques

Programmable objects

Summary

Assessments

Assessments

Chapter 1

Chapter 2

Chapter 3

Chapter 4

Chapter 5

Chapter 6

Chapter 7

Chapter 8

Chapter 9

Chapter 10

Chapter 11

Chapter 12

Chapter 13

Chapter 14

Chapter 15

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Using INNER JOIN

If you want to only return records that have matching rows in each table you join, use an INNER JOIN. The syntax of INNER JOIN and examples will be outlined in this section.

Learning INNER JOIN syntax

To inner join two tables, use the following syntax:

SELECT column(s)
FROM table1
INNER JOIN table2
ON table1.column = table2.column
WHERE conditions 
ORDER BY column(s);

The preceding syntax shows you how to join two tables together with an INNER JOIN. You join a column in table1 that matches a column in table2. The WHERE and ORDER BY clauses are optional. They are there to show you that the INNER JOIN syntax goes between the FROM and WHERE clauses.

The following example will help you to understand how to use...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learn SQL Database Programming

Search

Your notes and bookmarks