Artwork

内容由Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata提供。所有播客内容(包括剧集、图形和播客描述)均由 Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal
Player FM -播客应用
使用Player FM应用程序离线!

Databases, Wireframes, Schema, and Dummy Data, Oh My!

25:14
 
分享
 

已归档的系列专辑 ("不活跃的收取点" status)

When? This feed was archived on June 10, 2022 18:27 (2y ago). Last successful fetch was on April 24, 2022 22:30 (2y ago)

Why? 不活跃的收取点 status. 我们的伺服器已尝试了一段时间,但仍然无法截取有效的播客收取点

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 287711429 series 2792805
内容由Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata提供。所有播客内容(包括剧集、图形和播客描述)均由 Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

Today's episode we discuss databases! A topic a full-stack developer should know. The two most popular database types we'll cover are relational vs. non-relational.
Relational databases

A relational database works by linking information from multiple tables through the use of “keys.” A key is a unique identifier which can be assigned to a row of data contained within a table. This unique identifier, called a “primary key,” can then be included in a record located in another table when that record has a relationship to the primary record in the main table. When this unique primary key is added to a record in another table, it is called a “foreign key” in the associated table. The connection between the primary and foreign key then creates the “relationship” between records contained across multiple tables.
Historically, the most popular relational databases have been Microsoft SQL Server, Oracle Database, MySQL and IBM DB2.
Non-relational databases

The non-relational database, or NoSQL database, stores data. However, unlike the relational database, there are no tables, rows, primary keys or foreign keys. Instead, the non-relational database uses a storage model optimized for specific requirements of the type of data being stored.

Some of the more popular NoSQL databases are MongoDB, Apache Cassandra, Redis, Couchbase and Apache HBase.
Within computer programming, the acronym CRUD stands for create, read, update and delete. These are the four basic functions of persistent storage. Also, each letter in the acronym can refer to all functions executed in relational database applications and mapped to a standard HTTP method, SQL statement or DDS operation.
Dummy data is benign information that does not contain any useful data, but serves to reserve space where real data is nominally present. Dummy data can be used as a placeholder for both testing and operational purposes.
A wireframe is a schematic or blueprint that is useful for helping you, your programmers and designers think and communicate about the structure of the software or website you're building.

References:

Connect With Us!
Instagram: @badforeducationpodcast
Twitter: @badforedupod
Email: badforeducationpodcast@gmail.com
Send us questions! Or say hello to us via email!

Want a free $20 Amazon gift card and to start your own podcast with Buzzsprout?
It's as simple as one click in our link below. Get started today, and have access to their extensive network and assistance. Podcasting isn't hard when you have the right partners!
Click our link here

  continue reading

35集单集

Artwork
icon分享
 

已归档的系列专辑 ("不活跃的收取点" status)

When? This feed was archived on June 10, 2022 18:27 (2y ago). Last successful fetch was on April 24, 2022 22:30 (2y ago)

Why? 不活跃的收取点 status. 我们的伺服器已尝试了一段时间,但仍然无法截取有效的播客收取点

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 287711429 series 2792805
内容由Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata提供。所有播客内容(包括剧集、图形和播客描述)均由 Andrew Ly & Jason Yata, Andrew Ly, and Jason Yata 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品,您可以按照此处概述的流程进行操作https://zh.player.fm/legal

Today's episode we discuss databases! A topic a full-stack developer should know. The two most popular database types we'll cover are relational vs. non-relational.
Relational databases

A relational database works by linking information from multiple tables through the use of “keys.” A key is a unique identifier which can be assigned to a row of data contained within a table. This unique identifier, called a “primary key,” can then be included in a record located in another table when that record has a relationship to the primary record in the main table. When this unique primary key is added to a record in another table, it is called a “foreign key” in the associated table. The connection between the primary and foreign key then creates the “relationship” between records contained across multiple tables.
Historically, the most popular relational databases have been Microsoft SQL Server, Oracle Database, MySQL and IBM DB2.
Non-relational databases

The non-relational database, or NoSQL database, stores data. However, unlike the relational database, there are no tables, rows, primary keys or foreign keys. Instead, the non-relational database uses a storage model optimized for specific requirements of the type of data being stored.

Some of the more popular NoSQL databases are MongoDB, Apache Cassandra, Redis, Couchbase and Apache HBase.
Within computer programming, the acronym CRUD stands for create, read, update and delete. These are the four basic functions of persistent storage. Also, each letter in the acronym can refer to all functions executed in relational database applications and mapped to a standard HTTP method, SQL statement or DDS operation.
Dummy data is benign information that does not contain any useful data, but serves to reserve space where real data is nominally present. Dummy data can be used as a placeholder for both testing and operational purposes.
A wireframe is a schematic or blueprint that is useful for helping you, your programmers and designers think and communicate about the structure of the software or website you're building.

References:

Connect With Us!
Instagram: @badforeducationpodcast
Twitter: @badforedupod
Email: badforeducationpodcast@gmail.com
Send us questions! Or say hello to us via email!

Want a free $20 Amazon gift card and to start your own podcast with Buzzsprout?
It's as simple as one click in our link below. Get started today, and have access to their extensive network and assistance. Podcasting isn't hard when you have the right partners!
Click our link here

  continue reading

35集单集

כל הפרקים

×
 
Loading …

欢迎使用Player FM

Player FM正在网上搜索高质量的播客,以便您现在享受。它是最好的播客应用程序,适用于安卓、iPhone和网络。注册以跨设备同步订阅。

 

快速参考指南