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.
Overview
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.
Syllabus
- Introduction 20mins
- Manipulating a Database Schema 17mins
- Creating, Updating, and Deleting Records 17mins
- Basic Queries and ResultSet Iteration 23mins
- Using RowGateway and TableGateway for Easy Record Management 24mins
- Hydrating Objects and Paginating Results 12mins
- Writing Reusable and Flexible Queries 9mins
Taught by
Matthew Setter
