FULL SQL DATABASE COURSE | Learn SQL in 70 minutes
Portfolio, Projects, Resume, Courses & Certifications, Newsletter
https://mochen.info
Sponsorships: https://mo-chen.notion.site/partnerships
Hi, I'm Mo! I'm a Data & Analytics Manager. I'm all about turning complex, big data into insights and actions. I am not interested in building yet another dashboard that nobody looks at - I'm interested in solving the most challenging business problems using data.
=========================================================
COURSES & CERTIFICATES
Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen
INDUSTRY RECOGNIZED CERTIFICATIONS
Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCe...
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAn...
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientist...
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert
TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWi...
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPo...
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateData...
TOP DATA SCIENTIST COURSES
Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateData...
Associate Data Scientist in R: https://datacamp.pxf.io/AssociateData...
TOP DATA ENGINEER COURSES
Data Engineer in Python: https://datacamp.pxf.io/DataEngineerI...
TOP BUSINESS INTELLIGENCE COURSES
PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundam...
Tableau Fundamentals: https://datacamp.pxf.io/TableauFundam...
TOP PROGRAMMING LANGUAGE COURSES
Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundame...
Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundame...
SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals
R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals
TOP AI COURSES
AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDev...
AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDat...
Developing AI Applications Course: https://datacamp.pxf.io/AIApplications
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
PROJECT FILES
Github repo for code ➡︎ https://github.com/mochen862/full-sql...
Install pgAdmin (Windows & Mac) ➡︎ https://www.postgresql.org/download/
Nesta página do site você pode assistir ao vídeo on-line FULL SQL DATABASE COURSE | Learn SQL in 70 minutes duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Mo Chen 29 Abril 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 175,762 vezes e gostou 5.9 mil espectadores. Boa visualização!
