SQL and data analysis: relational DBMS and Python integration
The course is aimed at studying the principles of operation of relational databases and mastering the SQL language for creating, managing and analytical data processing. Database design, normalization, transactions, complex SQL queries …
- Duration
- 30 hours
- Students
- 11
- Language
- Казахский
- Reviews
- 0.0 (0)
Certificate
When you finish the course
// About the Course
About the Course
The course is aimed at studying the principles of operation of relational databases and mastering the SQL language for creating, managing and analytical data processing. Database design, normalization, transactions, complex SQL queries (JOIN, SubQuery, CTE), as well as integration of Python (Pandas, NumPy, Matplotlib) data for analysis and visualization are considered.
What you will learn
- 01 Relational database design.
- 02 Writing complex SQL queries.
- 03 Data and transaction management.
- 04 Creation and analysis of procedures.
- 05 Data integration with Python for visualization.
Curriculum
3 modules-
video Databases and their types. The structure of a relational database.
-
video Creating and deleting databases and tables. Types of data in tables. Restrictions on columns.
-
video Data manipulation. INSERT, UPDATE, and DELETE operators.
-
video Types and structure of SQL queries. SELECT, WHERE, DISTINCT, TOP, IS NULL. The BETWEEN, IN, and LIKE operators.
-
video Sorting and grouping. Arithmetic and logical operations, aggregate functions.
-
video Multi-tabular queries. JOIN, INNER JOIN, OUTER JOIN.
-
video Subqueries: single-line and single-column subqueries. Multi-line and single-column subqueries.
-
video Multi-column subqueries. Correlated subqueries.
-
video Generalized Tabular Expressions (CTE). The WITH operator.
-
video Combining requests. The UNION operator.
-
text Conditional logic: the CASE statement and the IF function.
-
text Stored procedures and functions.
-
video Importing SQL data into Python and getting to know NumPy arrays. The Pandas library.
-
video An introduction to SQL data visualization. Matplotlib basics and the Figure object.
Student Requirements
- Basic knowledge of programming.
- Understanding algorithms and data structures.
- Experience working with databases is not required.
Course Experts
Student Reviews 0
No reviews yet. Be the first!
~/kaznu $ cscourse consult
Want to take this course?
Leave your number — a consultant will call you back, tell you about the courses and prices, and help you choose a direction.
- ✓Free consultation
- ✓We will call back within a business day
Free
SQL and data analysis: relational DBMS and Python integration