We may earn an affiliate commission when you visit our partners.

Python에서 데이터베이스 사용하기

이 과정은 학생들에게 SQL(Structured Query Language)의 기초와 다단계 데이터 수집, 분석 및 처리 노력의 일환으로 데이터를 저장하기 위한 기본 데이터베이스 설계를 소개합니다. 본 과정은 SQLite3를 데이터베이스로 사용합니다. 또한 웹 크롤러와 다단계 데이터 수집 및 시각화 프로세스를 구축합니다. D3.js 라이브러리를 사용하여 기본 데이터 시각화를 수행합니다. 본 과정은 ‘Python for Everybody’의 14-15장을 다룹니다. 이 과정을 성공적으로 마치려면 교과서의 1-13장과 이 전문 과정의 처음 세 과정에서 다루는 내용을 숙지해야 합니다. 본 과정은 Python 3를 다룹니다.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

객체 지향 Python

이 강의를 시작하기 위해 객체 지향 Python의 기본 사항을 다룹니다. 직접 객체를 작성하지 않을 것이나 BeautifulSoup, 문자열, 딕셔너리, 데이터베이스 연결과 같이 사용하는 많은 것들이 모두 객체 지향(OO) 패턴을 사용하므로 그 패턴과 용어의 일부 정도는 이해해야 합니다.

기본 구조화 질의 언어

데이터베이스에 저장된 데이터를 관리하기 위한 4가지 핵심 CRUD 작업(Create, Read, Update, Delete)을 배웁니다.

데이터 모델 및 관계형 SQL

이 섹션에서는 데이터베이스의 여러 테이블에 데이터가 저장되는 방식과 데이터베이스에서 행이 연결되는 방식(즉, 관계를 설정하는 방식)에 대해 배웁니다.

SQL의 다대다 관계

이 섹션에서는 각 과정에 많은 학생이 있고 각 학생은 많은 과정에 등록되어 있을 때 학생들을 과정에 등록시키는 것과 같은 상황을 모델링하는 방법에 대해 탐구합니다.

데이터베이스 및 시각화

이 섹션에서는 이를 모두 통합하고 일부 데이터를 검색 및 처리한 다음 Google Maps API를 사용하여 데이터를 시각화합니다.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

SQL 데이터를 사용하여 다단계 데이터 분석 및 시각화를 다룹니다

SQLite3와 같은 기본 데이터베이스 설계를 소개합니다

웹 크롤러를 사용한 데이터 수집 및 시각화를 다룹니다

파이썬과 SQL을 사용하여 데이터 분석을 수행합니다

기본적인 데이터 시각화를 위한 D3.js 라이브러리를 소개합니다

객체 지향 Python의 기본 사항을 다룹니다

Save this course

Save Python에서 데이터베이스 사용하기 to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Python에서 데이터베이스 사용하기 with these activities:

SQLite3 데이터베이스 튜토리얼

Show steps

SQLite3에 대한 튜토리얼을 따라 데이터베이스에 데이터를 저장하고 관리하는 기술을 향상시킬 수 있습니다.

Browse courses on sqlite3

Show steps

SQLite3 공식 문서 튜토리얼 참조
온라인 튜토리얼 또는 코스 플랫폼에서 SQLite3 튜토리얼 수강

데이터베이스 쿼리 연습

Show steps

다양한 데이터베이스 쿼리를 연습하여 데이터 검색, 조작 및 분석 기술을 강화할 수 있습니다.

Browse courses on SQL

Show steps

SQL 튜토리얼 또는 쿼리 연습 웹사이트에서 문제 해결
직접 데이터베이스 만들고 데이터 입력
다양한 쿼리를 작성하고 실행해 원하는 데이터 추출 및 조작

Show all two activities

Career center

Learners who complete Python에서 데이터베이스 사용하기 will develop knowledge and skills that may be useful to these careers:

Data Warehouse Architect

Data Warehouse Architects design and build data warehouses that store and manage large amounts of data. This course provides a comprehensive overview of database design, SQL, and data visualization, all of which are essential skills for Data Warehouse Architects. By taking this course, you will gain the knowledge and skills needed to succeed in this critical role.

See salaries and explore the career path for Data Warehouse Architect

Database Architect

Database Architects design and build databases that meet the needs of businesses and governments. This course provides a comprehensive overview of database design, SQL, and data visualization, all of which are essential skills for Database Architects. By taking this course, you will gain the knowledge and skills needed to succeed in this critical role.

See salaries and explore the career path for Database Architect

Data Visualization Specialist

Data Visualization Specialists design and create visualizations that help businesses and governments communicate data effectively. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Data Visualization Specialists. By taking this course, you will gain the skills needed to succeed in this growing field.

See salaries and explore the career path for Data Visualization Specialist

Database Administrator

Database Administrators manage and maintain databases, ensuring that they are running smoothly and that data is secure. This course provides a comprehensive overview of database design, SQL, and data visualization, all of which are essential skills for Database Administrators. By taking this course, you will gain the knowledge and skills needed to succeed in this critical role.

See salaries and explore the career path for Database Administrator

Data Scientist

Data Scientists use data to solve complex business problems. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Data Scientists. By taking this course, you will gain the skills needed to succeed in this high-demand field.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

Machine Learning Engineers design and build machine learning models that can learn from data and make predictions. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Machine Learning Engineers. By taking this course, you will gain the skills needed to succeed in this emerging field.

See salaries and explore the career path for Machine Learning Engineer

Data Engineer

Data Engineers design and build the infrastructure that stores and processes data. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Data Engineers. By taking this course, you will gain the skills needed to succeed in this emerging field.

See salaries and explore the career path for Data Engineer

Cloud Architect

Cloud Architects design and build cloud-based solutions that meet the needs of businesses and governments. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Cloud Architects. By taking this course, you will gain the skills needed to succeed in this emerging field.

See salaries and explore the career path for Cloud Architect

Big Data Engineer

Big Data Engineers design and build systems that can store and process large amounts of data. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Big Data Engineers. By taking this course, you will gain the skills needed to succeed in this emerging field.

See salaries and explore the career path for Big Data Engineer

Statistician

Statisticians collect, analyze, and interpret data to help businesses and governments make informed decisions. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Statisticians. By taking this course, you will gain the skills needed to succeed in this growing field.

See salaries and explore the career path for Statistician

Business Analyst

Business Analysts use data to help businesses make informed decisions. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Business Analysts. By taking this course, you will gain the skills needed to succeed in this critical role.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts collect, clean, analyze, and interpret data to help businesses make informed decisions. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Data Analysts. By taking this course, you will gain the skills needed to succeed in this growing field.

See salaries and explore the career path for Data Analyst

Web Developer

Web Developers design and develop websites and web applications. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Web Developers. By taking this course, you will gain the skills needed to succeed in this creative and technical field.

See salaries and explore the career path for Web Developer

Information Security Analyst

Information Security Analysts protect computer systems and networks from unauthorized access and attack. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Information Security Analysts. By taking this course, you will gain the skills needed to succeed in this critical role.

See salaries and explore the career path for Information Security Analyst

Software Engineer

Software Engineers design, develop, and maintain software systems. This course provides a strong foundation in SQL, data visualization, and data modeling, all of which are essential skills for Software Engineers. By taking this course, you will gain the skills needed to succeed in this in-demand field.

See salaries and explore the career path for Software Engineer

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Python에서 데이터베이스 사용하기.

SQL Instant Reference

Save

이 책은 SQL 구문과 함수의 종합적인 참조서입니다. 본 과정에서 다루는 SQL 문법을 참조하는 유용한 도구가 됩니다.

Python에서 데이터베이스 사용하기

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses