- Видео 8
- Просмотров 1 386
61d
Добавлен 14 фев 2023
61D Lecture 9: Database CRUD Operations (Drizzle part 2)
Create, Read, Update, and Delete data from your database using Drizzle ORM. Then take on more advanced filtering, upsert operations, and aggregations. Finally, learn how to write joins both with Drizzle's native sql wrapping and their custom queries api.
Lecture Starter Code: github.com/CS61D/Lecture-Databases
Drizzle Queries: orm.drizzle.team/docs/rqb
Drizzle Aggregation Helpers: orm.drizzle.team/docs/select#aggregations-helpers
Timestamps
Introduction
0:00 Setup
4:41 SQL
Select
7:53 Basic example
14:44 Sorting
19:45 Efficient Offset and Pagination
Insert, Update, Delete
28:53 Basic Insert
30:42 Batch Insert
31:42 Update
33:54 Upsert
41:10 Delete
Joins
42:03 Types of Joins
44:34 Left Join Example
47:00 Comp...
Lecture Starter Code: github.com/CS61D/Lecture-Databases
Drizzle Queries: orm.drizzle.team/docs/rqb
Drizzle Aggregation Helpers: orm.drizzle.team/docs/select#aggregations-helpers
Timestamps
Introduction
0:00 Setup
4:41 SQL
Select
7:53 Basic example
14:44 Sorting
19:45 Efficient Offset and Pagination
Insert, Update, Delete
28:53 Basic Insert
30:42 Batch Insert
31:42 Update
33:54 Upsert
41:10 Delete
Joins
42:03 Types of Joins
44:34 Left Join Example
47:00 Comp...
Просмотров: 79
Видео
61D Lecture 0: Developer Essentials: Bash, Git, and Markdown
Просмотров 17914 дней назад
Develop fundamental skills needed by all software developers. Use basic bash commands to create and edit files from the terminal. Track changes to your projects using Git, and unlock the ability to collaborate on GitHub. Finally, use markdown to document your software projects. Course Setup: www.61d.org/docs/setup Git, Markdown, and Bash Assignment: www.61d.org/docs/Assignments/git-md-bash Bash...
61D Lecture 8: Relational Data Modeling (Drizzle Part 1)
Просмотров 1743 месяца назад
Create a complex schema for a relational database using Drizzle ORM. Define one to one, one to many, and many to many relationships. Lecture Starter Code: github.com/CS61D/Lecture-Databases Timestamps Choosing a Database 0:00 Intro 1:57 What is a Database? 2:29 Special Purpose Databases 3:25 Comparing Relational vs Document Databases 8:49 Choosing a Relational Database Why Drizzle ORM 11:03 Pur...
61D Lecture 7: Forms and Validation
Просмотров 1324 месяца назад
Intro: 0:00 Overview 0:43 Preview of finished form 1:50 Setup Form Basics 4:12 Form Component 5:44 Form Elements React Hook Form 9:31 React Hook Form 10:40 useForm 12:32 Strict Typing 15:10 handleSubmit 19:08 register 23:11 Side note 23:42 Validation with React Hook Form 26:40 Displaying Error Messages Zod Validation 29:39 Zod Validation 31:37 Schema Declaration 34:34 Type Validation (Date and ...
61D Lecture 4: React State and Context
Просмотров 1134 месяца назад
Learn how to make your React project interactive by using state. Learn common patterns when using state and how to extract state into a reusable context. Finally, persist state data in the browser with local storage and useEffects. Completed Lecture Code: github.com/CS61D/Lecture-React Finished Project: dice.61d.org/ Timestamps State Intro 0:00 Recap 1:19 Why we need state 4:21 Simple useState ...
61D Lecture 3: React Basics
Просмотров 2584 месяца назад
Learn the fundamental principles of React from the ground up. Create a React project, use common html tags, and create and compose your own React Components. Sample data gist: gist.github.com/aidansunbury/970875b69bd043a8ad582d66d789edf2 Biome Setup: 61d.org/docs/bonus/extensions#biomecanicadelosejercicios Completed Dice Roller: dice.61d.org/ Timestamps: Intro 0:00 Lecture Outline 0:47 Dice rol...
61D Lecture 2: TypeScript
Просмотров 1324 месяца назад
Make JavaScript code easier to maintain and scale by adding TypeScript types. Learn how to add types to basic variables, objects, and functions. Then dive into type inference and generics. Lecture Code: github.com/CS61D/Lecture-TypeScript Setup Assignment: 61d.org/docs/Assignments/setup TypeScript Notes: www.61d.org/docs/Readings/typescript TypeScript Assignment: github.com/CS61D/Assignment-Sta...
61D Lecture 1: JavaScript
Просмотров 3234 месяца назад
Learn fundamental features of the most popular programming language in the world: JavaScript. This introduction covers the fundamentals of JavaScript syntax and some of the most commonly used functions from the standard library. Lecture Code: github.com/CS61D/Lecture-JavaScript JavaScript Practice Problems: github.com/CS61D/Assignment-Starter-Javascript JavaScript Notes: www.61d.org/docs/Readin...
Hey msn these two drizzle tutorial very helpful.
thanks for sharing this
Keep going
"Not the tutorial we deserved, but the tutorial we needed" Im sorry I just trying to be funny by quoting batman movie. Thanks for the tutorial , cant wait to watch another tutorial, road to react mastery. Thank you 🔥🔥🔥
41:19 The note should say "Edit: Should be <=, not <, since we want to include today as a valid date." Sorry about the text getting mangled up!
very useful my friend thanks a lot ❤️
Note: In the final version of the dice roller, bugs can appear when using dice names as keys while rendering the DieDisplay. To fix this, either add a unique id to every die and use the id as a key, or enforce unique names for each die.
Keep up the good Work :)