[Тимур Гуев, Школа BEEGEEK] Поколение Python: базы данных и SQL для начинающих [Тимур Гуев, Школа BEEGEEK]

[SlivInfoKurs]

Описание:
Python Generation": SQL for Beginners:

• Introduces relational databases
• Introduces the basic capabilities of the SQL language

This course covers the fundamental concepts of relational databases and SQL: grouping, joins, subqueries, built-in functions, user-defined functions and stored procedures, triggers, views, common table expressions (CTE), SELECT, UPDATE, INSERT, DELETE, CREATE, ALTER operators.

The DBMS used is MySQL.

Solutions are checked by an automated system, so you will receive feedback quickly. If you have any questions, the course team will provide advice and hints. In addition, problems can be discussed with fellow students in the comments to the tasks.

What you will learn:

• Extract information from tables using SQL queries
• Add new data to tables
• Delete and modify data in tables
• Filter data using WHERE and HAVING
• Perform data aggregation using GROUP BY
• Extract information from multiple tables using JOIN
• Merge tables using UNION
• Work with functions for processing numbers, dates, and text
• Calculate average, minimum, and maximum values using AVG, MIN, MAX functions
• Use nested SQL queries
• Create custom functions and stored procedures

Who is this course for?
1. Beginner programmer
Learn the basics of relational databases and SQL, learn to solve practical tasks.

2. Advanced programmer
Hone your SQL skills by solving a large number of tasks.

3. Analyst
Learn to process information using one of the most powerful languages for data work.

4. Tester
Learn the basics of SQL necessary for automation testing.

Link to the sales page

Этот курс появится в скором времени на форуме SLIVINFOKURS.BIZ. Проверьте по поиску форума, возможно данный курс уже слит.

​