Books by 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.

C++ was first released in 1985, and it was a hard language to learn. That's because it required programmers to master low-level techniques to work with memory. Over the years, C++ has evolved to provide many higher-level techniques that make it much easier to write effective C++ code. But most C++ books haven't evolved with the language. Now, Murach's top authors have tackled the subject, rethinking the whole approach. So this book takes advantage of the modern techniques to make it easier to learn C++ than ever before. It's organized in a logical way that gets you off to a fast start with a practical subset of today's C++, and then builds out your coding and OOP skills to the professional level. With that foundation in place, it also covers older techniques so you'll be able to maintain the vast amount of legacy code that's out there, as well as work with embedded systems that don't support the newer techniques. To make all that manageable, this book uses Murach's distinctive "paired-pages" format that programmers find so helpful for both training and reference: Each topic is presented in a 2-page spread, with syntax, coding examples, and bulleted guidelines on the righthand page and extra explanation and perspective on the left. What's more, this book gives you 50+ realistic program examples to study, as well as practice exercises for hands-on experience. Examples and exercises like these are the key to learning any programming language. But you'll have a hard time finding such effective ones in other books and courses, that deliver the skills ours do.

If you want to learn how to program but do not know where to start, this is the right book and the right language for you. From the first page, our unique self-paced approach will help you build competence and confidence in your programming skills. And Python is the best language ever for learning how to program because of its simplicity and breadth two features that are hard to find in a single language. But this is not just a book for newbies! Our self-paced approach also works for experienced programmers, helping you learn faster and better than you have ever learned a language before. By the time you are through, you will have mastered all of the Python skills that are needed on the job, including those for object-oriented, database, and GUI programming. To make all of this possible, section 1 of this book presents an 8-chapter course that will get anyone off to a great start. Section 2 builds on that base by presenting the other essential skills that every Python programmer should have. Section 3 shows you how to develop object-oriented programs, a critical skillset in todays world. And section 4 shows you how to apply all of the skills that you have already learned as you build database and GUI programs for the real world.