📞 91132 45779
in W ✉ 👥 Cuesys Connect BETA
👥
🆕 🆕 Cuesys Connect is Live — Build, Connect & Grow your IT Career!
Connect with SAP professionals • Ask questions • Post jobs • Share tips
Join Community →

SQL & Database Fundamentals

Database Training -- 3 Days | Online / On-site

Home › Courses › SQL & Database Fundamentals
Duration
3 Days
Mode
Online / On-site
Level
Intermediate
Availability
On Demand

Course Overview

Master SQL from basic queries to advanced concepts. Covers joins, subqueries, stored procedures, indexing and performance tuning on MySQL and Oracle.

Course Objectives

  • ✓ Write complex SQL queries with confidence
  • ✓ Optimize slow queries with indexing
  • ✓ Create stored procedures and functions
  • ✓ Design normalized database schemas
  • ✓ Work with MySQL, Oracle and SQL Server

Course Curriculum

📚 Module 1: SQL Foundations +
  • ► Relational database concepts -- tables, keys, constraints
  • ► DDL: CREATE, ALTER, DROP, TRUNCATE
  • ► DML: INSERT, UPDATE, DELETE, MERGE
  • ► DQL: SELECT with WHERE, ORDER BY, GROUP BY
  • ► Aggregate functions: COUNT, SUM, AVG, MIN, MAX
📚 Module 2: Joins & Relationships +
  • ► INNER JOIN -- matching records in both tables
  • ► LEFT, RIGHT and FULL OUTER JOIN
  • ► SELF JOIN and CROSS JOIN use cases
  • ► Joining multiple tables in one query
  • ► Understanding the JOIN execution order
📚 Module 3: Advanced Querying +
  • ► Subqueries -- correlated and non-correlated
  • ► Common Table Expressions (CTEs) with WITH
  • ► Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD
  • ► PIVOT and UNPIVOT for report generation
  • ► Regular expressions in SQL (REGEXP)
📚 Module 4: Stored Procedures & Functions +
  • ► Creating stored procedures with parameters
  • ► IF/ELSE and WHILE loops in SQL
  • ► User-defined functions -- scalar and table-valued
  • ► Cursors -- when and when NOT to use them
  • ► Error handling with TRY/CATCH
📚 Module 5: Database Design & Normalization +
  • ► Entity-relationship (ER) diagrams
  • ► 1NF, 2NF, 3NF and BCNF with examples
  • ► Primary, foreign and composite keys
  • ► Indexes -- clustered vs non-clustered
  • ► Views -- creating and managing
📚 Module 6: Performance & Query Optimization +
  • ► Reading execution plans (EXPLAIN)
  • ► Index strategy -- when to add, when not to
  • ► Query rewriting for performance
  • ► Partitioning large tables
  • ► Database statistics and caching

Enquire About This Course

Who Should Attend

  • ✓Data analysts
  • ✓Developers needing SQL skills
  • ✓Business analysts
  • ✓DBA aspirants

What You Will Gain

  • ★Certificate of Completion
  • ★Expert Trainer
  • ★Online & On-site
  • ★Industry Case Studies

Need more info? Call us!

📞 91132 45779 💬 WhatsApp Us
← Back to All Courses
💬 ▲