Aprenda SQL Tutorial (Oracle) gratuitamente com 16 vídeo(s). Curso online grátis de Oracle Database | YouCourse.
Aulas do Curso
(16 vídeos)
0 de 16 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Installation - Oracle Database 11g Release 2 Express Edition for Windows 64
We will look at the installation of the oracle 11g express edition software which is used for all the SQL Demos.
1
SQL DDL Commands - CREATE, ALTER , DROP TABLE - DEMO - Using ORACLE
In this session we will look at SQL DDL Commands Demo using Oracle
1. We will use CREATE Table, ALTER Table and Drop Ta…
2
SQL - DML Commands - Operators (Relational - Like & Between) -Demo using ORACLE
In this session we will look at
Insert statement in SQL
Select Statement with Operators (Relational - Like & Between)
…
3
SQL - String Handling Functions - Demo using Oracle
Just a quick look at some of the String handling functions
4
SQL Date Data type (Oracle) - Use of SQL Date data type and its functions
In this lecture we will learn the Oracle SQL Date Data Type and its Functions.
5
SQL - Group by, Having - Order by Clause - Demo Using Oracle
In this lecture we will understand the following
The use if Group by , Having and Order By Clause in SQL using Oracle.
6
SQL - Primary Key Constraint - Demo using Oracle
In this lecture we will look at establishing Primary Key Constraint on a relation.
7
SQL - Column Level Vs Table Level Constraints - Demo using Oracle
In this lecture we will understand the difference between column level declaration of constraints versus the table level…
8
SQL - Foreign Key Constraint - Introduction and Demo using Oracle
In this lecture we will look at what are foreign keys and how to establish foreign keys on relations. SQL demo is shown …
9
SQL - Foreign Key - On Delete Cascade - On Delete Set Null
In this session we will understand the application of On Delete Cascade and On Delete Set Null clauses while creating Fo…
10
SQL - Joins Demo - Using Oracle
11
SQL - Views - Database Management Systems - Demo using Oracle
This lecture will help you get an understanding on the following concepts
What are Views
Creating and Replacing Views
V…
12
SQL - Introduction to Sub Queries (using Oracle) - Nested Sub Queries, ALL - ANY Keywords
We will look at the following in this lecture
What are Sub Queries
Write some Simple Sub Queries using In and Not IN O…
13
Pl/SQL Session 1 - Introduction , Anonymous block, Procedures, Conditional and Case Statements
Link for Oracle11g XE edition installation and SQL Tutorials
https://youtu.be/USrm2_Ot6DQ
https://youtu.be/H0KFEj65d1…
14
PL/SQL - Session 2 (for, while and simple Loop) GOTO and NULL statements
Link to PL /SQL Session 1
https://www.youtube.com/watch?v=GAF66gfkvwI
In this session we will look at the following co…
15
PL/SQL Session 3 - Select into Statement , Procedures - IN , OUT, IN OUT parameters - Demo
In this Session we will take a look at the following concepts in PL/SQL
1. Select into statement with a single variable…
