SQL
SQL (Structured Query Language) is the backbone of our education website, facilitating seamless communication with databases. It empowers us to efficiently manage, retrieve, and manipulate data, ensuring dynamic content delivery. Through SQL, we create and optimize queries, enabling users to access and interact with educational resources effortlessly. Its declarative nature streamlines data operations, fostering a robust and responsive learning environment on our platform. Embracing SQL enhances the educational experience by providing a solid foundation for data-driven decision-making and personalized user interactions.
Where it is used?
WHY REPL?
Life time validity (enroll one time and revise many times)
Interaction with the best faculty and Industry Experts
Small Batches to focus on each student
We focus on both theoretical and practical approaches in a parallel way.
You will be given the opportunity to work on a live project.
Outdoor activities to boost your confidence.
Presentation in class by the students.
Our Key Features:
Good Quality Material Notes
Smart Classes Available
Online Test
Chapter wise Assignments
Offline And Online Classes
Recorded class on Rays App
Eminent faculties of the IT Industry( Amazon, Wal-Mart, Oracle, Microsoft..)
Fully AC and Wi-Fi Campus.
Syllabus
SQL
About SQL
Introduction to SQL
Advantages of SQL
Categorization of SQL
Data Definition language (DDL)
Create Command
To create an user
To create a table
Data type
Naming convention of table or column in SQL
Constraint/Restriction in SQL.
(a) null (b) not null (c)unique (d) primary key (e) check
Operators
(a) Relational / Comparison operators
(b) Logical operators
(c) Special operators
Foreign key restriction / constraints
On delete cascade restriction / constraints
Enabling / Disabling constraint
Alter command
Add clause
Add column into an existing table
Add constraints/restriction to an existing column
Drop clause
To drop constraints from an existing column
To drop column from an existing table
Modify clause
Modify a datatype/size of column
Change null type column into not null and vice versa
Drop command
To drop an existing user
To drop an existing table
Truncate command
Rename command
About Buffer command
Data manipulation language (DML)
Insert command
(a) fixed / static method
(b) Dynamic method
Select command
(a) Select command with single table
Renaming column heading in query result
where clause
Operators with select statement
(a)Arithmetic operator
(b)Relational/comparison operator
(c)Logical operator
Special operator
About dual table
About pseudo column
-Level
-Rownum
-Sysdate
-Uid
Accepting a value interactively in query statement
Concatenation in SQL
Set operators with select statement
Aggregate function
Numeric function
Character function
Date function
Group by clause
Having clause
Order by clause
(b)Query based on multiple table
Joining in multiple table query
Types of joining
(i) Equi joinin
(ii) Natural joining
(iii) Self joining
(iv) Outer joining
Subquery / nested query
Types of subquery
>>Subquery introduce with unmodified comparison operator
>>Subquery introduce with
(a) modified comparison operator
(b) in and not in operator
(c) co- related query
>>Subquery introduce with exist or not exist
Delete command
Delete command used in single table
Delete command used in multiple table
Update command
Update command used on a single table
Update used on a multiple table
Data Control language (DCL)
Create Command
Commit command
Rollback command
Grant command
Revoke