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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT posts.ID, posts.post_title | |
| FROM wp_posts AS posts | |
| WHERE posts.post_type = 'post' AND posts.post_status = 'publish'; |
Code. Eat. Code. Sleep. Dream about Code. Code.
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
