The Ultimate Pandas and PostgreSQL Bootcamp - Data Analysis

Focused View

Jobshie Academy

6:47:13

120 View

1. Introduction

1. Introduction.mp4

03:37

2.1 oops.rar

2.2 Pandas Resources.rar

2.3 PostgreSQL Resources.rar

2.4 Python.rar

2. Resources.html

3. Hello.mp4

00:53

4. Tour.mp4

02:52

2. Data Description

1. Data Description.mp4

04:12

2. Importing the data.mp4

15:29

3. Creating a DataFrame

1. Series.mp4

03:42

2. Creating a DataFrame.mp4

07:43

3. Homework.mp4

00:31

4. Data Cleaning

1. Data Cleaning.mp4

03:02

5. Dealing with Empty cells

1. Mean Median Mode.mp4

02:11

2. Empty cells.mp4

08:33

6. Dealing with wrong data

1. Wrong Data.mp4

12:51

7. Dealing with wrong data type

1. Wrong Datatype.mp4

06:10

8. Dealing with duplicate data

1. Duplicates.mp4

05:30

9. Correlation

1. Correlation Introduction.mp4

01:53

2. Correlation.mp4

02:01

10. Review

1. Review.mp4

00:25

11. PostgreSQL Introduction

1. Intro.html

2. Installation.mp4

03:07

3. Select Statement.mp4

01:09

12. Creating a table

1. Creating a table.mp4

07:09

13. Insert data into a table

1. Insert data into a table.mp4

07:50

14. Alter data in a table

1. Alter data in a table.mp4

03:44

15. Drop a column

1. Drop a column.mp4

01:46

16. Order by command

1. Order by command.mp4

04:17

17. Limit, alias, distinct

1. Limit, alias, distinct.mp4

05:00

18. WHERE, AND, OR, IN, BETWEEN

1. WHERE, AND, OR, IN, BETWEEN.mp4

09:35

19. Aggregate and Group by command

1. Aggregate and Group by command.mp4

05:46

20. Project 1

1. Create database and drop table.mp4

04:10

2. Create table and Foreign Key.mp4

11:48

3. Insert data.mp4

05:38

4. Update using SET.mp4

02:31

5. Delete Records.mp4

01:25

6. Display Specific Columns.mp4

02:02

7. Display Specific Rows.mp4

01:28

8. ORDER BY - LIMIT.mp4

01:56

9. WHERE - NOT.mp4

00:58

10. BETWEEN.mp4

03:11

11. Equal to, Not Equal to.mp4

01:17

12. Nested Queries.mp4

05:33

13. LIKE Condition.mp4

03:55

14. DISTINCT.mp4

01:16

15. Connect Two Tables.mp4

05:48

16. JOINS.mp4

04:41

17. EXCEPT.mp4

04:19

18. Special Query.mp4

05:44

21. Instagram clone Database

1. Create Database and Users Table.mp4

05:36

2. Photos Table.mp4

02:14

3. Comment Table.mp4

01:57

4. Like Table.mp4

01:43

5. Follows Table.mp4

01:25

6. Tags Table.mp4

00:58

7. Photos Tags Table.mp4

01:36

8. Insert Data.mp4

05:58

9. Query 1.mp4

02:19

10. Query 2.mp4

05:54

11. Query 3.mp4

02:42

12. Query 4.mp4

01:30

13. Query 5.mp4

02:59

14. Query 6.mp4

03:01

15. Query 7.mp4

05:08

16. Query 8.mp4

04:16

17. Query 9.mp4

04:16

22. Python (Optional)

1. Installation - Python.mp4

03:57

2. Installation - VS Code.mp4

01:39

3. Setup and Hello World.mp4

08:02

4. Drawing a Shape.mp4

02:33

5. DataTypes.mp4

04:24

6. Variables.mp4

07:28

7. Strings.mp4

20:34

8. Numbers.mp4

12:57

9. Taking an input.mp4

03:31

10. Lists.mp4

06:04

11. List_functions.mp4

09:27

12. Tuples.mp4

03:52

13. Dictionaries.mp4

04:12

14. Functions.mp4

08:48

15. Return Statement.mp4

05:18

16. Operators.mp4

02:23

17. If Statement.mp4

12:50

18. If Statements & Comparisons.mp4

03:44

19. While Loop.mp4

04:23

20. For Loops.mp4

08:05

21. Exponent Function.mp4

03:41

22. 2D Lists & Nested Loops.mp4

04:01

23. Comments.mp4

01:38

24. Try & Except.mp4

03:45

25. Reading Files.mp4

03:54

26. Writing Files.mp4

03:04

23. Certificate

1. Certificate.mp4

00:49

Description

Become Expert in data analysis using Pandas and PostgreSQL. Store and fetch data, tune queries, and design efficient DB

What You'll Learn?

You will be able to program in Python professionally
Be able to use Python for data science and machine learning
You will be able to use Python for your own work problems or personal projects.
Importing and creating data frame in python
Learn everything there is to know about pandas - from absolute scratch!
Perform a multitude of data operations in Python's popular pandas library including grouping, pivoting, joining and more!
Create your own database or interact with existing databases
You will write basic to advance PostgreSQL queries
Troubleshoot everyday PostgreSQL database related issues
Have a detailed knowledge and understanding of using PostgreSQL, one of the most widely used databases in the world.

Who is this for?

Students and professionals who wants to do data analysis using python.

Python developer who wants to do analysis of tabular data.

Anyone interested in learning about SQL, PostgreSQL, or basic data analysis!

Anyone who wants to learn about database and data management systems

More details

Description
*** Enrol now in the most comprehensive and up-to-date (Nov 2022) course available for the Pandas and PostgreSQL Concepts! *

About the Instructor.
This course is led by Aditya Dhandi - an international trainer, consultant, and data analyst with over 100 000 enrollments on Udemy. Aditya specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, & Google Data Studio & his courses average 4+ stars out of 5.

He's also the founder of the popular website, Jobshie.

Why learn pandas?
If you've spent time in a spreadsheet software like MS Excel or Google Sheets and want to take your data analysis skills to the next level, this course is for you!
Pandas is a Python package providing fast, flexible, and expressive data structures designed to make working with â€œrelationalâ€ or â€œlabeledâ€ data both easy and intuitive. It aims to be the fundamental high-level building block for doing practical, real-world data analysis in Python.

Pandas is the most powerful and flexible open source data analysis/manipulation tool available in any language.
pandas is well suited for many different kinds of data:
Tabular data with heterogeneously-typed columns, as in an SQL table or Excel spreadsheet
Ordered and unordered (not necessarily fixed-frequency) time series data.
Arbitrary matrix data (homogeneously typed or heterogeneous) with row and column labels
Any other form of observational / statistical data sets. The data need not be labeled at all to be placed into a pandas data structure

Why Learn Advanced SQL and PostgreSQL?
It is almost impossible not to interact with a database daily, Every Mobile Application or Website you use uses a database to commit your request, You just don't know it, Which makes you wonder, What is a database? Why is it important? how can I communicate with it? and most importantly, What's SQL?
SQL is a Standard Structured Query Language that you can use to code queries to interact with a database. PostgreSQL is a database management system that uses SQL to interact with the database.
SQL is by far the most coding skill in demand in the tech industry and it is one of the fastest ways to improve your career prospects, Whether you're a Mobile developer, A Web Developer, A Data Scientist, A Data Analyst, or Even New to the tech industry, You have to learn Databases and SQL.

Finally, This course is concise and to the point, It aims to teach you the basics of Databases and SQL from Beginner to Intermediate bearing in mind how valuable is your time.

Key Features:

Video Lectures: Learn the best ways to learn Pandas and PostgreSQL
Course Certificate: Complete the course and show off your skills with the course certificate.
Learn from experts: Your expert instructor will teach you Pandas and PostgreSQL skills you can apply immediately.
Full Excess: There is no time limit, so take the course at your own pace and retake lessons as you need.
Use any Device: Join the course using any modern browser on your phone, tablet and computer.
Ask Question: Ask questions and share ideas with other students in the course community.

What's included?
High quality video lessons to build your knowledge and skills.
Guided walk-throughs with techniques and tips.
14 pre-built dashboards you can use and customize.
Practical exercises to apply your skills.
Quizzes to reinforce learnings and test your knowledge.
Private discussion area where you can ask questions.
Course certificate for completing the lessons and assignment.
Full access lets you review lessons whenever you need.
Updates when lessons in the course are refreshed.

Jobshie Academy Reviews
300+ learner reviews | 4+ average rating**
We help learners across the globe develop new skills and achieve their personal and professional goals. Browse learner reviews below to discover how people enjoy the online learning experience at Jobshie Academy.

"I have gained useful skills while learning this course. I can consider myself a data analysis specialist. Thank you"
by Joseph Israel

"I was a nice experience about this course as it introduces with many topics which are related to data analysis ."
by Sreeraj Mopkar

"very good explaination , bohot achhe se sab samajh aata hai ...100% Understanding all concept very much....excellent explanation"
by Moosa Khan

"The course is very instructive and didactic, I liked it, it is all the information I need for my activities"
by Jaime Ronald Palma Aguilar

"yeah it was such a great course, the teacher took time out to disect all angles of Excel, he touched all the essential parts, needed for our daily use of excel. Thanks a lot"
by Unyime Joshua

"The instructor is very knowledgeable and teach in a very engaging way. I totally recommend this course.????"
by Aditya

FAQs
When does the Pandas and PostgreSQL course start and finish?
The course starts as soon as you join! It is a completely self-paced online course, so you decide when you start and when you finish.
How long does it take to complete the course?
We recommend taking the course over two to three weeks, so you have time to apply the lessons to your account (or your clientâ€™s account). That being said we've seen people complete the course in a week and others that spread the lessons over a couple of months.
How long do I have access to the Pandas and PostgreSQL course?
You receive full access to the course so that you can take the lessons at any time. You can rewatch lessons whenever you like and any lesson updates are included.
Will I receive a certificate?
Yes, once you complete all of the lessons, exercises, quizzes, and course assignment, you'll receive your course certificate.

What are you waiting for?
Thereâ€™s never been a better time to add a skill like programming to your toolbox and Pandas and PostgreSQL to get started. So check out the free preview and get enrolled! You've got nothing to lose and everything to gain!

Who this course is for:
Students and professionals who wants to do data analysis using python.
Python developer who wants to do analysis of tabular data.
Anyone interested in learning about SQL, PostgreSQL, or basic data analysis!
Anyone who wants to learn about database and data management systems

User Reviews

Rating

average 0

Total votes0

Focused display

I have working experience of Data Analysis of more than three years. I create videos on SQL, Big query, Data Science, Data Analysis, Python, Machine Learning, Deep Learning. There are more than 70000 Enrollments in my courses. My most popular course is: Data Analysis for Entry Level Job - Zero to Hero Skill Path

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.