Introduction to Databases, Data Modeling and SQL

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

learn basics of data modeling, how to build your model in a database and interact with that data using SQL

1. Introduction

1. Introduction

2. What is a database

2. Data Modeling

1. Structured vs Unstructured Data

2. Introduction to Structuring data - A Student

3. Tables, Fields and Relationships

4. Refining Structuring data - A Refined Student

5. Entity Relationship Diagrams - Visualizing a Refined Student

6. Section Quiz.html

3. Introduction of database concepts

1. Keys Primary and Foreign

2. Initial SQL Commands

3. Your Own Database - Postgres Install

4. Restart - Seriously, Restart

5. PG Admin and install completion

6. More SQL Commands Create Table

7. Create additional tables

4. Using SQL to manage and manipulate data

1. Understanding the Insert statement

2. Insert Statement practice

3. Understanding the Select Statement

4. More Insert Practice

5. Potential Problems with Primary Keys

6. Natural and Surrogate Keys

7. An improved ERD

8. Create table with new Primary Keys

9. Create additional tables with New Primary Keys

10. Dollar Quoting, and Return Values

11. Insert practice with Dollar Quoting

12. Insert Review

13. Section Quiz.html

5. Joins and Lookup Tables

1. Introduction to Joins

2. Review of Join Types

3. Join results with multiple values

4. Join Practice

5. Select practice with Joins

6. Introduction to Lookup Tables

7. Lookups and our data model of a Student

8. Create Lookup Table

9. Populate Lookups and phone tables

10. Advanced Bonus Modify Phone table for use of Lookup

11. Joins with Lookup Tables

12. Update and Delete SQL commands

13. Section Quiz.html

6. Class Summary and Closing

1. Class Summary

2. Congratulations!

54,900 تومان

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

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

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

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