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.
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.
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.
- 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
If you've found this repository useful, you might want to check out some of our other workshop titles: