Sharing Is Caring:

Understanding Databases using SQL – Basic

  • SQL with Entity Relationship Model and constraints
  • Free tutorial
  • Rating: 3.9 out of 53.9 (63 ratings)
  • 7,848 students
  • 1hr 57min of on-demand video
  • Created by Madhavi Vaidya


What you’ll learn

  • As SQL provides a systematic method of creating, updating, retrieving, and storing information in a database.
  • As SQL allows to query data, sort data, and manipulate data in various ways
  • SQL is a backend technology that allows us to store and manipulate data with various programming language like Python ,languages on .Net plartform, Java, Android etc.


  • Need to have interest in learning programming in query like manner
  • Get excited about handling queries
  • Need to have interest in learning where to store and how to manipulate the data
  • Need to know English language as SQL statements are similar to it.


Overview of Database Management Systems –

Overview of DBMS, Advantages of DBMS, Introduction to RDBMS, overall system architecture

Database Management System Models –

Read Also -->   Translation Technology II

Relational model, Normalization, ER model, Mapping Cardinalities.

Structured Query Language –


Introduction to SQL, SQL Datatypes, Components of SQL, Range Operators(In, Between, Like, NULL Predicate), Clauses(into, where), Constraints, implementation of constraints in SQL

Who this course is for:

  • Anybody who wants who wants to handle data
  • Anybody who would like to carry out data analytics
  • Who would like to know about the concepts such as ERD and Constraints

Show less

Course content

10 sections • 14 lectures • 1h 58m total lengthCollapse all sections

Introduction to SQL and1 lecture • 8min

  • Introduction07:58
  • Understand the characteristics and difference of MySQL and SQL offered by Oracle1 question

SQL, SeQUEL, Queries/SQL statements, Data Types1 lecture • 6min

  • Understand the difference between SQL and SEQUEL, SQL statement and Data Types05:41

MySQL – open source database – structured query language2 lectures • 13min

  • MySQL – open source software for databases – structured query language06:15
  • Various Data Types in Oracle 10g along with Select and Insert statement06:42

DML statements with where clause1 lecture • 7min

  • DML statements with where condition and relational operators07:07
  • Assignment on update statement1 question

Delete statement with where condition and how to use logical operators1 lecture • 6min

  • Delete statement with where condition and how to use logical operators06:11

Understanding Entity Relationship Model3 lectures • 20min

  • Understanding ERD and Normalization Concepts01:30
  • Draw an Entity Relationship Model diagram for the given case study.1 question
  • Understanding Entity Relationship Model08:51
  • Learning Constraints , mainly Primary Key constraint09:17

Learning Constraints, Foreign Key2 lectures • 16min

  • Learning Constraints, Foreign Key08:09
  • Learning Constraints, Foreign Key08:09

Understanding Integrity, Foreign and Business Constraints1 lecture • 7min

  • Understanding Integrity, Foreign and Business Constraints07:21
Read Also -->   The Bitcoin Basics

How to create many to many(m:n) relationship in SQL1 lecture • 9min

  • How to create many to many(m:n) relationship in SQL08:30

To understand few more Operators/Clauses1 lecture • 5min

  • To understand few more Operators/Clauses04:52

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock