Introductory Course to Database Management System and SQL

Database management system

  • (3 ratings) 13 students enrolled

Course Overview

Nowadays, the most valuable thing in the world is data. Much of the world’s data is stored in databases.

Databases are the backbone of almost all the digital services and e-governance solutions. Modern

businesses and financial systems heavily depend on databases systems and transaction processing for

their successful operation. SQL (or Structured Query Language) is a powerful language which is used for

communicating with and extracting data from databases. A working knowledge of databases and SQL is a

must if you want to become a Database Designer, Database Administrator or an Application Programmer.

This course introduces the concepts of relational databases systems with the help of MySQL database and

the fundamental knowledge of the SQL Language. During the course, you will learn how to work with

phpMyAdmin, which is one of the best GUI to work with MySQL.

1. What are the requirements?

  • Familiarity in using computers.
  • Basic English Knowledge

2. What am I going to get from this course?

  • you will understand the basics of Relational Database Management System
  • You will understand the basics of Database Management System
  • you will understand the basics of normalization concepts
  • you will understand the MySQL database and the GUI phpMyAdmin
  • you will have the basics skills to grab the job like Database designer, Database administrator etc
  • you will understand the basics of SQl

3. Who this course is for?

  • Anyone who wants to learn the concept of Database Management System, especially engineering or degree or school students.

About the Author

  • Cibi Jacob is a highly experienced professional with over 10 years of working in the IT industry. She has predominantly worked as a Software Developer, Project Lead, and Project Manager. With a high passion for training, Cibi Jacob is currently pursuing as an online trainer with an additional three years of training experience.

    Her forte primarily being

        * web designing using HTML, JavaScript, and CSS

        * web programming using PHP and MYSQL

        * Web hosting

Course Curriculum

Introduction

  •  
  •  
  •  
  • Applications of database management system
     
  • examples of database management system
     
  • advantages of database management system
     

Database Management System

  • Introduction to database : Keywords
     
  • Database management system : Keys
     
  • Database Management System : Operations
     
  • normalization
     

Database management system: MySQL

  • Creating a Database User
     
  • Creating and managing database
     

introduction to Structured Query Language (SQL)

  • What is Structured Query Language (SQL)
     
  • SQL commands: Creating database and table using SQL
     
  • Data manipulation language (DML)
     
  • Data query language (DQL)
     
  • Transaction Control Language (TCL) and Data control language (DCL)
     
  • database management system joins
     
  • indexing in database management system
     

reviews

toprated

Computer Programming - An Intr

  In today’s world, computer programmin... Read More

Aug 24, 2020, 23 Comments

Machine Learning and Data Scie

Globally, the machine learning market is expected ... Read More

Jul 2, 2020, 15 Comments

View More...