AI Level 7- Structured Query Language (SQL)

Introduction to DataBase Management System (DBMS)

Introduction to Oracle IDE

Basic Terminologies in SQL

1
Entity
2
Attributes
3
Tuple
4
Constraints
5
Primary Key, Foreign Key, Unique Key

Introduction to Sequential Query Language (SQL)

Data Definition Language (DDL)

1
Create
2
Alter
3
Drop
4
Rename
5
Truncate

Data Manipulation Language (DML)

1
Insert
2
Update
3
Delete

Data Retrieval Language (DRL)

1
Select

Data Control Language (DCL)

1
Grant
2
Revoke

Select

Where

Arithmetic Operations

Conditional Statements

Aggregate Function

1
Min
2
Avg
3
Count
4
Sum
5
Round
6
Trunc

Format

1
Upper
2
Lower
3
Concatenate
4
In
5
Like

Group By

Order By

Join

1
Inner Join
2
Outer Join (Left Join, Right Join)

Set Operations

1
Union
2
Unionall
3
Intersect
4
Minus

Subqueries

Correlated Queries

Views

Over()

Partition by

Lead

Lag

Rollup

Cube

Final Assessment

Live Project

Be the first to add a review.

Please, login to leave a review
AI Level 7- Structured Query Language (SQL)
Price:
₹17,000 ₹16,000