Hands-on Data Skills: Python Programming, SQL Queries & Oracle Database

From 26 € /h

This course is designed for anyone who wants to learn practical data skills using Python, SQL, and Oracle databases. Whether you're a complete beginner or looking to strengthen your data handling skills, I’ll guide you step-by-step through core concepts and real-world projects.

You'll learn:

Python programming basics and data analysis tools for data science, data engineering and data analytics

SQL queries: SELECT, JOIN, GROUP BY, procedures, Functions and subqueries

How to work with Oracle Database: tables, indexes, stored procedures

Real-world use cases from business and data science

Best practices for clean, efficient, and scalable code

Lessons are project-based and tailored to your skill level, whether you're in school, switching careers, or preparing for a job in data or IT.

Extra information

Lectures will be Online

Location

Online from Germany

About Me

I'm a certified Data Scientist, Data Engineer, and Data Analyst with over 5 years of teaching and industry experience. I’ve taught students and professionals from around the world — helping them learn Python, SQL, databases, data analytics, and cloud technologies with confidence.

My teaching style is hands-on, project-based, and tailored to each student’s level — whether you're a complete beginner, university student, or a working professional. I believe in learning by doing, and my sessions focus on solving real-world problems using tools like Python, Power BI, SQL, and Oracle.

I've led corporate training, internship programs, and 1-on-1 online tutoring sessions, and many of my students now work in tech, banking, and multinational companies.

If you're looking for personalized, practical lessons that focus on results and clarity, I’d love to help you reach your learning goals.

Education

Bachelor's in Computer Science (CGPA: 3.78/4.0) from Virtual University of Pakistan.
Focused on software development, databases, data structures, and applied machine learning. Developed strong foundations in programming (Python, C++, Java), SQL, and algorithmic thinking. Participated in academic projects related to data analysis and automation.

Experience / Qualifications

5+ Teaching Experience
Oracle Certified Data Science Professional
Certified Automation Engineer
Certified Python Developer
Certified Oracle Database Professional

Age

Children (7-12 years old)

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

30 minutes

45 minutes

60 minutes

90 minutes

120 minutes

The class is taught in

English

Urdu

Hindi

Skills

Database

Python

Oracle database

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Learn Python, SQL and MySQL databases from beginner to Advanced Level | Certified Data Science Professional

26 € /h

Learn
Python
SQL
Power BI
Excel
Data Science
Data Engineering
Data Analytics
Data Modeling
Data Warehousing
ETL
API's
Machine Learning
Lecture will be Hands-on, beginner friendly, solving real world problems just like I do in my job. So, if you’re just starting out like college, university student, switching careers, or preparing for a job in data field — book a trial lesson, and let’s begin your journey together. I look forward to seeing you in class!

Matías

4.88

(85)

Python is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.

This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.

As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.

I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.

Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.

Amin

4.88

(85)

Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL.

Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program.

Additionally, upon request, we offer courses in other programming languages such as C, JAVA, R, and MATLAB.

Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs.

If you have any questions, feel free to contact us.

Salah

4.88

(85)

Master Python with Personalized Courses

Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels.

Why Choose My Courses?

Personalized Teaching Approach: Each course is tailored to your skill level and individual goals.

Practical Experience: Learn by doing with real-world projects that build your understanding and skills.

Ongoing Support: Get unlimited email support for any questions you have between sessions.

As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey.

Book Your First Lesson:

Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.

Amine

4.88

(85)

Discover programming lessons suitable for children! With a fun and educational approach, my lessons allow young minds to dive into the fascinating world of programming. Provide your children with an enriching learning opportunity in a fun and stimulating environment.

Francisco

4.88

(85)

Welcome to my Programming Projects Support class!

Are you facing hurdles with your programming projects? Let's tackle them together!

As a Geophysics PhD student, I rely heavily on programming tools like Matlab, Python, and R for data analysis, mathematical modeling, plot results and much more.

After a lot of requests from students I created this course which is specifically meant to give you support completing your final programming projects.

Here's what you can expect:

- We'll review your project's background and requirements.
- Analyze your coding progress and identify areas for improvement.
- Collaborate to overcome obstacles, debug your code and advance your project.
- Tailored sessions based on your project's complexity and your skill level.

Whether you require a single session or a series of in-depth consultations, my goal remains the same: to help you break through programming barriers and achieve your goals.

Ready to level up your programming skills? Let's get started!

Please note:
This is a support course only ! While I'm here to guide you, the project's success lies in your hands and I will not finish your project for you.

Baia

4.88

(85)

Code Your Ideas Into Reality 💻🚀
Want to build your own website or start a tech career? This class is perfect for absolute beginners who want to learn Python and use it to build real, working web apps with Django. You'll go from writing your first line of code to deploying complete projects - step by step, clearly explained, and handsOn.

✨ No experience needed.
🧠 Learn by doing - real apps, real logic.
🌍 Build skills for school, work, or freelance life.

Let’s turn your curiosity into code. First session gets you started!

Amr

4.88

(85)

In today's rapidly evolving technological landscape, **Python programming** has emerged as one of the most **critical skill sets** for professionals across industries. With applications spanning web development, data science, artificial intelligence, automation, and more, Python continues to dominate as the **language of choice** for developers and organizations worldwide. This proposal outlines a comprehensive Python course designed and delivered by **Amr**, a developer and instructor with over **20 years of experience** in the field. The course combines fundamental programming concepts with practical, real-world applications, ensuring students gain not just theoretical knowledge but **marketable skills** that align with current industry demands. By leveraging cutting-edge teaching methodologies and extensive professional experience, this course offers an unparalleled learning opportunity for aspiring programmers and experienced developers alike.

## 1 Introduction to Python Programming

Python has established itself as a **powerhouse programming language** across various domains, from web development and data analysis to artificial intelligence and automation. As of 2025, the demand for Python skills continues to soar, with industry giants like Cisco, IBM, and Google leveraging its capabilities for their projects . Python's dominance in the technology sector is undeniable – it remains the **most requested programming language** in job postings across multiple industries, including finance, healthcare, technology, and entertainment.

The language's popularity stems from several key factors: its **user-friendly syntax** that resembles natural English, making it exceptionally accessible for beginners; its **versatile nature** that supports multiple programming paradigms; and its **extensive ecosystem** of libraries and frameworks that simplify complex programming tasks. Python's cross-platform compatibility ensures code runs seamlessly on Windows, macOS, and Linux environments, while its open-source nature has fostered a massive community of contributors who continuously expand its capabilities . These attributes make Python not just a programming language but a **comprehensive toolset** for solving diverse computational problems.

For professionals looking to future-proof their careers, Python offers **exceptional value**. According to industry data, Python developers in the United States earn an average of **$116,028 per year**, reflecting the high market demand for these skills . Beyond financial rewards, Python proficiency opens doors to cutting-edge fields like machine learning, natural language processing, and data analytics – domains that are shaping the future of technology across industries.

## 2 Course Overview & Learning Objectives

### 2.1 Course Philosophy
This Python programming course is designed with a **practice-oriented approach** that emphasizes hands-on learning and real-world application. Unlike traditional programming courses that focus heavily on theory, this program balances conceptual understanding with **practical implementation**, ensuring students develop the skills needed to solve actual business problems. The curriculum is structured to build proficiency gradually, starting with fundamental concepts and progressing to advanced applications, with each module incorporating **project-based learning** components.

### 2.2 Key Learning Objectives
Upon successful completion of this course, students will be able to:

- **Demonstrate proficiency** in core Python programming concepts including data structures, control flow, functions, and file handling
- **Develop functional applications** using Python for various domains including web development, data analysis, and automation
- **Implement object-oriented programming** principles to create modular, maintainable code
- **Utilize popular Python libraries** such as Pandas, NumPy, and BeautifulSoup for specialized tasks
- **Integrate with databases** and web APIs to create full-stack applications
- **Apply debugging and testing** techniques to ensure code quality and reliability
- **Build portfolio-worthy projects** that demonstrate marketable skills to potential employers

## 3 Instructor Qualifications & Experience

### 3.1 Professional Background
**Amr** brings an exceptional **twenty-year track record** of development and instruction experience to this Python course. His extensive background encompasses both corporate training and software development, providing a unique blend of pedagogical expertise and practical knowledge. With credentials including a **Bachelor of Computer Science and Management Technology** from Modern Academy and a **Computer Science Diploma** from Arab Academy for Science and Technology, Amr possesses the academic foundation to complement his extensive professional experience.

His career demonstrates **progressive responsibility** and expertise across multiple programming languages and frameworks. Beginning as a technical instructor at renowned institutions including NewHorizons, Knowlogy, and Informatica, he quickly established himself as a developer at Microtech and ITS, where he worked on enterprise-level systems including **ERP and banking applications**. This combination of education and hands-on development experience creates an ideal foundation for teaching programming concepts with both theoretical rigor and practical relevance.

### 3.2 Industry Client Portfolio
Amr's exceptional teaching credentials are further enhanced by his impressive roster of **corporate clients**, which includes some of the world's most recognized brands:

- **Technology Leaders**: Microsoft, IBM, Siemens, Vodafone, and Telecom Egypt
- **Financial Institutions**: National Bank of Egypt, NSGB, CIB, and Central Bank of Egypt
- **Global Consumer Brands**: Pepsi, Coca-Cola, Nestlé, Cadbury, and Americana
- **Industrial Conglomerates**: Chrysler, Valeo, 3M, ABB, and BP (British Petroleum)
- **Government Entities**: Libya Government IT Department, Sudan Army Officers, Egyptian Airports Company

This diverse client experience has provided Amr with **unparalleled insight** into how Python is applied across different industries and organizational contexts. His exposure to various business domains allows him to teach Python not as an abstract academic exercise but as a **practical tool** for solving real business problems.

### 3.3 Teaching Methodology
Amr employs a **learner-centered approach** that emphasizes interactive engagement and practical application. His teaching philosophy is based on the principle that programming is best learned through doing, rather than passive listening. Each concept is introduced through **clear explanations** followed immediately by hands-on exercises that reinforce learning. He adapts his pace and approach based on student comprehension, ensuring no one is left behind while maintaining challenging content for advanced learners.

*Table: Instructor's Recent Training Engagements (2023-2025)*

| **Year** | **Corporate Clients** | **Training Centers** | **Technologies Covered** |
|----------|-----------------------|----------------------|--------------------------|
| **2023** | International Finance Corporation, Raya Integration | Raya Academy, IT-Egypt | VBA, Office Automation, Web Technologies, Software Fundamentals with C#, SQL Server Database Design and Querying, Introduction to .NET Core Framework, Building ASP.NET Core Web API, Front-End Development Basics (HTML, CSS, JavaScript, TypeScript), Advanced Front-End Development with Angular, Integration and Deployment |
| **2024** | 3M, Pepsi | NewHorizons, Radio & Television Institute, Informatics (Lebanon), Total-Tech (KSA), Global Business Star (USA) | SQL Query (20761), SQL Development (20762), SQL Admin (20764,20765), Tabular, MQL5, ASP.NET Core MVC Web Applications (20486), Programming in C# (20483), Programming in HTML5 with JavaScript and CSS3 (20480), LINQ, EF (Entity Framework) |
| **2025** | Siemens, Vodafone | YAT, Future University | Full Stack Development, Data Analysis |

## 4 Detailed Course Curriculum

### 4.1 Module Breakdown
The Python course is structured into **eight comprehensive modules** that systematically build programming proficiency from foundation to advanced application:

1. **Python Fundamentals** (10 hours): Syntax, variables, data types, operators, and basic input/output operations. Students will write their first programs and understand how Python interprets and executes code.

2. **Control Structures & Functions** (15 hours): Conditional statements (if/elif/else), loops (for/while), function definition, parameters, return values, and scope. Emphasis on writing clean, reusable code.

3. **Data Structures** (20 hours): Lists, tuples, dictionaries, sets, and their appropriate applications. Includes comprehensive exercises on data manipulation and storage.

4. **Object-Oriented Programming** (20 hours): Classes, objects, inheritance, polymorphism, and encapsulation. Students will learn to structure code using OOP principles for better maintainability.

5. **File Handling & Modules** (10 hours): Reading/writing files, exception handling, importing modules, and creating custom modules. Practical applications for data persistence.

6. **Web Development with Python** (25 hours): Introduction to Flask/Django frameworks, REST APIs, and basic front-end integration. Students will build a functional web application.

7. **Data Analysis & Visualization** (25 hours): Using Pandas for data manipulation, NumPy for numerical computing, and Matplotlib/Seaborn for visualization. Real-world datasets will be used for analysis.

8. **Introduction to Automation & Scripting** (15 hours): Applying Python to automate repetitive tasks, web scraping with BeautifulSoup, and working with APIs.

### 4.2 Practical Projects
The curriculum includes **five portfolio projects** that allow students to apply their learning:

1. **Data Analysis Project**: Analyzing real business data to extract insights and create visualizations
2. **Web Application Project**: Building a fully functional web application with database integration
3. **Automation Script**: Creating a practical tool to automate a repetitive computer task
4. **API Integration Project**: Connecting to external services and processing returned data
5. **Final Capstone Project**: A comprehensive application that demonstrates mastery of course concepts

### 4.3 Python in Marketing Analytics
A special section of the course will focus on **Python applications in digital marketing**, covering how Python can be used for marketing automation, data analysis, and operations . Students will learn:

- **Working with APIs** to connect different software tools and automate marketing workflows
- **Web scraping** to gather data from web pages for content analysis and competitive intelligence
- **Text analysis** for sentiment analysis, content optimization, and customer feedback processing
- **Data analysis** for marketing analytics using Pandas and visualization libraries
- **Technical SEO** applications using Python libraries like advertools and EcommerceTools

This specialized content demonstrates Python's versatility beyond traditional programming roles, showing its value in business functions like marketing where data skills are increasingly crucial.

## 5 Training Methodology & Delivery

### 5.1 Interactive Learning Approach
This Python course employs a **multimodal teaching methodology** that accommodates diverse learning styles while ensuring practical skill development. Each session follows a structured pattern:

1. **Concept Introduction**: Clear explanation of programming concepts with real-world analogies
2. **Live Coding Demonstration**: Step-by-step coding examples that students can follow along
3. **Guided Practice**: Structured exercises with instructor support and immediate feedback
4. **Independent Challenge**: Problem-solving activities that require applying concepts creatively
5. **Code Review**: Collaborative analysis of solutions to identify best practices and improvements

This approach ensures that students not only understand theoretical concepts but develop the **problem-solving mindset** essential for effective programming. The emphasis is always on writing clean, efficient, and maintainable code following industry standards.

### 5.2 Hands-On Labs & Exercises
A distinctive feature of this course is the extensive **hands-on programming practice** integrated throughout the curriculum. Students will spend approximately **60% of course time** actively writing code rather than passively listening to lectures. Practical components include:

- **Coding exercises** for each new concept introduced
- **Mini-projects** that combine multiple concepts into functional applications
- **Debugging challenges** that develop problem-solving skills
- **Code optimization** activities focusing on efficiency and performance
- **Pair programming** sessions to foster collaboration and knowledge sharing

ِSend me if you have any questions,
Regars,
Amr

Karim

4.88

(85)

Python programming
Algorithms
Data base
web development
HTML5, CSS3, JavaScript, PHP, SQL
Everything for high school students or students during customized training according to their needs, and don't forget your computers.

Mohammed

4.88

(85)

My teaching approach is highly practical and structured, starting with strong fundamentals and gradually progressing to advanced concepts. Each topic is explained using clear examples, visual demonstrations, and step-by-step problem-solving techniques to ensure learners build confidence as they progress. Master Python and learn core concepts including variables, data types, control flow, functions, and error handling. The course also covers critical ideas such as object-oriented programming, libraries, file handling, exploratory data analysis (EDA), and data visualization using Matplotlib and Seaborn.

I focus on hands-on learning through live practice, real-time datasets, mini projects, and case studies. Regular assessments, interactive discussions, and doubt-clearing sessions are incorporated to reinforce understanding. This methodology helps learners not only grasp concepts effectively but also apply them independently in real-world and professional environments.

Additionally, I emphasize career-oriented learning by guiding learners on best practices, industry standards, and project presentation. I provide mentorship on resume building, interview preparation, and portfolio development, ensuring learners are well-prepared to transition their skills into real job opportunities or career growth.

Amine

4.88

(85)

◾ Tools

RStudio • SQL • SPSS • SAS • Jamovi • JASP

◾ Statistical Methods & Tests

Student's t-test • ANOVA • MANOVA • ANCOVA • Regression (linear & logistic) • Correlation • Chi-square • Nonparametric tests • PCA • MCA • Exploratory factor analysis • Classification / Clustering • Mediation • Moderation • Interpretation

◾ Data analysis & decision support

- Data preparation, structuring and validation using SAS, R and SQL
- Descriptive, exploratory and multivariate statistical analyses on business data
- Production of performance indicators and actionable analyses to support decision-making

◾ Selection and implementation of methods

- Preparation and structuring of databases
- Hypothesis testing and univariate, bivariate and multivariate analyses (ANOVA / ANCOVA)
- Linear and logistic regressions
- Factor analyses (PCA / MCA)
- Mediation and moderation models
- Classification / clustering

1) Academic support

- Lectures, tutorials, projects and assignments in statistics
- Help in understanding and interpreting the results
- Preparation for exams and academic presentations

2) Statistical analysis

- Descriptive statistics (univariate and bivariate)
- Multivariate analyses
- Data exploration and outlier detection

3) Statistical tests

- Correlations (Pearson, Spearman, Cohen's Kappa)
- t-tests (one and two samples, independent or paired)
- Chi-square, binomial tests
- z-scores and associated indicators

4) Statistical modeling

- Linear regressions (simple and multiple)
- Logistic regression
- Interpretation of coefficients, diagnostics and validation of models

5) ANOVA & ANCOVA

- One- or multi-factor ANOVA
- Repeated measures ANOVA
- Fixed and random effects
- Post-hoc tests and effect sizes

6) Factor analyses

- ACP / PCA (scree plot, factor scores, matrices)
- Exploratory factor analysis
- Factorial rotations
- Validation and interpretation of structures and clusters

◾ Reporting & communication

- Clear, structured and concise reporting of results
- Visualizations tailored to decision-makers
- Support for strategic and operational decision-making

Taiwo

4.88

(85)

This online programming class is designed for students who want to build real technical skills in computer science and web development — not just learn theory, but actually create and understand how systems work.

I teach:

• Python programming (fundamentals, logic building, problem-solving, data handling)
• JavaScript (core concepts, DOM manipulation, interactivity)
• CSS (styling, layout systems, responsive design)
• Website Development (front-end foundations and structure)
• WordPress Development (customization, site building, content management)
• UI/UX Fundamentals (design thinking, layout clarity, user experience principles)

Students learn how to think computationally, break down problems logically, and build structured solutions. Lessons are practical and project-based, meaning students don’t just watch — they build.

For beginners, we focus on strong foundations: understanding how code works, writing clean syntax, and developing confidence in debugging.
For intermediate learners, we move into structured projects such as creating simple websites, improving layout design, adding interactivity, and understanding how front-end components connect.

My approach emphasizes clarity, structure, and application. I help students understand not only what to type, but why it works — which is the difference between copying code and truly understanding it.

This class is suitable for:
• School students exploring computer science
• Beginners transitioning into tech
• Learners preparing for academic computer science courses
• Individuals interested in web development skills

All sessions are fully online, interactive, and tailored to the student’s pace and goals.

Chrayet

4.88

(85)

Specialized in using Power BI and able to configure you on demand, whether you are a beginner who wants to understand the basics of data analysis or a professional seeking to master building advanced reports and dashboards.

Microsoft Power BI is considered one of Microsoft's most powerful business intelligence tools, and is widely used in the fields of industry 🏭, finance 💰, commerce 📊, project management 📈, human resources 👥, supply chains 🚚 and more.

With Power BI you can:

Linking multiple data sources (Excel, ERP, SQL, SharePoint...).

Cleaning and transforming data professionally using Power Query.

Creating powerful data models using DAX.

Interactive and easy-to-read dashboard design.

Track Key Performance Indicators (KPIs) in real time.

Supporting decision-making through in-depth and accurate data analysis.

I offer practical training based on real-world scenarios from your work environment, simplifying technical concepts like Data Modeling and DAX in a systematic and accessible way. The goal is to empower you to transform raw data into strategic insights that help you make smart, fast decisions.

Mastering Power BI gives you a strong added value in the job market, and enables you to lead the digital transformation within your organization 🚀

A customized training program can be set up according to your level and professional needs.

Asmaa

4.88

(85)

A training program to teach programming to children aged 7 to 18, divided into several levels to suit each age group.
Each level is designed for a specific age and aims to develop logical thinking and problem-solving skills.
The student begins learning programming using Scratch, App Inventor and PictoBlox in an easy and fun way.
Then he moves on to learning the basics of Python programming and building simple programs and games.
After that, he trains in designing and developing websites using HTML, CSS, and JavaScript.
At the end of each level, the student submits a practical project and a certificate of completion for the level.

Madhav

4.88

(85)

Hi, I’m Madhav (Canada, ET). I am an MSc in Computer Science with 7+ years of professional experience building real-world software systems in Python. Currently, I work as a Software Development Manager where I lead 2 teams building web applications in python.

I bring 4+ years of programming instruction, combining academic rigor with real-world tech industry standards. During my Master’s in Canada, I served as a Teaching Assistant for undergraduate CS courses and delivered Python workshops to over 500 learners, mastering the art of breaking down complex topics for beginners.

My greatest asset to you is my 7+ years of industry experience. In our lessons, I am going to focus on building real world projects that will prepare you for python programming in the real world.

Book the first session to start your journey to learning python!

Dani

4.88

(85)

This advanced course builds on programming fundamentals using Python (programming language) and is designed for students who want to deepen their programming knowledge.

The course continues from functions and introduces advanced programming concepts including object-oriented programming principles such as polymorphism, inheritance, abstraction, and encapsulation.

Students will also learn data handling techniques, working with Python libraries, and developing structured programs using complex loops and data collections.

The course covers practical implementation of nested loops, nested lists, tuples, and dictionaries, as well as an introduction to data structures and algorithmic thinking.

Additional topics include graphical user interface development using libraries such as Tkinter, along with introductory concepts in data science and machine learning using Python.

Teaching combines theoretical explanation with real coding exercises to help students develop strong practical programming skills.

• Review of programming fundamentals and functions
• Object-Oriented Programming (OOP) concepts
• Polymorphism, inheritance, abstraction, and encapsulation
• Data structures basics
• Nested loops and complex data handling
• Lists, tuples, and dictionaries
• Introduction to algorithms
• Working with Python libraries
• GUI development using Tkinter
• Introduction to data science and machine learning concepts