In this book, you learned many things about the SQL programming language and how to use it in MySQL Workbench. This included creating databases, creating and alerting tables, and creating and altering indexes.
You learned how to select data with SQL syntax using the SELECT, WHERE, ORDER BY, JOIN, GROUP BY, and HAVING clauses. We also provided information about the aggregate functions you can use in the GROUP BY clause. You also learned how to modify data with SQL syntax including INSERT, UPDATE, and DELETE. This included how to use SQL transactions to commit and rollback SQL statements.
Then, you learned about advanced query techniques, including how to create and use subqueries, common table expressions, query hints, and transaction isolation level syntax. You learned about programmable objects, including creating and using views, variables, stored procedures, functions...
