Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching FULL SQL DATABASE COURSE | Learn SQL in 70 minutes. and this video is uploaded by Mo Chen at 2023-04-29T08:00:45-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [MvcDM2nLdzI]
| Name | FULL SQL DATABASE COURSE | Learn SQL in 70 minutes |
| Video Uploader | Video From Mo Chen |
| Upload Date | This Video Uploaded At 29-04-2023 15:00:45 |
| Video Discription | GET YOUR DATA JOB ➡ https://mochen.info/ ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimate-data-portfolio-lp/ AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/ai-job-quest-lp/ PATREON ➡ https://www.patreon.com/mo_chen 1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/1-1-mentorship-lp/ CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?course=data-analytics Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ https://www.youtube.com/playlist?list=PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU ┋Community & Socials┋ https://discord.gg/EBh7j9uRJ2 ⬅ Join our Discord Data Community https://www.instagram.com/mo_chen1/ ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well https://www.linkedin.com/in/mo-chen1/ ⬅ Daily tips & advice on how to enhance your data analysis skills https://twitter.com/mo_chen_1 ⬅ Figuring out what I want to do in this space... ┋Professional Certificates┋ CourseCareers ➡ https://coursecareers.com/a/mochen DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/1112311/13294 Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6t39nRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/advanced-data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tWpnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tVZnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProjectManagement ┋Timestamps┋ 00:00 Course outline 03:11 Databases 06:27 Queries, tables and keys 09:39 Windows postgreSQL installation 11:48 MacOS postgreSQL installation 13:54 CREATE TABLE 20:58 INSERT INTO 24:37 SELECT, WHERE, AND & OR 28:49 IN, NOT IN, IS NULL, BETWEEN 32:32 ORDER BY, LIMIT, DISTINCT and Renaming columns 35:09 EXTRACT 36:21 UPPER, LOWER, LENGTH, TRIM 38:30 Concatenation, Boolean expressions and Wildcards 43:02 SUBSTRING, POSITION, COALESCE 46:11 MIN, MAX, AVG, SUM & COUNT 48:16 GROUP BY & HAVING 52:05 CASE (with GROUP BY and for transposing data) 56:18 JOIN & UNION 1:02:31 Subqueries 1:07:15 Bonus - 30 day moving total 1:09:34 Outro ┋Files┋ Github repo for code ➡︎ https://github.com/mochen862/full-sql-database-course Install pgAdmin (Windows & Mac) ➡︎ https://www.postgresql.org/download/ Thanks so much for taking a little time out of your day to watch this! [MvcDM2nLdzI] |
| Category | People & Blogs |
| Tags | People & Blogs Download MP4 | People & Blogs Download MP3 | People & Blogs Download MP4 360p | People & Blogs Download MP4 480p | People & Blogs Download MP4 720p | People & Blogs Download MP4 1080p |
