Database Management System Lab

Sonia Setia
Last Update September 15, 2021
3 already enrolled

About This Course

Through this course students will be able to create a simple database

Learning Objectives

Students will be able to-
Create tables and databases using SQL.
Design a query in database using SQL DML/DDL commands
Implement the relational databases in order to optimize database performance in practice. Apply query based data on any given set of conditions.
Develop a database schema from a problem statement to conceptualize the database design.

Requirements

  • SQL , Oracle software

Target Audience

  • Beginners in Programming

Curriculum

24 Lessons20h

Basic SQL Commands

Commands based on select project operation
Video lecture on Merits and demerits of dbms00:00:00Preview
Video lecture on Components of DBMS00:00:00Preview
Create Command00:00:00Preview
Select with where clause00:00:00Preview
Basic Select command00:00:00Preview
Insert Command00:00:00Preview
Like clause00:00:00Preview
FAQ Discussion00:00:00Preview
Assignment00:00:00Preview
Arithmetic Functions00:00:00Preview
FAQs00:00:00Preview
Quiz00:00:00Preview
Assignment00:00:00Preview
Quiz

sql commands

DDL Commands

SQL commands with syntax

Your Instructors

Sonia Setia

5.0/5
6 Courses
1 Review
5 Students
See more

Write a review

Free
Level
All Levels
Duration 20 hours
Lectures
24 lectures
Language
English
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Wishlist 0
Open wishlist page Continue shopping