Frontend Master – Complete Introduction to Databases 2020-12 – Download

explanation

Complete Intro to Databases. This is the database preliminary training period. When learning how to become a developer, the databases can be big and the obstacles can seem endless. This course covers all the basics and uses four popular open source databases, including MongoDB and PostgreSQL. Neo4j and Redis After taking this course, you will understand when and how to use each of these databases.

Here’s what you’ll learn in this introductory database course:

Knowledge of environment, setting, and prior biology-related topics.
It explains NoSQL as a database, what SQL doesn’t use, and discusses various topics related to MongoDB.
Describes and works with the essentials of databases, SQL, and database PostgreSQL.
Knowledge of databases, graphing one example of this type of database such as Neo4j and knowledge of working with it.
Working with databases, key-value stores like Redis

Specification period

Publisher: FrontendMasters
teacher: Brian Holt
Language: English,
Education level: Beginner to advanced;
Number of classes: 53
Duration: 7 hours 5 minutes

This process:

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)
MongoDB Query (00:39:18 – 00:52:16)
MongoDB logical operators (00:52:17 – 00:57:55)
Photos and life stories. (00:57:56 – 01:01:33)
MongoDB update (01:01:34 – 01:13:47)
Delete document (01:13:48 – 01:18:13)
Indexes in MongoDB (01:18:14 – 01:28:14)
Text Search Index (01:28:15 – 01:35:25)
Tally (01:35:26 – 01:44:20)
Tally, Q&A (01:44:21 – 01:48:13)
Writing Node.js apps with MongoDB (01:48:14 – 01:59:30)
Connect and query with Mongoose & Express (01:59:31 – 02:10:55)
MongoDB operations (02:10:56 – 02:18:41)

SQL

What is a SQL Database (02:18:42 – 02:27:53)
PostgreSQL(02:27:54 – 02:33:10)
Creating databases, tables and records (02:33:11 – 02:43:29)
Selection, Restrictions and Location (02:43:30 – 02:48:43)
Calculate, Sort, Update and Delete (02:48:44 – 02:59:05)
Foreign Key (02:59:06 – 03:04:19)
Introduction to JOIN (03:04:20 – 03:11:36)
SQL Join (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 operations (04:15:57 – 04:18:08)

graph

Graph database (04:18:09 – 04:25:19)
Neo4j (04:25:20 – 04:29:30)
Neo4j: Adding nodes and relationships (04:29:31 – 04:41:32)
Querying with matches and constraints (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)
Index in Neo4j (05:12:35 – 05:17:20)
Node.js app with Neo4j (05:17:21 – 05:33:33)

key-value store

Neo4j Operations (05:33:34 – 05:35:03)
Key-value store database (05:35:04 – 05:42:47)
Namespace (05:42:48 – 05:47:34)
Redis math 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)
Additional Redis concepts,(06:17:12 – 06:27:30)
Node.js apps with Redis (06:27:31 – 06:36:36)
Combining PostgreSQL and Redis (06:36:37 – 06:46:03)
Redis Operations (06:46:04 – 06:51:10)