120-days of job Ready Data Science Course

This course is a paid course, if you want to register and join our zoom meeting and online live classes you can register here

Introduction to the course

We will cover follwoing things in this course:

• Google Data Analytics Professional Certificate (completely Taught by Dr. Aammar in Urdu)
• IBM Data Science Professional Certificate (completely Taught by Dr. Aammar in Urdu)
• DeepLearning.AI TensorFlow Developer Professional Certificate (completely Taught by Dr. Aammar in Urdu)
• Everyday post on LinkedIn to polish your portfolio
• Everyday post on Twitter to increase your networking
• Maintain your kaggle account with real life projects
• Fiverr profile update and gigs
• Upwork profile and gigs
• Freelancing tips and tricks
• Job Application guidelines in big companies
• Interview Tips and Tricks
• Mock Interview
• Full of Assignments and Tasks (Real life projects that you need to work on)
• CV Make up for your job
• One to job application guided project
• Content and report writing for Data Science
• Only few people in Team so you can work free and ask questions
• Much more, which will only be disclosed to registered people.

Resources

Books (I will keep updating this list, if you have any book that you think should be added in this list, please let me know via telegram or email)

• R for Data Science
• Statistics for Data Scientists
• Python for Data Analysis
• Python Data Science Handbook
• Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow 2nd Edition
• Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow 3rd Edition

Lecture No. 0: Pre-requisite of this course:

Is lecture ko complete kiay bina ap agay nahi chal saken gay is course ko start karne se pehlay ye 11 hours ka lectures zaroor sunen or practice karen, phir agay chalen, warna masla ho ga.

Pre-requisite lecture link is here

Lecture No. 1: Course plan | Data is Everywhere:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

This lecture explains our strategy in the course and you will learn how you can learn data science job ready skills in upcoming 120 days In Sha Allah.

Click this image to watch the lecture:

Lecture No. 2: Introduction to Data Science and importance of Statistics:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

This lecture explains what is data science and what are the skills you need to become a data scientist.

Click this image to watch the lecture:

Lecture No. 3: Statistics to Data Science:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

This lecture explains what is statistics and how it is related to data science.

Click this image to watch the lecture:

Lecture No. 4: Stat ka zero se start (Complete Workshop):

This lecture is the complete workshop on statistics for Data Science and tells you basic - advance concepts in Data Science.

This lecture explains why statistics is important for data science.

Click this image to watch the lecture:

Lecture No. 5: Introduction to Python and Data Science Revision:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Please revise this lecture before going to the next step. This lecture was a pre-requisite for the course. Is liay is lecture ko pehlay ap practice karen phir agay chalen, warna maslay masael hun gay.

Click this image to watch the lecture:

Lecture No. 6: Statistics for Data Science (Scales of Measurements and details about Data Types):

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

This lecture explains the scales of measurements and Data Types in statistics.

Click this image to watch the lecture:

Lecture No. 7: Descriptive vs. Inferential Statistics (Choosing a right statistical Method):

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi. This lecture explains the Descriptive Statistics in statistics.

Click this image to watch the lecture:

Lecture No. 8: Descriptive and Inferential Statistics:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-1
Click this image to watch the lecture:

Part-2
Click this image to watch the lecture:

Lecture No. 9: Statistics:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-1 Inferential Statistics for Data Science

Part-2 Inferential Statistics for Data Science

Lecture No. 10: Statistics:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-1 Hypothesis Testing

Part-2 Important Terms in Statistics

Lecture No. 11: Data Analytics Skills and Job plans:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 12: (Revise the Lecture 11) Data Analytics Skills and Job plans:

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 13: Spreadsheets in Data Science

We will learn about MS Excel for next few lectures and the lectures will be uploaded here in sequence.

These instructions are a must thing to learn during this MS Excel Series, MS Excel aik bht bara software hy and we can not finish in short time, main ap ko basics sikhaoun ga but you have to learn the advance techniques. Q k har aik company main MS Excel se hi start kia jata hy.

Installation
Install MS Excel office 365 free for life time here

---

You also have to practice yourself for MS Excel basics from following online free resources:

1. Learn the basics of MS Excell from here
2. Learn Basic to Intermediate MS Excel from here

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 14: Spreadsheets in Data Science

The dataset used in this video can be downloaded from here

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 15: Excel Statistics and SQL

Part-1: In this video you will learn basic statistical analysis in MS Excel Spreadsheet.

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-2: SQL (Structured Query Language) Language

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Here is the link to download SQL Cheat sheet

Lecture No. 16: SQL

Part-1: SQL (Structured Query Language) Language- Introduction

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-2: SQL (Structured Query Language) Language Introduction

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-3: SQL Software installation

• Download:
  Here is the link to download mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-4: How to create SQL database?

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-5: How to create SQL table?

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 17: SQL intermediate

Part-1: Distinct Function in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-2: Constraints in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-3: Auto-increament in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-4: mySQL workbench first look

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-5: Import mySQL database in mySQL workbench

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 18: SQL intermediate

Part-1: Pandas procerssing on mySQL database

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-2: SELECT clause in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-3: Data Manipulation in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-4: Where Clause and Comparison operators in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Part-5: AND NOT OR IN in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 19: SQL intermediate

BETWEEN clause in mySQL

Here is the complete lecture, click the image and watch the lectrue in Urdu/Hindi.

Lecture No. 20: SQL Practice

mySQL Practice

Remember to pratice from this website Link for more practice.

Lecture No. 21: R and R studio

Aaj se ham R and RStudio per kaam karna start karen gay. Sab se pehlay ap log following software install kar len:

• R downlpoad and install from here
• Rstudio download and install from here

Software install karne k baad aaaj se ham R or Rstudio ko Data Analaysis k tasks k liay use karne walay hyn agar ap tez speed per seekhna chahtay hyn tu is playlist se R with Aammar seekh len, warna ham tu anay walay lectures main sikha hi den gay ap ko.

Click the image to watch the lecture in Urdu/Hindi.

Click the image to watch the complete playlist of R with Aammar in Urdu/Hindi.

Lecture No. 22: R and R studio

Click the image to watch the lecture in Urdu/Hindi.

Lecture No. 23: R and R studio

Lecture 23a: Installation of Software and Introduction to R

• Click this image to watch the lecture
  

Lecture 23b: First Line of Code in R and learning to work with R

• Click this image to watch the lecture
  

Lecture 23c: Data Visualization and plotting in R using ggplot2

• Click this image to watch the lecture
  

Lecture 23d: Data Visualization and Data Transformation in R using tidyverse packages

• Click this image to watch the lecture
  

Publication Ready Graphs in R

Wathc these two Playlist to learn Data Visualization in R in Desi style:

1. Publication Ready Graphs in R
2. Many plots in R

Lecture No. 24: R and R studio

Lecture 24a: Data Transformation in R using tidyverse packages

• Click this image to watch the lecture
  

Cheat sheet
Practice this cheatsheet today and then move to next point tomorrow.
Link to dplyr cheatsheet is here

Lecture 24b: Statistics in R

• Click this image to watch the lecture
  

The following links were taught in this lecture:

1. How to test Normal Distribution in R?
2. How to make correlation plot in R?
3. How to make PCA plot in R
4. Here is a nice publication about choosing a right statistical method

Lecture 24c: Choosing a right Statistical Method for Data Analysis in R

• Click this image to watch the lecture
  

Here is the code that we used today

Lecture 24d: t-test (all Types), ANOVA, One-way ANOVA, Two-way ANOVA, lettering and plotting in R

• Click this image to watch the lecture
  

Here are the codes we discussed in this lecture:

1. RScript used in this lecture:
   1. t-test script
   2. ANOVA
2. t-test blog
3. One-way ANOVA in R complete blog
4. Two-way ANOVA in R complete blog

Lecture 24e: Publication Ready Plots in R

1. Publication Ready Bar plot with one-way ANOVA and lettering in R:

Here is the code: code.md

2. Publication Ready Bar plot with two-way ANOVA and lettering in R:

Here is the code: code.md

---

Information about the instructor:

Dr. Muhammad Aammar Tufail

PhD Data Science in Agriculture

For any query

contact: aammar@codanics.com