The Ultimate Pandas and PostgreSQL Bootcamp – Data Analysis

سرفصل های دوره

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

1. Introduction

1. Introduction

2.1 oops.rar

2.2 Pandas Resources.rar

2.3 PostgreSQL Resources.rar

2.4 Python.rar

2. Resources.html

3. Hello

4. Tour

2. Data Description

1. Data Description

2. Importing the data

3. Creating a DataFrame

1. Series

2. Creating a DataFrame

3. Homework

4. Data Cleaning

1. Data Cleaning

5. Dealing with Empty cells

1. Mean Median Mode

2. Empty cells

6. Dealing with wrong data

1. Wrong Data

7. Dealing with wrong data type

1. Wrong Datatype

8. Dealing with duplicate data

1. Duplicates

9. Correlation

1. Correlation Introduction

2. Correlation

10. Review

1. Review

11. PostgreSQL Introduction

1. Intro.html

2. Installation

3. Select Statement

12. Creating a table

1. Creating a table

13. Insert data into a table

1. Insert data into a table

14. Alter data in a table

1. Alter data in a table

15. Drop a column

1. Drop a column

16. Order by command

1. Order by command

17. Limit, alias, distinct

1. Limit, alias, distinct

18. WHERE, AND, OR, IN, BETWEEN

1. WHERE, AND, OR, IN, BETWEEN

19. Aggregate and Group by command

1. Aggregate and Group by command

20. Project 1

1. Create database and drop table

2. Create table and Foreign Key

3. Insert data

4. Update using SET

5. Delete Records

6. Display Specific Columns

7. Display Specific Rows

8. ORDER BY - LIMIT

9. WHERE - NOT

10. BETWEEN

11. Equal to, Not Equal to

12. Nested Queries

13. LIKE Condition

14. DISTINCT

15. Connect Two Tables

16. JOINS

17. EXCEPT

18. Special Query

21. Instagram clone Database

1. Create Database and Users Table

2. Photos Table

3. Comment Table

4. Like Table

5. Follows Table

6. Tags Table

7. Photos Tags Table

8. Insert Data

9. Query 1

10. Query 2

11. Query 3

12. Query 4

13. Query 5

14. Query 6

15. Query 7

16. Query 8

17. Query 9

22. Python (Optional)

1. Installation - Python

2. Installation - VS Code

3. Setup and Hello World

4. Drawing a Shape

5. DataTypes

6. Variables

7. Strings

8. Numbers

9. Taking an input

10. Lists

11. List_functions

12. Tuples

13. Dictionaries

14. Functions

15. Return Statement

16. Operators

17. If Statement

18. If Statements & Comparisons

19. While Loop

20. For Loops

21. Exponent Function

22. 2D Lists & Nested Loops

23. Comments

24. Try & Except

25. Reading Files

26. Writing Files

23. Certificate

1. Certificate

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training