Hivi Technology

Elevate Your Skills with Comprehensive Online Training

sql training in hivi technology

SQL Course Module

Course Module: SQL Fundamentals


Module 1: Introduction to Databases and SQL

  • Overview of Databases and Database Management Systems (DBMS)
  • Introduction to SQL (Structured Query Language)
  • Understanding Relational Databases and their Components
  • Setting Up a Database Environment for Practice


Module 2: Basic SQL Queries

  • Retrieving Data with SELECT Statement
  • Filtering Data with WHERE Clause
  • Sorting Data with ORDER BY Clause
  • Limiting Rows with LIMIT and OFFSET Clauses


Module 3: Working with Tables and Data

  • Creating and Altering Tables
  • Inserting Data into Tables
  • Updating and Deleting Data from Tables
  • Truncating and Dropping Tables


Module 4: Advanced SQL Queries

  • Joining Tables with INNER JOIN, LEFT JOIN, RIGHT JOIN
  • Using Aliases for Table and Column Names
  • Aggregating Data with GROUP BY Clause
  • Filtering Groups with HAVING Clause


Module 5: Subqueries and Derived Tables

  • Understanding Subqueries and their Types
  • Using Subqueries in SELECT, WHERE, and FROM Clauses
  • Working with Derived Tables and Common Table Expressions (CTEs)


Module 6: SQL Functions and Expressions

  • Using Scalar Functions: String, Numeric, Date Functions
  • Aggregating Functions: SUM, AVG, MIN, MAX, COUNT
  • Date and Time Functions for Date Manipulation
  • Conditional Functions: CASE, COALESCE, NULLIF


Module 7: Data Manipulation Language (DML)

  • Understanding INSERT, UPDATE, and DELETE Statements
  • Transaction Management with COMMIT and ROLLBACK
  • Using SAVEPOINTs for Partial Rollbacks
  • Handling Auto-Increment Columns and Identity Columns


Module 8: Data Definition Language (DDL)

  • Creating and Altering Database Objects: Tables, Views, Indexes
  • Managing Constraints: Primary Key, Foreign Key, Unique, Not Null
  • Using Triggers for Automated Actions
  • Working with Sequences and Identity Columns


Module 9: Data Control Language (DCL) and Security

  • Understanding Data Control Language: GRANT and REVOKE
  • Managing User Permissions and Access Control
  • Implementing Row-Level Security and Column-Level Security
  • Best Practices for Database Security


Module 10: Advanced SQL Topics

  • Working with Window Functions and Analytical Functions
  • Using Common Table Expressions (CTEs) for Recursive Queries
  • Query Optimization Techniques: Indexing, Query Plan Analysis
  • Database Administration Tasks: Backups, Restores, Maintenance


Each module will include hands-on exercises, quizzes, and assignments to reinforce learning and practical application of SQL concepts.

  • 1 Month
  • Weekdays : Mon to Fri ( 1hr/day )
  • Weekend: 2hrs/day
  • Flexible Time
  • Free Session Videos
  • Course Completion Certificate
  • Lifetime Customer Support
  • Helping to Get a Job
  • Resume Preparation
Scroll to Top