Expanded Library

Zend Db Deep Dive

by Matthew Setter

SQL is an essential skill in developing modern web applications. This course will teach you how to generate SQL for manipulating schemas and extracting data in an object-oriented, nearly hassle-free manner using the Zend\Db library.

What you'll learn

Modern web applications demand that developers know how to write and maintain SQL queries. Whether you need to make database schema changes or run reports to satisfy management, SQL is the tool that is most often required. In this course, Zend/Db Deep Dive, you will learn how to generate SQL whether for manipulating schemas or searching and extracting data, in an object-oriented, low-hassle manner using the Zend\Db library. You'll start with an introduction to Zend/Db, a SQL refresher, and how to make database connections. You will go over some of the create, update, and delete operations for schemas objects and records. You will also get to see how to make record manipulation simpler and more robust by getting to know two essential data access patterns: RowGateway and TableGateway. You will also learn how to run existing, handwritten SQL queries. By the end of this course, you will be familiar with both the fundamentals as well as some of the most advanced aspects of the library, you'll know how to create easily maintainable and reusable code. Software required: PHP and a good editor or IDE.

About the author

Matthew Setter is a freelance software developer, with over 10 years development experience, across three countries, and a range of industries. He specializes in a range of technologies, primarily: PHP, Zend Framework, and JavaScript. He's also a freelance technical writer, regularly creating technical blog posts, deep-dive reports, and video tutorials to help other developers learn and hone their craft. In addition to these two specialties, he is also the founder and editor of Master Zend Frame... more

Ready to upskill? Get started