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

From 23 £ /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 -04: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

23 £ /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)

Are you a university student, engineer, or professional who needs to actually use data — not just learn theory about it?
This course is built around real problems and real code. We skip the textbook formulas and go straight to applying statistics and data science the way professionals do: with Python (pandas, NumPy, scikit-learn, matplotlib) and R (RStudio).
What we cover, adapted to your level and goals:
- Descriptive and inferential statistics (the ones that actually matter)
- Data cleaning, exploration, and visualization
- Regression, classification, and intro to machine learning
- Time series and forecasting basics
- R for statistical analysis and academic research

Who this is for:
- University students in statistics, economics, engineering, or biology
- Professionals wanting to move into data analysis or data science
- Researchers who need to process and present data properly

I use Python and R professionally as a working engineer — everything I teach comes from real application, not just academic exercises.

Giuliano

4.88

(85)

Python is a very powerful and multi purpose tool. Image analysis, data analysis. Do you want to create your own software?
Do you want to manage your own hardware?
For who may want to learn Python or need help for a project I would gladly help you with that!

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.

Patrick

4.88

(85)

Do you need professional support for your quantitative data analysis?
I offer you a personalized service, adapted to your academic or professional needs.

Whether you are a student, researcher, consultant or professional, I put my expertise at your disposal to help you:
Prepare and organize your databases,
Perform reliable statistical analyses with R, Stata, SPSS...
Interpret your results rigorously,
Present your work in the form of clear reports, graphics and publications.
Each project is handled with rigor, pedagogy, and confidentiality. You benefit from tailored support, whether for a professional assignment, a dissertation, a thesis, or a publication.

For those who wish to train in parallel, I have also designed a complete course to learn how to explore, manipulate and analyze your data independently.

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

Ali

4.88

(85)

I offer one-to-one Programming tuition in Python, C, and C++, for GCSE Computer Science, A-Level Computing, and university students studying engineering, computer science, or related subjects. Lessons are available online or in person around Birmingham.

What I cover:

Python for beginners and intermediate learners
C and C++ programming
GCSE and A-Level Computer Science (all exam boards)
University coursework support, debugging help, and project guidance
Core concepts: variables, loops, functions, data structures, object-oriented programming, file handling, basic algorithms

How I teach:
I start by understanding exactly where you are — whether that's "I've never coded before" or "I'm stuck on a specific assignment." Then I build lessons around small, practical examples you can actually run and modify yourself. I'm patient with errors (everyone gets them), and I make sure you understand the why behind the code, not just how to copy it. For university students, I can also help with debugging, code reviews, and explaining tricky concepts in plain English.
If you or your child is preparing for exams, working on coursework, or just wants to finally feel comfortable with coding, I'd love to help.

Baia

4.88

(85)

I'm a working MEP engineer, currently building Python automation for Revit workflows daily - plan checks, model coordination, and repetitive drafting tasks. I teach other engineers, architects, and BIM professionals how to do the same, using pyRevit and real project workflows, not toy examples.

Topics include:
pyRevit fundamentals and setup
Automating repetitive Revit tasks (model checks, plan generation, data extraction)
Writing custom scripts for your firm's specific workflows
Applying Python automation to real MEP/BIM projects

Abdelrahman

4.88

(85)

This class covers university-level Computer Science and Engineering coursework across a wide range of topics, including Operating Systems, Databases, Software Engineering, Computer Organization, Data Structures & Algorithms, Discrete Mathematics, Computer Networks, and other core CS/CE subjects. Sessions are built around your specific course material, textbook, or exam syllabus, working through concepts, past exam questions, assignments, or project support depending on what you need. The focus is on connecting theory to how it's actually applied, so ideas are easier to retain and use — not just memorize for a test. Whether you need help catching up on a specific topic, preparing for an exam, or working through a course project, sessions are tailored to your goals.

Hiba

4.88

(85)

Level Up Your Coding Skills with Hands On Python Coaching!
From core syntax to advanced problem-solving, learn Python through a dynamic process tailored specifically to your goals. No matter your current level, we will enhance your expertise by building fun, real-world projects and solving interactive coding challenges.
Turn abstract logic into functional software while mastering the world's most versatile language.
Ready to transform your ideas into working code? Schedule your first session today!

Pallavi

4.88

(85)

Learn Python with a structured, hands-on approach! Whether you are a absolute beginner looking to start coding, a student needing help with coursework, or a professional aiming to automate tasks, these lessons are tailored for you.What we will cover:
Core Fundamentals: Variables, loops, functions, and data structures.Object-Oriented Programming: Building reusable and clean code.Real-World Projects: Creating scripts, data analysis, or web scraping based on your goals.

Problem Solving: Learning how to debug and think like a programmer. Lessons are highly interactive. We will write code together from day one, and you will receive practical exercises after every session to build your confidence.

Jebabli

4.88

(85)

As a senior computer science professor with over 19 years of experience, I offer courses tailored to students, beginners, and professionals. You will learn computer science, programming, SQL and NoSQL databases, as well as the main concepts of artificial intelligence. The courses are based on clear explanations, concrete examples, and practical exercises. The content is adapted to your level and objectives, whether you want to learn, prepare for an exam, complete a project, or improve your skills.

Nuria

4.88

(85)

Do you want to learn Artificial Intelligence from scratch or do you need support with a subject, practice or project related to AI?

The classes are online, one-on-one, and fully tailored to your level and goals. We can work from the fundamentals to practical applications using Python, generative AI tools, language models, and APIs.

We can work on content such as:

fundamentals of Artificial Intelligence;
Python applied to AI and data processing;
data preparation, cleaning and analysis;
NumPy, pandas and data visualization;
Introduction to Machine Learning;
classification, regression and model evaluation;
Generative AI and Language Models (LLM);
use of ChatGPT, Gemini and other AI tools;
design and improvement of prompts;
consumption of AI model APIs;
task automation using AI;
AI integration in applications;
search and work with information and documents;
development of small projects and prototypes;
internships, projects and exam preparation.

The goal is not only to learn how to use AI tools, but to understand how they work, when to use them, and how to practically integrate them into your own projects.

We can start from scratch, work on the syllabus of your subject, or develop a specific application or project step by step.

In addition to the classes, you will have access to our educational platform with its own documentation, exercises, examples, practices and other resources to continue working between sessions.

Additional information for the student

You can bring your own syllabus, practical exercises, data, or project. We will adapt the classes to your prior knowledge and the objective you want to achieve.

Sam

4.88

(85)

Learn Physics and Mathematics with a PhD physicist from ITA who is currently completing his third postdoctoral research appointment and has more than 15 years of teaching experience. Lessons can cover Physics, Mathematics, Calculus, Linear Algebra, Statistics and Python. I adapt the content and pace to each learner, whether the goal is to strengthen foundations, understand a difficult university topic, improve problem-solving skills, prepare for an assessment, or use mathematical and computational tools in scientific work. Lessons are available in native Portuguese or professional English for learners aged 16 to 65. My approach combines conceptual clarity, step-by-step reasoning, worked examples and guided practice so students learn to solve problems independently.