I created this course to help freshers start day career as Oracle DBA. SQL and Unix is really important to start career as Oracle DBA.
In this course I have explain about the basic concept of SQL. this course will help you to get the knowledge about structured query language.
whenever you go for an interview as a fresher Oracle DBA there is a chances that interviewer can expect that you have a knowledge about SQL.
Introduction
1
Prerequisite for SQL Course
Oracle Tables
1
What is Table
2
How to Create Oracle Table
3
SYSTEM Tables and User Created Tables
4
Alter Table in SQL
5
Create Table as select (CTAS)
Oracle Queries
1
Insert Data in Table
2
Select Data from Tables
3
Update Statement Introduction
4
Update Statement Example
5
Fetch Clause SQL
6
drop table
7
Delete Table
Oracle Data Types
1
Data Types
Order Clauses
1
Order By In SQL
2
Distinct in SQL
Oracle Opearator
1
AND Operator
2
OR Operator in SQL
3
Between in SQL
4
IN Operator in SQL
Bonus Lecture
1
Generate Mock Data
Aggregate Function
1
Aggregate Function – Count
2
aggregate Function – Average
3
Aggregate Function – SUM
SQL Transactions
1
Commit in SQL
2
Rollback in SQL
Added few more Videos to SQL Course. Thanks.
Regards,
Ankush Thavali
Mob No - +91 9960262955
Related Courses
New
Unix Course
This course will helpful for the candidate who want to work on oracle dba as well as Unix server. I have explained all the important command relate...
Free
New
FREE Course
Oracle DB is a very responsible job and we must be aware what utilities we are using. In this course I have explained about all the utilities that ...
Free
DBA Training
Ankush sir will take this online live training on schedule date and time. You will get email confirmation regarding same. LearnoMate is the best or...
499 $
399 $