Database Users | Coding Bootcamps

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

Database Users

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock