- SurrealDB Fundamentals
- Introduction
- Welcome to SurrealDB University
- Intro to SurrealDB
- Why SurrealQL is SQL-like
- Part 1: Schemaless CRUD
- Introduction
- Record IDs
- Inserting data
- Reading data
- Updating data
- Deleting data
- Part 2: Adding relationships
- Introduction
- Graph relations
- Record links
- Relational style joins
- Part 3: Making it Schemafull
- Introduction
- Define tables, views and Change Feeds
- Define fields, constraints and assertions
- Schemafull CRUD
- Part 4: Making it secure
- Introduction
- Authentication
- Query capabilities
- Part 5: Making it Performant
- Introduction
- Indexing & data model considerations
- Deployment & storage layer considerations
- Completion
- Certificate pending completion
SurrealDB Fundamentals
Hi, I’m Alexander, welcome to the SurrealDB Fundamentals course!
The goal of this course is to help you build your idea as soon as possible.
To achieve that, we’ll do a quick intro to multi-model databases, then go through the five fundamental parts of building a production-ready database:
- Part 1: Rapid prototyping using schemaless CRUD
- Part 2: Adding relationships between tables
- Part 3: Making it schemafull to ensure consistency
- Part 4: Making it secure (because you don’t want data leaks)
- Part 5: Making it performant (because time is money)
Each part primarily focuses on practical hands-on learning with concepts explained in context instead of the typical boring slides and annoying quizzes.
You’ll find both video and text so you can pick the mode of learning that works best for you.
All the queries we’ll explore are runnable and will be right next to the text or video in our embedded Surrealist query interface. This means you don’t need to install anything and can always follow along with what is happening.
If at any point you’re wondering, “What if I do X?” go right ahead and try it in the editor. You can always adjust any query that is shown or try out new ones.
Surreal Deal Store
The database we’ll build throughout this course is the Surreal Deal Store, which you might have seen in our documentation, blogs, or YouTube videos.
A lot of thought has been put into making this as useful as possible for learning the various features and patterns everyone should be aware of. It was created to be realistic and production-like, but also simplified such that it’s not overwhelming to learn.
That is also why we’ve broken it down into 5 parts such that we start simple and gradually work our way into the full database you see here.
We’d advise you to go through each step in sequence as that is how you’ll learn the fastest and avoid massive jumps in complexity, which might leave you confused.
Even if you’re already experienced, doing each step will plug the gaps in your knowledge the fastest.
By the end of this course you should be comfortable enough with SurrealDB and SurrealQL to start building your idea.
Feedback and support
You can join our amazingly helpful community on Discord for support, where you’ll also find the entire SurrealDB team.
If you have any feedback about the course, reach out at education@surrealdb.com or the university channel in Discord.
We take feedback very seriously and will try our best to fix it!