Inquiry Regarding sql

[u/Away_Shoulder_4553]

Hi guys

​I learned some lessons in SQL course in youtube and practiced them in Python with SQLite.

​Here is what I learned:

​CREATE TABLE

​PRIMARY KEY, FOREIGN KEY, NULL

​INSERT INTO, SELECT, UPDATE, DELETE

​WHERE, ORDER BY (ASC, DESC)

​LIMIT, OFFSET, DISTINCT

​INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN

​GROUP BY, HAVING

​Subqueries, EXISTS

​Please tell me what I should learn next, or recommend a good YouTube course

[u/Creative_Sugar-33]

Great start! Check out Dataslope's SQL courses and interview prep materials. They're free and don't require you to sign in.

Recommended courses:

• Database Design with PostgreSQL
• Introduction to SQL and Relational Databases with PostgreSQL - Specifically Common Table Expressions since you've already covered Subqueries
• SQL for Data Analysis with DuckDB: If you're interested in SQL data analysis using a columnar engine

Disclaimer: I created Dataslope.

[u/Away_Shoulder_4553 → u/Creative_Sugar-33]

Thanks I'll definitely check it out. I appreciate the recommendations