- Introduction
- Concept of Data Abstraction and Views
- Creating Views on Tables using SQL
- Practical Video – Create and Drop view
- Concept of Sequence and its use in table data insertion
- Practical Video - Create Sequence
- Concept of Index
- Practical Video - Create and Drop Index
- Concept of Synonym and Creating Synonym using SQL
What you'll learn
- In this course, You will learn Advance Concepts of Database which includes View, Sequence, Indexes, Synonym .
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
Other Courses
Digital SAT Practice Test 1 Solved
New SAT Digital Version Practice Test 1 Solved for Practice
Amazon, Walmart, & More: Marketplaces Overview
Learn how Amazon and other marketplaces can be used to generate leads for your business, and how to do it profitably
Unreal Engine - Beginner Guide
Get into Game Design World through these baby steps by getting introduced to Unreal Engine.
Machine Learning for Research
Learn about machine learning and its powerful applications in scientific research!
Nutrition for Oral Health in the early years
A child’s first experiences with oral health can impact on the rest of their life.
Credit Repair: The Complete Guide To A Good Credit Score
Beginners Credit Repair Guide w/ Many Credit Repair Secrets
About the instructors
- 4.22 Calificación
- 4333 Estudiantes
- 1 Cursos
Samidha Chavan
Lecturer at Vidyalanakar Polytechnic
Hi , I am Mrs. Samidha Chavan, working for the past 12 years as a Lecturer in Vidyalankar Polytechnic. Today when I turned back, I see a long path and a wonderful journey that I have travelled with Vidyalankar. It’s my privilege to be a part of this esteemed institution as an ex-student and as a teacher. I have completed my Diploma in Computer Engineering from Vidyalankar Polytechnic, and then pursued B.Tech in Information Technology from V.J.T.I Mumbai. To keep myself upgraded, I enrolled for Masters in Computer Engineering and completed it in January 2017. I like to attend technical seminars which make me aware about latest developments and technologies. I teach subjects like Database, Programming languages(C, C++ and Java), Computer Networks, etc. My research interest is in Internet of Things (IoT). I like to use group exercises, PowerPoint slides and videos where ever applicable to make the concepts easier for students. I believe this is something which increases student interest significantly and leads to a better learning experience.
Student feedback
Course Rating
Reviews
This course is good.
Its more insightful
GREAT COURSE BUT LOW VOLUME