HomeCourse Details

Database Fundamentals (SQL)

Learn how data is stored, retrieved, and managed. Master SQL queries to interact with relational databases effectively.

Back to All Courses

Syllabus

Database Fundamentals (SQL) Course

  • Database Concepts

    • What is a Database?
    • RDBMS vs NoSQL
    • Tables, Rows, and Columns

  • Setup & Installation

    • Installing MySQL / PostgreSQL
    • Understanding Database Clients (DBeaver, pgAdmin)

  • Data Definition Language (DDL)

    • CREATE TABLE
    • ALTER TABLE
    • DROP TABLE

  • Data Manipulation Language (DML)

    • INSERT INTO
    • SELECT queries
    • UPDATE and DELETE statements

  • Data Filtering

    • WHERE clause
    • AND, OR, NOT operators
    • LIKE and IN operators

  • Aggregate Functions

    • COUNT, SUM, AVG
    • MIN, MAX
    • GROUP BY and HAVING clauses

  • Connecting Data

    • Primary Keys and Foreign Keys
    • INNER JOIN
    • LEFT, RIGHT, and FULL OUTER JOIN

  • Advanced Concepts

    • Subqueries
    • Database Normalization (1NF, 2NF, 3NF)
    • Entity-Relationship (ER) Diagrams
Database Fundamentals (SQL)

Course Details

  • Duration1 Month
  • LevelBeginner
  • Price₹8,000
  • Enrolled110+ Students

Skills Covered:

Relational DatabasesCRUD OperationsJoins & SubqueriesDatabase NormalizationPostgreSQL / MySQL
Contact Us

Previous Course

Web Development Basics

Next Course

API Development & Integration