{"id":3298,"date":"2026-08-10T09:03:36","date_gmt":"2026-08-10T09:03:36","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/oreilly-database-fundamentals-livelessons-2023-9\/"},"modified":"2026-08-10T09:03:36","modified_gmt":"2026-08-10T09:03:36","slug":"oreilly-database-fundamentals-livelessons-2023-9","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/oreilly-database-fundamentals-livelessons-2023-9\/","title":{"rendered":"Oreilly \u2013 Database Fundamentals LiveLessons 2023-9"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<div class=\"presented-response-container ng-tns-c2892812740-91\" style=\"text-align: left\">\n<div class=\"response-container-content ng-tns-c2892812740-91\">\n<div class=\"response-content ng-tns-c2892812740-91\">\n<div class=\"markdown markdown-main-panel\">\n<p data-sourcepos=\"5:1-5:59\"><span style=\"vertical-align: inherit\">Database Fundamentals LiveLessons course. In this training course, you will learn the basic concepts of databases and learn how to work with them. Also, you will get the necessary preparation to take Microsoft\u2019s MTA 98-364 exam.<\/span><\/p>\n<p data-sourcepos=\"7:1-7:210\"><span style=\"vertical-align: inherit\">SQL Server database expert Eric Johnson guides you from basic database concepts such as tables and indexes to the fundamentals of database design and layout. Building on this foundation, you will learn how to perform more advanced skills such as database management, backup and security. The course topics are organized in such a way that they are easy to understand and you can easily learn these skills. This video course, along with additional study, will help you gain the hands-on experience you need to take the exam and demonstrate your mastery of database fundamentals.<\/span><\/p>\n<p data-sourcepos=\"11:1-11:25\"><strong><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/strong><\/p>\n<ul data-sourcepos=\"13:1-13:1\">\n<li data-sourcepos=\"13:1-13:1\"><span style=\"vertical-align: inherit\">Understand database storage concepts<\/span><\/li>\n<li data-sourcepos=\"14:1-14:37\"><span style=\"vertical-align: inherit\">Perform database normalization<\/span><\/li>\n<li data-sourcepos=\"15:1-15:33\"><span style=\"vertical-align: inherit\">Create database objects<\/span><\/li>\n<li data-sourcepos=\"16:1-16:43\"><span style=\"vertical-align: inherit\">Manipulate data in databases<\/span><\/li>\n<li data-sourcepos=\"17:1-17:29\"><span style=\"vertical-align: inherit\">Secure the database<\/span><\/li>\n<li data-sourcepos=\"18:1-19:0\"><span style=\"vertical-align: inherit\">Backup and restore databases<\/span><\/li>\n<\/ul>\n<p data-sourcepos=\"20:1-20:31\"><strong><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/strong><\/p>\n<ul data-sourcepos=\"22:1-23:0\">\n<li data-sourcepos=\"22:1-23:0\"><span style=\"vertical-align: inherit\">Developers and system administrators who have no prior experience working with databases<\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 style=\"text-align: left\" data-sourcepos=\"11:1-11:29\"><span style=\"vertical-align: inherit\">Course details<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.oreilly.com\/library\/view\/database-fundamentals-livelessons\/9780136617105\/\/\/\" target=\"_blank\"><span style=\"vertical-align: inherit\">Oreilly<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/eric-johnson\/\"><span style=\"vertical-align: inherit\">Eric Johnson<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: beginner to advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 6 hours 42 minutes<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings in history<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Introduction\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\">Database Fundamentals LiveLessons (Video Training): Introduction<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 1: Understanding Database Concepts\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\">Learning objectives<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">1.1 Understand tables<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">1.2 Understand and select primary keys<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">1.3 Understand foreign keys<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 2: Understanding Database Storage\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\"><span style=\"vertical-align: inherit\">Learning objectives<\/span><\/li>\n<li class=\"toc-level-2 t-toc-level-2\">2.1 Understand database normalization<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">2.2 Understand indexes and how they are used in databases<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">2.3 Configure non-clustered indexes<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">2.4 Configure clustered indexes<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 3: Creating Database Objects\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\"><span style=\"vertical-align: inherit\">Learning objectives<\/span><\/li>\n<li class=\"toc-level-2 t-toc-level-2\">3.1 Understand data definition language (DDL)<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">3.2 Choose appropriate data types<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">3.3 Create tables<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">3.4 Understand and create views<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">3.5 Understand and create stored procedures and functions<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 4: Manipulating Data\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\"><span style=\"vertical-align: inherit\">Learning objectives<\/span><\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.1 Understand data manipulation language (DML)<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.2 Read data using SELECT statements<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.3 Query multiple tables with join statements<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.4 Use UNION and INTERSECT statements<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.5 Add data using INSERT statements<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.6 Change data using UPDATE statements<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">4.7 Remove data using DELETE statements<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 5: Understanding Database Security\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\"><span style=\"vertical-align: inherit\">Learning objectives<\/span><\/li>\n<li class=\"toc-level-2 t-toc-level-2\">5.1 Understand the need for database security<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">5.2 Understand logins and users<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">5.3 Set permissions on database objects<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">5.4 Understand database roles<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Lesson 6: Understanding Database Backup and Restore\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\"><span style=\"vertical-align: inherit\">Learning objectives<\/span><\/li>\n<li class=\"toc-level-2 t-toc-level-2\">6.1 Understand different types of backups<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">6.2 Create and verify backups<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">6.3 Restore a database<\/li>\n<li class=\"toc-level-2 t-toc-level-2\">6.4 Define a backup and recovery strategy<\/li>\n<\/ol>\n<\/li>\n<li class=\"toc-level-1 t-toc-level-1\" style=\"text-align: left\">Summary\n<ol>\n<li class=\"toc-level-2 t-toc-level-2\" style=\"text-align: left\">Database Fundamentals LiveLessons (Video Training): Summary<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course prerequisites<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li style=\"text-align: left\">Knowledge of Windows operating system<\/li>\n<li style=\"text-align: left\">IT background with no prior database experience<\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Images of Database Fundamentals LiveLessons course<\/span><\/h3>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-902122 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/05\/Database-Fundamentals-LiveLessons.jpg\" alt=\"Database Fundamentals LiveLessons\" width=\"1039\" height=\"367\"><\/p>\n<h3 style=\"text-align: left\"><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-126289-1\"><video class=\"wp-video-shortcode\" id=\"video-126289-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Database_Fundamentals_LiveLessons_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Database_Fundamentals_LiveLessons_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Database_Fundamentals_LiveLessons_Downloadly.ir.mp4?nocache=1786098038056\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Database_Fundamentals_LiveLessons_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 style=\"text-align: left\">\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\">English subtitle<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 720p<\/span><\/p>\n<\/div>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl3.downloadly.ir\/Files\/Elearning\/Oreilly_Database_Fundamentals_LiveLessons_2023-9.part1_Downloadly.ir.rar?nocache=1786098035\"><span style=\"vertical-align: inherit\">Download part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl3.downloadly.ir\/Files\/Elearning\/Oreilly_Database_Fundamentals_LiveLessons_2023-9.part2_Downloadly.ir.rar?nocache=1786098035\"><span style=\"vertical-align: inherit\">Download part 2 \u2013 526 MB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">1.5 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Database Fundamentals LiveLessons course. In this training course, you will learn the basic concepts of databases and learn how to work with them. A<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[36912,36913,36914,36915,36916,36917,36918,36919,36920,36921,36922,36923,36924,26577,36925,36926,36927,36928,36929,36930,36931,36932,36933,36934],"class_list":["post-3298","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-database-fundamentals-livelessons","dgi_tag-database-fundamentals-livelessons-download-course","dgi_tag-database-fundamentals-livelessons-download-links","dgi_tag-database-fundamentals-livelessons-for-free","dgi_tag-database-fundamentals-livelessons-free-course","dgi_tag-database-fundamentals-livelessons-free-download","dgi_tag-download-course-database-fundamentals-livelessons","dgi_tag-download-database-fundamentals-livelessons","dgi_tag-download-database-fundamentals-livelessons-course","dgi_tag-download-database-fundamentals-livelessons-course-for-free","dgi_tag-download-link-database-fundamentals-livelessons","dgi_tag-download-links-database-fundamentals-livelessons","dgi_tag-download-paid-course-database-fundamentals-livelessons","dgi_tag-eric-johnson","dgi_tag-free-database-fundamentals-livelessons","dgi_tag-free-database-fundamentals-livelessons-download-course","dgi_tag-free-download-course-database-fundamentals-livelessons","dgi_tag-free-download-database-fundamentals-livelessons","dgi_tag-free-download-link-database-fundamentals-livelessons","dgi_tag-free-download-links-database-fundamentals-livelessons","dgi_tag-free-download-paid-course-database-fundamentals-livelessons","dgi_tag-free-links-download-database-fundamentals-livelessons","dgi_tag-free-paid-course-download-links-database-fundamentals-livelessons","dgi_tag-paid-course-database-fundamentals-livelessons"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/3298","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\/3298\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=3298"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=3298"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=3298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}