آموزش MySQL : طراحی پایگاه داده فروشگاه آنلاین از صفر تا صد
Sarvin Style Coding
@sarvinstyleAbout
سلام! من سروینخان طباطبایی هستم؛ برنامهنویس ارشد با بیش از ۲۵ سال سابقه در توسعه وب و موبایل. توی این کانال تجربیاتم رو به اشتراک میذارم تا به شما کمک کنم برنامهنویسی رو اصولی، کاربردی و حرفهای یاد بگیرید. اگه به برنامهنویسی علاقهمندید، اینجا جای شماست! 🔔 حتماً کانال رو سابسکرایب کنید تا ویدیوهای جدید رو از دست ندید. برنامهنویسی فقط یه مهارت نیست — یه مسیر هیجانانگیزه! Hi! I'm Sarvin Khan Tabatabaei, a senior developer with 25+ years of experience in web and mobile development. On this channel, I share practical knowledge and insights to help you learn coding the right way — clear, professional, and step-by-step. 🎯 Whether you're a beginner or looking to grow, you're in the right place. 🔔 Subscribe and start your journey! Coding is more than a skill — it’s a powerful journey.
Latest Posts
![آموزش کامل ری اکت [ React js ] :نحوه دریافت داده از API (Fetch data from API)](https://imgz.pc97.com/?width=500&fit=cover&image=https://i.ytimg.com/vi/Hfi0P__p1iw/hqdefault.jpg)
Video Description
بهترین راه برای یادگیری MySQL، آموزش پروژه محور MySQL هست که شما می تونید در مدت 3 ساعت MySQL پیشرفته را یاد بگیرید. من در این سه قسمت آموزش جامع MySQL تجربیات 20 ساله خودم را با شما به اشتراک می گذارم. این آموزش MySQL از مبتدی تا پیشرفته بوده و من از صفر یک پایگاه داده را با توضیحات کامل و جامع طراحی می کنم. در این آموزش پروژه محور، پایگاه داده فروشگاه آنلاین را طراحی کردم و نحوه تعریف فیلدها را توضیح دادم و بعد فوت و فن انتخاب primary key یا همان کلید را توضیح دادم. در مورد کلیدهای از نوع UUID کامل توضیح دادم. نحوه تعریف مقدار پیشفرض برای انواع مختلف داده کاملا توضیح دادم. همینطور نحوه ایجاد Relation در MySQL را مو به مو شرح دادم. در درس بعدی هم روی همین پایگاه داده کلی عملیات انجام دادم که می توانید از لینک زیر آن را تماشا کنید. https://youtu.be/yXsT5FzbqRY اما قبل از تماشا این آمورش MySQL پیشفرفته باید، آموزش کامل MySQL سروین استایل را تماشا کنید تا با دستورات MySQL آشنا و یادبگیرید. https://youtu.be/gaUhNlSytUI
Upgrade Your Everyday
AI-recommended products based on this video
Amazon Echo Show 8 (newest model), With Spatial Audio, Smart Home Hub, and Alexa, Charcoal
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Wireless Earbuds, Bluetooth 5.4 Headphones, True Wireless Stereo Earphones with IPX7 Waterproof, Noise Cancelling Mic, Fast Charging and Comfort Fit Ear Buds for Sports/Workouts - Black
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Smart Watch for Men/Women, 1.95" AMOLED Fitness Tracker Watches with Bluetooth Calls/Flashlight/100+ Sport Modes Heart Rate/Sleep Monitor Ultra Lightweight Ultrathin Design
Smart Watch for Men Women (Answer/Make Call), 1.96" HD Smartwatch Fitness Activity Tracker, 110+ Sports IP68 Waterproof, Heart Rate/Sleep Monitor/Pedometer/Calories, Fitness Watch for Android iOS
![Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/61nNNMI1cFL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
![Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/6105jZyXyPL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
NOCO Boost GB40: 1000A UltraSafe Jump Starter – 12V Lithium Battery Booster Pack, Portable Jump Box, Power Bank & Jumper Cables - for 6.0L Gas and 3.0L Diesel Engines
UGREEN Nexode Power Bank 20000mAh 130W Portable Charger 72Wh PD Fast Charging 3-Port USB C Battery Pack with TFT Smart Display for MacBook/iPad/iPhone 16/Samsung S24 and More
ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More
VOLTME Portable Charger, Slim 10000mAh 5V/3A Power Bank, USB C in&Out High-Speed Charging Battery Pack, Travel Essentials Dual Output Compatible with iPhone 16 15 14 13 12 Samsung Google iPad etc
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Bose QuietComfort Bluetooth Headphones, Wireless Headphones with Active Over Ear Noise Cancelling and Mic, Deep Bass, Up to 24 Hours of Playtime, White Smoke
Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (Black)
Eye Contact Web Camera for Desktop Computer – 1080P USB Camera with Microphone & Stand, Center Cam for Laptop or Desktop, Manual Focus, Plug & Play for macOS & Windows（Black）
![PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]](https://m.media-amazon.com/images/I/61PnVkv6KKL._AC_UL960_FMwebp_QL65_.jpg)
PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]
![Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film](https://m.media-amazon.com/images/I/815keamN-BL._AC_UL960_FMwebp_QL65_.jpg)
Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film
