Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-25 22:35:28
30-Day Money-Back Guarantee
Development Database Design & Development Database Management

Introduction to Database Engineering

Learn ACID, Indexing, Partitioning, Sharding, Concurrency control, Replication, DB Engines, Best Practices and More!
Bestseller
Rating: 4.7 out of 54.7 (1,140 ratings)
33,402 students
Created by Hussein Nasser
Last updated 4/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn and understand ACID Properties
  • Database Indexing
  • Database Partitioning
  • Database Replication
  • Database Sharding
  • Database Cursors
  • Concurrency Control (Optimistic, Pessimistic)
  • Database System Designs
  • Difference between Database Management System, Database Engine and Embedded database
  • Database Engines such as MyISAM, InnoDB, RocksDB, LevelDB and More
  • Benefits of Using one database engine over the other
  • Switching Database Engines with MySQL
  • Database Security
  • Homomorphic Encryption
Curated for the Udemy for Business collection

Course content

16 sections • 104 lectures • 14h 38m total length

  • Preview06:36
  • Preview00:37
  • Course Update April 2021
    07:36

  • Preview01:39
  • What is a Transaction?
    02:31
  • Atomicity
    02:39
  • Isolation
    20:35
  • Consistency
    13:06
  • Durability
    01:44
  • Eventual Consistency
    14:33
  • ACID by Practical Examples
    21:21
  • Phantom Reads
    07:35
  • ACID Quiz
    1 question

  • Preview18:18
  • Preview04:22
  • Preview10:16
  • Key vs Non-Key Column Database Indexing
    14:11
  • Index Scan vs Index Only Scan
    08:08
  • Preview14:07
  • Preview11:19
  • Bitmap Index Scan vs Index Scan vs Table Scan
    11:24
  • Create Index Concurrently - Avoid Blocking Production Database Writes
    03:10
  • Preview09:18
  • Preview13:40

  • Introduction to Database Partitioning
    01:26
  • What is Partitioning
    03:28
  • Vertical vs Horizontal Partitioning
    02:07
  • Partitioning Types
    01:32
  • The Difference Between Partitioning and Sharding
    02:43
  • Preparing: Postgres, Database, Table, Indexes
    05:22
  • Execute Multiple Queries on the Table
    01:18
  • Create and Attach Partitioned Tables
    03:46
  • Populate the Partitions and Create Indexes
    03:59
  • Class Project - Querying and Checking the Size of Partitions
    05:32
  • The Advantages of Partitioning
    04:41
  • The Disadvantages of Partitioning
    02:48
  • Section Summary - Partitioning
    01:10
  • How to Automate Partitioning in Postgres
    10:06

  • Introduction to Database Sharding
    01:06
  • What is Database Sharding?
    03:31
  • Consistent Hashing
    02:41
  • Horizontal partitioning vs Sharding
    01:08
  • Sharding with Postgres
    01:05
  • Spin up Docker Postgres Shards
    07:23
  • Writing to a Shard
    21:58
  • Reading from a Shard
    11:19
  • Advantages of Database Sharding
    01:59
  • Disadvantages of Database Sharding
    03:33
  • Database Sharding Section Summary
    00:45
  • When to Shard your Database?
    20:06

  • Shared vs Exclusive Locks
    11:04
  • Preview05:31
  • Two-phase Locking
    07:08
  • Preview13:42
  • SQL Pagination With Offset is Very Slow
    09:09
  • Database Connection Pooling
    10:50
  • Serializable vs Repeatable Read
    08:17

  • Introduction to Database Replication
    01:19
  • Master/Standby Replication
    03:45
  • Multi-master Replication
    01:23
  • Synchronous vs Asynchronous Replication
    03:06
  • Replication Demo with Postgres 13
    19:20
  • Pros and Cons of Replication
    03:28

  • Preview37:50
  • Preview36:47

  • Preview02:44
  • What is a Database Engine?
    06:41
  • Row-Based vs Column-Based Databases
    34:15

  • MyISAM
    06:49
  • Aria
    02:27
  • InnoDB
    06:45
  • XtraDB
    02:05
  • SQLite
    03:44
  • BerkeleyDB
    02:40

Requirements

  • Basic understanding of database systems

Description

Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the right place. I have curated this course carefully to discuss one of the main concepts of database engineering.


This course will not teach you SQL or programming languages, however, it will teach you skillset and patterns that you can apply in database engineering. A few of the things that you will learn are Indexing, Partitioning, Sharding, Replication, Concurrency control, database engines and security, and much more.


Database engines or storage engines or sometimes even called embedded databases is a software library that a database management software uses to store data on disk and do CRUD (create update delete) Embedded means move everything in one software no network client-server. In this video course, I want to go through the few popular database engines, explain the differences between them and finally I want to spin up a database and change its engine and show the different features on each engine.

Who this course is for:

  • Software Engineers and Database Engineers

Instructor

Hussein Nasser
Software Engineer, Author
Hussein Nasser
  • 4.6 Instructor Rating
  • 1,754 Reviews
  • 69,008 Students
  • 2 Courses

My name is Hussein and I’m a software engineer. Ever since my uncle gave me my first programming book in 1998 (Learn programming with Visual Basic 2) I discovered that software is my passion. I started my blog, and YouTube channel as an outlet to talk about software.



I specialize in the field of geographic information systems (or GIS). I helped many organizations in different countries implement GIS technology and designed, developed apps to fit their use cases and streamline their workflows since 2005. I wrote five books on Esri ArcGIS technology and I've been an engineer at Esri building cool GIS technologies since 2015.



Between my Software Engineering YouTube channel and Podcast, I have made over 500 hundred pieces of content on different topics of software engineering ranging from proxies, security, networking, and programming. I also discuss recent software news and current events on software.



Using software to solve interesting problems is one of the fascinating things I really enjoy. Feel free to contact me on my social media channels to tell your software story, ask questions or share interesting problems. I would love to hear it!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.