Frontend Masters – Complete Intro to Databases 2020-12

Published on: 2024-02-03 14:39:14

Categories: 28

Description

Complete Intro to Databases, a period of preliminary training database is. The databases may seem big and obstacles unfailing when learning to become a developer, full-stack come. In this course, you have all the basics, use the four open source database reputed includes MongoDB, etc., PostgreSQL, etc. Neo4j and Redis’ll learn after taking this course you will understand when and how of each of these databases should use.

What the period of Complete Intro to Databases’ll learn:

Familiarity with the environment, the setup and dictionary biology related topics
Explain the NoSQL as a database, that SQL is not using, and then explain various topics related to MongoDB
Explain the essential elements of databases, SQL, and then the databases PostgreSQL and work with them
Familiarity with databases, Graph and explain one example of this type of database as Neo4j and familiarity working with it
Work with databases, Key-Value Store like Redis

Specifications period

Publisher: FrontendMasters
instructor: Brian Holt
language: English,
educational 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 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)
Photography And Life Story.(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)