Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Understanding Databases using SQL - Basic

via Udemy

Overview

SQL with Entity Relationship Model and constraints

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.

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


Taught by

Madhavi Vaidya

Reviews

Start your review of Understanding Databases using SQL - Basic

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.