The SQL Workshop

This is the repository for The SQL Workshop, published by Packt. It contains all the supporting project files necessary to work through the course from start to finish.

Requirements and Setup

To get started with the project files, you'll need to install MySQL

Please note that the SCRIPTS directory has two subdirectories

• /MYSQL SCRIPTS
• /SQL SERVER SCRIPTS

Each of these subdirectories has two files. One file builds the appropriate PACKT ONLINE SHOP database structure - tables, columns, relations - for MySQL or SQL Server, and one file inserts MySQL or SQL Server data rows into the appropriate database structure.

About The SQL Workshop

Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. You'll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems.

What you will learn

• Create databases and insert data into them
• Use SQL queries to create, read, update, and delete data
• Maintain data integrity and consistency through normalization
• Customize your basic SQL queries to get the desired output
• Refine your database search using the WHERE and HAVING clauses
• Use joins to fetch data from multiple tables and create custom reports
• Improve web application performance by automating processes
• Secure a database with GRANT and REVOKE privileges

Related Books and Workshops

If you've found this repository useful, you might want to check out some of our other workshop titles:

• MongoDB Fundamentals
• The Applied SQL Data Analytics Workshop
• The Data Analysis Workshop