Murach s Mysql 3rd Edition by Joel Murach ISBN 9781943872367 1943872368

Murach s Mysql 3rd Edition by Joel Murach – Ebook PDF Instant Download/Delivery: 9781943872367, 1943872368

Full download Murach s Mysql 3rd Edition after payment

 

Product details:

ISBN 10:  1943872368

ISBN 13: 9781943872367

Author: Joel Murach

 This is the latest edition of the book that application developers worldwide have used to master MySQL now updated for MySQL 8 and beyond. As you would expect, this book shows how to code all the essential SQL statements for working with a MySQL database. You will use these statements every day to have MySQL do more of your work for you. But beyond that, it shows how to work with classic MySQL features that take you to new level, 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. It even presents a starting set of skills for a database administrator (DBA) if you are interested in that career path or if you need to be your own DBA. In short, its a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.

Table of contents: 

Section 1: An introduction to MySQL

Chapter 1: An introduction to relational databases

Chapter 2: How to use MySQL Workbench and other development tools

Chapter 3: How to retrieve data from a single table

Chapter 4: How to retrieve data from two or more tables

Chapter 5: How to insert, update, and delete data

Section 2: More SQL skills as you need them

Chapter 6: How to code summary queries

Chapter 7: How to code subqueries

Chapter 8: How to work with data types

Chapter 9: How to use functions

Section 3: Database design and implementation

Chapter 10: How to design a database

Chapter 11: How to create databases, tables, and indexes

Chapter 12: How to create views

Section 4: Stored program development

Chapter 13: Language skills for writing stored programs

Chapter 14: How to use transactions and locking

Chapter 15: How to create stored procedures and functions

Chapter 16: How to create triggers and events

Section 5: Database administration

Chapter 17: An introduction to database administration

Chapter 18: How to secure a database

Chapter 19: How to back up and restore a database

People also search for:

murach mysql
    
murach’s mysql 2nd edition
    
murach’s mysql pdf
    
murach’s mysql 2nd edition pdf
    
murach’s mysql (3rd edition)

 

Tags: Joel Murach, Murach s, MySQL