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

Udemy

Introduction to Relational Database and SQL

via Udemy

Go to class Write review

Overview

Full scale SQL and Relational Database course

What you'll learn:
  • SQL
  • Entity Relationship Model
  • Relational Database

This course teaches you how to design a relational database and how to write SQL. It covers all the important SQLstatements, including CREATE, INSERT, UPDATE,DELETE, SELECT, ALTER, and DROP, and provide some insight into entity-relationship model design. This course is based on my on-campus teaching at colleges and comes with a mid-term project and a final project. There is no prerequisite for this course.

Syllabus

  • Course Introduction
  • Relational Database Design
  • SQL Introduction: CREATE and DROP
  • Simple Data Handling
  • Single Table SELECT Statement
  • Changing Data: UPDATE, DELETE, INSERT, and ALTER
  • WHERE Clause Deep Dive
  • Mid-term Project
  • Aggregation and GROUP BY
  • Dataset Operation: UNION, INTERSECT, and MINUS
  • JOINing Tables
  • View and Non Permanent Table
  • Stored Procedure, Cursor, and Window Functions
  • DBMS Operations
  • Final Project

Taught by

Jun Shan

Reviews

4.5 rating at Udemy based on 431 ratings

Start your review of Introduction to Relational Database and SQL

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.