Querying Relational Databases

سرفصل های دوره

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

01. Database Normalization

01. Why We Make Databases Relational

02. Database Normalization

03. How Normalization Helps Us

04. Set Theory and Relational Databases

05. Theoretical Groundwork

02. Database Keys

01. Unique Keys

02. Primary Keys

03. Foreign Keys

03. Table Relationships

01. One to Many Relationships

02. Many to Many Relationships

03. One to One Relationships

04. Modeling Table Relationships

04. Joining Table Data with SQL

01. Join Queries

02. Inner Joins

03. Outer Joins

04. Review and Practice

05. Set Operations

01. What are Set Operations

02. Union Operations

03. Union All Operations

04. Intersect Operations

05. Except Operations

06. Review and Practice

06. Subqueries

01. What are Subqueries

02. Using IN with Subqueries to Filter Data

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

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

05. Review and Practice

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

مدرس: Andrew Chalkley