FrontendMasters – Complete Intro to Databases 2020-12

Description

Complete Intro to Databases is a basic database training course. Databases may seem large and there are endless barriers to learning to become a full-stack developer. In this course you will learn all the basics of using four popular open source databases including MongoDB, PostgreSQL, Neo4j and Redis and after this course you will understand when and how to use each of these databases. .

What you will learn in the Complete Intro to Databases course

Familiarity with the setting environment and lexicography of related topics

Explain NoSQL as a database that does not use SQL and then explain various topics related to MongoDB

Explain what SQL databases are and then PostgreSQL databases and how to work with them

Familiarity with Graph databases and explanation of an example of this type of database called Neo4j and familiarity with working with it

Working with Key-Value Store databases like Redis

Course information

Publisher: FrontendMasters Instructor: Brian Holt English language Level of training: basic to advanced Number of courses: 53 Duration: 7 hours and 4 minutes

Topics

Introduction

Introduction (00:00:00 – 00:06:35) Installation Notes (00:06:36 – 00:10:56) Terminology (00:10:57 – 00:25:38)

NoSQL

NoSQL (00:25:39 – 00:28:03) MongoDB (00:28:04 – 00:39:17) Querying MongoDB (00:39:18 – 00:52:16) MongoDB Logical Operators (00:52:17 – 00:57:55) Projections (00:57:56 – 01:01:33) Updating MongoDB (01:01:34 – 01:13:47) Deleting Documents (01:13:48 – 01:18:13) Indexes in MongoDB (01:18:14 – 01:28:14) Text Search Indexes (01:28:15 – 01:35:25) Aggregation (01:35:26 – 01:44:20) Aggregation Q&A (01:44:21 – 01:48:13) Write a Node.js App with MongoDB (01:48:14 – 01:59:30) Connect & Query with Mongoose & Express (01:59:31 – 02:10:55) MongoDB Ops (02:10:56 – 02:18:41)

SQL

What are SQL Databases (02:18:42 – 02:27:53) PostgreSQL (02:27:54 – 02:33:10) Creating a Database, Table, and Record (02:33:11 – 02:43:29) Select, Limit, and Where (02:43:30 – 02:48:43) Count, Sort, Update, and Delete (02:48:44 – 02:59:05) Foreign Keys (02:59:06 – 03:04:19) Introducing JOIN (03:04:20 – 03:11:36) SQL JOINS (03:11:37 – 03:19:39) Group By (03:19:40 – 03:28:20) JSON in PostgreSQL (03:28:21 – 03:41:41) Indexes in PostgreSQL (03:41:42 – 03:48:07) Node.js App with PostgreSQL (03:48:08 – 04:04:06) SQL Injection (04:04:07 – 04:10:51) Hasura (04:10:52 – 04:15:56) PostgreSQL Ops (04:15:57 – 04:18:08)

Graph

Graph Databases (04:18:09 – 04:25:19) Neo4j (04:25:20 – 04:29:30) Neo4j: Adding Nodes & Relationships (04:29:31 – 04:41:32) Querying with Match & Constraint (04:41:33 – 04:48:30) Neo4j Browser (04:48:31 – 05:00:07) Complex Neo4j Queries (05:00:08 – 05:07:53) Recommendation Algorithm Example (05:07:54 – 05:12:34) Indexes in Neo4j (05:12:35 – 05:17:20) Node.js App with Neo4j (05:17:21 – 05:33:33)

Key-Value Store

Neo4j Ops (05:33:34 – 05:35:03) Key-Value Store Databases (05:35:04 – 05:42:47) Namespaces (05:42:48 – 05:47:34) Redis Mathematical Commands (05:47:35 – 05:53:04) Redis Command Options (05:53:05 – 06:01:45) Redis Data Types (06:01:46 – 06:13:03) HyperLogLog and Streams (06:13:04 – 06:17:11) More Redis Concepts (06:17:12 – 06:27:30) Node.js App with Redis (06:27:31 – 06:36:36) Combining PostgreSQL & Redis (06:36:37 – 06:46:03) Redis Ops (06:46:04 – 06:51:10)

Wrapping Up

Wrapping Up (06:51:11 – 07:05:08)

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 1080p