0:00 Accessing Databases 0:27 Database Features: Normalized database, Redundancy, Schemas 4:40 Exploring Metadata: Database management. 3 common types of metadata: * Descriptive: describes a piece of data (book: ispn, ..) * Structural: a piece of data is organized (book: chapter) * Administrative: indicates the technical source of a digital asset 8:33 Using Metadata Like an Analyst * Metadata: clean, accurate (precise), relevant and timely * Metadata repository, Metadata Repositories 12:22 Metadata Management * First: the location of the system, and the data sets are located within those systems * Second: metadata is connected between in those systems * Governance: security, privacy, integrity, and usability, internal and external flows 15:52 Working with Various Data Sources: Internal and External data 19:02 Importing Data: csv format, .. 22:56 Using Filters and Sorts: Sorting and Filtering data 28:07 Large Dataset Challenges: use database Data sources link: * data.gov/metrics.html * www.who.int/data/gho
0:00 Accessing Databases
0:27 Database Features: Normalized database, Redundancy, Schemas
4:40 Exploring Metadata: Database management. 3 common types of metadata:
* Descriptive: describes a piece of data (book: ispn, ..)
* Structural: a piece of data is organized (book: chapter)
* Administrative: indicates the technical source of a digital asset
8:33 Using Metadata Like an Analyst
* Metadata: clean, accurate (precise), relevant and timely
* Metadata repository, Metadata Repositories
12:22 Metadata Management
* First: the location of the system, and the data sets are located within those systems
* Second: metadata is connected between in those systems
* Governance: security, privacy, integrity, and usability, internal and external flows
15:52 Working with Various Data Sources: Internal and External data
19:02 Importing Data: csv format, ..
22:56 Using Filters and Sorts: Sorting and Filtering data
28:07 Large Dataset Challenges: use database
Data sources link:
* data.gov/metrics.html
* www.who.int/data/gho
I just love how you explain the concepts in a simple way
Isn't there a mistake in the example of foreign key? Timestamp 2.33! BranchID is a foreign key in product details table right?
Yeah it looks like. Great attention for details. Did you finish the whole certificate? Im just starting..
@@robinpuerta I am yet to start the course .. at the moment learning on youtube! All the best to you!
i'm glad someone else also caught this, wasn't sure if i misheard something
Excellent!! this video helps a lot for my metadata class
You explain very clearly.
Great Course.Thank you
what Google product is similar to ms access?
Thank you !!! you guys are awesome !!
From this video, can you guys give me summaries????