コース概要
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
要求
- An understanding of basic computer operations
- Experience with any programming language is beneficial but not required
Audience
- Data analysts
- Database professionals
- Software developers
お客様の声 (9)
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
コース - Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
コース - Oracle 11g - SQL language for developers - Workshop
トレーニングでは、2日間にわたってすべてのモジュールが詳細にカバーされた。
Bernadetta - Urząd Komisji Nadzoru Finansowego
コース - SQL Advanced
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
コース - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
コース - 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
コース - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
Folio さんの幅広い知識に感謝しました。彼はコースの内容に精通しているだけでなく、例を私たちにとってより意味のあるものにするために、私たちが使い慣れている言語の構文についても知っていました。合間に彼は、トレーニングの範囲外のテクノロジーやソリューションに関する知識を共有し、将来 (および将来のトレーニング) で使用できる他のソリューションについての洞察を提供しました。
Raphael - Markit Valuations Limited
コース - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Machine Translated
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
コース - ORACLE PL/SQL Fundamentals
演習は楽しく、トピックもうまく紹介されていました。
Adrian-Madalin Chirita - DB Global Technology SRL
コース - Oracle SQL Advanced
Machine Translated