This course is part of the CertNexus Certified Data Science Practitioner Professional Certificate

Stacey McBrine +2 more instructors

1,953 already enrolled

Offered By

CertNexus Certified Data Science Practitioner Professional CertificateCertNexus

About this Course

11,019 recent views

This course is designed for business and data professional seeking to learn the first technical phase of the data science process known as Extract, Transform and Load or ETL.  
Learners will be taught how to collect data from multiple sources so it is available to be transformed and cleaned and then will dive into collected data sets to prepare and clean data so that it can later be loaded into its ultimate destination. In the conclusion of the course learners will load data into its ultimate destination so that it can be analyzed and modeled. 

The typical student in this course will have experience working with data and aptitude with computer programming.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 5 in the

CertNexus Certified Data Science Practitioner Professional Certificate

Intermediate Level

Understand data science concepts, experience with programming languages (Python), libraries (NumPy,pandas) and database querying languages (SQL).

Approx. 15 hours to complete

English

Skills you will gain

Extraction, Transformation And Loading (ETL)
Cleaning
Data Mining

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 5 in the

CertNexus Certified Data Science Practitioner Professional Certificate

Intermediate Level

Understand data science concepts, experience with programming languages (Python), libraries (NumPy,pandas) and database querying languages (SQL).

Approx. 15 hours to complete

English

Instructors

Offered by

CertNexus

Syllabus - What you will learn from this course

Week1

Week 1

4 hours to complete

Extract Data

The first truly hands-on technical phase of the data science process is actually a combination of related tasks known as extract, transform, and load (ETL). This is where you, the data science practitioner, start to mold and shape the data so that it can be as useful as possible for the later steps in the data science process. In this course, you'll go through each ETL task in order, starting with "E" (extract).

4 hours to complete

12 videos (Total 66 min), 6 readings, 1 quiz

12 videos

Course Intro: Extract, Transform, and Load Data3mStructure of Data6mTerms Describing Portions of Data3mBig Data5mData Sources6mPublic APIs and Web Scraping6mData Read from Cloud Storage4mExtract, Transform, and Load (ETL)7mCSV Files4mSQL Queries6mNoSQL Queries6mData Consolidation and Joins5m

6 readings

Overview2mOpen Datasets20mGuidelines for Reading Data from CSV Files3mGuidelines for Extracting Data with Database Queries10mInner Join Example15mGuidelines for Consolidating Data from Multiple Sources5m

1 practice exercise

Extracting Data30m

Week2

Week 2

5 hours to complete

Transform Data

5 hours to complete

9 videos (Total 55 min), 7 readings, 1 quiz

9 videos

Data Preparation and Cleaning6mTypes of Data and Data Operations7mContinuous vs. Discrete Variables5mData Parsing2mData Irregularities8mCorrection of Data Formats and Date Conversion8mDeduplication4mWord Embedding7mImage Data Representation4m

7 readings

Overview2mGuidelines for Parsing Data3mGuidelines for Handling Irregular and Unusable Data10mGuidelines for Correcting Data Formats15mGuidelines for Deduplicating Data5mText Data Transformation Techniques15mGuidelines for Transforming Data10m

1 practice exercise

Transforming Data30m

Week3

Week 3

3 hours to complete

Load Data

3 hours to complete

6 videos (Total 25 min), 7 readings, 1 quiz

6 videos

Data Loading Considerations5mData Loading: Databases3mData Loading: DataFrames6mData Loading: Text Files4mETL Endpoints3mData Loading: Visualization Tools2m

7 readings

Overview2mGuidelines for Loading Data into Databases5mGuidelines for Loading Data into DataFrames3mGuidelines for Loading Data into Text Files15mGuidelines for Configuring ETL Endpoints5mGuidelines for Loading Data into Visualization Tools5mExploring Data Visualization Tools20m

1 practice exercise

Loading Data30m

Week4

Week 4

3 hours to complete

Apply What You've Learned

3 hours to complete

About the CertNexus Certified Data Science Practitioner Professional Certificate

The field of Data Science has topped the Linked In Emerging Jobs list for the last 3 years with a projected growth of 28% annually and the World Economic Forum lists Data Analytics and Scientists as the top emerging job for 2022.

Data can reveal insights and inform business—by guiding decisions and influencing day-to-day operations. This specialization will teach learners how to analyze, understand, manipulate, and present data within an effective and repeatable process framework and will enable you to bring value to the business by putting data science concepts into practice. This course is designed for business professionals that want to learn how to more effectively extract insights from their work and leverage that insight in addressing business issues, thereby bringing greater value to the business. The typical student in this course will have several years of experience with computing technology, including some aptitude in computer programming. Certified Data Science Practitioner (CDSP) will prepare learners for the CertNexus CDSP certification exam. To complete your journey to the CDSP Certification Complete the Coursera Certified Data Science Practitioner Professional Certificate. Review the CDSP Exam Blueprint. Purchase your CDSP Exam Voucher. Register for your CDSP Exam.

CertNexus Certified Data Science Practitioner

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Extract, Transform, and Load Data

About this Course

Skills you will gain

Instructors

Stacey McBrine

Sarah Haq

Megan Smith Branch

Offered by

CertNexus

Syllabus - What you will learn from this course

Extract Data

Transform Data

Load Data

Apply What You've Learned

About the CertNexus Certified Data Science Practitioner Professional Certificate

Frequently Asked Questions

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More

Extract, Transform, and Load Data

About this Course

Skills you will gain

Instructors

Stacey McBrine

Sarah Haq

Megan Smith Branch

Offered by

CertNexus

Syllabus - What you will learn from this course

Extract Data

Transform Data

Load Data

Apply What You've Learned

About the CertNexus Certified Data Science Practitioner Professional Certificate

Frequently Asked Questions

Coursera Footer

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More