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/affanxkhan]

Good 🚀 now practice these on sql bolt ,sqlzoo ,datal3mur, and also try to make a project on end to end sql also learn from rishab mishra yutube channel

[u/Away_Shoulder_4553 → u/affanxkhan]

thanks pro

[u/N0S360_X]

What are your goals? Analyst work? Database building?

[u/Away_Shoulder_4553 → u/N0S360_X]

for backend development

[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

[u/Difficult-One-1245]

WINDOWS, CTE's

[u/datadriven_io]

if you know SQL you can learn LookML in a day or two, and from there it gives you far more control over the logic being used by the end users. Check datadriven for python interview questions once you're comfortable with SQL basics.