Home
About Us
Gallery
Blogs
Google Us
Our Courses
CAD Courses
Rhino 3D Modeling & Visualization
AutoCAD – Professional Drafting & Design
3ds Max and Corona Mastery
BIM Design & Modeling – Revit
Architectural Design & Visualization Mastery
Master SketchUp & V-Ray
Programming Courses
C Programming
C++ Programming
Core Java Programming
Core Coding Skills for Beginners
Python Programming
DSA with Python
Data Structures & Algorithms
Graphic Designing Courses
Graphic Design & Video Editing
Mastering Graphic Design
Professional Photo Editing
Illustrator – Master Vector Graphics
Motion Graphics & Visual Effects
Professional Video Editing
Social Media & Marketing Design
CorelDraw Training
Mockup Design – Product Visualization
Skill Development Courses
Digital Literacy Course
Professional Advanced Excel Course
Financial Accounting with TallyPrime
Digital Explorers – Age Group 10-12 years
Tech Innovators – Aged 13 & Above
Web Technologies
Full Stack Web Development
AngularJS Course
Back-End Web Development Course
Modern Front-End Web Development
Complete JavaScript Course
HTML, CSS & Bootstrap for Beginners
WordPress-Website Development Without Coding
PHP-MySQL Training
Laravel Course – Master PHP Framework
React.js Training
SQL – Database Management
Data Science Courses
Data Analysis
Power BI Course
Professional Digital Marketing Course
Student Corner
Book Demo Class
Verify Certificates
Student Projects
Fee Payment
Student Reviews
Shopping cart
+91 74900 08464
Mon - Fri: 09:00 AM - 08:00 PM
Follow Us:
Login / Register
Home
About Us
Gallery
Blogs
Google Us
Our Courses
CAD Courses
Rhino 3D Modeling & Visualization
AutoCAD – Professional Drafting & Design
3ds Max and Corona Mastery
BIM Design & Modeling – Revit
Architectural Design & Visualization Mastery
Master SketchUp & V-Ray
Programming Courses
C Programming
C++ Programming
Core Java Programming
Core Coding Skills for Beginners
Python Programming
DSA with Python
Data Structures & Algorithms
Graphic Designing Courses
Graphic Design & Video Editing
Mastering Graphic Design
Professional Photo Editing
Illustrator – Master Vector Graphics
Motion Graphics & Visual Effects
Professional Video Editing
Social Media & Marketing Design
CorelDraw Training
Mockup Design – Product Visualization
Skill Development Courses
Digital Literacy Course
Professional Advanced Excel Course
Financial Accounting with TallyPrime
Digital Explorers – Age Group 10-12 years
Tech Innovators – Aged 13 & Above
Web Technologies
Full Stack Web Development
AngularJS Course
Back-End Web Development Course
Modern Front-End Web Development
Complete JavaScript Course
HTML, CSS & Bootstrap for Beginners
WordPress-Website Development Without Coding
PHP-MySQL Training
Laravel Course – Master PHP Framework
React.js Training
SQL – Database Management
Data Science Courses
Data Analysis
Power BI Course
Professional Digital Marketing Course
Student Corner
Book Demo Class
Verify Certificates
Student Projects
Fee Payment
Student Reviews
Contact Us
Home
Web Technologies
SQL Course – Master Database Management
SQL Course – Master Database Management
Curriculum
13 Sections
43 Lessons
13 Days
Expand all sections
Collapse all sections
➢ Introduction to Databases & SQL Basics
6
1.1
What is SQL?
1.2
Overview of Relational Databases
1.3
SQL syntax and structure
1.4
Basic SQL commands: CREATE, INSERT, SELECT
1.5
SQL data types: Integer, String, Date, etc.
1.6
Basic query structure and examples
➢ Filtering Data with WHERE and Operators
6
2.1
Using the WHERE clause for filtering
2.2
Comparison operators (>, <, =, !=, etc.)
2.3
Logical Operators: AND, OR, NOT
2.4
Pattern matching with LIKE
2.5
Using IN, BETWEEN, and IS NULL
2.6
Case-insensitive search
➢ Data Manipulation (INSERT, UPDATE, DELETE)
5
3.1
Inserting Data (INSERT INTO)
3.2
Updating Data (UPDATE)
3.3
Deleting Data (DELETE)
3.4
Difference between DELETE and TRUNCATE
3.5
Using WHERE to restrict data manipulation
➢ Sorting and Limiting Results
3
4.1
Using ORDER BY
4.2
Sorting in ascending/descending order
4.3
Use of LIMIT
➢ Aggregating Data with Aggregate Functions
4
5.1
Aggregate functions: COUNT, SUM, AVG, MIN, MAX
5.2
Using GROUP BY
5.3
HAVING clause (filtering grouped data)
5.4
Combining aggregates in complex queries
➢ Constraints, Keys, and Table Design
4
6.1
Creating tables with CREATE TABLE
6.2
Primary Key, Foreign Key, Unique, NOT NULL constraints
6.3
ALTER TABLE: Adding/Removing columns, constraints
6.4
Composite keys and indexing considerations
➢ Joins (Part 1)
3
7.1
Introduction to Joins
7.2
INNER JOIN
7.3
LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
➢ Joins (Part 2)
2
8.1
Join conditions
8.2
Using JOIN with multiple tables
➢ Subqueries or Nested Queries
4
9.1
Introduction to subqueries
9.2
Subqueries in SELECT, WHERE, and FROM clauses
9.3
Correlated subqueries
9.4
Using subqueries with aggregate functions
➢ Views of tables
3
10.1
What are Views?
10.2
Creating, updating, and deleting Views
10.3
Using Views to simplify complex queries
➢ Wildcard Characters
1
11.1
Use of (% , _ , LIKE , NOT LIKE )
➢ Miscellaneous Examples
1
12.1
Miscellaneous Examples
➢ Final Assignment
1
13.1
Execute queries based on a real dataset
This content is protected, please
login
and
enroll
in the course to view this content!
×
Modal title
Main Content