Home
Videos uploaded by user “Crazy4 DB”
What is RDBMS - RDBMS Tutorial - Relational Database Management System - Relational Data Model
 
16:44
What is RDBMS? What is Relational Data Model in DBMS? This RDBMS tutorial brings DBMS basics for beginners. This DBMS concepts tutorial explains you everything right from definition of data to relational data model. #dbmsforbeginners,#dbms, #crazy4db Other video of interest - SQL vs NoSQL : https://youtu.be/D2T8CDooCwc SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 SQL Turotial Part 2 : https://youtu.be/cze26lOEYz8 sQL Tutorial Part 1 : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk Facebook Page : https://www.facebook.com/crazy4db
Views: 1020 Crazy4 DB
SQL Introduction for Beginners - Learn SQL for Beginners - SQL Crash Course for Interview
 
17:24
SQL tutorial for beginners : in this lesson we study the concept of NULL and how to deal with the NULL in the SQL. The operators IS or IS NOT, and functions NVL NVL2 and Coalesce. SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL vs NoSQL : https://youtu.be/D2T8CDooCwc SQL Tutorial - LIKE, DISTINCT, ORDER BY clauses : https://youtu.be/cze26lOEYz8 sQL Tutorial - AND, OR, NOT, IN, BETWEEN : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db #sqldbms,#sql, #crazy4db, #LearnSQL,#SQLTutorial, #MunshiSir
Views: 213 Crazy4 DB
NoSQL vs SQL - NoSQL vs RDBMS - SQL vs NoSQL - What is NoSQL Database
 
21:17
SQL vs NoSQL lesson is about differences between two databases of RDBMS versus Document type databases with reference to Oracle as RDBMS and MongoDB as document type NoSQL database. It will also answer the questions like if NoSQL will completely make the RDBMS and SQL obsolete and the basis for selection between SQL and NoSQL databases. You may also visit video of "DBMS basics", the link of which has been provided below to learn details about different models of the databases including relational and document models. SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL NVL, NVL2, Coalsece, handle null values : https://youtu.be/y45AEBbvf_0 SQL LIKe, DISTINCT, ORDER BY clauses : https://youtu.be/cze26lOEYz8 sQL Basics - AND,OR,IN,BETWEEN operators : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db #nosql,#sqldbms, #crazy4db, #sql,#LearnSQL,#SQLTutorial, #MunshiSir
Views: 421 Crazy4 DB
SQL delete vs truncate - delete and truncate difference - SQL delete vs truncate vs drop
 
19:22
SQL delete vs truncate is always a regular question asked in the interviews. Delete and Truncate difference has been explained with examples in this video. #deletevstruncate #SQLtruncate #crazy4b #SQLdelete A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 272 Crazy4 DB
Initially Deferred Constraint | Deferrable Constraint in Oracle | Deferred Constraints Oracle
 
17:59
Initially deferred constraints are required in special situations where the constraint checking is required to be delayed until the commit.Deferrable constraint in Oracle has been demonstrated here. The video contains example on deferred constraint using the case of storing the data of two employees in relationship as husband and spouse #IntegrityConstraints #LearnSQL #Crazy4DB #SQLBasics #MunshiSir #DBMSBasics #BasicSQL #Constraints Interview Questions : (1) What is the normal mode of data integrity checking? What does it mean? (2) What are the two options for delaying the integrity verification of the data to the transaction level? DBMS Keys Tutorial : https://youtu.be/DLrCop3-I2M Integrity Constraint Part 1 Video : https://youtu.be/MaZIN_MVFY8 Integrity Constraint Part 2 Video : https://youtu.be/dLzuFmFiHxk Integrity Constraint Part 3 Video : https://youtu.be/l6C-gmIaswA My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 122 Crazy4 DB
PL SQL Triggers - Triggers in Oracle - Triggers in DBMS - What are triggers in Oracle
 
18:34
What are triggers? This video brings introduction to PL SQL Triggers. Triggers in Oracle are implicitly executing program in response to a triggering event. Triggers are used in DBMS for performing some data validations which are not possible through integrity constraints. If you would like to support this channel then visit this link for more details : https://www.patreon.com/crazy4db #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : trigger predicates : https://youtu.be/bG9hPV_hzNU DML Triggers : https://youtu.be/D71vWBZMqIk For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ For Views : https://youtu.be/K_NaE5q9yPU My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 230 Crazy4 DB
Oracle SQL - SQL Introduction - Learn SQL - Oracle SQL Tutorial - SQL Queries - SQL Queries Examples
 
23:15
A basic Oracle SQL tutorial brings SQL introduction for beginners with live screen lab presentation. Viewers will be able learn SQL with these practical sessions. Here we are studying SQL queries examples using AND, OR, NOT, BETWEEN operators #sqldbms,#sql, #crazy4db, #LearnSQL,#SQLTutorial, #MunshiSir SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL vs NoSQL : https://youtu.be/D2T8CDooCwc SQL for Beginners Part 2 : https://youtu.be/cze26lOEYz8 SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 Relational Algebra Link : https://youtu.be/wNaX1a5Kc48 RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk
Views: 578 Crazy4 DB
SQL group functions - SQL group by clause - SQL aggregate functions - SQL having clause
 
21:15
This video brings examples and explanation on SQL group functions which are same as SQL aggregate functions . Group by is an important clause as you use group functions. Having clause is used for comparison of group functions with a value in a condition. #SQLGroupBy #GroupFunctions #Crazy4DB #MunshiSir #LearnSQL #BasicSQL Problem to solve : Please solve the query of listing rows of employees who are getting less salary than the average salary of their own department by using in-line view. Interview Question : How the avg function is used to find the average over all the rows in the group if the referenced column may contain NULL values. Subquries explained : https://youtu.be/a69CaAru1aU Predicate explained : https://youtu.be/vOvsI8nMD-c A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 57 Crazy4 DB
Normalization in DBMS : Normalization - Normalization in Database with Example - Normal Forms
 
24:57
This video explains normalization 1nf 2nf 3nf with example. Database normalization is dune up to first normal form, second normal form and third normal form in the real time environment. The video also has explanation on bcnf normalization example. #dbmsforbeginners,#dbms, #crazy4db DBMS Keys Tutorial : https://youtu.be/DLrCop3-I2M SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 SQL Turotial Part 2 : https://youtu.be/cze26lOEYz8 SQL Tutorial Part 1 : https://youtu.be/vOvsI8nMD-c Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db
Views: 1197 Crazy4 DB
Subquery in Oracle - Correlated subquery in SQL - Oracle subqueries - NULL subquery in SQL
 
35:18
SQL subqueries or SQL nested queries are the queries used within other SQL Queries. SQL subqueries is a great technique to be mastered with all its benefits and limitations. SQL Subqueries, SQL Subqueries Tutorial, SQL Subqueries Explained with Examples, SQL Subquery Examples #subqueries, #sql, #crazy4db, #LearnSQL, #MunshiSir, #Oracle SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL Tutorial - NVL, NVL2, Coalesce, Handle NULL in SQL : https://youtu.be/y45AEBbvf_0 SQL Turotial - LIKE, DISTINCT, ORDER BY clauses : https://youtu.be/cze26lOEYz8 sQL Tutorial - IN, BETWEEN, AND, OR, NOT operators : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db
Views: 977 Crazy4 DB
PL/SQL Conditional Statements Example - Case Statements in PL SQL - If Then Else in PL SQL
 
28:58
Conditional statements are important in any language and so they are important in Oracle PL/SQL language also. They allow conditional execution of lines of code. #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Videos to visit : PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss Code for complex programs of this video : If-then-elsif-then-else-end if; Problem : Calculate salary with formula salary = basic + allowance under following terms - (1) basic can not be less than 1800 and more than 10,000 (2) basic between 1800 and 3000 allownace is 120% of basic (3) basic above 3000 and up to 5000 allowance rate 130% of basic (4) basic above 5000 and up to 7000 allowance rate 140% of basic (5) basic above 7000 allowance rate is 150% Input to the program is basic Output print : basic, calculated allowance, and salary = basic + allowance declare basic number; salary number; allow number; minbas number := 1800; maxbas number := 10000; baslim1 number := 3000; baslim2 number := 5000; baslim3 number := 7000; allow1 number := 120; allow2 number := 130; allow3 number := 140; allow4 number := 150; invalid exception; begin basic := '&basic'; if basic [less than] minbas or basic [greater than] maxbas then raise invalid; elsif basic between minbas and baslim1 then allow := basic * allow1/100; elsif basic [greater than] baslim1 and basic [less than equal] baslim2 then allow := basic * allow2/100; elsif basic [greater than] baslim2 and basic [less than equal] baslim3 then allow := basic * allow3/100; else allow := basic * allow4/100; end if; salary := basic + allow; dbms_output.put_line('Basic : '||basic); dbms_output.put_line('Allowance : '||allow); dbms_output.put_line('salary : '||salary); exception when value_error then dbms_output.put_line('basic has to be number'); when invalid then dbms_output.put_line('basic must be in valid range'); end; CASE control structure ========================================================== Case was introduced in oracle 9i. It is equivalent to if-elsif structure demonstrated above, but simplifies it by taking expression only for once, in normal use but tests the evaluation of expression with value for equality. Problem : consider a school which has alternate day half day and weekly off on Sunday. We want to display the name of the day and if it is half day or full day or holiday. The input is numeric week day, with 1 as Sunday. declare daynum number(1); err exception; begin daynum := '&DayNumber'; if daynum [less than] 1 or daynum [greater than] 7 then raise err; end if; case daynum when 1 then dbms_output.put_line('it is Sunday : weekly off'); when 2 then dbms_output.put_line('it is Monday : Full Day'); when 3 then dbms_output.put_line('it is Tuesday : Half Day'); when 4 then dbms_output.put_line('it is Wednesday : Full Day'); when 5 then dbms_output.put_line('it is Thursday : Half Day'); when 6 then dbms_output.put_line('it is Friday : Full Day'); else dbms_output.put_line('it is Saturday : Half Day'); End case; exception when err then dbms_output.put_line('numeric week day 1 to 7 only accepted'); when value_error then dbms_output.put_line('input must be between 1 to 7 only'); end; CASE in Searched form declare basic number; salary number; allow number; minbas number := 1800; maxbas number := 10000; baslim1 number := 3000; baslim2 number := 5000; baslim3 number := 7000; allow1 number := 120; allow2 number := 130; allow3 number := 140; allow4 number := 150; invalid exception; begin basic := '&basic'; CASE when basic [less than] minbas or basic [greater than] maxbas then raise invalid; when basic between minbas and baslim1 then allow := basic * allow1/100; when basic [greater than] baslim1 and basic [less than equal] baslim2 then allow := basic * allow2/100; when basic [greater than] baslim2 and basic [less than equal] baslim3 then allow := basic * allow3/100; else allow := basic * allow4/100; end case; salary := basic + allow; dbms_output.put_line('Basic : '||basic); dbms_output.put_line('Allowance : '||allow); dbms_output.put_line('salary : '||salary); exception when value_error then dbms_output.put_line('basic has to be number'); when invalid then dbms_output.put_line('basic must be in valid range'); end;
Views: 88 Crazy4 DB
PL SQL strong ref cursor - Strong ref cursor in PL SQL - Strong ref Cursor in Oracle
 
20:17
In this video PL SQL strong ref cursor has been explained with examples. Strong ref cursor is also called as strongly typed ref cursor in which we have to specify a record type as the return datatype while creating the reference cursor type. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 145 Crazy4 DB
analytical functions in oracle explained with real examples - Rank vs dense rank in Oracle
 
21:54
Rank and dense_rank are used as analytical functions in oracle for determining the rank depending upon some column values. These analytical functions in Oracle are explained with real examples in this video. #LearnSQL #BasicSQL #Crazy4DB #MunshiSir #OracleSQL Nth Highest Query : https://youtu.be/egxv5e_YRgU Relational Algebra : https://youtu.be/wNaX1a5Kc48 Rollup and Cube : https://youtu.be/bXbaqas8AFQ Normalization tutorial : https://youtu.be/Y0mX6cy2r5U Complete SQL course : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 151 Crazy4 DB
Relational Algebra Tutorial for Beginners - Relational Algebra Model in DBMS - Relational Calculus
 
14:43
Relational Algebra, Relational Calculus in DBMS, Relational Model in DBMS, Relational Data Model in DBMS, Relational Database Design, Relational Calculus, Relational Database Design, Relational Database Management System, Relational Algebra concepts #dbmsforbeginners,#dbms, #crazy4db DBMS Keys Tutorial : https://youtu.be/DLrCop3-I2M SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL Tutorial : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk
Views: 296 Crazy4 DB
What is cursor in PL SQL - Cursor in PL SQL - Oracle PL SQL Cursor - PL/SQL Cursors
 
14:38
PL/SQL cursors are means of fetching data in the memory for processing by the PL/SQL blocks. This video explains concept and different types of cursors in PLSQL with reference to Oracle Database. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/ Interview Question : What are different types of subqueries? What care should be taken if there is a reference to a NULLable column in the subquery? First try to answer it yourself. Refer to following video to check your answer : https://youtu.be/a69CaAru1aU
Views: 117 Crazy4 DB
SQL decode vs case - Decode and Case difference - Difference between Case and Decode
 
22:53
Difference between decode and case is significant. While decode is proprietary function of Oracle, Case is ANSI compliant. Decode has certain limitations as compared to Case. The examples in this video makes out difference between decode vs case. #DecodevsCase #OracleDecode #Crazy4DB #SQLBasics #LearnSQL Interview question : What is that a decode can not do but case can do? explain with example. A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 118 Crazy4 DB
Tricky SQL queries for interview - oracle interview questions and answers for freshers
 
16:04
There are always some tricky SQL queries asked in interviews. This video brings most important Oracle interview questions and answers to those questions. There is a trending question being asked in most Oracle interviews - An SQL query which involves aggregate SUM function to be used over multiple tables. The trick is to use SQL UNION operator. Link to other referenced videos in the lesson - SUM Group function : https://youtu.be/fx4EnMdyTOM UNION operator : https://youtu.be/bIJ2Gx8FiFM Relational Algebra : https://youtu.be/wNaX1a5Kc48 Tell about yourself : https://youtu.be/TgliWPyBQPU More SQL Interview : https://youtu.be/egxv5e_YRgU complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 253 Crazy4 DB
Stored Procedure - Execute Privilege - PL SQL Stored Procedure - Procedure in PL SQL
 
13:25
This video is about applicability of privileges to PL/SQL Stored Subprograms. Execute privilege is granted on the stored procedure to the other users. Stored procedure are schema objects in the databases as they are owned by a user Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : Sys Ref cursor : https://youtu.be/S-pMilEj_EE For Views : https://youtu.be/K_NaE5q9yPU System triggers : https://youtu.be/YG3E7KzPDAs Trigger WHEN clause : https://youtu.be/kszD6F0Bs5I Trigger Predicates : https://youtu.be/bG9hPV_hzNU Mutating table trigger error : https://youtu.be/hFhAaMxqAHo DML Triggers : https://youtu.be/D71vWBZMqIk Trigger basics : https://youtu.be/_XSaPlQRQBg PL/SQL Package : https://youtu.be/1_IVMS35oJM For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 140 Crazy4 DB
Oracle Architecture Tutorial for Beginners - Oracle DBA Tutorial for Beginners
 
10:23
This Oracle Architecture Tutorial for Beginners is dedicated to ths study of Oracle storage architecture. Study about physical storage. Datafiles, control files & redo log files. Oracle 10g tutorial for beginners will explain the concept which is applicable to all the versions. Oracle DBA Tutorial for beginners, Oracle Architecture #dbmsforbeginners,#dbms, #crazy4db SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM
Views: 292 Crazy4 DB
Object Type in Oracle - PL SQL Tutorial - Objects in Oracle - Oracle Objects
 
24:20
Oracle PL/SQL is Object Oriented Language. The PL SQL Tutorial offers how to create object type in Oracle. Objects in Oracle are same as class in other object oriented languages. Oracle Objects encapsulate attributes and methods Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : Oracle OOPS intro : https://youtu.be/MP0X8Pj8LgE PL SQL Definer rights : https://youtu.be/3vOpxFX5aVw Sys Ref cursor : https://youtu.be/S-pMilEj_EE For Views : https://youtu.be/K_NaE5q9yPU System triggers : https://youtu.be/YG3E7KzPDAs Trigger WHEN clause : https://youtu.be/kszD6F0Bs5I Trigger Predicates : https://youtu.be/bG9hPV_hzNU Mutating table trigger error : https://youtu.be/hFhAaMxqAHo DML Triggers : https://youtu.be/D71vWBZMqIk Trigger basics : https://youtu.be/_XSaPlQRQBg PL/SQL Package : https://youtu.be/1_IVMS35oJM For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 111 Crazy4 DB
Authid in Oracle - Definers rights in Oracle - Invoker rights in PL SQL - Authid in PL SQL
 
16:07
Authid clause in Oracle is used for definers rights or invoker rights in PL SQL stored subprograms. It is possible to control access to the objects through Authid clause used in the stored subprograms and stored procedures and stored functions and PL/SQL packages Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : PL SQL Definer rights : https://youtu.be/3vOpxFX5aVw Sys Ref cursor : https://youtu.be/S-pMilEj_EE For Views : https://youtu.be/K_NaE5q9yPU System triggers : https://youtu.be/YG3E7KzPDAs Trigger WHEN clause : https://youtu.be/kszD6F0Bs5I Trigger Predicates : https://youtu.be/bG9hPV_hzNU Mutating table trigger error : https://youtu.be/hFhAaMxqAHo DML Triggers : https://youtu.be/D71vWBZMqIk Trigger basics : https://youtu.be/_XSaPlQRQBg PL/SQL Package : https://youtu.be/1_IVMS35oJM For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 90 Crazy4 DB
Codd Rules in dbms : Codd's Rules  - dr e f codd rules - Codd's rule in dbms
 
17:42
Codd's rules implementation in a Relational Database Management System. Codds rules explained with examples. Codds Rules Tutorial suitable for beginners in Information Technology and Database Technology. #dbmsforbeginners,#dbms, #crazy4db SQL vs NoSQL : https://youtu.be/D2T8CDooCwc SQL Tutorial - AND, OR, NOT, IN, BETWEEN operators : https://youtu.be/vOvsI8nMD-c SQL Tutorial - LIKE, DISTINCT, ORDER BY clauses : https://youtu.be/cze26lOEYz8 SQL Tutorial - NULL, NVL, NVL2, Coalesce functions : https://youtu.be/y45AEBbvf_0 RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U DBMS Basics : https://youtu.be/YSowepMbzqk
Views: 6764 Crazy4 DB
Mutating Trigger in Oracle - Mutating Table in Oracle - Mutating Table Error in Oracle Trigger
 
25:41
Mutating table error in oracle database comes only in Row Level trigger. Mutating trigger error in Oracle is not thrown by the Statement Level triggers. Mutating table error in oracle trigger is common when row level trigger contains an SQL statement targeted at the same table on which the trigger has been written. Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : Trigger predicates : https://youtu.be/bG9hPV_hzNU DML Triggers : https://youtu.be/D71vWBZMqIk Trigger basics : https://youtu.be/_XSaPlQRQBg PL/SQL Package : https://youtu.be/1_IVMS35oJM For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ For Views : https://youtu.be/K_NaE5q9yPU My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 131 Crazy4 DB
Overloading in PL SQL - Stored Program Overloading in PL/SQL - Function Overloading in Oracle
 
17:49
Packages are used for overloading in PL SQL. Function and procedure overloading in oracle has been explained with case study. Function or procedure overloading in PL/SQL involves two or more functions or procedures share common name but different set of parameters. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Packages : https://youtu.be/1_IVMS35oJM PL/SQL Procedures : https://youtu.be/xJUYBtwg9Pg PL/SQL Functions : https://youtu.be/nKb-CFkIisA PL/SQL Weak Ref Cursor : https://youtu.be/cEqsglhsvfQ PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 119 Crazy4 DB
SQL Interview Questions & Answers - DBMS Inerview Questions & Answers - Oracel Interview Questions
 
30:47
This video of SQL interview questions and answers is great resource for candidates appearing for interview or technical tests on or off campus and GATE. It covers in general DBMS interview questions and answers with Oracle as the reference database. Post your questions and doubts in the comments. #sql, #sqltutorial, #crazy4db, #sqldbms, #munshisir SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 SQL Turotial Part 2 : https://youtu.be/cze26lOEYz8 sQL Tutorial Part 1 : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db Website : http://oracletrainingnagpur.com/
Views: 224 Crazy4 DB
PL SQL Packages - Packages in PL SQL - PL SQL Packages Examples - Introduction to PL/SQL Packages
 
23:47
PL SQL packages are used to group the related program items and components together. Packages in PL SQL have many advantage such as better efficiency, easy manageability, overloading, etc. This video brings the concept of PL SQL Packages and PL SQL Packages Examples. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Procedures : https://youtu.be/xJUYBtwg9Pg PL/SQL Functions : https://youtu.be/nKb-CFkIisA PL/SQL Weak Ref Cursor : https://youtu.be/cEqsglhsvfQ PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 176 Crazy4 DB
Oracle rollup and cube - Rollup and cube in Oracle with examples - Group by function in SQL
 
14:36
Rollup and cube are group by function in SQL. Use of Rollup and cube are explained in this video in Oracle with examples. These functions are very important as they allow to generate certain reports which required subtotals and grand totals to be calculated using group by clause in SQL #BasicSQL #LearnSQL #Crazy4DB #MunshiSir #Oracle #GroupByClause SQL DECODE and CASE : https://youtu.be/-TK-7oI59DE Group Functions Examples : https://youtu.be/fx4EnMdyTOM A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 108 Crazy4 DB
Column Object - Object Type in Oracle - Objects in Oracle - Oracle Objects - PL SQL Objects
 
19:01
It is possible to create a column of a table using Object type called as column object in oracle. The attributes and methods integrated with oracle object type then remain integrated with the column of a normal heap table and help process the data in the column object without need of writing any program. Oracle PL/SQL is Object Oriented Language. The PL SQL Tutorial offers how to create object type in Oracle. Objects in Oracle are same as class in other object oriented languages. Oracle Objects encapsulate attributes and methods Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL URL of the code file download : https://drive.google.com/open?id=1b5DIGtdLU3c9Ze1iJp9JxwN-aoKONMin Important reference videos : How to create Object Table : https://youtu.be/tB3dMRZapBE Creating Object Type ITAX : https://youtu.be/mvNkeIRJQSM Oracle OOPS intro : https://youtu.be/MP0X8Pj8LgE PL SQL Definer rights : https://youtu.be/3vOpxFX5aVw Sys Ref cursor : https://youtu.be/S-pMilEj_EE For Views : https://youtu.be/K_NaE5q9yPU System triggers : https://youtu.be/YG3E7KzPDAs Trigger WHEN clause : https://youtu.be/kszD6F0Bs5I Trigger Predicates : https://youtu.be/bG9hPV_hzNU Mutating table trigger error : https://youtu.be/hFhAaMxqAHo DML Triggers : https://youtu.be/D71vWBZMqIk Trigger basics : https://youtu.be/_XSaPlQRQBg PL/SQL Package : https://youtu.be/1_IVMS35oJM For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 49 Crazy4 DB
SQL set operations - SQL set operators tutorial - Set operators in Oracle
 
21:12
SQL set operations are the operations like UNION, MINUS and INTERSECT. This SQL set operators tutorial contains explanation of basic concepts with practical examples to demonstrate the use of set operators in Oracle. #LearnSQL #BasicSQL #Crazy4DB #MunshiSir #SQLBasics #SQLTutorial Watch following videos : Relational Algebra : https://youtu.be/wNaX1a5Kc48 Normalization tutorial : https://youtu.be/Y0mX6cy2r5U Complete SQL course : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 104 Crazy4 DB
DBMS Transactions - ACID Properties of Transaction - ACID Property in database
 
16:27
DBMS transaction is an important concept. ACID properties of transaction have been explained in this video. How the consistent read operation takes place by locking has been explained with example. Also Explained READ ONLY Transaction. ACID properties in DBMS is about defining process of changes that are valid from the point of view of data consistency. Plz Answer this question in the comment section :- Question : What it READ ONLY Transaction?Why and when it is used? You may also post your questions and doubts in the comment section. Some important links below : DBMS Transaction 2 (Locking & Isolation) : https://youtu.be/ZjK31EuWFsY DBMS Transaction 1 (Concept) : https://youtu.be/3bT7rDNabic SQL interview questions & answers : https://youtu.be/2Vrnszs1TbM SQL Tutorial JOINS, INNER JOINS, OUTER JOINS, LEFT JOINS, RIGHT JOINS, FULL JOINS : https://youtu.be/F3SuSwXxWPk SQL v/s NoSQL : https://youtu.be/D2T8CDooCwc SQL Tutorial Subqueries all types : https://youtu.be/a69CaAru1aU SQL Tutorial NULL, NVL, NVL2, Coalesce functions : https://youtu.be/y45AEBbvf_0 SQL Turotial LIKE, DISTINCT, ORDER BY : https://youtu.be/cze26lOEYz8 sQL Tutorial AND, OR, NOT, IN, BETWEEN operators : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db Blog : https://www.crazy4db.blogspot.in Website : http://www.oracletrainingnagpur.com #sqldbms,#sql, #crazy4db, #LearnSQL,#SQLTutorial, #MunshiSir
Views: 105 Crazy4 DB
commit rollback and savepoint in sql with example - savepoint in oracle - DBMS Transactions
 
19:18
DBMS transaction is an important concept. ACID properties of transaction are mandatory in each valid transaction. Here are explained the TCL commands namely COMMIT, ROLLBACK and SAVEPOINT with exmples. ACID properties in DBMS is about defining process of changes that are valid from the point of view of data consistency. Plz Answer this question in the comment section :- Question : Explain a case when SAVPOINT command may be required to be used? You may also post your questions and doubts in the comment section. Some important links below : DBMS Transaction 3 (Consistent Read) : https://youtu.be/TIw7cGbKeLs DBMS Transaction 2 (Locking & Isolation) : https://youtu.be/ZjK31EuWFsY DBMS Transaction 1 (Concept) : https://youtu.be/3bT7rDNabic SQL interview questions & answers : https://youtu.be/2Vrnszs1TbM SQL Tutorial JOINS, INNER JOINS, OUTER JOINS, LEFT JOINS, RIGHT JOINS, FULL JOINS : https://youtu.be/F3SuSwXxWPk SQL v/s NoSQL : https://youtu.be/D2T8CDooCwc SQL Tutorial Subqueries all types : https://youtu.be/a69CaAru1aU SQL Tutorial NULL, NVL, NVL2, Coalesce functions : https://youtu.be/y45AEBbvf_0 SQL Turotial LIKE, DISTINCT, ORDER BY : https://youtu.be/cze26lOEYz8 sQL Tutorial AND, OR, NOT, IN, BETWEEN operators : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk Facebook Page : https://www.facebook.com/crazy4db Blog : https://www.crazy4db.blogspot.in Website : http://www.oracletrainingnagpur.com #sqldbms,#sql, #crazy4db, #LearnSQL,#SQLTutorial, #MunshiSir
Views: 229 Crazy4 DB
PL/SQL exception handling - PL/SQL error handling - Exception handling in PL/SQL
 
36:19
PL/SQL exception handling is one of the most important requirement Of Oracle back end programming. This video explains PL/SQL error handling in detail with examples. #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Videos to visit : PL/SQL Basics : https://youtu.be/5fXsfOTRSHc complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 165 Crazy4 DB
Sysdate Oracle - Sysdate SQL - Pseudo columns in Oracle - Pseudo Column - Pseudo columns in SQL
 
27:08
Pseudo columns in oracle play an important role in providing some information from the system like rowid, rownum, sysdate and user account. The difference between rowid vs rownum has been explained with examples in this video. Sysdate function returns the current system date as on the serve while user pseudo column returns the name of the current user. #LearnSQL #OracleSQL #Crazy4DB #MunshiSir #PseudoColumns #BasicSQL Types of Subqueries : https://youtu.be/a69CaAru1aU Relational Algebra : https://youtu.be/wNaX1a5Kc48 A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 112 Crazy4 DB
Oracle Architecture Tutorial for Beginners - Oracle DBA Tutorial for Beginners
 
20:45
In this Oracle Architecture tutorial for beginners segment we study Oracle process architecture basics, oracle architecture background processes and server processes. Oracle Tutorial for Beginners, Oracle Database, Oracle DBA Tutorial for Beginners, Oracle Architecture, Oracle Tutorial. #dbmsforbeginners,#dbms, #crazy4db SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM
Views: 290 Crazy4 DB
Ref Cursor in Oracle - PL SQL Ref Cursors in Oracle Database - Types of Ref Cursors in Oracle
 
14:22
Ref cursors in Oracle PL SQL are used for dynamic assignment of different SELECT statements to a cursor variable in same PL/SQL block. There are three types of Ref cursors in Oracle PL SQL - Strong Ref Cursor, Weak Ref Cursor and Sys_refcursor which is a built in form of weak ref cursor. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 116 Crazy4 DB
Super Key in DBMS - Candidate Key in DBMS - Primary key - DBMS Keys
 
16:02
DBMS keys are such such combination of columns in a relation or table which helps to identify a row uniquely. DBMS Keys are also Super Key. The minimal of the Super Key in DBMS is also called as Candidate key. One of the several candidate key in at table is chosen to become primary key. #SuperKey #CandidateKey #Crazy4DB #PrimaryKey #DBMSKeys Interview Questions : (1) Why we require keys in a database system ? (2) How to you differentiate between a candidate key and primary key? (3) Define the candidate key with your own example. DBMS Normalization : https://youtu.be/Y0mX6cy2r5U Type of Constraints : https://youtu.be/MaZIN_MVFY8 Creating constraints : https://youtu.be/dLzuFmFiHxk Foreign key creation : https://youtu.be/l6C-gmIaswA Initially deferred constraint : https://youtu.be/5YxFJNqPPAM My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 119 Crazy4 DB
Constraints in DBMS - Constraints in SQL - Integrity Constraints in DBMS - Constraints in Oracle
 
12:17
This lesson defines complete yet brief about type of constraint in databases. This database constraints tutorial brings with example all the explanation with examples about data integrity constraints in DBMS. #IntegrityConstraints #LearnSQL #Crazy4DB #MunshiSir #DBMSTutorial #SQLBasics #SQLTutorial Try answering the test question, put your answers in the comments - (1)What is another name for foreign key constraint (2) What is the difference between primary key and unique constraint (3) Give an example of domain integrity constraint. DBMS Keys Tutorial : https://youtu.be/DLrCop3-I2M Integrity Constraint Part 2 Video : https://youtu.be/dLzuFmFiHxk Integrity Constraint Part 3 Video : https://youtu.be/l6C-gmIaswA Integrity Constraint Part 4 Video : https://youtu.be/5YxFJNqPPAM My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 348 Crazy4 DB
PL/SQL Sys_Ref Cursor in Oracle Database - Ref Cursor and Sys_RefCursor in Oracle Example
 
12:35
PL/SQL Sys_Ref Cursor in Oracle Database is a weak type ref cursor of built-in form. Sys_RefCursor allows to exchange data between front end and back end in convenient manner. Sys_RefCursor has been explained fully here in this video with example. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Weak Ref Cursor : https://youtu.be/cEqsglhsvfQ PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 101 Crazy4 DB
Foreign key integrity Constraint - Type of Constraint in Database
 
20:34
Referential integrity in the relational database systems are implemented through foreign key integrity constraint. Foreign key integrity constraint is one of the important type of constraint in the database apart from primary key, NOT NULL, Check and Unique. Referential integrity rule enforces that the child only refers to a unique parent and an existing parent only or may remain unrelated. #IntegrityConstraints #LearnSQL #Crazy4DB #MunshiSir #DBMSTutorial #SQLBasics #SQLTutorial Try answering the interview questions - (1) What is the default behaviour of the parent child relationship with respect to deletetion of the parent? (2) What if it is required to be allowed to delete the parent with the related child record existing? (3) Can the foreign key column contain NULL, why? #IntegrityConstraints #LearnSQL #Crazy4DB #SQLBasics #MunshiSir #DBMSBasics #BasicSQL #Constraints DBMS Keys Tutorial : https://youtu.be/DLrCop3-I2M Integrity Constraint Part 1 Video : https://youtu.be/MaZIN_MVFY8 Integrity Constraint Part 2 Video : https://youtu.be/dLzuFmFiHxk Integrity constraint part 4 video : https://youtu.be/5YxFJNqPPAM My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 115 Crazy4 DB
PL/SQL Weak Ref Cursor in Oracle Database - PL/SQL Tutorial - Ref Cursor in Oracle
 
21:05
PL/SQL provides a very flexible form of reference cursor variable called as weak ref cursor which does not have a return data type specified. This is part of PL/SQL tutorial series on Ref Cursor. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 85 Crazy4 DB
Anchored data type (%TYPE) in pl/sql - %TYPE datatype - Anchored datatype in Oracle database
 
19:38
%TYPE is called as anchored datatype used in the PL/SQL language of Oracle database. This datatype is used for declaration of a variable in PL/SQL programs based on columns of tables. In this PL/SQL tutorial for beginners the %TYPE datatype has been explained with example programs #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Videos must visit : PL/SQL Exception Handling : https://youtu.be/tahOBL8Ogss PL/SQL block basics : https://youtu.be/5fXsfOTRSHc complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 112 Crazy4 DB
Most important SQL queries asked in interview - Tricky SQL queries for interview
 
34:18
This video brings most important SQL queries asked in interview. The tricky SQL queries have been explained with rich examples and explanations. The queries contain nth highest sql query example, cumulative sum, connect by prior hierarchical queries with also examples of use of correlated queries in update and delete SQL statements. #SQLQueries #SQL #Crazy4db #MunshiSir #LearnSQL #BasicSQL #OracleSQL Types of subqueries : https://youtu.be/a69CaAru1aU SQL Decode and CASE : https://youtu.be/-TK-7oI59DE Group functions SUM, AVG, COUNT : https://youtu.be/fx4EnMdyTOM SQL Distinct operator : https://youtu.be/cze26lOEYz8 My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 190 Crazy4 DB
DML Triggers in Oracle - Row Level Trigger - Statement Level Trigger - Triggers in Oracle
 
27:07
DML triggers are such triggers in Oracle which execute in response to a DML event over an Oracle database table. There are two main types Row level triggers and Statement level triggers. They can be fired Before triggers or After triggers. Become patron : https://www.patreon.com/crazy4db/ #Crazy4DB #OraclePLSQL #LearnPLSQL Important reference videos : Trigger predicates : https://youtu.be/bG9hPV_hzNU Trigger basics : https://youtu.be/_XSaPlQRQBg Mutating trigger error : https://youtu.be/hFhAaMxqAHo For integrity constraints : https://www.youtube.com/playlist?list=PLdNnjIwbbBtZgOBw2u-IjsaF8tVDJZcBZ For Views : https://youtu.be/K_NaE5q9yPU My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 97 Crazy4 DB
Oracle pl/sql tutorial for beginners - Pl/sql developer tutorial - Oracle pl/sql interview
 
24:25
Oracle PL/SQL Tutorial for Beginners brings to you the fist hand explanation of the PL/SQL language, its concept, and details about the PL/SQL block structure. This series of pl/sql developer tutorial should be helpful for the visitors to prepare for Oracle pl/sql interview #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Videos to visit : complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 488 Crazy4 DB
PL SQL Forward Declarations - What is Forward Declaration in Oracle - What is Forward Declaration
 
19:30
PL SQL allows forward declaration of subprograms in packages. Forward declarations allow to declare the subprograms procedures and functions to be declared in the package body prior to writing the code for it. This video explains the forward declaration in oracle. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL initialization : https://youtu.be/nrnoCAJrhao Pl/SQL overloading : https://youtu.be/e7IQIQqFxkM PL/SQL Packages : https://youtu.be/1_IVMS35oJM PL/SQL Procedures : https://youtu.be/xJUYBtwg9Pg PL/SQL Functions : https://youtu.be/nKb-CFkIisA PL/SQL Weak Ref Cursor : https://youtu.be/cEqsglhsvfQ PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 76 Crazy4 DB
Introduce Yourself - Introduce yourself in interview for fresher - Interview introduce yourself
 
13:53
Tell me about yourself or introduce yourself is almost always the first question to face in any job interview. Most people particularly fresher find it hard to give an answer of rather a well known question. Here you will find a good way of giving answer to this question tell me about yourself. #TellAboutYourself, #IntroduceYourself, #Carzy4DB, #JobInterviewQuestions
Views: 217 Crazy4 DB
PL SQL For Loop - PL SQL While Loop Example - Loops in Oracle PL SQL - PL SQL Loop
 
18:19
Oracle PL/SQL has 3 forms of looping statements or looping structures. PL/SQL simple loop, PL/SQLFor Loop and PL/SQL While Loop. All the three have been explained here with nice examples. The code of the example programs has been given below - #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Interview Question : What is Anchored data type in PL/SQL, why is it required to be used? [For answer refer to the list of following videos] Videos to visit : PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/ Code for programs : Example simple loop ===================== declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; loop exit when num1 [greater than] num2; if mod(num1, 2) = 0 then sqr := num1 * num1; dbms_output.put_line ('square of '||num1||' is '||sqr); end if; num1 := num1 + 1; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example While Loop ========================== declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; While num1 [less than] num2 loop if mod(num1, 2) = 0 then sqr := num1 * num1; dbms_output.put_line ('square of '||num1||' is '||sqr); end if; num1 := num1 + 1; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example For Loop ========================= declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; for n in num1..num2 loop if mod(n, 2) = 0 then sqr := n * n; dbms_output.put_line ('square of '||n||' is '||sqr); end if; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end; Example Reverse For Loop ============================= declare num1 number; num2 number; sqr number; begin num1 := '&LowerNumber'; num2 := '&HigherNumber'; for n in reverse num1..num2 loop if mod(n, 2) = 0 then sqr := n * n; dbms_output.put_line ('square of '||n||' is '||sqr); end if; end loop; exception When value_error then dbms_output.put_line ('input must be a number'); end;
Views: 90 Crazy4 DB
inner joins vs outer joins - inner join left join right join full outer join
 
24:49
SQL joins have been explained with examples of inner join, left join, right join, full outer join, etc . SQL joins are part of operations defined in relational algebra. RDBMS Joins is an essential operation as the data is in the normalized tables. #sqljoins, #sqldbms, #crazy4db, #sql,#LearnSQL,#SQLTutorial, #MunshiSir SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 SQL Turotial Part 2 : https://youtu.be/cze26lOEYz8 sQL Tutorial Part 1 : https://youtu.be/vOvsI8nMD-c RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk
Views: 204 Crazy4 DB
SQL Like Operator - SQL Distinct - SQL Order By - SQL Tutorial for Beginners - SQL for Beginners
 
21:00
A basic SQL tutorial for beginners using Oracle SQL. This SQL crash course covers LIKE, DISTINCT and ORDER BY clauses of SQL Queries. Several examples are there of SQL for beginners. #sqldbms,#sql, #crazy4db, #LearnSQL,#SQLTutorial, #MunshiSir SQL Interview Questions & Answers : https://youtu.be/2Vrnszs1TbM SQL vs NoSQL : https://youtu.be/D2T8CDooCwc SQL for Beginners Part 1 : https://youtu.be/vOvsI8nMD-c SQL Tutorial Part 3 : https://youtu.be/y45AEBbvf_0 Relational Algebra Link : https://youtu.be/wNaX1a5Kc48 RDBMS Normalization : https://youtu.be/Y0mX6cy2r5U Codd's Rules : https://youtu.be/nb2RzcyVUZk DBMS Basics : https://youtu.be/YSowepMbzqk
Views: 157 Crazy4 DB
How to create table in SQL - SQL create table - SQL alter table - SQL drop table
 
20:01
This video teaches you how to create table in SQL databases or SQL alter table command used for modifying the structure of the table. SQL drop table command is used for dropping a table. All the commands have been demonstrated with Oracle SQL. #LearnSQL #BasicSQL #Crazy4db #MunshiSir Interview Questions : (1) Which are the two methods to create a table in SQL? (2) How to create a table from another table without importing any data from it? (3) What are the restrictions of modifying the data type of a column? Videos you must visit :- Types of constraints : https://youtu.be/MaZIN_MVFY8 How to create constraints : https://youtu.be/dLzuFmFiHxk How to create FK constraint : https://youtu.be/l6C-gmIaswA Lesson of DBMS Keys : https://youtu.be/DLrCop3-I2M A complete course on SQL : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z
Views: 74 Crazy4 DB