Relational Databases and SQL

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

Data Abstractions, Data Models, Normalization, Normal Forms, Aggregate Functions, Group By, Joins, Unions, Order by

1. Introduction

1. Introduction

2. Excerpts

3. Databases

4.1 levels of abstraction.zip

4. Data Abstractions

5. Data Models

6.1 Installation.txt

6. Relational Databases

7.1 Data Types.xlsx

7.2 sql server data types.zip

7. Data Types

8.1 SQL Constraints.xlsx

8. Constraints

9.1 #1.pdf

9. Exercises I

10. Solutions to Ex. I

2. Basic SQL Commands

1. SQL Commands - Part I (Initialize DB)

2.1 #2.pdf

2. Exercises II.html

3.1 #2 shopdb.zip

3. Solutions to Ex. II

4. SQL Commands - Part II (CRUD)

5.1 #3.pdf

5. Exercises III.html

6.1 #3 shopdb.zip

6. Solutions to Ex. III

3. Normalization and Normal Forms

1.1 Normal Forms.pdf

1.2 normal forms.zip

1. Normalization and Normal Forms

2.1 Normal Forms - Solution.pdf

2. NF 1-3

3.1 #4.pdf

3. Exercises IV

4.1 #4 - Solution.pdf

4. Solutions to Ex. IV

5. NF 4-5

6. DKNF and NF6

7.1 #5.pdf

7. Exercises V.html

8.1 #5 - Solution.pdf

8. Solutions to Ex. V

4. Advanced SQL Commands

1. Union

2.1 sql joins.zip

2. Joins - Part I

3.1 Subqueries and Joins.txt

3. Joins - Part II

4. Aggregate Functions

5. Group By

6. Order By and Having

7.1 #6.pdf

7. Exercises VI.html

8.1 #6 populace - initialization.zip

8.2 #6 populace - queries.zip

8. Solutions to Ex. VI

9.1 #7.pdf

9. Exercises VII.html

10.1 #7 complicated db scenario (mysql).zip

10.2 #7 complicated db scenario (sql server).zip

10.3 #7 inner joins and subqueries task (marti last).zip

10. Solutions to Ex. VII

11. End

45,900 تومان

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

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

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

تولید کننده: Udemy