تحليل البيانات

SQL Program

SQL is the common language for retrieving and managing data in relational databases used by ERP, CRM and government systems. This practical programme takes participants from basic queries to production-quality work: SELECT, filtering and sorting, joins across multiple tables, aggregation and grouping, subqueries and common table expressions, window functions for ranking and running totals, data modification, table design with keys and constraints, views, indexes and transactions, and query performance basics.

الحصول على الكتيب

للحصول على كتيب بكامل محتويات الدورة برجاء ملء النموذج التالي ببياناتك الصحيحة

تحميل الكتيب

دورات مشابهة
تحليل البيانات

IIBA Endorsed Certified Data Analyst

يوليو
، 2027
الإنجليزية
دبي
$3,600.00
اعرف المزيد
تحليل البيانات

Business Intelligence: Data Analysis and Reporting Techniques

أكتوبر
، 2027
الإنجليزية
جورجيا
$4,500.00
اعرف المزيد
تحليل البيانات

Power BI: Data Visualization and Dashboards

نوفمبر
، 2027
الإنجليزية
أمستردام
$4,900.00
اعرف المزيد
تحليل البيانات

مهارات تحليل البيانات باستخدام Excel وPower BI

يونيو
، 2027
العربية
الكويت
$3,600.00
اعرف المزيد
ديسمبر
، 2027
الإنجليزية
أبو ظبي
$3,600.00
NEVADA | PROFESSIONAL EXPERIENCE

Program Professional Framework

SQL Program

Program Overview

SQL is the common language for retrieving and managing data in relational databases used by ERP, CRM and government systems. This practical programme takes participants from basic queries to production-quality work: SELECT, filtering and sorting, joins across multiple tables, aggregation and grouping, subqueries and common table expressions, window functions for ranking and running totals, data modification, table design with keys and constraints, views, indexes and transactions, and query performance basics.

Learning Outcomes

  • ✓Write SELECT queries with filtering, sorting and calculated columns against a relational database.
  • ✓Combine tables using inner, left and self joins and explain the effect of each on result rows.
  • ✓Summarise data with GROUP BY, HAVING and aggregate functions.
  • ✓Use subqueries, CTEs and window functions for ranking, running totals and period comparisons.
  • ✓Create tables with primary keys, foreign keys and constraints and modify data safely within transactions.
  • ✓Improve slow queries by reading execution plans and applying suitable indexes.

Target Audience

  • Data and reporting analysts
  • Junior database developers and administrators
  • Application support specialists
  • BI developers who need direct database access

Detailed Program Modules

01Relational Database Concepts
  • Tables, keys and relationships
  • Normalisation basics
  • Database tools and query editors
02Querying Single Tables
  • SELECT, WHERE and ORDER BY
  • Operators, NULL handling and CASE
  • String, date and numeric functions
03Joins and Aggregation
  • Inner, outer and self joins
  • GROUP BY and HAVING
  • Set operations
04Advanced Querying
  • Subqueries and CTEs
  • Window functions
  • Pivoting and reporting queries
05Data Definition and Modification
  • CREATE and ALTER TABLE with constraints
  • INSERT, UPDATE, DELETE and MERGE
  • Transactions and data integrity
06Views, Indexes and Performance
  • Views and stored procedures
  • Indexing strategies
  • Reading execution plans

Training Methodology

Interactive expert-led sessions grounded in workplace examples
Case studies and practical exercises drawn from the region
Group workshops with peer review of decisions and deliverables
Formative feedback against clear performance criteria

Applied Project & Assessment

Applied Project

Participants design a small database for a service request process, load sample data and write a set of analytical queries covering joins, aggregation, CTEs and window functions, plus a view and index set that supports a monthly performance report.

Assessment

Short diagnostic at the start, practical tasks linked to each learning outcome, and evaluation of the applied project against published criteria.