Create Your Page
Md Saidul Haque
Create Your Page
Sign in
Md Saidul Haque
Home
About
Knowledge Base/Blog
All knowledgebase
Single Articles
Serise Articles
Tutorials
Courses
Problem: Question/Answer
Experience
Education
Skill
Page of Life
Connection
Contact
Md Saidul Haque
Md Saidul Haque
KB Dashboard
Knowledge Base
All knowledgebase
Single Articles
Serise Articles
Tutorials
Courses
Problem: Question/Answer
Courses
Add Knowledge Base
Introduction to Oracle Database
Database Overview
What Is Oracle Database
History of Oracle Database
Why Oracle Database
Features of Oracle Database
Oracle Vs. SQL Server: Key Differences
Oracle Vs. MySQL Server: Key Differences
Oracle Vs. NoSQL
Install Oracle Database Server
Oracle Database Sample Schema
Execute Sample Database
Connect to SQL Developer and Other SQL Editor
Oracle Tables and Data definition
CREATE TABLE
CREATE TABLE AS
IDENTITY Column In Oracle
ALTER TABLE ADD Column
ALTER TABLE MODIFY Column
ALTER TABLE DROP Column
ALTER TABLE RENAME column
ALTER TABLE RENAME table
DROP TABLE
Global Temp Tables
Local Temp Tables
Table virtual column
Oracle Dual Table
Modifying data
INSERT
INSERT INTO SELECT
INSERT ALL
UPDATE
DELETE
MERGE
TRUNCATE TABLE
Oracle Query and Filter
Oracle Queries
Oracle Select
Oracle Order by
DISTINCT
WHERE
AND
OR
FETCH
IN
BETWEEN
LIKE
IS NULL and IS NOT NULL
Subquery
Correlated Subquery
EXISTS and NOT EXISTS
ANY, SOME, and ALL
Oracle CASE expression
Oracle data types
Oracle data types
NUMBER
FLOAT
CHAR
NCHAR
VARCHAR2
NVARCHAR2
DATE
TIMESTAMP
INTERVAL
TIMESTAMP WITH TIME ZONE
Joining tables
INNER JOIN
OUTER JOIN: LEFT
OUTER JOIN: RIGHT
OUTER JOIN: FULL
CROSS JOIN
Self-join
Equi Join
Anti Join
Oracle Operators
Oracle Union
Oracle Union All
Oracle Intersect
Oracle Minus
Grouping data
GROUP BY
HAVING
Grouping sets
CUBE
ROLLUP
PIVOT
UNPIVOT
Constraints
Primary key
Foreign key
NOT NULL constraint
UNIQUE constraint
CHECK constraint
Oracle Views
Oracle Indexes
Oracle Synonyms
Oracle Sequences
Oracle Built-in Functions
Oracle String Functions
Oracle Aggregate Functions
Oracle Analytic Functions
Oracle Comparison Functions
Oracle Date Functions
Oracle Query Problem
Oracle Procedure
Oracle Function
Oracle Cursor
Oracle Trigger
YOUR PROGRESS
10%
DISTINCT
Oracle Database Basic Course
2020-12-07 03:13:23
Programming, Software and application
Oracle Trigger
Content Table
Single Articles
|
Series Articles
|
Tutorials
|
Courses
|
Question/Answer
|
All Knowledge Base
Completed
Next lesson
Session is expired,Please
login
.
Basic Info
Select KnowledgeBase Post Type:
{{value}}
Courses
KnowledgeBase Post Type:
Courses
This is single page article.
This is Series Articles where you can write more than one articles on one topic .
Tutorial will have facility to add menu and submenu item where content will be
Text Content like article
Question Item - MCQ, Short Question
Glossary/Terminology
Course will have facility to add any course free/paid where content will be
Text Content like article
Video content
Documents content (txt/doc/pdf)
Question Item - MCQ, Short Question
Glossary/Terminology
Exam Item - MCQ, Short Question
Problem is same as single page article but here you can give problem and your answer and other people can give answer of your problem.
Glossary will have a system to add glossary of specific topic or subject with lot of categories.
Series Article Topic:
{{value.title}}
Episode Number:
Topic Title:
Title:
Brief
Details
:
Option:
No
Menu
Menu Submenu
Multiple Section/Chapter/Group
Series
Sections/Chapter/Group {{key+1}}:
X
Add More
Knowledge Base Link
Category:
{{parent_category_label}}
{{value}}
Sub Category:
{{subcategory_category_label}}
{{value}}
Featured Video or Image
Featured Image
Featured Video
Upload Featured Image(jpg,png, pdf, doc).
Video URL(Only Youtube URL):
Video or Image Position
Top of the content
Bottom of the content
Inside of the content
Please put the legend:
in the content inside where you want to see.
Tags or Search Keywords:
Meta Title:
Meta Description:
Post Status:
{{value}}
Update
OR
Cancel
Page Title:
Content:
Summery(Optional):
Menu Name:
Same as title but many time, it will shorter than title.
Video URL(Only Youtube URL):