Skip to content
Ontoor Training
Ontoor Training
Home
About Us
Courses
All Instructors
Become an Instructor
Blog
Contact
Close Menu
Home
Courses
Education
SQL Course (Beginner to Intermediate)
SQL Course (Beginner to Intermediate)
Curriculum
5 Sections
30 Lessons
10 Weeks
Expand all sections
Collapse all sections
Introduction
7
1.1
What is a Database?
1.2
Types of Databases (Relational vs. Non-Relational – brief overview)
1.3
Why Relational Databases?
1.4
Database Management Systems (DBMS) – Introduction to Oracle Database
1.5
Client-Server Architecture in a Database Environment
1.6
Basic Database Terminology (Table, Row, Column, Schema, Instance, etc.)
1.7
Database Entities
Data types
7
2.1
Char
2.2
VARCHAR2
2.3
Number
2.4
Date
2.5
Timestamp
2.6
CLOB
2.7
BLOB
Tables
8
3.1
Create
3.2
Drop
3.3
Truncate
3.4
Insert
3.5
Delete
3.6
Update
3.7
Select
3.8
Quiz 1
1 Question
Constraints
Table Constraints
7
4.1
Understanding Constraints
4.2
PRIMARY KEY
4.3
FOREIGN KEY
4.4
UNIQUE KEY
4.5
NOT NULL
4.6
CHECK Constraint
4.7
Default
Views
2
5.1
Create View
5.2
Drop View
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
