К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Applied Data Analytics with Python and SQL · LearnSpace
Назад в каталог
courseraАнализ данных

Applied Data Analytics with Python and SQL

Курс от Edureka
Средний≈ 14.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Learn how to work with data using Python and SQL in a practical, project-based course designed to give you relevant, industry-ready skills. You’ll gain hands-on experience manipulating, querying, and analyzing large datasets preparing you to solve real-world data challenges in business, science, or technology. By the end of this course, you’ll know how to: - Process and analyze data efficiently using Python, with a focus on Pandas and NumPy for manipulation and cleaning. - Write SQL queries to retrieve, filter, and aggregate data in relational databases. - Handle data files (CSV, Excel, JSON) and automate common data tasks for faster, repeatable analysis. - Visualize and report insights from your data to support decision-making. This course is designed for beginners, data enthusiasts, and aspiring data analysts and scientists. No prior programming experience is required, but some familiarity with databases or basic computing concepts will help you progress. You’ll finish with solid skills in Python scripting, SQL, and data analysis, giving you a strong foundation for further study or entry-level roles in data-driven industries.

Навыки, которые вы освоите

Python ProgrammingNumPyWeb ScrapingPandas (Python Package)Data ManipulationDatabase ManagementSQLData ProcessingData WranglingDatabasesDatabase SystemsData AnalysisQuery LanguagesProgramming PrinciplesData PresentationData CollectionData-Driven Decision-MakingData Visualization

Программа курса

4 модулей · 130 учебных материалов

01Python Essentials55 материалов

Programming with Python

Welcome to Applied Data Analytics with Python and SQLЧтениеCourse IntroductionВидеоYour Baseline Knowledge CheckpointDIALOGUEProgramming Languages and MythsВидео

Учитесь у экспертов

Edureka

Преподаватель курса

Applied Data Analytics with Python and SQL
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 14.5 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Венгерский

Часть программы вашего университета
Python for AI/ML - Code SimplicityВидео
Python for AI/ML - Ease of LearningВидео
Starting with PythonЧтение
Identifiers in PythonВидео
Literals in PythonВидео
Arithmetic, Comparison, Logical, and Assignment OperatorsВидео
Bitwise, and Membership OperatorsВидео
Python Token TypesВидео
Practice Quiz : Python Programming BasicsЗадание
Introduce YourselfОбсуждение

Data Types in Python

Boolean Operators in Conditional StatementВидеоAND, OR, NOT in PythonВидеоWorking with DictionariesВидеоManipulating DictionaryВидеоTuples in PythonВидеоWorking with Strings in PythonВидеоManaging StringsВидеоOperations on StringВидеоCreating ListsВидеоImmutable and Mutable Data TypesВидеоOperations Performed on ListsВидеоSets ВидеоManipulating Sets ВидеоAn Introduction to Python Data TypesЧтениеPractice Quiz : Working with Data Types in PythonЗаданиеDifferences in Sets, Tuples and DictionaryОбсуждение

Conditional Statements

Exploring Python's Built-in FunctionsВидеоBuilt-in Functions in PythonЧтениеConditional Statement - if conditionВидеоConditional Statement - if else conditionВидеоInitializing For loopВидеоConditional Statements and For Loop in PythonЧтениеBreak, Continue and Pass StatementВидеоControl Flow with Python: break, continue, and pass StatementsЧтениеValidating Prime NumbersВидеоMastering the While Loop in PythonВидеоPractice Quiz : Conditional and Control Flow StatementsЗаданиеHave You Worked on Other Programming Language apart for PythonОбсуждение

Functions and File Handling

Opening FilesВидеоFile OperationsВидеоGlobal vs. Local Variables in PythonВидеоIntroduction to Lambda Functions in PythonВидео Built-in Modules ВидеоStandard ModulesВидеоCreating User Defined FunctionsВидеоFunctions with Multiple ParametersВидеоLambda Functions in PythonЧтениеFile Handling with PythonЧтениеPractice Quiz : Handling Files and File OperationsЗадание

Module Wrap-Up and Assessment

Summary of Python EssentialsВидеоKnowledge Check: Python Essentials for ProgrammingЗадание
02Exploring Data with NumPy and Pandas28 материалов

NumPy with Python

Introduction to NumPy in PythonВидеоHands-On with NumPyВидеоNumPy in PythonЧтениеPractice Quiz : Working with NumPyЗадание

Data Manipulation using Pandas

Introduction to Pandas in PythonВидеоWorking with Pandas SeriesВидеоUnderstanding Pandas DataFramesВидеоData Manipulation with PandasВидеоCombining Datasets with PandasВидеоPractice Quiz : Handling Data using PandasЗаданиеGetting Started with PandasЧтение

Data Visualization

Data Visualization FundamentalsЧтениеMatplotlib LibraryВидеоPlotting ChartsВидеоPlotting Histogram and Box PlotВидеоPlotting Multiple ChartsВидеоIntroduction to Seaborn - Scatter PlotВидеоSeaborn Basic Charts

Module Wrap-Up and Assessment

Summary of Exploring with NumPy and Pandas ВидеоKnowledge Check: NumPy, Pandas and Data Visualization LibrariesЗадание
03Web Scraping and SQL42 материалов

Urllib and Scraping Data with Python

What is Web Scraping?ВидеоWeb Scraping Process FlowВидеоManaging DataВидеоBeautiful SoupВидеоDemonstration of Beautiful SoupВидеоDemonstration of ScrapyВидеоPractice Quiz : Web Scraping with PythonЗаданиеWeb Scraping Best PracticesЧтение

Normalization

What is SQL?ВидеоOperation on KeysВидеоNormalization in DatabasesВидеоTypes of Normalization 1 NFВидеоTypes of Normalization 2 NFВидеоTypes of Normalization 3 NFВидеоTypes of Normalization 4 NF

SQL Commands

DDL CommandsВидеоDQL CommandsВидеоDML CommandsВидеоDCL CommandsВидеоTCL CommandsВидеоSetting Up SQL ServerВидеоManaging Foreign Key Видео

Python Integration with MS SQL Server

Connecting with DatabaseВидеоCreating TableВидеоInserting Data ВидеоSelecting DataВидеоUpdating RecordsВидеоDeleting RecordsВидеоPractice Quiz : Integrating SQL with Python

Module Wrap-Up and Assessment

Summary of Web Scraping and SQLВидеоKnowledge Check : SQL, Normalizations and Web Scraping with PythonЗадание
04Course Wrap-Up and Assessment5 материалов
End Course CheckpointDIALOGUECourse Summary: Applied Data Analytics with Python and SQLВидеоPractice Project: Data Analysis of Police RecordsЧтениеEnd Course Knowledge Check: Python and StatisticsЗаданиеDescribe Your Learning JourneyОбсуждение
Видео
Seaborn - HeatMap ManipulationВидео
Seaborn : Flights DatasetВидео
Seaborn: Gaining Insights in Flight DataВидео
Visualizing Charts with PlotlyВидео
Customizing different charts in PlotlyВидео
Practice Quiz : Visualizing Data in PythonЗадание
Data Visualization with MatplotlibЧтение
Visualization with SeabornЧтение
Видео
Types of Normalization 5 NFВидео
Installation of MS SQL ServerВидео
Practice Quiz : SQL and NormalizationЗадание
Difference Between MS SQL Server and MySQL Чтение
Inserting DataВидео
Deleting DataВидео
Alter CommandВидео
Setting up TransactionВидео
Practice Quiz : Operations on SQLЗадание
SQL CommandsЧтение
Задание
Python with Microsoft SQL ServerЧтение