Introduction to Databases, Data Modeling and SQL

Focused View

John McTiernan

3:44:58

17 View

1. Introduction

1. Introduction.mp4

02:30

2. What is a database.mp4

02:21

2. Data Modeling

1. Structured vs Unstructured Data.mp4

06:20

2. Introduction to Structuring data - A Student.mp4

05:00

3. Tables, Fields and Relationships.mp4

09:20

4. Refining Structuring data - A Refined Student.mp4

07:19

5. Entity Relationship Diagrams - Visualizing a Refined Student.mp4

08:10

6. Section Quiz.html

3. Introduction of database concepts

1. Keys Primary and Foreign.mp4

02:49

2. Initial SQL Commands.mp4

06:52

3. Your Own Database - Postgres Install.mp4

05:14

4. Restart - Seriously, Restart.mp4

00:36

5. PG Admin and install completion.mp4

03:16

6. More SQL Commands Create Table.mp4

06:37

7. Create additional tables.mp4

09:06

4. Using SQL to manage and manipulate data

1. Understanding the Insert statement.mp4

06:56

2. Insert Statement practice.mp4

03:09

3. Understanding the Select Statement.mp4

08:33

4. More Insert Practice.mp4

01:49

5. Potential Problems with Primary Keys.mp4

03:53

6. Natural and Surrogate Keys.mp4

06:25

7. An improved ERD.mp4

06:05

8. Create table with new Primary Keys.mp4

06:33

9. Create additional tables with New Primary Keys.mp4

02:31

10. Dollar Quoting, and Return Values.mp4

13:28

11. Insert practice with Dollar Quoting.mp4

02:54

12. Insert Review.mp4

03:41

13. Section Quiz.html

5. Joins and Lookup Tables

1. Introduction to Joins.mp4

04:26

2. Review of Join Types.mp4

09:18

3. Join results with multiple values.mp4

02:57

4. Join Practice.mp4

08:16

5. Select practice with Joins.mp4

09:01

6. Introduction to Lookup Tables.mp4

05:46

7. Lookups and our data model of a Student.mp4

07:12

8. Create Lookup Table.mp4

04:18

9. Populate Lookups and phone tables.mp4

07:46

10. Advanced Bonus Modify Phone table for use of Lookup.mp4

04:25

11. Joins with Lookup Tables.mp4

05:59

12. Update and Delete SQL commands.mp4

06:44

13. Section Quiz.html

6. Class Summary and Closing

1. Class Summary.mp4

06:13

2. Congratulations!.mp4

01:10

Description

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

What You'll Learn?

Understand what a database is and what its used for
The difference between Structured and unstructured data
Understanding of an ERD (Entity Relationship Diagram) and how to "model" your data
Learn how to create and manage tables using SQL (structured query language)
Learn most common types of SQL commands: Select, Insert, Update, Delete
Understand different types of table joins

Who is this for?

New developers who are looking to learn or improve their skills in modeling and working with data

What You Need to Know?

No skill prerequisites.

You will need a PC where you can install a PostgreSQL database (admin rights and about 1 GB of storage)

More details

Description
This class is designed for anyone involved in software development, with a focus on those new to the concepts of Data Modeling and Structured Query Language (SQL)Â .Â At DTÂ Group, we believe application development is about more then just code.Â The more all members of an application development team understand the other roles, the more effect each member of the team will become.

In this class, we will walk through concepts of data modeling. Â This includes the following topics:
Understand the difference between Structured and Unstructured Data
Learn how to take a know concept ( we will use a Student) to build a Data Model to store relevant data
Understand common mistakes in data modeling and how to correct them
Learn how to represent this data model in an industry standard format (Entity Relationship Diagram, or ERD)
Learn how to build the data model in the database using Structured Query Language (SQL)
Learn how to interact with your data model using SQL, including the most common SQL commands (Insert, Update, Delete, Select)
Understand the different types of relationships between tables (Joins) and how to use these in SQL

Regardless of your role within the SLDC, a deeper understanding ofÂ data modeling and data interactions will dramatically improve the quality of your work and the software delivered.

I hope you enjoy!

NOTE:
In this class, we will be using a PostgreSQL database and learning SQL commands formatted specific for this type of database.Â Â The concepts are applicable to many other databases (MySQL, Oracle, and others), but the syntax will be slightly different.
This is a hands on class, where you will install and interact with a database on your own system .Â Â Please make sure you have at least 2 GB of free space on your computer and the ability to install software.

Who this course is for:
New developers who are looking to learn or improve their skills in modeling and working with data

User Reviews

Rating

average 0

Total votes0

Focused display

At DT Group, we bridge the gap between business requirements and technology solutions. We do this with a focus on training and mentoring your employees to solve their own technology needs. This greatly reduces the number of items that enter the 'submit to IT and wait' cycle. Instead, as an operations owner, you have control over which projects get prioritized.To do this, we help companies adopt what is called a Citizen Development (CD) program. Citizen development involves training your business users on tools to solve their own problems. These tools allow rapid development to occur through: screen recorders, drag-and-drop and configuration with minimal or no coding. Business users can quickly learn and adopt these tools.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.