Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Plan Szkolenia
Part 1: SQL Basics
Introduction to SQL and Databases
- Understanding databases
- Introduction to SQL
- Setting up the SQL environment
SQL Syntax and Basic Queries
- SQL syntax overview
- SELECT statements
- Filtering data with WHERE clause
Working with Functions and Aggregates
- Common SQL functions
- Aggregate functions: COUNT, SUM, AVG, MAX, MIN
- Grouping data with GROUP BY
Joining Tables
- Understanding JOINs
- INNER JOIN
- LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
Subqueries and Set Operations
- Writing subqueries
- UNION, INTERSECT, and EXCEPT operations
Data Manipulation
- INSERT INTO statement
- UPDATE statement
- DELETE statement
Part 2: Intermediate SQL
Advanced Data Filtering
- Advanced WHERE clause techniques
- LIKE operator and pattern matching
- IN and BETWEEN operators
Complex Joins and Subqueries
- Self-joins
- Non-correlated and correlated subqueries
- EXISTS clause
Working with Indexes and Views
- Understanding indexes and their impact on performance
- Creating and using views
Advanced Functions and Stored Procedures
- User-defined functions
- Stored procedures and triggers
- Error handling in SQL
Data Transformation and Analysis
- Pivoting and unpivoting data
- Window functions: ROW_NUMBER, RANK, DENSE_RANK
- CTEs (Common Table Expressions)
Database Design and Normalization
- Database design principles
- Normal forms and normalization
- Entity-Relationship (ER) modeling
Performance Tuning and Optimization
- Query optimization techniques
- Execution plans
- Performance tuning best practices
SQL in the Real World
- Integrating SQL with other technologies
- Case studies and real-world scenarios
- Final project: Building a database solution from scratch
Summary and Next Steps
Wymagania
- An understanding of basic computer operations
- Experience with any programming language is beneficial but not required
Audience
- Data analysts
- Database professionals
- Software developers
35 godzin
Opinie uczestników (5)
Ćwiczenia w czasie rzeczywistym razem z trenerem.
Weronika - Urzad Komisji Nadzoru Finansowego
Przekazanie wiedzy na prostych i zrozumiałych przykładach.
Katsiaryna
Szkolenie - SQL language in MSSQL
funkcje analityczne
khusboo dassani - Tech Northwest Skillnet
Szkolenie - SQL Advanced
Przetłumaczone przez sztuczną inteligencję
Sposób nauczania instruktora jest bardzo informacyjny i efektywny,尤其是在第二天话题有点高级时。 （注意：最后一部分翻译似乎已经是中文了，根据指南第5条，当无法翻译且保留意义时，应保持原文不变。但此示例似乎与目标语言波兰语和源语言英语不匹配，请确认是否需要对这部分进行处理或保持原样。） Sposób nauczania instruktora jest bardzo informacyjny i efektywny, szczególnie drugiego dnia, gdy tematy są już trochę zaawansowane.
Aynanie Kiram - Aarki, Inc.
Szkolenie - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
Przetłumaczone przez sztuczną inteligencję
Kwalifikacje Zawodowe Trenera
Rares Serea - eMAG IT Research
Szkolenie - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
Przetłumaczone przez sztuczną inteligencję
