Get to Understand the field of Data Science with SQL
Data Science is bringing innovations to the world. The recent incident of Covid and ChatGPT is making the demand for Data scientists even more crucial in organizations.
What you’ll learn
- Build Robust Industry Machine Learning Models.
- Don’t just learn, Become a Data Scientist through hands-on practice.
- Learn practical SQL skills needed by current industry.
- Understand the field of Data Science through demonstrable experience..
- Learn from an industry expert.
Course Content
- Introduction –> 13 lectures • 1hr 1min.
- COMPLETE SQL FOR DATA SCIENCE COURSE –> 2 lectures • 1min.
- SQL : BEGINNER LEVEL –> 10 lectures • 42min.
- SQL COMMANDS –> 2 lectures • 4min.
- UNDERSTANDING AND CREATING SQL DATABASES –> 3 lectures • 7min.
- UNDERSTANDING AND CREATING SQL TABLES –> 1 lecture • 3min.
- TYPES OF SQL KEYS –> 6 lectures • 12min.
- DATA TYPES IN SQL –> 1 lecture • 8min.
- CREATE TABLE AND INSERT DATA INTO TABLE –> 2 lectures • 20min.
- SQL CONSTRAINTS –> 7 lectures • 42min.
- WEEK 2 :: SQL INTERMEDIATE LEVEL –> 1 lecture • 6min.
- SQL JOINS –> 9 lectures • 1hr 11min.
- WORKING WITH EXISTING SQL TABLE –> 4 lectures • 25min.
- SQL VIEW –> 4 lectures • 17min.
- SQL DATA SUMMARIZATION: AGGREGATION FUNCTIONS –> 4 lectures • 8min.
- ADVANCE SQL FUNCTIONS –> 7 lectures • 39min.
- WEEK 3 :: SQL ADVANCED LEVEL –> 1 lecture • 1min.
- SQL STORED PROCEDURE –> 5 lectures • 22min.
- TRIGGERS –> 4 lectures • 18min.
- TRANSACTION –> 3 lectures • 17min.
- RECOMMENDATION –> 1 lecture • 1min.
- FULL PYTHON FOR DATA SCIENCE COURSE –> 6 lectures • 52min.
- DATASETS –> 1 lecture • 1min.
- HANDS-ON WITH PYTHON –> 6 lectures • 41min.
- PYTHON OUTPUT(), INPUT() AND IMPORT() FUNCTIONS –> 3 lectures • 15min.
- PYTHON OPERATORS –> 6 lectures • 25min.
- PYTHON FLOW CONTROL –> 7 lectures • 28min.
- WEEK 2: PYTHON FUNCTIONS –> 5 lectures • 36min.
- PYTHON GLOBAL AND LOCAL VARIABLES –> 2 lectures • 6min.
- WORKING WITH FILES IN PYTHON –> 4 lectures • 19min.
- PYTHON MODULES –> 3 lectures • 10min.
- PYTHON PACKAGES AND LIBRARIES –> 2 lectures • 12min.
- DATA TYPES IN PYTHON –> 7 lectures • 26min.
- EXTRA CONTENT –> 5 lectures • 43min.
- WEEK 3: NUMPY –> 13 lectures • 53min.
- WEEK 4: PANDAS –> 22 lectures • 2hr 19min.
- DATA VISUALISATION: MATPLOTIIB AND SEABORN –> 3 lectures • 1hr 42min.
- PROJECT: PYTHON ASSIGNMENT –> 1 lecture • 1min.
- PYTHON PROJECTS –> 2 lectures • 2hr 42min.
- 2ND MONTH :: FULL STATISTICS FOR DATA SCIENCE –> 2 lectures • 13min.
- STATISTICAL METHODS DEEP DIVE –> 3 lectures • 15min.
- DATA –> 4 lectures • 17min.
- FREQUENCY DISTRIBUTION –> 1 lecture • 15min.
- CENTRAL TENDENCY –> 2 lectures • 19min.
- MEASURES OF DISPERSION –> 5 lectures • 18min.
- THE FIVE NUMBER SUMMARY & THE QUARTILES –> 2 lectures • 14min.
- THE NORMAL DISTRIBUTION –> 3 lectures • 29min.
- CORRELATION –> 3 lectures • 15min.
- 3RD MONTH :: WEEK 1 :: PROBABILITY –> 4 lectures • 27min.
- HYPOTHESIS TESTING –> 10 lectures • 26min.
- STATISTICS PROJECT –> 2 lectures • 1min.
- GITHUB FOR DATA SCIENCE –> 3 lectures • 27min.
- ARTIFICIAL INTELLIGENCE(AI) AND MACHINE LEARNING(ML) –> 1 lecture • 1min.
- WEEK 2 :: FULL MACHINE LEARNING COURSE –> 6 lectures • 57min.
- USE CASE –> 1 lecture • 20min.
- MACHINE LEARNING ALGORITHMS –> 3 lectures • 29min.
- WORKING WITH MACHINE LEARNING DATA –> 18 lectures • 1hr 11min.
- WEEK 3 :: SUPERVISED MACHINE LEARNING ALGORITHMS –> 9 lectures • 2hr 38min.
- LOGISTIC REGRESSION ALGORITHM –> 7 lectures • 2hr 11min.
- NAIVE BAYES ALGORITHM –> 3 lectures • 1hr 11min.
- K-NEAREST NEIGBHOR ALGORITHM (KNN) –> 3 lectures • 48min.
- SUPPORT VECTOR MACHINE (SVM) ALGORITHM –> 3 lectures • 32min.
- SUPPORT VECTOR MACHINE (SVM) ALGORITHM –> 3 lectures • 23min.
- MACHINE LEARNING ALGORITHM PERFORMANCE METRICS –> 9 lectures • 44min.
- DECISION TREE ALGORITHM –> 6 lectures • 16min.
- WEEK 4 :: ENSEMBLE TECHNIQUES –> 5 lectures • 20min.
- PROJECT: SUPERVISED MACHINE LEARNING –> 1 lecture • 1min.
- UNSUPERVISED MACHINE LEARNING ALGORITHMS –> 1 lecture • 1min.
Requirements
Data Science is bringing innovations to the world. The recent incident of Covid and ChatGPT is making the demand for Data scientists even more crucial in organizations.
Employees with data science and analytical skills are highly valued and paid for in organizations. If you are interested in learning and understanding the field of data science, then this course is for you.
In this course, you will get to understand the core areas of Data Science and the various career opportunities in Data Science. After that, you will start with SQL for Data Science to give you solid grounds for your data science career.
This should give you the foundation needed for advanced concepts in data science such as Machine learning, Deep learning, Computer vision (CV), and Natural Language Processing (NLP).
The instructor for this course has 15 years of industry experience as well as classroom experience in developing and deploying machine learning models in production. He is also instructor of top online courses and books. He combines his industry and academic experience in delivering the lessons. The lessons are broken down for easy understanding. A step by step approach is followed in order to cater for diverse audience such as beginners, intermediate as well as advanced learners.
You only need your laptop, internet and willingness to learn and you are good to go.
See you in the course.