Frontend Masters – Complete Introduction to Databases 2020-12

Description

Complete introduction to databases, a phase of the preparatory training database. The databases seem large and there are endless obstacles on the path to becoming a full stack developer. In this course, you will master all the basics and use the four open source databases including MongoDB, etc., PostgreSQL, etc. After taking this course, you will learn when and how each of these databases should be used.

What you’ll learn in the Complete Introduction to Databases section:

Familiarity with the environment, structure and topics related to biology in the dictionary
Explain NoSQL as a database that does not use SQL, and then explain various topics related to MongoDB
Explain and work with the essential elements of databases, SQL and then PostgreSQL databases
Familiarity with databases, graphical representation and explanation of an example of this type of database such as Neo4j and familiarity with using it
Work with databases, key-value stores like Redis

Specification period

Publisher: FrontendMasters
Teacher: Brian Holt
Language: English,
Education Level: Introductory to Advanced,
the number of lessons: 53
Duration: 7 hours and 5 minutes

This course:

introduction

Introduction (00:00:00 – 00:06:35)
Installation instructions (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)
Query MongoDB (00:39:18 – 00:52:16)
MongoDB logical operators (00:52:17 – 00:57:55)
Photography and life story. (00:57:56 – 01:01:33)
Update MongoDB (01:01:34 – 01:13:47)
Delete 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, Questions and Answers (01:44:21 – 01:48:13)
Write a Node.js app with MongoDB (01:48:14 – 01:59:30)
Connect and 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 dataset (02:33:11 – 02:43:29)
Select, limit and where (02:43:30 – 02:48:43)
Counting, sorting, updating and deleting (02:48:44 – 02:59:05)
Foreign key (02:59:06 – 03:04:19)
Introduction to 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: Add nodes and relationships (04:29:31 – 04:41:32)
Queries 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 storage

Neo4j Ops (05:33:34 – 05:35:03)
Key-value storage 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)
Combination of PostgreSQL and Redis (06:36:37 – 06:46:03)
Redis Ops (06:46:04 – 06:51:10)