SQL & AI

“SQL Pro & AI” is a new program by the Girls Code Fun Foundation. It builds on participants’ existing SQL knowledge and expands their perspective, showing new applications such as how to use artificial intelligence in working with databases. This is a free workshop for individuals who already have some SQL knowledge and want to continue their education in this field.

Workshop Goals:

• Mastering advanced SQL techniques in PostgreSQL
• Understanding and applying query optimization
• Using artificial intelligence to generate and analyze SQL code
• Practical skills in creating prompts for AI

Who is it for? For women who already know SQL but want to reach the next level of knowledge and strengthen their position in the IT world.

Number of Spots: Limited – we will train 15 women in the project who convince us with their motivation that a spot is waiting for them.

Agenda:

• Introduction to Advanced SQL and AI in PostgreSQL
• Advanced Data Manipulation Techniques
• Indexes and Database Optimization
• Advanced Functions and Stored Procedures
• Security and Access Management
• Integrating AI with PostgreSQL and Practical Case Study

SQL Pro & AI is an online workshop for one group. The workshop lasts 15 hours and is conducted over 6 sessions in 2 weeks, with each session lasting 2.5 hours, always at the same time on Mondays, Wednesdays, and Fridays.

Meeting Dates:

• July 1, 3, 5, 8, 10, 12, 2024 (6:00 PM – 8:30 PM)

To participate in the SQL Pro & AI workshop, you should already know:

1. Writing basic queries using the SELECT command
2. Data types: varchar, integer, bool, date, datetime
3. Finding unique values using SELECT DISTINCT
4. Sorting results using ORDER BY
5. WHERE clause, IN/AND operators, LIKE and BETWEEN
6. What NULL values are and how to perform operations on them
7. Aggregate functions – MIN, MAX, SUM, AVG, COUNT, GROUP BY
8. Joining tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
9. DML/DDL commands: CREATE, UPDATE, INSERT, DELETE
10. Working with date and time data types
11. Useful functions: CASE WHEN, CONCAT, CAST, etc.
12. Subqueries / Nested Queries
13. UNION, INTERSECT, EXCEPT
14. CTE (Common Table Expression) in practice
15. Introduction to PIVOT: converting rows to columns
16. Database objects: functions, triggers, stored procedures, primary and foreign keys, sequences, etc.
17. Query optimization