SQL Users Group

SQL Users Group covering major Databases like MySQL, PostgreSQL, MS SQL Server.

Covering:
SQL DML: INSERT, SELECT, UPDATE, DELETE.
SQL DDL: CREATE, ALTER, DROP.

• Basic SELECT statement for data retrieval.
• Where clause to filter rows.
• Using wild cards.
• Specifying columns and column aliases.
• Order by (Sorting).
• Limiting number of rows.
• SQL Operators: Arithmetic, Comparison, Logical
• SQL Null Functions
• Set Operations: UNION, UNION ALL, INTERSECT, EXCEPT
• Primary & Foreign Keys.
• Joins: INNER, LEFT, RIGHT, FULL, SELF
• Sub queries: Columns, FROM, JOIN, WHERE
• CTE: Common Table Expression, temp tables (with)
• Aggregates: COUNT, SUM, AVG, MIN, MAX.
• Group By and Having (filter).
• CASE statements.
• Views.
• Materialized
• Date, String, Number, Window, Table functions
• Stored Procedures
• Connectivity with Python, JavaScript and Java