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

Àpd 221.19 CNY /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!

Lieu

En ligne depuis Allemagne

Présentation

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.

Expérience / Qualifications

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

Age

Enfants (7-12 ans)

Adolescents (13-17 ans)

Adultes (18-64 ans)

Seniors (65+ ans)

Niveau du Cours

Débutant

Intermédiaire

Avancé

Durée

60 minutes

Enseigné en

anglais

ourdou

hindi

Compétences

Mysql

Python

Microsoft excel

Disponibilité semaine type

(GMT -05:00)

New York

Cours par webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

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

221.19 CNY /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.

Matías

4.88

(84)

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.

Ahmed

4.88

(84)

Python is the programming language these days. It is simple, nice and almost all modern applications use it. With Python, we can now create artificial intelligence models that reduce human effort and give us more accurate and reliable results. The Java and C languages are not lacking in importance, they also make it possible to create applications optimized in terms of RAM.

The composition of the course depends on the level of the student and his own objectives. The first session is a one-hour evaluation session which allows the diagnosis of the level and the needs of the student. From this diagnosis we establish together a program that we will follow during our course.

Generally the course allows the student to assimilate:
* Predefined Data Types & Variables;
* Conditional Structures & Loops;
* Functions ;
* Object-oriented programming (OOP);
* Digital engineering;
* An introduction to databases (Examples and uses)
* Relational Algebra
* LDD, LCD, LMD, LCT
* SQL queries (SELECT, UPDATE, ...)
* Creation of a database and automation of queries using the Python language
* Handling files (TXT, Excel, CSV, JSON, Word);
* Data science;
* Introduction and some applications of Artificial Intelligence.

I am waiting for you to start this adventure.

Amin

4.88

(84)

By delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.

Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.

We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.

If you have any further questions, please do not hesitate to contact us.

Zakaria

4.88

(84)

This training adapts to your needs: Several durations and methods are offered.
The objective is to master the 3 office software of the Microsoft suite. You assimilate the essential knowledge to use Word, Excel and PowerPoint: models, style, layout, tabulations, lists, simple and advanced calculations, functions, pivot tables, design of clear and dynamic presentations, mastery of transitions and animations, etc.

Brahim

4.88

(84)

Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views

Giuliano

4.88

(84)

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

(84)

Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Francisco

4.88

(84)

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.

Zahr

4.88

(84)

Are you ready to take your Excel skills to the next level? Our personalized online classes are designed to meet your unique needs, whether you’re a beginner looking to learn the basics or an advanced user wanting to master complex functions.

What We Offer:

Tailored Learning: Customized lessons focused on your specific goals and areas of interest.

Flexible Scheduling: Learn at your own pace from the comfort of your home, at times that work for you.

Hands-On Practice: Engage in real-world projects and exercises to reinforce your skills.

Expert Guidance: Benefit from one-on-one instruction with experienced Excel professionals.

Join us today and become proficient in Excel! Sign up for your first class and start your journey toward mastering this essential tool.

Yassine

4.88

(84)

Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

Mohammed

4.88

(84)

Are you ready to become the tech-savvy problem-solver everyone turns to?

Join this dynamic, hands-on class designed to unlock your full potential across four essential pillars of the digital age:

🧮 Mathematics – Strengthen your logical thinking and problem-solving skills, the foundation of all great tech minds.

🐍 Python Programming – Learn to code smart, build real-world projects, and automate anything. Python makes it fun and powerful.

🌐 Networking – Understand how the internet works from the ground up. Routers, protocols, IPs – we’ll demystify them all.

🔐 Cybersecurity – Learn how hackers think, how to protect systems, and start your journey into ethical hacking.

Abdelhak

4.88

(84)

I offer Python courses suitable for all levels, from complete beginners to students wishing to deepen their knowledge.
The course may include:

Python Basics: Variables, Loops, Conditions, Functions

Algorithms and Problem Solving with Python

Practical projects to apply your knowledge

Tips and methodology for effective progress

The course is personalized according to your objectives, to allow you to develop concrete and directly usable skills in IT.

Armstrong

4.88

(84)

Ce cours de bureautique de niveau débutant est conçu pour toute personne souhaitant acquérir les compétences de base nécessaires à l’utilisation d’un ordinateur et des logiciels bureautiques les plus courants. Il s’adresse aux débutants ou aux utilisateurs ayant peu d’expérience en informatique. À l’issue de la formation, les apprenants seront capables d’utiliser efficacement un ordinateur dans un contexte personnel, scolaire ou professionnel

Dona

4.88

(84)

Découvrez les fondamentaux de l’IoT, les architectures typiques (capteurs, passerelles, cloud), les protocoles de communication et les enjeux de sécurité. Ce cours couvre des cas pratiques pour concevoir et déployer des solutions IoT simples et sécurisées.
Ce cours introduit l’Internet des Objets (IoT) et ses fondements. Vous explorerez les composants typiques d’un système IoT (capteurs, actuateurs, passerelles, cloud), les flux de données et les méthodes de communication. À travers des projets pratiques, vous apprendrez à concevoir des solutions IoT simples et sécurisées, à collecter et analyser des données, et à déployer des prototypes fonctionnels

Victoria

4.88

(84)

I offer private computer lessons regardless of your level.
With a bachelor's and master's degree in Computer Science, I have always enjoyed sharing my knowledge with my students. I help you solve your exercises, understand and apply the theory, and complete projects.