Relational Databases: The Big Picture

Focused View

Tom Taulli

1:56:29

60 View

1. Course Overview

1. Course Overview.mp4

01:44

2. Getting to Know Relational Databases

1. Introduction.mp4

03:57

2. Fundamentals of Relational Databases.mp4

06:09

3. Types of Databases.mp4

05:56

4. Roles.mp4

03:33

5. Alternatives.mp4

07:01

6. Conclusion.mp4

01:52

3. Understanding How Relational Databases Work

1. Introduction.mp4

01:22

2. Architecture and Deployment.mp4

05:02

3. Design Principles.mp4

03:40

4. Relationships.mp4

05:32

5. Naming Conventions.mp4

04:14

6. Data Normalization.mp4

05:32

7. Conclusion.mp4

01:51

04. Learning SQL (Structured Query Language)

01. Introduction.mp4

02:25

02. Navigating PostgreSQL.mp4

03:25

03. Creating Databases and Tables.mp4

05:41

04. Data Types.mp4

04:58

05. Primary and Foreign Keys.mp4

06:36

06. Querying Data.mp4

06:24

07. Formatting Data in a Table.mp4

03:06

08. Aggregate Functions.mp4

04:02

09. Indexes.mp4

02:39

10. Joins.mp4

03:25

11. Conclusion.mp4

01:30

5. Understanding Advanced Capabilities

1. Introduction.mp4

01:31

2. Blockchain.mp4

04:03

3. AI.mp4

04:11

4. Security.mp4

03:21

5. Conclusion.mp4

01:47

Description

In this course, you’ll learn about the core functions and practical use cases for relational databases.

What You'll Learn?

In this course, Relational Databases: The Big Picture, you’ll learn about the core functions, capabilities and use cases for relational databases. First, you’ll explore the fundamentals, such as the advantages and disadvantages, types of databases, and alternatives. Next, you’ll discover how relational databases work. This will include the architecture, design principles, and SQL (structured query language). Finally, you’ll learn about advanced features like stored procedures, object-oriented approaches, and concurrency. When you’re finished with this course, you’ll have the skills and knowledge about relational databases needed to understand the main features and uses of this powerful technology.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

PostgreSQL

Database Programming

Microsoft SQL

Tom Taulli

Instructor's Courses

Tom Taulli is the author of Modern Mainframe Development: COBOL, Databases, and Next-Generation Approaches (O'Reilly Media - amzn.to/3EJxDhe) and The Robotic Process Automation Handbook: A Guide to Implementing RPA Systems (http://amzn.to/2tURWJx). He has been programming since he was in high school, when he wrote computer programs for magazines (yes, in the 1980s, there were publications that had code listings!). When he got into college, he started a company that sold Windows software for exam preparation. He then founded other companies like Hypermart.net – which was the mid-1990s version of Shopify – that was sold to InfoSpace.com. Along the way,

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.