{"id":2926,"date":"2026-08-10T09:00:34","date_gmt":"2026-08-10T09:00:34","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/laracasts-mysql-database-design-2019-8\/"},"modified":"2026-08-10T09:00:34","modified_gmt":"2026-08-10T09:00:34","slug":"laracasts-mysql-database-design-2019-8","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/laracasts-mysql-database-design-2019-8\/","title":{"rendered":"Laracasts \u2013 MySQL Database Design 2019-8"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p><span style=\"vertical-align: inherit\">MySQL Database Design course. Developers often jump in without taking the time to learn the basics of the technologies they\u2019re using. Unfortunately, basic database design is a perfect example of this. Let\u2019s fix this. Step by step, I will introduce you to the techniques and terms that you have wanted to learn for years.<\/span><\/p>\n<h3><span style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Primary and foreign keys<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Foreign key constraints<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Laravel and foreign key constraints<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">The difference between MySQL membership types<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Group results with sum functions<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Multiple joins in one query<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Filtering aggregated data<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">one by one<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">one to many<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">several by several<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Apply an index to dramatically improve performance<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Reduce a query from 12 seconds to 1 millisecond<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">MySQL automatically creates an index for the keys<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Use unique keys to avoid duplication<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">And \u2026<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">MySQL Database Design course specifications<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/laracasts.com\/series\/mysql-database-design\" target=\"_blank\"><span style=\"vertical-align: inherit\">Laracasts<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Lecturer:&nbsp; <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/jeffrey-way\"><span style=\"vertical-align: inherit\">Jeffrey Way<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">English language<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Education level: Intermediate<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 1 hour and 42 minutes<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Chapters of the MySQL Database Design course<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-897169 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/04\/MySQL-Database-Design.jpg\" alt=\"MySQL Database Design \" width=\"899\" height=\"607\"><\/p>\n<h3><span style=\"vertical-align: inherit\">Pictures<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-897171 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/04\/MySQL-Database-Design-1.jpg\" alt=\"MySQL Database Design\" width=\"920\" height=\"350\"><\/p>\n<h3><span style=\"vertical-align: inherit\">Sample video of the course<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-123564-1\"><video class=\"wp-video-shortcode\" id=\"video-123564-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/MySQL_Database_Design_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/MySQL_Database_Design_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/MySQL_Database_Design_Downloadly.ir.mp4?nocache=1786096742045\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/MySQL_Database_Design_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<h3><span style=\"vertical-align: inherit\">Installation guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite Player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Subtitle: None<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 720p<\/span><\/p>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl3.downloadly.ir\/Files\/Elearning\/Laracasts_MySQL_Database_Design_2019-8_Downloadly.ir.rar?nocache=1786096740\"><span style=\"vertical-align: inherit\">Download file \u2013 470 MB<\/span><\/a><\/p>\n<p><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">470 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description MySQL Database Design course. Developers often jump in without taking the time to learn the basics of the technologies they\u2019re using. Unfortunately,<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[31637,31638,31639,31640,31641,31642,31643,31644,31645,31646,31647,31648,31649,31650,31651,31652,31653,31654,31655,31656,31657,31658,31659,31660],"class_list":["post-2926","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-mysql-database-design","dgi_tag-download-course-mysql-database-design","dgi_tag-download-link-mysql-database-design","dgi_tag-download-links-mysql-database-design","dgi_tag-download-mysql-database-design","dgi_tag-download-mysql-database-design-course","dgi_tag-download-mysql-database-design-course-for-free","dgi_tag-download-paid-course-mysql-database-design","dgi_tag-free-download-course-mysql-database-design","dgi_tag-free-download-link-mysql-database-design","dgi_tag-free-download-links-mysql-database-design","dgi_tag-free-download-mysql-database-design","dgi_tag-free-download-paid-course-mysql-database-design","dgi_tag-free-links-download-mysql-database-design","dgi_tag-free-mysql-database-design","dgi_tag-free-mysql-database-design-download-course","dgi_tag-free-paid-course-download-links-mysql-database-design","dgi_tag-jeffrey-way","dgi_tag-mysql-database-design-download-course","dgi_tag-mysql-database-design-download-links","dgi_tag-mysql-database-design-for-free","dgi_tag-mysql-database-design-free-course","dgi_tag-mysql-database-design-free-download","dgi_tag-paid-course-mysql-database-design"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/2926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/2926\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=2926"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=2926"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=2926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}