- 49
- 7 974
Sohail Jafri
India
เข้าร่วมเมื่อ 30 ธ.ค. 2021
Sharing the knowledge I have gained working in the industry for over 5 years
Mastering User and Permission Management in MySQL | Day 17 Of MySQL
🔴 Welcome to Day 17 MySQL Mastery: User and Permission Management! 🚀
MySQL Cheatsheet: Coming Soon
Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4
📌 What You’ll Learn in This Video:
Managing users and their permissions is essential for securing your database. In this tutorial, we’ll explore User and Permission Management in MySQL using practical examples.
Here’s what’s included:
✅ How to create users with specific access permissions.
✅ Granting, revoking, and managing privileges effectively.
✅ Viewing user accounts and understanding their scope.
✅ Best practices for keeping your database secure.
🔥 Why You Need This Tutorial
Security: Protect your database by providing limited access to users.
Customization: Grant users only the permissions they need.
Efficiency: Simplify user and permission management with a structured approach.
👍 Don’t forget to like, subscribe, and enable notifications for more advanced MySQL tutorials!
💬 Have Questions? Drop them in the comments, or connect with me on socials below.
🥂 Socials
Twitter: x.com/thesohailjafri
LinkedIn: www.linkedin.com/in/thesohailjafri/
Github: github.com/thesohailjafri
Instagram: thesohailjafri
⏰ Timestamp Breakdown
00:00 : Introduction
00:20 : Importance of User and Permission Management
01:15 : Creating Users
03:10 : Viewing Users
04:30 : Granting Privileges (Specific vs. Global)
06:45 : Revoking Privileges
08:00 : Best Practices for User Management
MySQL Cheatsheet: Coming Soon
Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4
📌 What You’ll Learn in This Video:
Managing users and their permissions is essential for securing your database. In this tutorial, we’ll explore User and Permission Management in MySQL using practical examples.
Here’s what’s included:
✅ How to create users with specific access permissions.
✅ Granting, revoking, and managing privileges effectively.
✅ Viewing user accounts and understanding their scope.
✅ Best practices for keeping your database secure.
🔥 Why You Need This Tutorial
Security: Protect your database by providing limited access to users.
Customization: Grant users only the permissions they need.
Efficiency: Simplify user and permission management with a structured approach.
👍 Don’t forget to like, subscribe, and enable notifications for more advanced MySQL tutorials!
💬 Have Questions? Drop them in the comments, or connect with me on socials below.
🥂 Socials
Twitter: x.com/thesohailjafri
LinkedIn: www.linkedin.com/in/thesohailjafri/
Github: github.com/thesohailjafri
Instagram: thesohailjafri
⏰ Timestamp Breakdown
00:00 : Introduction
00:20 : Importance of User and Permission Management
01:15 : Creating Users
03:10 : Viewing Users
04:30 : Granting Privileges (Specific vs. Global)
06:45 : Revoking Privileges
08:00 : Best Practices for User Management
มุมมอง: 20
วีดีโอ
Backup and Restore in MySQL Workbench | Day 16 Of MySQL
มุมมอง 124 ชั่วโมงที่ผ่านมา
🔴 Welcome to Day 16 MySQL Mastery: Backups and Restore Using MySQL Workbench! 🚀 🎥 MySQL Cheatsheet: Coming Soon 📄 Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: In this tutorial, we dive into one of the most critical skills in database management-Backup and Restore in MySQL. You’ll learn ...
Error Handling in MySQL | Day 15 Of MySQL
มุมมอง 2314 ชั่วโมงที่ผ่านมา
🔴 Welcome to Day 15 MySQL Mastery: Error Handling in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: In this tutorial, we’re tackling a crucial aspect of database management-Error Handling in MySQL. Learn how to identify, manage, and handle errors eff...
NextJS App Router Static Site Generation and Server Side Render | Easy and Full Setup
มุมมอง 11816 ชั่วโมงที่ผ่านมา
🔗 Resources: Github Repo: github.com/thesohailjafri/app-router-ssg-ssr 🚀 Discover how to leverage the Next.js App Router to implement Server-Side Rendering (SSR) and Static Site Generated (SSG) effectively! In this video, we’ll break down how to setup SSG and SSR in NextJs Application using App Router 👍 If you find this video helpful, please like, subscribe, and hit the notification bell to sta...
NextJS Pages Router Static Site Generated and Server Side Render | Easy and Full Setup
มุมมอง 7716 ชั่วโมงที่ผ่านมา
🔗 Resources: Github Repo: github.com/thesohailjafri/pages-router-ssg-ssr 🚀 Discover how to leverage the Next.js App Router to implement Server-Side Rendering (SSR) and Static Site Generated (SSG) effectively! In this video, we’ll break down how to setup SSG and SSR in NextJs Application using Pages Router 👍 If you find this video helpful, please like, subscribe, and hit the notification bell to...
Triggers in MySQL | Day 14 Of MySQL
มุมมอง 7621 ชั่วโมงที่ผ่านมา
🔴 Welcome to Day 14 of MySQL Mastery: Understanding Triggers in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Understand the concept of triggers and their role in automating database processes. Learn how to define a trigger using practical, step-by-...
How To Create a Dynamic Sitemap in Next.js | Works for version 13, 14, 15
มุมมอง 135วันที่ผ่านมา
Learn how to create a dynamic sitemap for your Next.js website 🗺️ Works Both App & Pages Router can be used with Sanity CMS, Contentful, Database or any other data source. In this video, I'll walk you through two straightforward approaches to adding a dynamic sitemap to your Next.js project, covering both App and Pages Routers. A sitemap.xml is crucial for improving SEO by making sure search en...
Functions in MySQL | Day 13 Of MySQL Mastery
มุมมอง 10614 วันที่ผ่านมา
🔴 Welcome to Day 13 of MySQL Mastery: Understanding Functions in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Unlock the Power of Functions in MySQL: 1️⃣ Creating a Simple Function: Learn how to define a reusable function to simplify your SQL code ...
Stored Procedures in MySQL | Day 12 Of MySQL Mastery
มุมมอง 5321 วันที่ผ่านมา
🔴 Welcome to Day 12 of MySQL Mastery: Understanding Stored Procedures in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Unlock the Power of Stored Procedures in MySQL: Creating a Simple Stored Procedure: Learn how to define a basic stored procedure t...
Views in MySQL | Day 11 Of MySQL
มุมมอง 8228 วันที่ผ่านมา
🔴 Welcome to Day 11 MySQL Mastery: Understanding Views in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Master Views in MySQL with Practical Examples: Simple View: Learn how to create basic views that encapsulate a single table's data for easier acc...
Primary, Unique, Composite Indexes in MySQL | Day 10 Of MySQL Mastery
มุมมอง 66หลายเดือนก่อน
🔴 Welcome to Day 10 of MySQL Mastery: Understanding Indexes in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Boost Database Performance with Indexes in MySQL: Primary Index: Learn how MySQL automatically creates a primary index when you define a pri...
Primary, Foreign , Unique, Default, Not Null, Check Constraints in MySQL | Day 9 Of MySQL Mastery
มุมมอง 57หลายเดือนก่อน
🔴 Welcome to Day 9 of MySQL Mastery: Understanding Constraints in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Unlock the Power of Constraints in MySQL: PRIMARY KEY: Understand how to use the primary key constraint to ensure unique identification f...
How to add Sitemap In Next.JS | Works for App and Pages Router
มุมมอง 309หลายเดือนก่อน
🔍 How to Add a Sitemap in Next.js (App & Pages Router) In this video, I'll walk you through two straightforward approaches to adding a static sitemap to your Next.js project, covering both App and Pages Routers. A sitemap is crucial for improving SEO by making sure search engines can easily crawl and index your pages. This guide will help you implement a sitemap to enhance visibility and rankin...
Subqueries In MySQL | Day 8 Of MySQL Mastery
มุมมอง 103หลายเดือนก่อน
🔴 Welcome to MySQL Mastery: Understanding Subqueries in MySQL! 🚀 MySQL Cheatsheet: Coming Soon Detailed MySQL Notes: thesohailjafri.notion.site/MySQL-Mastery-YT-TheSohailJafri-d807b466bd43454aa4f7beb495a27984?pvs=4 📌 What You’ll Learn in This Video: Master Subqueries in MySQL with Clear Examples: Single-Row Subqueries: Explore how to use subqueries that return a single row, often used to fetch ...
JOIN Tables in MySQL | Day 7 Of MySQL Mastery
มุมมอง 85หลายเดือนก่อน
JOIN Tables in MySQL | Day 7 Of MySQL Mastery
MySQL Set Operators: UNION & UNION ALL | Day 6 Of MySQL Mastery
มุมมอง 652 หลายเดือนก่อน
MySQL Set Operators: UNION & UNION ALL | Day 6 Of MySQL Mastery
MySQL Aggregation Operators: COUNT, SUM, AVG, MIN, MAX | Day 5 Of MySQL Mastery
มุมมอง 1132 หลายเดือนก่อน
MySQL Aggregation Operators: COUNT, SUM, AVG, MIN, MAX | Day 5 Of MySQL Mastery
MySQL Arithmetic, Comparison, Logical Operators | Day 4 Of MySQL Mastery
มุมมอง 1052 หลายเดือนก่อน
MySQL Arithmetic, Comparison, Logical Operators | Day 4 Of MySQL Mastery
MySQL Normalization, Primary And Foreign Keys | Day 3 Of MySQL Mastery
มุมมอง 703 หลายเดือนก่อน
MySQL Normalization, Primary And Foreign Keys | Day 3 Of MySQL Mastery
MySQL Installation and Setup | Day 1 Of MySQL Mastery
มุมมอง 1004 หลายเดือนก่อน
MySQL Installation and Setup | Day 1 Of MySQL Mastery
Chakra UI Responsiveness | In Hindi | T10
มุมมอง 944 หลายเดือนก่อน
Chakra UI Responsiveness | In Hindi | T10
Chakra UI Formik And Yup Form Validation | In Hindi | T8
มุมมอง 945 หลายเดือนก่อน
Chakra UI Formik And Yup Form Validation | In Hindi | T8
Chakra UI Accordion Component | In Hindi | T7
มุมมอง 1005 หลายเดือนก่อน
Chakra UI Accordion Component | In Hindi | T7
Chakra UI Center and Card Component | In Hindi | T6
มุมมอง 905 หลายเดือนก่อน
Chakra UI Center and Card Component | In Hindi | T6
Tabs, Heading And Text Component | In Hindi | T5
มุมมอง 665 หลายเดือนก่อน
Tabs, Heading And Text Component | In Hindi | T5
Chakra UI Stack and Simple-Grid Component | In Hindi | T4
มุมมอง 1175 หลายเดือนก่อน
Chakra UI Stack and Simple-Grid Component | In Hindi | T4
Chakra UI Image, Box and Flex Component | In Hindi | T3
มุมมอง 2795 หลายเดือนก่อน
Chakra UI Image, Box and Flex Component | In Hindi | T3
❤
SSG !== Server side generated SSG === Static Site Generation 😂
KEWL 🤡
My bad they are mouth full to say back n forth Server Side Render and Static Site Generated
Learned so much about SSR and SSG today
Appreciate it 💪
I love how you kept things practical without skipping the theory.
Thank you!
Please make more videos like this
Working on it
You made SSR setup so much easier than the documentation. Keep up the awesome work!
Appreciate the kind words! 👊
Good
Appreciate you watching! 🙏
Good
Thanks for the support bro! 🙏
Good
Appreciate you watching! 🙌
Thank you bhai 💪🔥
Good
Appreciate it man 👊
💡 Great content
Thank you so much brother
❤
Good job brother
😊😊😊😊
Appreciate the love, little brother! 👊
Today I learned something new
you give good information
Thanks for checking it out! 🙌
❤
thank you mamu
❤ good
Aye thanks 👊
👑💫
Aye thank you so much 👊
Great video 👍
Thank you shruti 👊
Just one question: Are there performance impacts of using too many constraints on a single table in MySQL?
Everything in moderation is good
Learning something new with every video of yours
This helps me make more!!
I didn’t realize how important these constraints were until I saw this! It’s incredible how much cleaner and more reliable my database designs will be now.
Glad they helped you!
Loved the explanation! Can you talk about how the FOREIGN KEY constraint behaves when the parent table data is updated or deleted?
yes they trigger based on what you have assigned them to
Wow, this is exactly what I needed! You covered all the key constraints so well, and I feel much more confident working with MySQL now
Happy to hear it! Keep grinding!
Thank you for simplifying MySQL for me
Happy to hear that! Keep on learning!
well explained, thanks, jazak Allah
Jazak Allah, I'm happy you found the video useful!
Helpful 👍.
Awesome! Glad you found it helpful. <3
you get new subscriber; thanks
Thanks for subscribing! Hope you find the video helpful.❤️
A sitemap is like a roadmap for a website. Imagine you’re visiting a huge museum and you’re given a map at the entrance. That map shows you the layout, the exhibits, and the quickest way to get to where you want. A sitemap does the same for a website! There are two main types: XML Sitemaps: Made mostly for search engines to help them crawl and index the site. HTML Sitemaps: These are user-friendly and often help visitors navigate large websites with lots of pages.
Quality content 🙌 Got to learn something new... Could have started the video, by explaining what is sitemap.. and why is it needed.. basically the topic. Other than that, keep up the good work 😊
You are absolutely right, I should have explained what a sitemap is and its importance. Thanks for the feedback! I will keep that In mind. I skiped it as I though it is a niche problem but I should have explained it.
This video is a life saver 🙏
Glad it helped. do let me know if you faced any problem
Great video
Glad you enjoyed it
This just made my sitemap setup much easier.
Glad it helped you!!!
I just started working on SEO for my project, and adding a sitemap was next on the list
Awesome! Hope this video helps you with your SEO journey.
Thanks for showing both approaches so thoroughly. Really helped me get it set up quickly
Happy to help you get that set up quickly!
The way you explain things makes it so easy to understand, even for complex setups like sitemaps in Next.js. I can already see this saving me a ton of time
You’re really good at explaining complex topics. I’ve watched a few other guides, but yours is by far the best. Thanks for the excellent walkthrough!
Appreciate the kind words! 🔥
Such a useful video for Next.js developers! I was unsure about the setup, but you made it crystal clear. Thanks for sharing your knowledge!
Awesome! Glad I could help you clear things up.
This tutorial is exactly what I needed! The step-by-step instructions made it super easy to follow. Thanks for making it simple for both app and pages routers!
Awesome! I'm always trying to simplify things.
Proud of u bhai 😢
Sachi? Thanks bhai for visiting the video and commenting. Feedback does help a lot to keep up the good work
❤❤
Awesome explanation - subqueries used to be confusing, but now it feels so much clearer!
That's great to hear! Glad I could help clarify!
Great breakdown of subqueries! I finally get how they fit into MySQL workflows. Thanks!
Awesome to hear that you found it helpful!
Wow, this video just made subqueries click for me. Thanks for simplifying it!
Happy to hear it made sense, keep grinding!
You made subqueries feel approachable, great examples throughout!
Thanks for the feedback, glad you found the examples helpful!
Loving this series! The subquery examples here were spot on. Keep it up!
Glad you're enjoying the series! Subqueries are so powerful.
Perfect timing! I was struggling with subqueries, and this video really helped. 🙌
Awesome, happy to hear it! 👍
Nice video! I just want to add a brief description of accessibility. If your web application is developed with accessibility features, it means you are supporting users with visual or hearing disabilities. Screen readers can work effectively on websites that incorporate accessibility features. Be sure to check out the WCAG guidelines for more information on this.
Thanks for the input, accessibility is definitely crucial! and Chakra UI does makes with most of the accessibility so its great out of the box!
Good ❤
Thanks for watching!