Personal Notes for the Data Engineer Academy

About Roger Huba

I am Roger. I am a software developer with emphasis in Python, CyberSecurity Enthusiast, and aspiring Data Engineer.

This is how I will keep myself in a growth mindset

• Look at topics from a different perspective.
• Be open to new ideas from those that are willing to share.
• Be flexible.

---

📚 SQL Lessons

SQL

    

Details

SQL Beginner Lessons

• SELECT FROM
• WHERE CONDITION
• COMPARISON OPERATORS
• LOGICAL OPERATORS
• LIKE OPERATOR
• IN OPERATOR
• BETWEEN OPERATOR
• IS NULL
• AND OPERATOR
• OR OPERATOR
• NOT OPERATOR
• ORDER BY
• LIMIT OFFSET

    

Details

SQL Intermediate Lessons

• GROUP BY
• COUNT OPERATOR
• SUBQUERIES
• MAX OPERATOR
• MIN OPERATOR
• SUM OPERATOR
• AVG OPERATOR
• HAVING CLAUSE
• SUBQUERY WITH AGGREGATE FUNCTIONS
• CASE STATEMENT
• LEFT JOIN
• RIGHT JOIN
• INNER JOIN
• FULL OUTER JOIN
• JOIN WITH WHERE
• JOIN WITH COMPARISON
• DISTINCT
• JOIN WITH MULTIPLE KEYS
• SELF JOIN
• UNION

    

Details

SQL Advanced Lessons

• DATA TYPES
• CONCAT
• CAST
• LENGTH
• SUBSTRING
• CHARINDEX or SUBSTRING_INDEX
• TRIM
• LEFT & RIGHT
• UPPER & LOWER
• EXTRACT
• COALESCE
• SUBQUERY IN CONDITION
• WINDOW FUNCTION
• ROW NUMBER
• RANK
• LEAD
• WITH STATEMENTS