Querying Relational Databases

Focused View

Andrew Chalkley

1:12:20

141 View

01. Database Normalization

01. Why We Make Databases Relational.webm

02:31

02. Database Normalization.webm

01:33

03. How Normalization Helps Us.webm

02:54

04. Set Theory and Relational Databases.webm

04:36

05. Theoretical Groundwork.webm

00:54

02. Database Keys

01. Unique Keys.webm

02:06

02. Primary Keys.webm

01:59

03. Foreign Keys.webm

04:36

03. Table Relationships

01. One to Many Relationships.webm

01:38

02. Many to Many Relationships.webm

02:16

03. One to One Relationships.webm

02:03

04. Modeling Table Relationships.webm

02:26

04. Joining Table Data with SQL

01. Join Queries.webm

01:47

02. Inner Joins.webm

05:44

03. Outer Joins.webm

04:14

04. Review and Practice.webm

02:03

05. Set Operations

01. What are Set Operations.webm

00:59

02. Union Operations.webm

04:40

03. Union All Operations.webm

01:51

04. Intersect Operations.webm

02:31

05. Except Operations.webm

02:37

06. Review and Practice.webm

02:02

06. Subqueries

01. What are Subqueries.webm

01:12

02. Using IN with Subqueries to Filter Data.webm

02:11

03. Using a Subquery to Create a Temporary Table (Part 1).webm

03:18

04. Using a Subquery to Create a Temporary Table (Part 2).webm

05:33

05. Review and Practice.webm

02:06

Description

About this Course

Building off of previous SQL courses, this course will begin to introduce the student to more complex database concepts. Students will learn to think about data as sets and subsets and practice achieving desired query results via such operations as inner and outer joins, unions and except. They will also be introduced to the concepts of Set Theory and Database Normalization to aid in understanding good query practices.

What you'll learn

What is a Relational Database?
Database Normalization
Database Keys
Table Relationships
Set Operations

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Programming Fundamentals

Database Programming

Andrew Chalkley

Instructor's Courses

I'm an alien, I'm a legal alien, I'm an Englishman in Portland. All of my professional life I've worked with computers online. I'm a polyglot programmer and like using the right tools for the job. In my spare time I enjoy spending time with my family and when I get chance, sticking opponents in Halo 4.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.