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
Opinie uczestników (10)
wiedza i przekłady
Jan Maksymowski
Szkolenie - Oracle 11g - Język SQL dla administratorów - warsztaty
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Szkolenie - Oracle 11g - SQL language for developers - Workshop
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Szkolenie - Oracle 11g - Programowanie w PL/SQL I - warsztaty
Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Szkolenie - SQL Advanced
Przetłumaczone przez sztuczną inteligencję
To było najlepsze szkolenie zdalne na którym byłam. Mimo, że trener nie nawiązywał na siłe kontaktu z uczestnikami, ani nie spoufalał się w celu zdobycia atencji, nieustannie zdobywał moją uwagę. Poziom merytoryczny baaaardzo wysoki. :)
Wioleta Angielczyk - Urząd Komisji Nadzoru Finansowego
Szkolenie - Master Data Services - Wprowadzenie
Lot of content and exactly the requested one.
Pascal - Diehl
Szkolenie - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Szkolenie - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Szkolenie - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael - Markit Valuations Limited
Szkolenie - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
All the various ways Darius explained concepts and then put them into our database tables.