how to use sql on mac to communicate with aws dynamo

Pro: scales near-linearly with the number of database servers (assuming rows are accessed fairly evenly).

(For our Staff table, we will reverse the logic) Logic can be based on either row numbers, ranges of values in those rows, or a hash on certain fields. For each table, put even rows in 1 table, odd rows in another table.

Row-level partitioning - Use 2 databases.

Con: Cross-table queries are extremely slow.

Database segmentation - Use 2 databases (instead of 1), with 1 table in each database.

Con: Costly, and we eventually hit a hardware ceiling.

Horizontal scaling - throw extra CPU and memory at the problem.

(SQL) You have 1 database server with 2 giant tables in it.

Now the combination of Employee ID and Department makes each row unique. We rip out the Department column and make a new table for it. We can create a many-to-many relationship using 2 one-to-many tables. If you have an Employee table, and the Employee needs to be in 2 Departments (IT, HR), you can't do that in SQL: A Department can have many Employees, and an Employee can be in many Departments.

How do 'Many-to-Many' relationship? (in SQL) - (15:30) Example: Lets assume we have Employee and Department.

What types of keys do NoSQL databases lack? - (6:35) Foreign keys, since NoSQL databases are not relational.

What are 'Primary Keys' called in NoSQL databases - (6:25) 'Hash keys' or 'Partition keys' in NoSQL databases.

Foreign key doesn't need to be unique in the table it's in. Uniquely identifies a row (Primary key value) in another table.

What's a 'Foreign Key'? (in SQL) - (5:30) maps to a primary key in another table.

What's a 'Primary Key'? (in SQL) - (5:00) one candidate key, selected to provide unique identification of every row in the table.

What's a 'Candidate Key'? (in SQL) - (4:00) any columns which can uniquely identify a row.

Chapter 2 - Database Fundamentals Database Fundamentals - Part 1

This repo is a concise summary and replacement of the AWS DynamoDB - From Beginner to Pro tutorial.

How to use sql on mac to communicate with aws dynamo