Querying data using Query Builder yii2 tutorials

In this video we will see how query data using query builder so that our select can be run on multiple relational databases.
We are going also to see how to deal with the problem when framework improperly quotes column names with back ticks which causes SQL syntax error.
The methods explained in the video.
- select()
- from()
- where(), andWhere(), orWhere()
- all(), one(), count(), column(), scalar(), exists()
- limit()
- offset()
- orderBy()
- groupBy()
- having()
Source Code:
https://github.com/thecodeholic/yii2-course/tree/quering-data
Documentation:
https://www.yiiframework.com/doc/guide/2.0/en/db-query-builder
-------------------------------------------------------------------------
Check my other videos about yii2 framework
-------------------------------------------------------------------------
Yii2 Crash course: https://youtu.be/sRJ6GYiCwkI
Building a REST API using yii2: https://youtu.be/XyHHMvRt6Cw
Integrate Landing page into yii2: https://youtu.be/eJBQeRocRac
Getting started with yii2 framework: https://youtu.be/JD5Y-lQNrPs
Migrations: https://youtu.be/V8NFXrr1JNI
Working with DAO: https://youtu.be/zOqUePK-01k
Working with Active Record classes: https://youtu.be/Vid_G04kLp4
Check my Github:
https://github.com/thecodeholic
Follow me on social media:
https://www.facebook.com/thecodeholic
https://twitter.com/thecodeholic