Build the Finance Skills That Lead to Promotions — Not Just Certificates
Google AI Professional Certificate - Learn AI Skills That Get You Hired
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Master SQL fundamentals in this comprehensive 47-minute tutorial designed for beginners. Start by setting up PostgreSQL, then dive into creating tables and databases. Learn essential operations like SELECT and INSERT, understand the importance of primary keys, and explore table and column alterations. Progress to updating records and implementing foreign keys for relational data. Delve into various JOIN operations, including INNER, LEFT, RIGHT, and FULL JOINs. Conclude with techniques for formatting tables to enhance data presentation. This fast-paced video covers crucial SQL concepts, providing a solid foundation for database management and querying.
Syllabus
Intro
Setting up PG
Creating Tables and Databases
SELECTS AND INSERTS
Primary Keys
ALTER TABLES & COLUMNS
UPDATE record
Brilliant
Foreign Keys
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
Formatting Tables
Taught by
developedbyed