Databases and Metadata for Beginners | Google Data Analytics Certificate

Databases make it possible to find the exact piece of information you need for your analysis. Learn how to sort data in order to zoom in on what you need, to generate insightful reports, and use metadata effectively.

0:00 Accessing Databases
0:27 Database Features
4:40 Exploring Metadata
8:33 Using Metadata Like an Analyst
12:22 Metadata Management
15:52 Working with Various Data Sources
19:02 Importing Data
22:56 Using Filters and Sorts
28:07 Large Dataset Challenges

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

Why earn a Google Career Certificate?
► No experience necessary: Learn job-ready skills, with no college degree required.
► Learn at your own pace: Complete the 100% online courses on your own terms.
► Stand out to employers: Make your resume competitive with a credential from Google.
► A path to in-demand jobs: Connect with top employers who are currently hiring.

[inhlam]

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:

[abiodunokunrinboye]

I just love how you explain the concepts in a simple way

[RagazzaInk]

Excellent!! this video helps a lot for my metadata class

[aditeepathak]

Isn't there a mistake in the example of foreign key? Timestamp 2.33! BranchID is a foreign key in product details table right?

[aliasyuhada]

From this video, can you guys give me summaries????

[peterpiper]

what Google product is similar to ms access?