Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Advanced Database Features using SQL
Rating: 3.9 out of 5(244 ratings)
6,012 students

Learn Advanced Database Features using SQL

Let's learn Advance Concepts of Database-View, Sequence, Indexes, Synonym .
Created bySamidha Chavan, Shraddha Deepak Ambekar
Last updated 12/2020
English

What you'll learn

  • In this course, You will learn Advance Concepts of Database which includes View, Sequence, Indexes, Synonym .

Course content

1 section • 9 lectures • 42m total length

  • Introduction1:19

    In this course, You will learn Advance Concepts of Database which includes View, Sequence, Indexes, Synonym .

    Modules include -

    Module 1 : Introduction

    Module  2 : View - Concept of Views and Data Abstraction, Creating Views using SQL on Tables .

    Module  3 : Sequence - Concept of Sequence and its use in table data insertion , Implementation of sequence using SQL.

    Module 4 : Index - Different Types of Index, Creating Simple , Composite and Unique Index using SQL.

    Module 5 : Synonym - Concept of Synonym, Creating Synonym using SQL .

  • Concept of Data Abstraction and Views2:49

    This lecture will help students to understand "Concept of Data Abstraction and Views "

  • Creating Views on Tables using SQL5:36

    This lecture will help students to understand "Creating Views on Tables using  SQL  "

  • Practical Video – Create and Drop view7:02
  • Concept of Sequence and its use in table data insertion5:35
  • Practical Video - Create Sequence5:37
  • Concept of Index1:06
  • Practical Video - Create and Drop Index4:47
  • Concept of Synonym and Creating Synonym using SQL8:46

Requirements

  • You should know Basic create, read, update, and delete (CRUD) operations on Database using SQL

Description

This Course will help you to learn following things :

  • Concept of Views and Data Abstraction

  • Creating Views using SQL on Tables

  • Concept of Sequence and its use in table data insertion

  • Implementation of sequence using SQL

  • Different Types of Index

  • Creating Simple , Composite and Unique Index using SQL

  • Concept of Synonym and Creating Synonym using SQL


Who this course is for:

  • Beginners Database Designers curious about advance features of database

Report abuse