Oracle SQL Complete from zero level

Focused View

panditi malhotra

3:47:39

100 View

1 - Introduction

1 - Data Definition Language.mp4

12:39

2 - Alter Table.mp4

44:06

3 - Data Manipulation Language Insert Command.mp4

18:18

4 - Unconditional Insert By using INSERT ALL.mp4

18:31

5 - Conditional Insert By Using INSERT ALL.mp4

06:00

6 - Conditional Insert by using INSERT FIRST.mp4

07:53

7 - Select Statement.mp4

41:39

8 - Group by Clause.mp4

22:59

9 - Having Clause And Order By Clause.mp4

19:05

9 - class-9-Having-Clause-and-Order-By-Clause-Notes.docx

2 - Constraints

10 - Not Null Constraint and CHECK Constraint.mp4

36:29

10 - class-10-SQL-Constraints-not-null-and-check.docx

Description

Oracle SQL Course from Scratch .Some other videos needs to be updated .Soon we will complete

What You'll Learn?

Oracle SQL Language

Who is this for?

Oracle apps,oracle developers,power bi,data sceince,snowflake

More details

Description

Main Topics
1) SQl Language types
1.DDL â€“ Data Definition Language
create,alter,drop,rename,truncate,comment
2.DML â€“ Data Manipulation Language
select,insert,update,delete,merge,call,explain plan,lock table
3.DCL â€“ Data Control Language
grant ,revoke
4. DTCL- Data Query Language
commit,rollback,save point
2.SQL Constraints
3.Functions
Single row functions
Group functions
4) Analytical functions
rank,dense rank,lead,lag,first value,last value
5) joins
6) Set operators
ïƒ˜ Numeric functions
ïƒ˜ character functions
ïƒ˜ Date functions
ïƒ˜ Miscellaneous functions
ïƒ˜ Conversion functions

7) Subquery
8) corelated subquery
9)Pseudo columns
rowid,rownum,nextval,curval,level
10)synonyms
11) views
12)materialized views
Oracle is currently the most popular relational database management system in the world. It is used by thousands of big companies who are usually willing to pay good salaries to the right people, which includes those with practical Oracle SQL knowledge that is based on best practices and experience.
Most SQL courses give you theoretical SQL knowledge. In this course, you will learn by actually writing code.
Learn Oracle SQL in a practical and smart way and jump-start your career as an Oracle SQL developer:
Requirements
No prior Oracle SQL knowledge is required. You will learn Oracle SQL from scratch (if that is what you need).
You should have a real desire to learn Oracle SQL and time to watch the lectures and practice the concepts as suggested by the instructor.
Who this course is for:
Aspiring application or database developers looking to acquire solid SQL knowledge to improve their careers.
College/University students who need SQL knowledge to pass their database-related courses.
Anyone with only basic SQL knowledge wanting to solidify their skill and use the language with confidence.
This course is not for you if you are already an experienced Oracle SQL developer looking to learn the most advanced features of the language.
This course is not for you if you are looking for a theoretical course.
Who this course is for:
Oracle apps,oracle developers,power bi,data sceince,snowflake

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

panditi malhotra

Instructor's Courses

Hi My name is panditi malhotra working as oracle apps technical consultant since last 15 years. Majorly worked in supply chain managment and finance modules and taught course for 88 batches offline. Nearly 4000 candidates taken course since institute establishment.Thank you for your interest in my courses, and in me as an instructor. Have a great learning .Thank you .

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.