Power BI Fundamentals - Create visualizations and dashboards from scratch
Finance Certifications Goldman Sachs & Amazon Teams Trust
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
Dive into a comprehensive 4-hour crash course on raw SQL for beginners. Learn essential database concepts and SQL fundamentals, starting with an introduction to SQL and Postgres installation. Master data structures, CRUD operations, and constraints. Explore advanced topics like data filtering, sorting, and various types of joins. Practice your skills with coding challenges. Delve into relationships, foreign keys, and bridge tables. Understand group by operations, unions, and subqueries. Familiarize yourself with different datatypes and table alterations. Access supplementary resources including a GitHub repository, Postgres download link, and recommended SQL tools like Postico and PopSQL to enhance your learning experience.
Syllabus
- Intro to SQL
- Download Postgres
- Data Structure
- Inserting Data
- Selecting Data
- Deleting Data
- Primary Key Constraint
- Filtering Data
- AND, OR, NOT
- Ordering/Sorting Data
- Challenge 1
- Relationships
- Foreign Keys
- Bridge/Join Table
- Inner Joins
- Right, Left, Outer Joins
- Many to Many Joins
- Group By
- Unions
- Challenge 2
- Subqueries
- Datatypes
- Altering a Table
Taught by
Laith Academy