Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great Learning

With the amount of data increasing exponentially by the day, its management becomes extremely crucial, and that's where SQL enters! Data in its raw form is more often than not incomprehensible and requires to be organized to be made sense of. SQL involves the organization, manipulation, retrieval and storage of data in relational databases. Here is the Oracle SQL Tutorial For Beginners to help you take that first step to learn SQL right from scratch! Technology is taking the world by storm, and a variety of its disciplines have evolved in this era of information! One such field is Structured Query Language, better known in its abbreviated form SQL, a programming language used to manage data in Database Management Systems.

🏁 Topics Covered:
00:01:25 Agenda
00:05:20 Introduction
00:21:42 Creation of Table
00:29:59 Oracle Setup and Installation
00:48:38 Relational Model
01:00:03 Miscellaneous topics
01:19:53 Operators as keywords
01:30:22 Functions
01:44:21 Clauses
01:57:55 Nested Query
02:09:25 Joins
02:48:55 SQL Commands
03:14:36 Database Objects
03:26:13 Summary

🔥 Free SQL Courses With Free Certificates:

⚡ About Great Learning Academy:

⚡ About Great Learning:
With more than 5.4 Million+ learners in 170+ countries, Great Learning, a part of the BYJU'S group, is a leading global edtech company for professional and higher education offering industry-relevant programs in the blended, classroom, and purely online modes across technology, data and business domains. These programs are developed in collaboration with the top institutions like Stanford Executive Education, MIT Professional Education, The University of Texas at Austin, NUS, IIT Madras, IIT Bombay & more.

#oraclesql #oracledatabase #oracledatabasetutorial

[greatlearning]

🔹Topics Covered
00:01:25 Agenda
00:05:20 Introduction
00:21:42 Creation of Table
00:29:59 Oracle Setup and Installation
00:48:38 Relational Model
01:00:03 Miscellaneous topics
01:19:53 Operators as keywords
01:30:22 Functions
01:44:21 Clauses
01:57:55 Nested Query
02:09:25 Joins
02:48:55 SQL Commands
03:14:36 Database Objects
03:26:13 Summary

[prisinha]

Learners please thumbs up Quick Reference Guide for this Oracle Tutorial

01:25 Agenda
05:20 Introduction
17:30 DBMS fields and values
19:00 field names become column names of table
21:30 values become rows of table
22:22 Query CREATE TABLE
27:07 INSERT INTO
00:29:59 Oracle Setup and Installation
35:00 password for both SYS and SYSTEM
36:22 initial error
37:00 correction of initial error
38:00 Application Express
38:18 Create Workspace
39:29 SQL Workshop
41:00 SQL Workshop - Object Browser - repo for all Tables - Tables - Tables Name - Table schema - Data - indexes - Model - Constraints - Grants - Statistics - UI Defaults - Triggers - Dependencies - SQL
43:13 SQL Workshop - Create Object - Select Object Type - Table - View - Index - Sequence - Type - Package - Procedure - Function -
46:56 Tables - click on Table name - Data - Insert Row
48:38 Relational Model
53:00 keywords
57:47 Foreign Key
1:00:35 Projection
1:02:44 Selection
1:04:22 Case Sensitivity is only applicable for values in Rows or Records or Tuples
1:07:37 Data Types
1:08:18 Difference between varchar and varchar2
1:09:19 NUMBER data type has p which stands for Precision and s for Scale
1:10:00 Date
1:10:10 Operators
1:13:10 Precedence of Operators
1:17:44 Dual Table
1:18:48 DESC TableName shows Description of Table
1:22:00 Precedence of Relational Operators
1:22:44 BETWEEN AND
1:23:23 NOT BETWEEN AND
1:24:24 in operator
1:25:25 LIKE
1:27:07 percentage sign means zero or more characters
1:27:27 underscore means single character
1:28:08 IS NULL operator
1:29:00 Logical Operator
1:30:30 Functions
1:37:00 LPAD vs RPAD
1:38:00 ROUND vs TRUNC
1:39:00 NVL
1:39:25 NVL2
1:39:55 month_between two date
1:40:25 ADD_MONTHS
1:40:44 NEXT_DAY
1:41:06 NULLIF
1:42:00 TO_CHAR is used to format
1:43:17 COUNT
1:44:22 CLAUSES
1:46:46 ORDER BY clause in ascending order puts NULL values at last rows of a column
1:46:56 GROUP BY clause
1:52:30 difference between GROUP BY clause and HAVING clause 1:55:11 AGGREGATE functions can NOT be used after WHERE clause and therefore HAVING clause is used
1:54:14 HAVING example
1:56:30 sequence of clauses
1:57:57 NESTED Query
2:05:55 Match values from Column of Nested Query
2:09:30 Joins
2:14:07 Types of Joins
2:17:21 inner join
2:21:07 Left Join
2:24:11 Right Join
2:27:55 Full Join
2:32:00 NATURAL Join
2:35:15 CROSS join
2:38:13 SELF Join
2:43:43 Select from multiple tables without join
2:44:34 Join multiple tables with conditions
2:45:45 join 3 tables
2:49:00 SQL commands
2:49:19 C of CRUD in DDL and UD of CRUD in DML
2:50:00 DDL applicable on Table
2:57:27 DROP vs TRUNCATE
2:58:58 DML
3:02:02 DELETE vs TRUNCATE
3:02:40 DCL
3:07:14 DCL Revoke
3:08:08 List Users in Oracle DB
3:09:29 TCL COMMIT
3:11:11 TCL ROLLBACK
3:14:36 DB Objects - Table - View - Sequence - index - Synonym
3:12:12 ROLL BACK TO SAVE POINT nameofSavepoint
3:17:13 VIEW
3:19:23 SEQUENCE
3:20:10 cycle vs nocycle
3:20:55 usage of Sequence in example
3:21:44 index - single - multiple - unique
3:22:22 create unique index nameOfindex
3:23:23 when indexes are not used
3:24:14 table containing indexes
3:24:40 Synonym
3:25:25 Synonym is temporary

[abhayashta]

Great explanation, it covered 7 weeks of my college's sql lectures in just 4 hours. Really helped me alot, all thanks to this guy.👍🏻

[vaishnavijain]

literally the best video on sql.... covering every imp and basic topics with lots of example....thanks

[rajasreeramisetty]

Excellent teaching skills with very great explanation and examples!!!Thankyou for the Video!!!

[ssekhar]

Thank you for making my IT journey so easy


I’ll keep in my mind who helped me at my struggling times after I became successful

[MsBcarolina]

You are very talented. You have structured all the subjects in a very simple way to introduce us to the sophisticated topic. Extraordinary method!

[prisinha]

1:52:30 difference between GROUP BY clause and HAVING clause 1:55:11 AGGREGATE functions can NOT be used after WHERE clause and therefore HAVING clause is used

[SachinSingh-rpmg]

This a perfect lecture for the beginners... if you still don't understand don't panic just try it again and again you will understand for sure.. all the best to everyone.

[kowsikap]

Very clear explanation sir. Thank you so much for this full tutorial ✨✨

[sreyag]

It is one of the best courses available on youtube. If you are a beginner, then you go for it! I am also learning from this channel. neat way of explanation.

[maheshsurwase]

Thank you so much for teaching in very easy way.... I understood all the SQL topics now

[axnkamen]

Thanks man...cause of you ..i revised my most of topics...well explained and done ✌️✌️🔥

[fazalkarim]

Ritwik, I have gone through this tutorial. You have completed all content for beginners. Many thanks for this course

[amruthaa]

Thanks for you clear video about oracle Ritwik, it will be very useful to the beginner .

[leomacdon]

Thank you. You explain everything more than my college teacher. Appreciate 👍

[chinthakagamage]

Great. Im a mechanical engineer. I didn't know anything on Oracle or even IT. U relieved me lot today as i'm looking for a new journey in the platform.

[rahuldalvi]

Excellent! Can you please explain the topic Constraints in SQL that you have not covered in this session?

[sushilvashishth]

Very neat and clean, very informative, very well explained. Thanks a ton.

[tesss_tequila]

A very interactive lesson.. thanks so much