Description
In this course on Views, Database Objects, User Access , set Operator, you will learn about Creating Views, Database Objects, Controlling User Access & Using SET Operators. The course starts from scratch and hence a beginner can also take and enjoy this course.
In this course you will be learning in detail about the following topics:
Creating Views
Objectives
Database Objects
What is a View?
Why Use Views?
Simple Views and Complex Views
Creating a View
Retrieving Data from a View
Querying a View
Modifying a View
Creating a Complex View
Rules for Performing DML Operations on a View
Using the WITH CHECK OPTION Clause
Denying DML Operations
Removing a View
Inline Views
Top-N Analysis
Summary
Practical Examples
Additional Examples
Other Database Objects
Objectives
Database Objects
What Is a Sequence?
The CREATE SEQUENCE Statement Syntax
Confirming Sequences
NEXTVAL and CURRVAL Pseudocolumns
Using a Sequence
Modifying a Sequence
Removing a Sequence
What is an Index?
How Are Indexes Created?
Creating an Index
Confirming Indexes
Function-Based Indexes
Removing an Index
Synonyms
Creating and Removing Synonyms
Summary
Practical Examples
Additional Examples
Objectives
Privileges
System Privileges
Creating Users
User System Privileges
What is a Role?
Creating and Granting Privileges to a Role
Changing Your Password
Granting Object Privileges
Using the WITH GRANT OPTION and PUBLIC Keywords
Confirming Privileges Granted
How to Revoke Object Privileges
Database Links
Summary
Using SET Operators
Objectives
The SET Operators
Tables Used in This Lesson
The UNION Operator
Using the UNION Operator
The UNION ALL Operator
Using the UNION ALL Operator
The INTERSECT Operator
Using the INTERSECT Operator
The MINUS Operator
SET Operator Guidelines
The Oracle Server and SET Operators
Matching the SELECT Statements
Controlling the Order of Rows
Summary
Practical Examples
Additional Examples
What is the target audience?
Anyone interested in SQL Programming
Programmers
Developers
Students and Freshers
Software Professionals
What are the requirements?
A PC with internet
The course starts from scratch. No prior programming knowledge required
Course Duration:-3h 51m
