Understanding Databases using SQL - Basic
Offered By: Udemy
Course Description
Overview
SQL with Entity Relationship Model and constraints
What you'll learn:
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
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX