{"id":25,"date":"2026-10-16T06:43:52","date_gmt":"2026-10-16T06:43:52","guid":{"rendered":"https:\/\/elementor.ltheme.com\/lt-elearning\/sql-basics\/"},"modified":"2026-10-16T15:22:41","modified_gmt":"2026-10-16T15:22:41","slug":"sql-basics","status":"publish","type":"page","link":"https:\/\/elementor.ltheme.com\/lt-elearning\/courses\/data-skills\/sql-basics\/","title":{"rendered":"SQL basics"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"25\" class=\"elementor elementor-25\">\n\t\t\t\t<section class=\"elementor-element elementor-element-200e6f0 e-con-boxed lt-sec lt-pagehead e-flex e-con e-parent\" data-id=\"200e6f0\" data-element_type=\"container\" data-e-type=\"container\" id=\"top\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-33f9662 e-con-full e-flex e-con e-child\" data-id=\"33f9662\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-29dbe2b lt-pagehead__title elementor-widget elementor-widget-heading\" data-id=\"29dbe2b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">SQL basics<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb15454 lt-lead elementor-widget elementor-widget-text-editor\" data-id=\"fb15454\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Seven chapters, 4 h 35 min: ask a database your own questions.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/section>\n\t\t<section class=\"elementor-element elementor-element-a3ad7dc e-con-boxed lt-sec e-flex e-con e-parent\" data-id=\"a3ad7dc\" data-element_type=\"container\" data-e-type=\"container\" id=\"course\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-7a8c830 e-grid e-con-full e-con e-child\" data-id=\"7a8c830\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-615f287 e-con-full e-flex e-con e-child\" data-id=\"615f287\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5287d6c lt-h3 elementor-widget elementor-widget-heading\" data-id=\"5287d6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What you will be able to do<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-467557f lt-lead elementor-widget elementor-widget-text-editor\" data-id=\"467557f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Write queries that filter, join and total real tables, check that the numbers are right, and answer one business question end to end. Everything runs in your browser.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6de9dc lt-photo lt-ar-photo elementor-widget elementor-widget-image\" data-id=\"f6de9dc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1600\" height=\"1060\" src=\"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql.jpg\" class=\"attachment-full size-full wp-image-9\" alt=\"A laptop with a code editor open next to a notebook and pen\" srcset=\"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql.jpg 1600w, https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql-300x199.jpg 300w, https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql-1024x678.jpg 1024w, https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql-768x509.jpg 768w, https:\/\/elementor.ltheme.com\/lt-elearning\/wp-content\/uploads\/sites\/70\/2026\/10\/demo-lt-elearning-sql-1536x1018.jpg 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ff9a03e e-con-full lt-facts e-flex e-con e-child\" data-id=\"ff9a03e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-534805d lt-h4 elementor-widget elementor-widget-heading\" data-id=\"534805d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SQL basics at a glance<\/h3>\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ee76087 e-con-full lt-rows lt-prices e-flex e-con e-child\" data-id=\"ee76087\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-f31f42c e-grid e-con-full lt-price e-con e-child\" data-id=\"f31f42c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-813415f e-con-full e-flex e-con e-child\" data-id=\"813415f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-710be62 lt-price__label elementor-widget elementor-widget-text-editor\" data-id=\"710be62\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Video<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-05bea90 lt-price__amount elementor-widget elementor-widget-text-editor\" data-id=\"05bea90\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">4 h 35 min<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a4e2815 e-grid e-con-full lt-price e-con e-child\" data-id=\"a4e2815\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-e9e8fd7 e-con-full e-flex e-con e-child\" data-id=\"e9e8fd7\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ebb4098 lt-price__label elementor-widget elementor-widget-text-editor\" data-id=\"ebb4098\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Chapters<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb78017 lt-price__amount elementor-widget elementor-widget-text-editor\" data-id=\"bb78017\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">7<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b9de8ff e-grid e-con-full lt-price e-con e-child\" data-id=\"b9de8ff\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-3287c8f e-con-full e-flex e-con e-child\" data-id=\"3287c8f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-213230c lt-price__label elementor-widget elementor-widget-text-editor\" data-id=\"213230c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b8b38c lt-price__amount elementor-widget elementor-widget-text-editor\" data-id=\"4b8b38c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">16, marked by an instructor<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0e48c53 e-grid e-con-full lt-price e-con e-child\" data-id=\"0e48c53\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-b1017bc e-con-full e-flex e-con e-child\" data-id=\"b1017bc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b1dc32 lt-price__label elementor-widget elementor-widget-text-editor\" data-id=\"3b1dc32\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Level<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21e95b4 lt-price__amount elementor-widget elementor-widget-text-editor\" data-id=\"21e95b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">Beginner<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2a791bd e-grid e-con-full lt-price e-con e-child\" data-id=\"2a791bd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-2fa78ab e-con-full e-flex e-con e-child\" data-id=\"2fa78ab\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e7e2f70 lt-price__label elementor-widget elementor-widget-text-editor\" data-id=\"e7e2f70\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Fee<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2da2f7f lt-price__note elementor-widget elementor-widget-text-editor\" data-id=\"2da2f7f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Yours to keep (Example prices)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2fbe819 lt-price__amount elementor-widget elementor-widget-text-editor\" data-id=\"2fbe819\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">$59<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-af0895a e-con-full lt-buttons  e-flex e-con e-child\" data-id=\"af0895a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4729acc lt-btn lt-btn--primary elementor-widget elementor-widget-button\" data-id=\"4729acc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/elementor.ltheme.com\/lt-elearning\/contact\/#enrol\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Ask for a free lesson<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/section>\n\t\t<section class=\"elementor-element elementor-element-e724c8e e-con-boxed lt-sec lt-tint e-flex e-con e-parent\" data-id=\"e724c8e\" data-element_type=\"container\" data-e-type=\"container\" id=\"chapters\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-907b4d3 e-grid e-con-full e-con e-child\" data-id=\"907b4d3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5b2df1b elementor-widget elementor-widget-heading\" data-id=\"5b2df1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Chapter by chapter<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04e1a98 lt-lead elementor-widget elementor-widget-text-editor\" data-id=\"04e1a98\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>7 chapters, 4 h 35 min of video. Each segment of the bar is one chapter, drawn to its length.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8b8e0db e-con-full lt-player e-flex e-con e-child\" data-id=\"8b8e0db\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ca33be9 lt-bar elementor-widget elementor-widget-text-editor\" data-id=\"ca33be9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-bar__track\" role=\"img\" aria-label=\"7 chapters, 4 h 35 min in all\"><span class=\"lt-seg\" style=\"width:10.909%\"><\/span><span class=\"lt-seg\" style=\"width:13.818%\"><\/span><span class=\"lt-seg\" style=\"width:18.909%\"><\/span><span class=\"lt-seg\" style=\"width:16.000%\"><\/span><span class=\"lt-seg\" style=\"width:13.091%\"><\/span><span class=\"lt-seg\" style=\"width:12.727%\"><\/span><span class=\"lt-seg\" style=\"width:14.545%\"><\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c054587 e-grid e-con-full lt-chapters e-con e-child\" data-id=\"c054587\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-b188e03 e-con-full lt-chap e-flex e-con e-child\" data-id=\"b188e03\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1eabdaa lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"1eabdaa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">0:00:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e21ddd lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"3e21ddd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">First queries<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0dd99cb e-con-full lt-chap e-flex e-con e-child\" data-id=\"0dd99cb\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0f7ff18 lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"0f7ff18\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">0:30:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f4a3129 lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"f4a3129\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Filtering and sorting<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f0f45d9 e-con-full lt-chap e-flex e-con e-child\" data-id=\"f0f45d9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9b94121 lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"9b94121\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">1:08:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fb7f lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"7f4fb7f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Joins<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-90b9bf5 e-con-full lt-chap e-flex e-con e-child\" data-id=\"90b9bf5\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0deab36 lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"0deab36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">2:00:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-682cc24 lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"682cc24\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Grouping and totals<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a526e57 e-con-full lt-chap e-flex e-con e-child\" data-id=\"a526e57\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-013d70d lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"013d70d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">2:44:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-327262f lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"327262f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Subqueries<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7c1963f e-con-full lt-chap e-flex e-con e-child\" data-id=\"7c1963f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-24a9869 lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"24a9869\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">3:20:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc48c44 lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"dc48c44\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Cleaning in SQL<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c6ef6fa e-con-full lt-chap e-flex e-con e-child\" data-id=\"c6ef6fa\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-270db71 lt-chap__time elementor-widget elementor-widget-text-editor\" data-id=\"270db71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">3:55:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-705c6ab lt-chap__title elementor-widget elementor-widget-heading\" data-id=\"705c6ab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A report from scratch<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-66b6a2b e-con-full lt-rows lt-chapters-list e-flex e-con e-child\" data-id=\"66b6a2b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-ee02caa e-grid e-con-full lt-chapter e-con e-child\" data-id=\"ee02caa\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c37f571 lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"c37f571\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">0:00:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dd04cdc e-con-full e-flex e-con e-child\" data-id=\"dd04cdc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7c465a4 lt-h4 elementor-widget elementor-widget-heading\" data-id=\"7c465a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">First queries<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3bdf22 elementor-widget elementor-widget-text-editor\" data-id=\"f3bdf22\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>SELECT, FROM and reading a table you did not design<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eae862e lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"eae862e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">30 min<br>2 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-714e2c6 e-grid e-con-full lt-chapter e-con e-child\" data-id=\"714e2c6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c5a1e5b lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"c5a1e5b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">0:30:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-94ed55c e-con-full e-flex e-con e-child\" data-id=\"94ed55c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-de7b01c lt-h4 elementor-widget elementor-widget-heading\" data-id=\"de7b01c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Filtering and sorting<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a692f8c elementor-widget elementor-widget-text-editor\" data-id=\"a692f8c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>WHERE, ORDER BY and the mistakes everyone makes with NULL<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a543331 lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"a543331\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">38 min<br>3 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b7af15c e-grid e-con-full lt-chapter e-con e-child\" data-id=\"b7af15c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db92fdf lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"db92fdf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">1:08:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-01da91f e-con-full e-flex e-con e-child\" data-id=\"01da91f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c738d9e lt-h4 elementor-widget elementor-widget-heading\" data-id=\"c738d9e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Joins<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-639bc71 elementor-widget elementor-widget-text-editor\" data-id=\"639bc71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Putting two tables together and checking the row count<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8fd8062 lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"8fd8062\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">52 min<br>3 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4808f6f e-grid e-con-full lt-chapter e-con e-child\" data-id=\"4808f6f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-54b6479 lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"54b6479\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">2:00:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-90c302e e-con-full e-flex e-con e-child\" data-id=\"90c302e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8d2df29 lt-h4 elementor-widget elementor-widget-heading\" data-id=\"8d2df29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Grouping and totals<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-107aae6 elementor-widget elementor-widget-text-editor\" data-id=\"107aae6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>GROUP BY, HAVING and totals that match the finance report<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16462c8 lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"16462c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">44 min<br>3 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c29b399 e-grid e-con-full lt-chapter e-con e-child\" data-id=\"c29b399\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6e0ff87 lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"6e0ff87\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">2:44:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8f16afe e-con-full e-flex e-con e-child\" data-id=\"8f16afe\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dbaa9c lt-h4 elementor-widget elementor-widget-heading\" data-id=\"2dbaa9c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Subqueries<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1d2d4d elementor-widget elementor-widget-text-editor\" data-id=\"a1d2d4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Questions inside questions, and when to use a CTE instead<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a17830b lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"a17830b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">36 min<br>2 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-25b45c7 e-grid e-con-full lt-chapter e-con e-child\" data-id=\"25b45c7\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0690f82 lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"0690f82\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">3:20:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-61b0704 e-con-full e-flex e-con e-child\" data-id=\"61b0704\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-96b4bc4 lt-h4 elementor-widget elementor-widget-heading\" data-id=\"96b4bc4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Cleaning in SQL<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-648a8a1 elementor-widget elementor-widget-text-editor\" data-id=\"648a8a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Text, dates and duplicates<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-546d86c lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"546d86c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">35 min<br>2 exercises<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fc5b66e e-grid e-con-full lt-chapter e-con e-child\" data-id=\"fc5b66e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3c3752d lt-chapter__time elementor-widget elementor-widget-text-editor\" data-id=\"3c3752d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">3:55:00<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8d0e53c e-con-full e-flex e-con e-child\" data-id=\"8d0e53c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5bd45ae lt-h4 elementor-widget elementor-widget-heading\" data-id=\"5bd45ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A report from scratch<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab3045b elementor-widget elementor-widget-text-editor\" data-id=\"ab3045b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>One business question answered end to end<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-543e6c8 lt-chapter__len elementor-widget elementor-widget-text-editor\" data-id=\"543e6c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"lt-num\">40 min<br>1 exercise<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/section>\n\t\t<section class=\"elementor-element elementor-element-0fbe75f e-con-boxed lt-sec lt-dark lt-cta lt-skip-menu e-flex e-con e-parent\" data-id=\"0fbe75f\" data-element_type=\"container\" data-e-type=\"container\" id=\"preview\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-60b4609 e-grid e-con-full e-con e-child\" data-id=\"60b4609\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8b2bc8a lt-cta__title elementor-widget elementor-widget-heading\" data-id=\"8b2bc8a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Watch the first lesson of any course, free<\/h2>\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3d13e4a e-con-full e-flex e-con e-child\" data-id=\"3d13e4a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-101f19e lt-lead elementor-widget elementor-widget-text-editor\" data-id=\"101f19e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Tell us which course and we email a login for its first chapter. No card, no trial that turns into a subscription.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eb5a218 e-con-full lt-buttons  e-flex e-con e-child\" data-id=\"eb5a218\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4c1d796 lt-btn lt-btn--primary elementor-widget elementor-widget-button\" data-id=\"4c1d796\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/elementor.ltheme.com\/lt-elearning\/contact\/#enrol\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Ask for a free lesson<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56a83b5 lt-btn lt-btn--outline elementor-widget elementor-widget-button\" data-id=\"56a83b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"tel:+15550142200\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Call (555) 014-2200<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":21,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-25","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/pages\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":1,"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/pages\/25\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/pages\/25\/revisions\/26"}],"up":[{"embeddable":true,"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/pages\/21"}],"wp:attachment":[{"href":"https:\/\/elementor.ltheme.com\/lt-elearning\/wp-json\/wp\/v2\/media?parent=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}