Published By
Created On
11 Jan 2022 14:06:05 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
MySQL - The Basics // Learn SQL in 23 Easy Steps
JOIN me for a full beginner’s tutorial on MySQL. Learn the basics of relational databases by recreating AirBnb’s database with raw SQL https://fireship.io/tags/sql/
Buy the MySQL Pillow https://fireshipio-swag.creator-spring.com/listing/mysql-pillow
References
Diagram https://drawsql.app/fireship/diagrams/airbnb-mysql-tutorial
Installer https://dev.mysql.com/downloads/installer/
MySQL Docs https://dev.mysql.com/doc/
#mysql #database #tutorial
00:00 0. SQL is King
00:49 1. The Legend of Ted Codd
01:24 2. ORM Magic
02:00 3. What is a RDBMS?
02:37 4. Draw SQL Diagrams
02:56 5. Schemas, Datatypes, & Constraints
04:12 6. Be Normalized
05:00 7. Install MySQL on Windows/Mac
05:50 8. Create a New Database
06:13 9. SQLTools VS Code Extension
06:46 10. --comments
07:02 11. Basic SQL Syntax
08:04 12. Primary Key
08:31 13. Varchar vs Text
09:31 14. INSERT New Data
10:28 15. Read or SELECT Data
10:57 16. LIMIT & ORDER
11:23 17. Filtering with WHERE
11:50 18. LIKE pattern matching
12:19 19. INDEX for read speed
12:56 20. JOIN a relationship
15:41 21. Alias AS
16:08 22. JOIN through a middle man
16:58 23. DROP a video
Install the quiz app ?
iOS https://itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android https://play.google.com/store/apps/details?id=io.fireship.quizapp
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
My VS Code Theme
- Atom One Dark
- vscode-icons
- Fira Code Font
...
https://www.youtube.com/watch?v=Cz3WcZLRaWc
Buy the MySQL Pillow https://fireshipio-swag.creator-spring.com/listing/mysql-pillow
References
Diagram https://drawsql.app/fireship/diagrams/airbnb-mysql-tutorial
Installer https://dev.mysql.com/downloads/installer/
MySQL Docs https://dev.mysql.com/doc/
#mysql #database #tutorial
00:00 0. SQL is King
00:49 1. The Legend of Ted Codd
01:24 2. ORM Magic
02:00 3. What is a RDBMS?
02:37 4. Draw SQL Diagrams
02:56 5. Schemas, Datatypes, & Constraints
04:12 6. Be Normalized
05:00 7. Install MySQL on Windows/Mac
05:50 8. Create a New Database
06:13 9. SQLTools VS Code Extension
06:46 10. --comments
07:02 11. Basic SQL Syntax
08:04 12. Primary Key
08:31 13. Varchar vs Text
09:31 14. INSERT New Data
10:28 15. Read or SELECT Data
10:57 16. LIMIT & ORDER
11:23 17. Filtering with WHERE
11:50 18. LIKE pattern matching
12:19 19. INDEX for read speed
12:56 20. JOIN a relationship
15:41 21. Alias AS
16:08 22. JOIN through a middle man
16:58 23. DROP a video
Install the quiz app ?
iOS https://itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android https://play.google.com/store/apps/details?id=io.fireship.quizapp
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
My VS Code Theme
- Atom One Dark
- vscode-icons
- Fira Code Font
...
https://www.youtube.com/watch?v=Cz3WcZLRaWc
Author
Content Type
Unspecified
video/mp4
Language
English
More from the publisher
Controlling
VIDEO
ANGUL
angular-seo-with-rendertron
Today I bring you an elegant search engine optimization solution for Angular progressive web apps. https://angularfirebase.com/lessons/seo-angular-part-1-rendertron-meta-tags/
Live demo: https://instafire-app.firebaseapp.com
1. This solution is fully compatible with AngularFire2
2. Will render links in twitter, facebook, etc.
3. Is crawlable by googlebot, bingbot, etc.
4. Does not require Angular Universal or any weird hacks
Rendertron: https://github.com/GoogleChrome/rendertron
Cloud Functions: https://firebase.google.com/docs/functions/
Inspiration: https://medium.com/dev-channel/solving-seo-with-headless-chrome-for-your-client-side-framework-288e66fdd2b7
...
https://www.youtube.com/watch?v=ANyOZIcGvB8
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
10 VE
10-very-promising-open-source-projects
Let's explore 10 game-changing open source libraries that can make your code faster, prettier, and cheaper. A hand-picked list of the coolest dev tools and projects on GitHub in 2022.
#tech #code #top10
? Resources
Full React Course https://fireship.io/courses/react/
REST in 100 Seconds https://youtu.be/-MTSQjw5DrM
GraphQL in 100 Seconds https://youtu.be/eIQh02xuVw4
? Packages Mentioned
The Fuck https://github.com/nvbn/thefuck
Partytown https://github.com/BuilderIO/partytown
Trcp https://github.com/trpc/trpc
Mantine https://mantine.dev/
Danfo https://github.com/javascriptdata/danfojs
Supertokens https://github.com/supertokens/supertokens-core
Zinc https://github.com/prabhatsharma/zinc
MeiliSeach https://github.com/meilisearch/meilisearch
NokoDB https://github.com/nocodb/nocodb
Hi Mom https://github.com/tsivinsky/hi-mom
Hoppscotch https://github.com/hoppscotch/hoppscotch
Amplication https://github.com/amplication/amplication
? Get More Content - Upgrade to PRO
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
? My Editor Settings
- Atom One Dark
- vscode-icons
- Fira Code Font
? Topics Covered
- Best open source libraries 2022
- List of developer tools
- New developer tools
...
https://www.youtube.com/watch?v=qXUl3VsbA6o
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
5 CRA
5-crazy-new-aws-services-just-launched
AWS Re:Invent 2023 just wrapped up and Amazon released 5 new services that could change the world. Learn about Amazon One palm scanning, Trainium AI chips, Bedrock, and more.
#tech #aws #thecodereport
? Chat with Me on Discord
https://discord.gg/fireship
? Resources
AWS Re:Invent Recap https://aws.amazon.com/blogs/aws/top-announcements-of-aws-reinvent-2023/
Generating AI influencers https://youtu.be/ky5ZB-mqZKM?si=--nhdpzGKnmknlx-
AWS for the Haters https://youtu.be/ZzI9JE0i6Lc?si=R-IdmPYbrIBTSc3C
? Get More Content - Upgrade to PRO
Upgrade at https://fireship.io/pro
Use code YT25 for 25% off PRO access
? My Editor Settings
- Atom One Dark
- vscode-icons
- Fira Code Font
? Topics Covered
- Custom AI chips from AWS Re:Invent
- Top cloud tech of 2023
- How does palm scanning work
- AWS vs Nvidia chips
- How to build an AI SaaS in the cloud
...
https://www.youtube.com/watch?v=ekPbZqPvCRA
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
JAVAS
javascript-pro-tips-code-this,-not-that
New Series! Code this ?, not that ?. Learn how to write solid modern JavaScript and avoid bad code from the olden days. https://angularfirebase.com
- Source https://github.com/codediodeio/code-this-not-that-js
...
https://www.youtube.com/watch?v=Mus_vwhTCq0
Transaction
Created
4 months ago
Content Type
Language
video/mp4
Controlling
VIDEO
GIT I
git-it-how-to-use-git-and-github
Learn how to use Git and Github ?? in this interactive tutorial by sending a pull request to this repo in exchange for a free AngularFirebase sticker ?https://github.com/codediodeio/gimmie-sticker
- PRO https://angularfirebase.com/pro
- Atlassian https://www.atlassian.com/git/tutorials
...
https://www.youtube.com/watch?v=HkdAHXoRtos
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
WHAT
what-will-we-build-next-channel-update
Thank you for 200K ? subscribers! Here's a quick look at my content plans for the next few months, including a full Angular Firebase project course. https://fireship.io
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
...
https://www.youtube.com/watch?v=OWy0e231eMI
Transaction
Created
4 months ago
Content Type
Language
video/mp4
Controlling
VIDEO
ANGUL
angular-universal-with-firebase
Learn how to server-side render your Firebase app with Angular Universal to make deep links readable by social media bots and search engines. https://angularfirebase.com/lessons/server-side-rendering-firebase-angular-universal/
- Universal https://angular.io/guide/universalf
- Firestore https://firebase.google.com/docs/firestore/
- AngularFire2 https://github.com/angular/angularfire2
...
https://www.youtube.com/watch?v=wij2-gyG12E
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
ANGUL
angular-universal-on-cloud-functions-or
Learn how to perform serverside rendering (SSR) with Angular Universal, then deploy to Firebase Cloud Functions or GCP AppEngine https://fireship.io/lessons/angular-universal-firebase/ for better perf and SEO
Universal - https://angular.io/guide/universal
Functions - https://firebase.google.com/docs/functions
GCP https://cloud.google.com/sdk
...
https://www.youtube.com/watch?v=VS0zsXvDJ08
Transaction
Created
4 months ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
COLLE
collection-group-queries-in-firestore
Learn how to use the new Collection Group Query feature to join subcollections. Great for hierarchical or deeply-nested data structures like threaded reddit-style comments https://fireship.io/lessons/collection-group-query-firestore/
#firebase
Take the firebase quizzes ?
iOS https://itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android https://play.google.com/store/apps/details?id=io.fireship.quizapp
Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
...
https://www.youtube.com/watch?v=fQ4u1J717ys
Transaction
Created
4 months ago
Content Type
Language
video/mp4
fr