- 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
English
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.
Requirements
- 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.
Description
Overview of Database Management Systems –
Overview of DBMS, Advantages of DBMS, Introduction to RDBMS, overall system architecture
Database Management System Models –
Relational model, Normalization, ER model, Mapping Cardinalities.
Structured Query Language –
DQL, DDL, DML, DCL, and TCL
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
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