강의

멘토링

로드맵

NEW
Data Science

/

Data Analysis

Database for Beginners

In this course, you will learn how to operate PostgreSQL and explore methods for integrating it with Python.

1 learners are taking this course

  • ezdatascience
실습 중심
데이터베이스
데이터분석
데이터분석실습
Python
PostgreSQL
SQLAlchemy

What you will learn!

  • Complete mastery of fundamental knowledge such as database design and SQL syntax

  • Database design methodology and design model: ER diagram

  • Python-based Database Integration and Automation

A course to learn Python and PostgreSQL together


Course Introduction

What you can learn through this course! And Curriculum

Learning databases to become a data analyst

To perform data analysis, you must learn SQL, which is a data analysis tool. EZDS has prepared a great course to help you build a solid foundation from the basics. Let's study together! This course was created with Python basics learners in mind, as well as those who have some interest in data analysis but haven't had a proper opportunity to learn SQL. Since SQL is a database language, it's somewhat different from the coding languages we typically know. Therefore, we need to approach it from a slightly different angle. Additionally, since databases are legacy software with their own functions and purposes, we need to keep that in mind while learning.

These days, in addition to relational databases, there are many cases where non-relational databases like NoSQL are used. Also, rather than companies directly operating their own servers, it's more common for them to deploy servers on the cloud. Understanding and installing VirtualBox that we use will serve as a foundation for studying the technologies being used in these industrial fields.

This course also covers database design. It would be great if we could explore how databases are designed and think about methods for proactively organizing and designing data.

To perform data analysis, you must be skilled at handling data. You also need to have a good understanding of how data is structured. SQL will serve as a very important foundation for that journey. Let's build the fundamentals together and make this a time where you can challenge your dreams and become a competent data analyst.

- EZDS Jay


Skills to Learn

  • PostgreSQL

  • Python Library (SQLAlchemy)


Practice Code

https://github.com/ezds-jay/python-database

Please check the practice code in the code repository above!

Recommended for
these people

Who is this course right for?

  • People who are starting with databases for the first time

  • Someone who is starting data analysis

  • Someone who knows how to handle Python to some extent

Need to know before starting?

  • Python Basics

  • Basic Linux Knowledge

Hello
This is

793

Learners

36

Reviews

1

Answers

4.8

Rating

3

Courses

데이터 사이언스 및 인공지능 관련 강의 제작자입니다.

학력은 정보학 석사/ 컴퓨터과학 박사 중입니다.

Curriculum

All

20 lectures ∙ (5hr 16min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

Limited time deal

$42,350.00

30%

$47.30

ezdatascience's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!