COURSE DATES
13.09.2024 - 05.10.2024
13.09.2024 - 05.10.2024
COURSE DURATION
3 weeks
3 weeks
LANGUAGE
English
English
LOCATION
Online
Online
CERTIFICATE
TU Berlin Certificate of Professional Education
TU Berlin Certificate of Professional Education
FORMAT
Online
Online
LECTURER
Dongrui Jiang
PRICE
3898,50 โฌ
Recognized as Bildungszeit
3898,50 โฌ
Recognized as Bildungszeit
PRACTICAL PYTHON APPLICATIONS (FOR PROFESSIONALS)
This comprehensive program is tailored for working professionals who want to use Python for practical applications in their fields. The course covers:
- Data manipulation
- Data visualization
- Web scraping
- Automation
- Database integration
Participants will also learn:
- Simple machine learning fundamentals
- Creation of interactive dashboards
The course culminates in a final project. Here, participants apply their skills to real-world challenges within their professional domains.
Learning goals
By the course's end, participants will master advanced Python concepts, gaining practical skills for real-world applications. Learning objectives include proficiency in advanced data types, navigating real-world data scenarios, creating interactive dashboards, implementing web scraping and automation, grasping basic machine learning principles, and effectively integrating Python with databases. The course emphasizes immediate applicability, empowering participants to handle diverse data, streamline workflows, and solve real-world challenges in their respective fields through a real-world project. The ultimate aim is to equip professionals with the tools necessary to enhance productivity and efficiency.Content
1. Python Programming Review- Quick Refresh: Rapid review of fundamental Python concepts to provide a swift start.
- Advanced Data Types Exploration: Delve deeper into sets, tuples, and dictionaries, with a focus on advanced topics such as JSON and database integration.
- Practical Exercises: Hands-on exercises emphasizing comprehensive practice in basic Python, incorporating advanced data types for real-world data processing scenarios.
- Real-world Data Scenarios: Dive into practical applications of Pandas for data manipulation
- Time Series Data Handling: Understand and apply Pandas functionalities tailored for time-dependent datasets.
- Geo-reference Data Processing: Learn techniques to manipulate and analyze location-based data effectively.
- Practical examples
- Advanced Topic: Pandas vs. Excel Comparison: Explore a comparative analysis of Pandas and Excel, demonstrating how to seamlessly integrate both for enhanced practical applications.
- Creating Impactful Visualizations: Explore the capabilities of Matplotlib for crafting compelling visualizations to support data-driven decision-making.
- Advanced Data Visualization Tools: Introduce additional tools for more sophisticated and interactive visualizations.
3. Web Scraping (crawling) and Automation
- Web Scraping for Targeted Data Extraction: Gain hands-on experience in extracting relevant data from websites, focusing on specific targets aligned with professional needs.
- Data Storage and Processing: Learn best practices for storing and processing scraped data efficiently.
- Identifying Repetitive Tasks: Explore strategies to identify and assess tasks suitable for automation within a professional setting.
- Scripting Automation Solutions: Develop Python scripts to automate repetitive tasks, improving efficiency and productivity in the workplace.
4. Building Interactive Dashboards
- Introduction to Dashboards: Explore the fundamentals of creating interactive dashboards for data exploration and presentation.
- Docker Integration: Learn how to use Docker to streamline the deployment and scalability of dashboard applications.
- Example case of dashboard and docker.
5. Database Integration
- Foundations of Databases: Gain a basic understanding of databases, including their types, structures, and role in business applications.
- Python Database Utilizing SQL: Explore advanced techniques for interacting with relational databases using SQL, focusing on efficient data retrieval and manipulation.
- Python Database Utilizing NoSQL: Introduce the principles of working with NoSQL databases, providing flexibility in handling unstructured data.
- Best Database Practices: Learn industry best practices for database management, including optimization, indexing, and data security considerations.
6. Introduction to Machine Learning with Python
- Getting started with Machine Learning: Begin your journey into machine learning by understanding the basic concepts and applications.
- Scikit-Learn Basics: Explore simple and practical implementations of machine learning using Scikit-Learn, a user-friendly library for beginners.
- Real-world Applications: Discover how machine learning can be applied to solve everyday problems in various professional fields.
7. Final Project - Business Solution
Embark on a hands-on journey to apply all acquired skills in Python for designing innovative solutions to real-world challenges within your professional domain.
Target group
Working professionals with a basic understanding of Python programming seeking to build their understanding and skills with a view to practical application in their respective fields.Prerequisites
To fully benefit from this course, participants should have a foundational understanding of Python programming. Prior experience with another coding language is beneficial but not mandatory. As this is an online course, participants will need to ensure access to a laptop or PC, a headset with a microphone and a reliable internet connection in order to participate effectively in live Q&A sessions and collaborative discussions. Participants are encouraged to bring their real-world challenges to the course, fostering a dynamic learning environment where the acquired skills directly address professional needs.Dates
Virtual classroom sessions:- September 13, 2024 (Friday), 15:00 - 21:00 (CET)
- September 20, 2024 (Saturday), 09:00 - 17:00 (CET)
- October 05, 2024 (Saturday), 09:00 - 17:00 (CET)
Following the conclusion of the first two virtual classroom sessions, participants will undertake a period of a self-study (of 20-30 hours). This independent study phase will be accompanied by the lecturer, up to the date of the final on-site session. The lecturer will support participants for approx. 8 hours online, in the form of an open consultation, a small group workshop (or similar), by arrangement.
LECTURER
Dongrui Jiang is a scientific researcher in the chair of Energy and Resource Management at TU Berlin. Her research primarily focuses on energy system analysis, with a significant emphasis on data analysis in the energy field.
Since 2020, she has also been a lecturer for the "Introduction to Python Programming" course at the TU Berlin Summer and Winter University. With over 5 years of experience utilizing Python for data processing, she brings extensive practical knowledge and expertise to the field. Passionate about teaching and sharing insights, she conducts training sessions on both basic Python grammar and advanced topics such as web scraping and data analysis.
Interested in signing up for this course?
Or do you have other questions?
