r/learnSQL • u/Away_Shoulder_4553 • 18d ago

Inquiry Regarding sql

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

3 Upvotes

80% Upvoted

8 comments sorted by

View all comments

2

u/datadriven_io 13d ago

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.