SQL

Learn Sql Classes and courses in vizag & PMC from top training institutes and get, Sql certification. SQL (pronounced “ess-que-el”) stands for Structured Query Language. Sql Online and Offline Courses. sql training in vizag.

For whom SQL is?

IT or NON IT people can easily enter into leading Database Oracle-sql Training Classes in Vizag. Technology which is commonly used for all domain application software as back-end in it Company.  On completion Oracle SQL training you can attempt certification exam. Certified candidate can take benefit as IT document and can get good opportunity in IT world. Oracle SQL is easy for any support project for initial stage which get into IT carrier. In case you want to grow for development environment than it’s entry for programming. Now a days SQL is basic skill set for any IT/NON IT folks, It’s always helpful for any functional, support and technical consultant. it’s very usefull on support,banking Domain ,sql classes in narhe vizag,sql classes in vizag,sql classes in vizag.

DDL and DML

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()
lpad()
replace()
translate()

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

VIEW

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

 

 

Open chat
Powered by