New Batch Available Weekday & Weekend Enroll yourself Today

SQL Programming Course

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. best sql classes in pune, best sql courses in karvenagar pune, sql traning in kothrud pune

Pay Fees After Satisfaction With Interview Guidance

Download
Data Warehousing Concepts
Create
Alter
add
modify
rename
drop
Drop
truncate
INSERT
UPDATE
DELETE
MERGE
Function
Max()
Min()
length()
avg()
count()
substr()
sysdate()
instr()
trim()
Column Level Constraint
Table Level Constraints
CASCADING CONSTRAINTS
NOT NULL Constraint
UNIQUE Constraint
PRIMARY KEY Constraint
CHECK Constraint
FOREIGN KEY Constraint
ALTER TABLE with CONSTRAINT
Enabling Constraint
Disabling Constraint
Group Function
Using NVL with group function
HAVING with Group Function
Single Row Subquery
Multiple Row Subquery
Group function using subquery
NOT IN with subquery
Join (Display Data from Multiple Tables)
String Handling
INNERJOIN
LEFTOUTERJOIN
RIGHTOUTERJOIN
EQUIJOIN
NON-EQUIJOIN
SELF Join
Merge
Substitution Variables
Using VERIFY command
Using SET commands
Using Format commands
BREAK Command
Creating VIEW
SIMPLE VIEW
WHERE using View
DML operation using View
FORCE using View
Column Alias using View
GROUP FUNCTION using VIEW
WITH CHECK OPTION using VIEW
Inline View
Creating Sequence, Index, Synonym
How to use Sequence
UNIQUE INDEX
Function Based Indexes
Using SET Operator
UNION
UNION ALL
INTERSECT
MINUS
DISTINCT
Advanced Subqueries
Multiple Column Subqueries
Pairwise Comparison Subquery
Using a Subquery in FROM clause
Using EXISTS operator INSERT
Using EXISTS operator UPDATE
Correlated UPDATE and DELETE
Using WITH clause
Enhancement to the GROUP BY clause
GROUPING using GROUP BY
GROUPING SETS using GROUP BY
Controlling User Access
CREATE TABLESPACE
Privileges in Oracle
CREATE USER
GRANTS
ROLE
Change Password
Object Privileges
WITH GRANT OPTION Keyword
PUBLIC Keyword
REVOKE Object Privileges
Many more..