Unlock your potential with a Pro Membership
Here is where you propel your career forward. Come join us today. Learn more.
Table Alias with AS
Lab: Introduction to Databases
Video Runtime: 05:08
In SQL, you can specify an alias for database tables using the keyword AS
. In this episode, you will use this keyword and see why you want to use it.
SELECT posts.ID, posts.post_title | |
FROM wp_posts AS posts | |
WHERE posts.post_type = 'post' AND posts.post_status = 'publish'; |
There’s a time to code and …. yup, that sums it up.
Episodes
Total Lab Runtime: 02:08:59
- 1 Lab Introductionfree 05:17
- 2 The Big Picturepro 14:35
- 3 Your First SQL Querypro 12:21
- 4 WordPress to Database Relationshippro 20:20
- 5 Filter Content with WHEREpro 08:24
- 6 Table Alias with ASpro 05:08
- 7 Defining Table Structure (Schema)pro 12:17
- 8 Create a New Database Tablepro 10:23
- 9 WordPress Schemapro 05:11
- 10 Exploring WordPress Queries with Query Monitorpro 07:14
- 11 SQL to Get a Custom Fieldpro 16:41
- 12 SQL to Update Custom Fieldpro 05:14
- 13 Wrap it Upfree 05:54