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.
Take the Certificate HERE: goo.gle/3YZJx1Z
Subscribe HERE: bit.ly/SubscribeGCC
#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.
Пікірлер: 11
I just love how you explain the concepts in a simple way
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
You explain very clearly.
Great Course.Thank you
Thank you !!! you guys are awesome !!
Isn't there a mistake in the example of foreign key? Timestamp 2.33! BranchID is a foreign key in product details table right?
@robinpuerta
2 жыл бұрын
Yeah it looks like. Great attention for details. Did you finish the whole certificate? Im just starting..
@aditeepathak8894
2 жыл бұрын
@@robinpuerta I am yet to start the course .. at the moment learning on youtube! All the best to you!
@rrosomasa
2 жыл бұрын
i'm glad someone else also caught this, wasn't sure if i misheard something
what Google product is similar to ms access?
From this video, can you guys give me summaries????