Description
Complete Intro to Databases is an introductory database training course. Databases can seem overwhelming and overwhelming when learning to become a full-stack developer. In this course, you will learn all the basic principles of using four famous open source databases, including MongoDB, PostgreSQL, Neo4j and Redis, and after completing 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:
- Getting to know the startup environment and the vocabulary of related topics
- Explaining NoSQL as a database that does not use SQL and then explaining various topics related to MongoDB
- Explaining what SQL databases are and then PostgreSQL databases and working with them
- Getting to know Graph databases and explaining an example of this type of database called Neo4j and getting to know how to work with it
- Working with Key-Value Store databases like Redis
Course details
Publisher: FrontendMasters
teacher: Brian Holt
English language
Training level: introductory to advanced
Number of courses: 53
Duration: 7 hours and 4 minutes
Course 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)
Course prerequisites:
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 1080p
download link
Password file(s): www.downloadly.ir
Size
2.48 GB