Adarsh Institute

₹6,500 ₹8,500

Course Includes

Duration45 Days
Enrolled0
Lectures44
Videos0
Notes0
CertificateYes

What you'll learn

A typical SQL (Structured Query Language) course provides a comprehensive guide to managing and manipulating data within relational databases. Courses generally range from beginner to advanced levels, often focusing on practical application through real-world datasets.

Course Syllabus

Introduction To DBMS

DBMS

SQL Commands

Overview Of SQL Commands
Detailed Study Of SQL Command Types (DDL, DML, DCL, TCL)

SQL Fundamentals (Sorting, Filtering, Logical Operators, String Operators)

SQL Basics

Aggregate Functions

Aggregate Functions (Common Aggregate Functions, Group By And Having Clauses, Use Of Coalesce And Other Functions)

Joins (Inner Join, Left Join, Right Join, Full Join, Self Join, Cross Join)

Theoretical Understanding Of Different Types Of Joins
Practical Implementation Of Joins
Practice Exercises On Joins

Case Statements

Working With CASE Statements

Date Functions

Date And Time Functions In SQL

Set Operators

SET Operators (Union, Union All, Intersect, Minus/Except)

Sub Query

Sub Queries (Correlated, Non Correlated)

CTE & View

Common Table Expressions (CTEs) And Views

Window Functions

Rank Functions And Running Total
Lead And Lag Functions, Working With Window Frames

Normalization

Database Normalization

ACID Properties

ACID Properties In Database

Query Optimization

Query Optimization Techniques (Indexing, Other Optimization Strategies)

Advanced Topics (Bonus)

Import And Export ERD
Users & Privileges
Locking And Unlocking Tables
Variables
Stored Procedures

Final Project: Ecommerce Store -- Insights And Analytics

General Sales Insights
Customer Insights
Product And Order Insights
Temporal Trends, Regional Insights, Return And Refund

Course Fees

₹8500/-

Discounted Fees

₹ 6500/-

Course Duration

45 Days

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

CERTIFICATE In SQL(S-S-4350)