Book

Learn SQL Database Programming

SQL is a powerful querying language used to store, manipulate, and retrieve data. This is a comprehensive guide for who are new to SQL, which will have you up-to-speed and using SQL to streamline your work in no time. It gives users enough confidence to use SQL queries for retrieving and manipulating data relevant to their work-related tasks.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

18h48m

Language

English

About Book

Who Is This Book For?

This book is for business analysts, SQL developers, database administrators, and students learning SQL. If you want to learn how to query and manipulate SQL data for database administration tasks or simply extract and organize relevant data for analysis, you’ll find this book useful. No prior SQL experience is required.

Book content

chapters 18h48m total length

Introduction to Relational Database Management Systems

Installing and Using MySQL Workbench

Understanding Data Types

Designing and Creating a Database

Importing and Exporting Data

Querying a Single Table

Querying Multiple Tables

Modifying Data and Table Structures

Working with Expressions

Grouping and Summarizing Data

Advanced Querying Techniques

Programmable Objects

Exploring and Processing Your Data

Tell a Story with Your Data

Best Practices for Design and Querying

SQL Appendix

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required