Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Core Tech

Zend Db Deep Dive

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.

Matthew Setter - Pluralsight course - Zend Db Deep Dive
by Matthew Setter

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.

Table of contents

About the author

Matthew Setter - Pluralsight course - Zend Db Deep Dive
Matthew Setter

Matthew Setter is a freelance software developer, with over 10 years development experience, specializing in PHP, Zend Framework, and JavaScript. He's also a freelance technical writer, founder, and editor of Master Zend Framework, which is dedicated to helping developers master Zend Framework.

More Courses by Matthew