Murach s MySQL
English | 2019 | ISBN: 1943872368 | 646 Pages | PDF | 94 MB
English | 2019 | ISBN: 1943872368 | 646 Pages | PDF | 94 MB
It shows how to code all the essential SQL statements for working with a MySQL database. You’ll use these statements every day to have MySQL do more of your work for you.
It shows how to use classic MySQL features such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security.
It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security.
It shows how to design a database, including how to use MySQL Workbench to create and implement the design.