Querying Relational Databases

Focused View

Andrew Chalkley

1:12:24

215 View

01 - Why We Make Databases 'Relational'.mp4

02:31

02 - Database Normalization.mp4

01:34

03 - How Normalization Helps Us.mp4

02:54

05 - Set Theory and Relational Databases.mp4

04:36

06 - Theoretical Groundwork.mp4

00:54

08 - Unique Keys.mp4

02:07

09 - Primary Keys.mp4

01:59

11 - Foreign Keys.mp4

04:36

13 - One to Many Relationships.mp4

01:38

14 - Many to Many Relationships.mp4

02:16

15 - One to One Relationships.mp4

02:03

16 - Modeling Table Relationships.mp4

02:26

18 - Join Queries.mp4

01:47

19 - Inner Joins.mp4

05:44

20 - Outer Joins.mp4

04:14

22 - Review and Practice.mp4

02:03

24 - What are Set Operations.mp4

00:59

25 - Union Operations.mp4

04:41

26 - Union All Operations.mp4

01:51

27 - Intersect Operations.mp4

02:31

28 - Except Operations.mp4

02:37

30 - Review and Practice.mp4

02:02

32 - What are Subqueries.mp4

01:12

33 - Using IN with Subqueries to Filter Data.mp4

02:11

34 - Using a Subquery to Create a Temporary Table (Part 1).mp4

03:18

35 - Using a Subquery to Create a Temporary Table (Part 2).mp4

05:33

37 - Review and Practice.mp4

02:07

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

SQL

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.