Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn how to develop databases with SQL programming by examples
Course contents
What you'll learn in this course
PDF File for All Lecture Sessions
PDF File for All Reading Materials
Next steps
Course Lectures- Session 1
Functional Dependencies (4:04)
Course Lectures- Session 2
a- What Is Normalization? (2:50)
b- First normal form (1NF) (1:42)
c- Second normal form (2NF) (1:59)
d- Third normal form (3NF) (1:40)
e- Boyce-Codd normal form (BCNF) (3:15)
Course Lectures- Session 3
Database Development Process (3:49)
Course Lectures- Session 4
Database Users (3:32)
Course Lectures- Session 5
a- Create Database (3:38)
b- Create Tables (5:15)
c- Data Type (3:01)
d- Optional Column Constraints (3:35)
e- Table Constraints (8:23)
f- User Defined Types (2:54)
Course Lectures- Session 6 Part I
a- SELECT statement alone and with WHERE criteria (5:27)
b- Using wildcards in the LIKE clause (1:08)
c- SELECT statement with ORDER BY clause (0:36)
d- SELECT statement with GROUP BY clause (0:45)
e- Restricting rows with HAVING (1:00)
Course Lectures- Session 6 Part II
a- INSERT SQL statements (8:09)
b- UPDATE SQL statements (3:23)
c- DELETE SQL statements (2:26)
Course Lectures- Session 6 Part III
a- SQL Built-in Functions- Aggregate (5:34)
b- SQL Built-in Functions- Conversion (1:07)
c- SQL Built-in Functions- Date (1:03)
d- SQL Built-in Functions- Mathematical (2:25)
Course Lectures- Session 6 Part IV
a- Inner join (4:10)
b- Left outer join (1:54)
c- Right outer join (2:53)
d- Full outer join (2:04)
e- Cross join (4:00)
Teach online with
What you'll learn in this course
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock