Работа с базами данных в Python from Coursera

What's inside

Syllabus

Объектно-ориентированный язык Object Oriented Python

Для начала мы рассмотрим основы языка Object Oriented Python. Хотя мы не будем создавать собственные объекты, но нам понадобится немало объектно-ориентированных конструкций: BeautifulSoup, строки, словари, подключение к базам данных. Поэтому необходимо как минимум понимать основные принципы и терминологию объектно-ориентированного подхода.

Основы структурированного языка запросов SQL

Мы изучим четыре базовые операции (создание, чтение, редактирование и удаление, сокращенно «CRUD») с данными, хранящимися в базе данных.

Модели данных и SQL-запросы в реляционных БД

В этом разделе мы рассмотрим принципы хранения данных в нескольких таблицах одной базы данных и способы установления связей между строками в таблицах.

Связи «многий ко многим» в языке SQL

В этом разделе мы научимся моделировать ситуации, когда, например, учащиеся записываются на курсы, при этом каждый курс посещает несколько учащихся, а каждый учащийся может записаться на несколько курсов.

Базы данных и визуализация

В этом разделе мы объединим все изученные темы. Мы займемся извлечением и обработкой данных с их последующей визуализацией в Google Maps API.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Знакомит с основами SQL, которые используются в отрасли data science

Помогает освоить принципы проектирования баз данных и устанавливать связи между таблицами

Обучает визуализации данных для их понятного представления

Требует предварительного изучения Python и трех предшествующих курсов этой специализации

Reviews summary

Excellent course in database fundamentals

This course is an excellent course for those who are interested in the fundamentals of structured query language (SQL) and database design. The course uses the SQLite3 library as the database management system and covers topics such as creating search bots, multi-stage data collection processes, and data visualization using the D3.js library.

The course instructor is responsive and helpful.

"Many thanks to the moderator of the course."

This course is a great starting point for beginners in the field.

"Отличный курс для начинающих."

In addition to theory, the course is complemented with practical applications.

"The theory is accompanied by applied examples."

Career center

Learners who complete Работа с базами данных в Python will develop knowledge and skills that may be useful to these careers:

Database Administrator

As a Database Administrator, you will be responsible for the maintenance and security of databases, ensuring the integrity and availability of data. This course provides a solid foundation in SQL, the language used to communicate with databases, and will help you develop the skills needed to manage and administer databases effectively.

See salaries and explore the career path for Database Administrator

Data Analyst

Data Analysts are responsible for collecting, cleaning, and analyzing data to help businesses make informed decisions. This course provides a foundation in SQL, the language used to query and manipulate data, and will help you develop the skills needed to extract valuable insights from data.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use advanced statistical and machine learning techniques to analyze data and solve business problems. This course provides a foundation in SQL, the language used to access and manipulate data, and will help you develop the skills needed to build and deploy data science models.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts bridge the gap between business and technology, helping organizations to understand their data and make informed decisions. This course provides a foundation in SQL, the language used to query and manipulate data, and will help you develop the skills needed to analyze data and provide insights to support decision-making.

See salaries and explore the career path for Business Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to build and maintain data-driven applications.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design, develop, and maintain websites and web applications. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to build and maintain data-driven web applications.

See salaries and explore the career path for Web Developer

Information Security Analyst

Information Security Analysts protect organizations from cyber threats by implementing and maintaining security measures. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to monitor and analyze data for security breaches.

See salaries and explore the career path for Information Security Analyst

Data Engineer

Data Engineers build and maintain the infrastructure that supports data analysis and machine learning. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to design and implement data pipelines.

See salaries and explore the career path for Data Engineer

Database Architect

Database Architects design and implement database systems to meet the needs of organizations. This course provides a foundation in SQL, the language used to create and manage databases, and will help you develop the skills needed to design and implement scalable and efficient database systems.

See salaries and explore the career path for Database Architect

Data Governance Analyst

Data Governance Analysts develop and implement policies and procedures to ensure the accuracy, reliability, and security of data. This course provides a foundation in SQL, the language used to query and manipulate data, and will help you develop the skills needed to analyze data and develop data governance policies.

See salaries and explore the career path for Data Governance Analyst

Data Quality Analyst

Data Quality Analysts ensure that data is accurate, complete, and consistent. This course provides a foundation in SQL, the language used to query and manipulate data, and will help you develop the skills needed to analyze data and identify and correct data quality issues.

See salaries and explore the career path for Data Quality Analyst

Technical Writer

Technical Writers create and maintain documentation for software and hardware products. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to write clear and concise documentation for data-related products.

See salaries and explore the career path for Technical Writer

Technical Support Specialist

Technical Support Specialists provide support to users of software and hardware products. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to troubleshoot and resolve data-related issues.

See salaries and explore the career path for Technical Support Specialist

Statistician

Statisticians collect, analyze, and interpret data to provide insights for businesses and organizations. This course provides a foundation in SQL, the language used to store and retrieve data, and will help you develop the skills needed to analyze data and draw meaningful conclusions.

See salaries and explore the career path for Statistician

Actuary

Actuaries use mathematical and statistical techniques to assess risk and uncertainty. This course may provide a helpful introduction to SQL, the language used to store and retrieve data, but it is important to note that actuaries typically require an advanced degree in mathematics or statistics.

See salaries and explore the career path for Actuary