A cheat sheet for you!
","title_cleaned":"sql-cheat-sheet","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5794332,"asset_type":"Article","title":"","created":"2016-04-17T20:02:11Z"},"sort_order":151,"can_be_previewed":false},{"_class":"lecture","id":4656400,"title":"SQL Statement Fundamentals","created":"2016-03-01T21:00:56Z","description":"","title_cleaned":"sql-statement-fundamentals","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":5414610,"asset_type":"Video","title":"sql statement fundamentals.mp4","created":"2016-03-01T21:01:42Z"},"sort_order":150,"can_be_previewed":false},{"_class":"lecture","id":18144838,"title":"SELECT Statement","created":"2020-02-21T19:56:09Z","description":"","title_cleaned":"select-statement","is_published":true,"transcript":"","is_downloadable":false,"is_free":true,"asset":{"_class":"asset","id":22473390,"asset_type":"Video","title":"01-SELECT.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":149,"can_be_previewed":true},{"_class":"lecture","id":18144842,"title":"Challenge: SELECT","created":"2020-02-21T19:56:36Z","description":"","title_cleaned":"challenge-select","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473392,"asset_type":"Video","title":"02-select-challenge.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":148,"can_be_previewed":false},{"_class":"lecture","id":18144846,"title":"SELECT DISTINCT","created":"2020-02-21T19:56:55Z","description":"","title_cleaned":"select-distinct","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22486440,"asset_type":"Video","title":"03-select-distinct-fixed.mp4","created":"2020-02-22T20:41:17Z"},"sort_order":147,"can_be_previewed":false},{"_class":"lecture","id":18144848,"title":"Challenge: SELECT DISTINCT","created":"2020-02-21T19:57:09Z","description":"","title_cleaned":"challenge-select-distinct","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473386,"asset_type":"Video","title":"04-select-distinct-challenge.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":146,"can_be_previewed":false},{"_class":"lecture","id":18144850,"title":"COUNT","created":"2020-02-21T19:57:17Z","description":"","title_cleaned":"count","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22499086,"asset_type":"Video","title":"here-count-fixed.mp4","created":"2020-02-23T18:57:16Z"},"sort_order":145,"can_be_previewed":false},{"_class":"lecture","id":18144854,"title":"SELECT WHERE - Part One","created":"2020-02-21T19:57:30Z","description":"","title_cleaned":"select-where-part-one","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473398,"asset_type":"Video","title":"05-select-where-part-one.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":144,"can_be_previewed":false},{"_class":"lecture","id":18145018,"title":"SELECT WHERE - Part Two","created":"2020-02-21T20:43:15Z","description":"","title_cleaned":"select-where-part-two","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473378,"asset_type":"Video","title":"06-select-where-part-two.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":143,"can_be_previewed":false},{"_class":"lecture","id":18145020,"title":"Challenge: SELECT WHERE","created":"2020-02-21T20:43:28Z","description":"","title_cleaned":"challenge-select-where","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473382,"asset_type":"Video","title":"07-select-where-challenge.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":142,"can_be_previewed":false},{"_class":"lecture","id":18145024,"title":"ORDER BY","created":"2020-02-21T20:45:32Z","description":"","title_cleaned":"order-by","is_published":true,"transcript":"","is_downloadable":false,"is_free":true,"asset":{"_class":"asset","id":22473380,"asset_type":"Video","title":"08-order-by.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":141,"can_be_previewed":true},{"_class":"lecture","id":18145028,"title":"LIMIT","created":"2020-02-21T20:46:03Z","description":"","title_cleaned":"limit","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473396,"asset_type":"Video","title":"09-LIMIT.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":140,"can_be_previewed":false},{"_class":"lecture","id":18145030,"title":"Challenge: ORDER BY","created":"2020-02-21T20:47:35Z","description":"","title_cleaned":"challenge-order-by","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473374,"asset_type":"Video","title":"10-orderby-challenge.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":139,"can_be_previewed":false},{"_class":"lecture","id":18145032,"title":"BETWEEN","created":"2020-02-21T20:47:47Z","description":"","title_cleaned":"between","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473376,"asset_type":"Video","title":"11-between.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":138,"can_be_previewed":false},{"_class":"lecture","id":18145034,"title":"IN","created":"2020-02-21T20:47:54Z","description":"","title_cleaned":"in","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473384,"asset_type":"Video","title":"12-IN.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":137,"can_be_previewed":false},{"_class":"lecture","id":18145036,"title":"LIKE and ILIKE","created":"2020-02-21T20:48:01Z","description":"","title_cleaned":"like-and-ilike","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22473372,"asset_type":"Video","title":"12-LIKE-and-ILIKE.mp4","created":"2020-02-21T19:00:11Z"},"sort_order":136,"can_be_previewed":false},{"_class":"lecture","id":4681736,"title":"General Challenge 1","created":"2016-03-06T05:58:01Z","description":"","title_cleaned":"general-challenge-1","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":5541338,"asset_type":"Video","title":"general challenge 1.mp4","created":"2016-03-16T19:58:39Z"},"sort_order":121,"can_be_previewed":false},{"_class":"chapter","id":1208256,"created":"2016-03-15T21:53:46Z","sort_order":120,"title":"GROUP BY Statements","description":"Learn the power of GROUP BY!","is_published":true},{"_class":"lecture","id":18192134,"title":"Introduction to GROUP BY","created":"2020-02-26T05:33:58Z","description":"","title_cleaned":"introduction-to-group-by","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22537392,"asset_type":"Video","title":"00-intro-groupby.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":119,"can_be_previewed":false},{"_class":"lecture","id":18192138,"title":"Aggregation Functions","created":"2020-02-26T05:34:08Z","description":"","title_cleaned":"aggregation-functions","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22537396,"asset_type":"Video","title":"01-agg-functions.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":118,"can_be_previewed":false},{"_class":"lecture","id":18192144,"title":"GROUP BY - Part One","created":"2020-02-26T05:34:26Z","description":"","title_cleaned":"group-by-part-one","is_published":true,"transcript":"","is_downloadable":false,"is_free":true,"asset":{"_class":"asset","id":22537398,"asset_type":"Video","title":"02-group-by-ptone.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":117,"can_be_previewed":true},{"_class":"lecture","id":18192148,"title":"GROUP BY - Part Two","created":"2020-02-26T05:34:33Z","description":"","title_cleaned":"group-by-part-two","is_published":true,"transcript":"","is_downloadable":false,"is_free":true,"asset":{"_class":"asset","id":22537390,"asset_type":"Video","title":"03-groupby-pt_two.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":116,"can_be_previewed":true},{"_class":"lecture","id":18192154,"title":"GROUP BY - Challenge","created":"2020-02-26T05:34:43Z","description":"","title_cleaned":"group-by-challenge","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22537394,"asset_type":"Video","title":"04-group-challenge.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":115,"can_be_previewed":false},{"_class":"lecture","id":18192156,"title":"HAVING","created":"2020-02-26T05:34:49Z","description":"","title_cleaned":"having","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22537386,"asset_type":"Video","title":"05-having.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":114,"can_be_previewed":false},{"_class":"lecture","id":18192160,"title":"HAVING - Challenge Tasks","created":"2020-02-26T05:35:02Z","description":"","title_cleaned":"having-challenge-tasks","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22537388,"asset_type":"Video","title":"06-having-challenges.mp4","created":"2020-02-26T00:34:55Z"},"sort_order":113,"can_be_previewed":false},{"_class":"chapter","id":1192196,"created":"2016-03-06T06:11:02Z","sort_order":106,"title":"Assessment Test 1","description":"Get ready to test your skills with a full assessment test!","is_published":true},{"_class":"lecture","id":4772494,"title":"Overview of Assessment Test 1","created":"2016-03-19T00:27:05Z","description":"","title_cleaned":"overview-of-assessment-test-1","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":5560014,"asset_type":"Video","title":"assessment test 1.mp4","created":"2016-03-19T00:39:27Z"},"sort_order":105,"can_be_previewed":false},{"_class":"lecture","id":4681772,"title":"Assessment Test 1","created":"2016-03-06T06:11:23Z","description":"","title_cleaned":"assessment-test-1","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5746758,"asset_type":"Article","title":"","created":"2016-04-10T21:35:01Z"},"sort_order":104,"can_be_previewed":false},{"_class":"lecture","id":4681774,"title":"Solutions to Assessment Test 1","created":"2016-03-06T06:11:31Z","description":"","title_cleaned":"solutions-to-assessment-test-1","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5746762,"asset_type":"Article","title":"","created":"2016-04-10T21:35:16Z"},"sort_order":103,"can_be_previewed":false},{"_class":"chapter","id":1192190,"created":"2016-03-06T05:58:40Z","sort_order":102,"title":"JOINS","description":"Learn about Joins in SQL!","is_published":true},{"_class":"lecture","id":4681746,"title":"Overview of JOINS","created":"2016-03-06T05:58:49Z","description":"","title_cleaned":"overview-of-joins","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":22722422,"asset_type":"Article","title":"","created":"2020-03-07T16:32:54Z"},"sort_order":101,"can_be_previewed":false},{"_class":"lecture","id":18335682,"title":"Introduction to JOINs","created":"2020-03-07T16:33:10Z","description":"","title_cleaned":"introduction-to-joins","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22722170,"asset_type":"Video","title":"00-intro-to-joins.mp4","created":"2020-03-07T16:17:45Z"},"sort_order":100,"can_be_previewed":false},{"_class":"lecture","id":18335678,"title":"AS Statement","created":"2020-03-07T16:33:02Z","description":"","title_cleaned":"as-statement","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22722178,"asset_type":"Video","title":"01-AS-clause.mp4","created":"2020-03-07T16:17:46Z"},"sort_order":99,"can_be_previewed":false},{"_class":"lecture","id":18335690,"title":"Inner Joins","created":"2020-03-07T16:33:37Z","description":"","title_cleaned":"inner-joins","is_published":true,"transcript":"","is_downloadable":false,"is_free":true,"asset":{"_class":"asset","id":22722168,"asset_type":"Video","title":"02-inner-joins.mp4","created":"2020-03-07T16:17:45Z"},"sort_order":98,"can_be_previewed":true},{"_class":"lecture","id":18335698,"title":"Full Outer Joins","created":"2020-03-07T16:33:59Z","description":"","title_cleaned":"full-outer-joins","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22722174,"asset_type":"Video","title":"03-full-outer.mp4","created":"2020-03-07T16:17:45Z"},"sort_order":97,"can_be_previewed":false},{"_class":"lecture","id":18335706,"title":"Left Outer Join","created":"2020-03-07T16:34:23Z","description":"","title_cleaned":"left-outer-join","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22722172,"asset_type":"Video","title":"04-left-outer-join.mp4","created":"2020-03-07T16:17:45Z"},"sort_order":96,"can_be_previewed":false},{"_class":"lecture","id":18335710,"title":"Right Joins","created":"2020-03-07T16:34:37Z","description":"","title_cleaned":"right-joins","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22722176,"asset_type":"Video","title":"05-Right-join.mp4","created":"2020-03-07T16:17:45Z"},"sort_order":95,"can_be_previewed":false},{"_class":"lecture","id":18937444,"title":"UNION","created":"2020-04-09T06:46:26Z","description":"","title_cleaned":"union","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491358,"asset_type":"Video","title":"09-unions.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":94,"can_be_previewed":false},{"_class":"lecture","id":18997814,"title":"JOIN Challenge Tasks","created":"2020-04-11T19:58:07Z","description":"","title_cleaned":"join-challenge-tasks","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23571120,"asset_type":"Video","title":"06-join-challenge.mp4","created":"2020-04-11T20:00:09Z"},"sort_order":93,"can_be_previewed":false},{"_class":"chapter","id":1192192,"created":"2016-03-06T06:00:38Z","sort_order":85,"title":"Advanced SQL Commands","description":"Learn about more advanced SQL commands!","is_published":true},{"_class":"lecture","id":18573906,"title":"Overview of Advanced SQL Commands","created":"2020-03-23T16:28:30Z","description":"","title_cleaned":"overview-of-advanced-sql-commands","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007514,"asset_type":"Video","title":"00-intro-to-adv-sql.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":84,"can_be_previewed":false},{"_class":"lecture","id":18573922,"title":"Timestamps and Extract - Part One","created":"2020-03-23T16:28:50Z","description":"","title_cleaned":"timestamps-and-extract-part-one","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007516,"asset_type":"Video","title":"01-timestamps-extract-pOne.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":83,"can_be_previewed":false},{"_class":"lecture","id":18573928,"title":"Timestamps and Extract - Part Two","created":"2020-03-23T16:28:56Z","description":"","title_cleaned":"timestamps-and-extract-part-two","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007512,"asset_type":"Video","title":"02-timestamps-extract-part-two.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":82,"can_be_previewed":false},{"_class":"lecture","id":19295762,"title":"Quick Note on TO_CHAR","created":"2020-04-23T19:13:44Z","description":"","title_cleaned":"quick-note-on-to_char","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":23951012,"asset_type":"Article","title":"","created":"2020-04-23T19:16:01Z"},"sort_order":81,"can_be_previewed":false},{"_class":"lecture","id":18573970,"title":"Timestamps and Extract - Challenge Tasks","created":"2020-03-23T16:30:05Z","description":"","title_cleaned":"timestamps-and-extract-challenge-tasks","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007518,"asset_type":"Video","title":"03-timestamps-extract-exercises.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":80,"can_be_previewed":false},{"_class":"lecture","id":18573930,"title":"Mathematical Functions and Operators","created":"2020-03-23T16:29:05Z","description":"","title_cleaned":"mathematical-functions-and-operators","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007510,"asset_type":"Video","title":"04-mathematical-functions.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":79,"can_be_previewed":false},{"_class":"lecture","id":18573934,"title":"String Functions and Operators","created":"2020-03-23T16:29:14Z","description":"","title_cleaned":"string-functions-and-operators","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007520,"asset_type":"Video","title":"05-string-functions-operators.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":78,"can_be_previewed":false},{"_class":"lecture","id":18573946,"title":"SubQuery","created":"2020-03-23T16:29:23Z","description":"","title_cleaned":"subquery","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007524,"asset_type":"Video","title":"06-subquery.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":77,"can_be_previewed":false},{"_class":"lecture","id":18573952,"title":"Self-Join","created":"2020-03-23T16:29:29Z","description":"","title_cleaned":"self-join","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23007522,"asset_type":"Video","title":"07-self-join.mp4","created":"2020-03-23T02:18:40Z"},"sort_order":76,"can_be_previewed":false},{"_class":"chapter","id":1192198,"created":"2016-03-06T06:11:50Z","sort_order":70,"title":"Assessment Test 2","description":"Get ready to test your skills with a full assessment test!","is_published":true},{"_class":"lecture","id":18693498,"title":"READ ME FIRST PLEASE","created":"2020-03-29T17:48:42Z","description":"","title_cleaned":"read-me-first-please","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":25196396,"asset_type":"Article","title":"","created":"2020-06-03T17:00:49Z"},"sort_order":69,"can_be_previewed":false},{"_class":"lecture","id":18324960,"title":"Setting up New Database for Assessment Exercises","created":"2020-03-06T19:15:44Z","description":"","title_cleaned":"setting-up-new-database-for-assessment-exercises","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":22710754,"asset_type":"Video","title":"000-exercises-installation.mp4","created":"2020-03-06T22:14:21Z"},"sort_order":68,"can_be_previewed":false},{"_class":"lecture","id":4681778,"title":"Assessment Test 2","created":"2016-03-06T06:12:03Z","description":"Test your SQL skills!
","title_cleaned":"assessment-test-2","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":23765894,"asset_type":"Article","title":"","created":"2020-04-17T22:41:43Z"},"sort_order":66,"can_be_previewed":false},{"_class":"lecture","id":19175688,"title":"Solutions to Assessment Test 2","created":"2020-04-18T23:01:16Z","description":"Test your SQL skills!
","title_cleaned":"solutions-to-assessment-test-2","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23796422,"asset_type":"Video","title":"assessmenttest_two.mp4","created":"2020-04-18T23:06:00Z"},"sort_order":65,"can_be_previewed":false},{"_class":"chapter","id":1192208,"created":"2016-03-06T06:32:21Z","sort_order":64,"title":"Creating Databases and Tables","description":"Learn how to manipulate Databases and Tables","is_published":true},{"_class":"lecture","id":18620748,"title":"Introduction to Section","created":"2020-03-26T04:02:23Z","description":"","title_cleaned":"introduction-to-section","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079492,"asset_type":"Video","title":"00-create-database-tables-intro.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":62,"can_be_previewed":false},{"_class":"lecture","id":18618140,"title":"Data Types","created":"2020-03-25T23:40:40Z","description":"","title_cleaned":"data-types","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079496,"asset_type":"Video","title":"01-data-type-considerations.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":61,"can_be_previewed":false},{"_class":"lecture","id":18620782,"title":"Primary Keys and Foreign Keys","created":"2020-03-26T04:04:05Z","description":"","title_cleaned":"primary-keys-and-foreign-keys","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079490,"asset_type":"Video","title":"02-pkeys-fkeys.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":59,"can_be_previewed":false},{"_class":"lecture","id":18620790,"title":"Constraints","created":"2020-03-26T04:04:13Z","description":"","title_cleaned":"constraints","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079494,"asset_type":"Video","title":"03-constraints.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":58,"can_be_previewed":false},{"_class":"lecture","id":18620820,"title":"CREATE Table","created":"2020-03-26T04:05:42Z","description":"","title_cleaned":"create-table","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079486,"asset_type":"Video","title":"04-CREATE.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":57,"can_be_previewed":false},{"_class":"lecture","id":18620824,"title":"INSERT","created":"2020-03-26T04:06:00Z","description":"","title_cleaned":"insert","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23079488,"asset_type":"Video","title":"05-INSERT.mp4","created":"2020-03-25T20:50:02Z"},"sort_order":56,"can_be_previewed":false},{"_class":"lecture","id":18620830,"title":"UPDATE","created":"2020-03-26T04:06:10Z","description":"","title_cleaned":"update","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23084442,"asset_type":"Video","title":"06-update.mp4","created":"2020-03-26T00:17:35Z"},"sort_order":55,"can_be_previewed":false},{"_class":"lecture","id":18620834,"title":"DELETE","created":"2020-03-26T04:06:23Z","description":"","title_cleaned":"delete","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23084440,"asset_type":"Video","title":"07-DELETE.mp4","created":"2020-03-26T00:17:35Z"},"sort_order":54,"can_be_previewed":false},{"_class":"lecture","id":18620840,"title":"ALTER Table","created":"2020-03-26T04:06:35Z","description":"","title_cleaned":"alter-table","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23084436,"asset_type":"Video","title":"08-ALTER.mp4","created":"2020-03-26T00:17:35Z"},"sort_order":53,"can_be_previewed":false},{"_class":"lecture","id":18620848,"title":"DROP Table","created":"2020-03-26T04:06:49Z","description":"","title_cleaned":"drop-table","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23084434,"asset_type":"Video","title":"09-DROP.mp4","created":"2020-03-26T00:17:35Z"},"sort_order":52,"can_be_previewed":false},{"_class":"lecture","id":18620936,"title":"CHECK Constraint","created":"2020-03-26T04:10:25Z","description":"","title_cleaned":"check-constraint","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23084438,"asset_type":"Video","title":"10-CHECK.mp4","created":"2020-03-26T00:17:35Z"},"sort_order":51,"can_be_previewed":false},{"_class":"chapter","id":1231448,"created":"2016-04-01T23:55:43Z","sort_order":36,"title":"Assessment Test 3","description":"Test your knowledge!","is_published":true},{"_class":"lecture","id":4863316,"title":"Assessment Test 3","created":"2016-04-01T23:55:05Z","description":"","title_cleaned":"assessment-test-3","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":33593068,"asset_type":"Article","title":"","created":"2021-05-16T19:42:20Z"},"sort_order":35,"can_be_previewed":false},{"_class":"lecture","id":4863318,"title":"Solutions to Assessment Test 3","created":"2016-04-01T23:55:28Z","description":"","title_cleaned":"solutions-to-assessment-test-3","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5702000,"asset_type":"Article","title":"","created":"2016-04-05T04:57:40Z"},"sort_order":34,"can_be_previewed":false},{"_class":"chapter","id":1192212,"created":"2016-03-06T06:36:15Z","sort_order":33,"title":"Conditional Expressions and Procedures","description":"Learn about Views in PostGreSQL","is_published":true},{"_class":"lecture","id":18937490,"title":"Conditional Expressions and Procedures Introduction","created":"2020-04-09T06:48:27Z","description":"","title_cleaned":"conditional-procedures-introduction","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491360,"asset_type":"Video","title":"08-condtional_procedures_intro.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":32,"can_be_previewed":false},{"_class":"lecture","id":18908956,"title":"CASE","created":"2020-04-08T00:06:53Z","description":"","title_cleaned":"case","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23453728,"asset_type":"Video","title":"01-Case.mp4","created":"2020-04-07T21:51:55Z"},"sort_order":31,"can_be_previewed":false},{"_class":"lecture","id":18908962,"title":"CASE - Challenge Task","created":"2020-04-08T00:07:03Z","description":"","title_cleaned":"case-challenge-task","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23453726,"asset_type":"Video","title":"02-case-challenge.mp4","created":"2020-04-07T21:51:55Z"},"sort_order":30,"can_be_previewed":false},{"_class":"lecture","id":18908966,"title":"COALESCE","created":"2020-04-08T00:07:11Z","description":"","title_cleaned":"coalesce","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23453724,"asset_type":"Video","title":"03-coalesce.mp4","created":"2020-04-07T21:51:55Z"},"sort_order":29,"can_be_previewed":false},{"_class":"lecture","id":18937518,"title":"CAST","created":"2020-04-09T06:49:42Z","description":"","title_cleaned":"cast","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491354,"asset_type":"Video","title":"04-CAST.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":28,"can_be_previewed":false},{"_class":"lecture","id":18937522,"title":"NULLIF","created":"2020-04-09T06:49:56Z","description":"","title_cleaned":"nullif","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491356,"asset_type":"Video","title":"05-nullif.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":27,"can_be_previewed":false},{"_class":"lecture","id":18937474,"title":"Views","created":"2020-04-09T06:47:37Z","description":"","title_cleaned":"views","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491352,"asset_type":"Video","title":"06-views.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":26,"can_be_previewed":false},{"_class":"lecture","id":18937480,"title":"Import and Export","created":"2020-04-09T06:47:56Z","description":"","title_cleaned":"import-and-export","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":23491350,"asset_type":"Video","title":"07-copy-import.mp4","created":"2020-04-09T03:52:53Z"},"sort_order":25,"can_be_previewed":false},{"_class":"chapter","id":1192216,"created":"2016-03-06T06:39:46Z","sort_order":23,"title":"Extra: PostGreSQL with Python","description":"Learn how to use psycopg2 with PostGreSQL","is_published":true},{"_class":"lecture","id":4858422,"title":"Overview of Python and PostgreSQL","created":"2016-04-01T01:28:15Z","description":"","title_cleaned":"overview-of-python-and-postgresql","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5702112,"asset_type":"Article","title":"","created":"2016-04-05T05:24:57Z"},"sort_order":22,"can_be_previewed":false},{"_class":"lecture","id":4681868,"title":"Psycopg2 Example Usage","created":"2016-03-06T06:45:24Z","description":"","title_cleaned":"psycopg2-example-usage","is_published":true,"transcript":"","is_downloadable":false,"is_free":false,"asset":{"_class":"asset","id":5702478,"asset_type":"Video","title":"pyscopg2.mp4","created":"2016-04-05T07:12:05Z"},"sort_order":21,"can_be_previewed":false},{"_class":"lecture","id":4681870,"title":"Psycopg2 Resources","created":"2016-03-06T06:45:32Z","description":"","title_cleaned":"psycopg2-resources","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":5795900,"asset_type":"Article","title":"","created":"2016-04-18T05:27:37Z"},"sort_order":20,"can_be_previewed":false},{"_class":"chapter","id":1192220,"created":"2016-03-06T06:45:49Z","sort_order":1,"title":"BONUS SECTION: THANK YOU!","description":"Thank you for taking the course!","is_published":true},{"_class":"lecture","id":4681874,"title":"Bonus Lecture","created":"2016-03-06T06:45:54Z","description":"Get special discount offers on my other courses!
","title_cleaned":"bonus-lecture","is_published":true,"transcript":"","is_downloadable":true,"is_free":false,"asset":{"_class":"asset","id":19772751,"asset_type":"Article","title":"","created":"2019-09-04T16:06:51Z"},"sort_order":0,"can_be_previewed":false}]}