Book Image

Learn SQL Database Programming

By : Josephine Bush

5 (1)

Book Image

Learn SQL Database Programming

5 (1)

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

Who this book is for

What this book covers

To get the most out of this book

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

Installing and Using MySQL Workbench

Installing and Using MySQL Workbench

Technical requirements

Installing MySQL Workbench

Using MySQL Workbench

Restoring a database

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

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

Further reading

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

Further reading

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

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

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

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

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

Advanced Querying Techniques

Advanced Querying Techniques

Technical requirements

Using subqueries

Using common table expressions

Using query hints and transaction isolation levels

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

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

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

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

SQL Appendix

SQL for designing databases

SQL for selecting data

SQL for modifying data

SQL expressions

Advanced query techniques

Programmable objects

Assessments

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 (1)

5 star

100%

4 star

0

3 star

0

2 star

0

1 star

0

Creating a database

In Chapter 1, Introduction to Relational Database Management Systems, we learned what a database is and its essential parts, such as tables, columns, rows, and fields. In this section, we will learn how to create a database. We'll also go through the guidelines for naming conventions and discuss SQL code errors.

Guidelines for naming conventions

Naming conventions are essential for multiple reasons. You must ensure that you name things accurately and descriptively, but, at the same time, avoid keywords that will create confusion. You should avoid spaces, choose the proper case, and stick to one convention. You should make sure that you use only permitted characters when naming a database object. Each...