Relational databases (SQL under MySql DBMS)

Translated by GoogleSee original

From 23 € /h

Description:
This course is a comprehensive introduction to database management, including design, administration, and integration into applications.

Goals :

Understand relational models and the use of the SQL language.
Create and administer efficient and secure databases.
Integrating foundations into modern applications.
Course methods and format:

Video courses: Guided practice on tools like MySQL or PostgreSQL.
Flexibility: Exercises adapted to your specific projects.
For who ?
Students, developers or professionals wishing to master databases.

Location

Online from Morocco

About Me

Hello,

I have been passionate about computers for over 20 years. With two decades of teaching experience, I have had the privilege of supporting learners of all ages and levels in developing their computer skills and achieving their professional and personal goals.

Computer science is an essential skill today, opening the door to countless opportunities. Whether you want to learn programming, website design, data analysis, or complex problem-solving, I'm here to guide you every step of the way.

Education

PhD in Computer Science (Artificial Intelligence), Master in E-commerce, Python Certified, Adobe Certified, Microsoft Certified, Several Scientific Publications,

Experience / Qualifications

20 years of experience in computer teaching.
Proven methods suitable for all levels.
Personalized support to help you achieve your goals.
A passion for passing on skills that make a difference.

Age

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

90 minutes

The class is taught in

French

Arabic

English

Skills

Database

Sql

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

Cybersecurity, practical work, practice exams, etc.

23 € /h

1 Discover the pillars of Cybersecurity
2 Identify terminology related to Cybersecurity
3 Understand the different postures of Cybersecurity
4 Understanding the term Cybersecurity,
5 Identify Cybersecurity terminologies,
6 Know the tactics, techniques and procedures used by attackers,
7 Practical workshops

Web Programming Languages (HTML, CSS, JavaScript)

26 € /h

Description:
Get started with web development and learn how to create modern applications. This course takes you from the basics (HTML/CSS) to advanced concepts (security, APIs).

Goals :

Master HTML, CSS and JavaScript.
Understand the basics of authentication and web services.
Explore the concepts of security and load testing.
Course methods and format:

Video course: Creation of interactive mini-web projects.
Flexibility: Adapted to specific needs (beginner or advanced).
For who ?
Students, budding developers or professionals wishing to get started in the web.

Aniket

5.0

(3)

- B.tech and M.tech in Computer Science
- Worked as a Software engineer in Virtusa Corp & DIGIDEZ
- More than 6 years of teaching experience
- Oracle Certified Developer
- Helped students placed in FAANG

Featured Review :
Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!!

Thanks
Aniket

Salah

5.0

(3)

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.

Patrick

5.0

(3)

Do you need professional support for your data analysis and quantitative methods?

I offer personalized support in data analysis, statistics and quantitative methods**, tailored to your academic or professional needs.

Whether you are a student, doctoral candidate, researcher, consultant or professional, I offer my expertise to support you through the various stages of your project:

Database preparation, cleaning and organization**
Statistical analyses with R, Python, Stata and SPSS**
Statistical and econometric modeling**
Analysis and processing of questionnaires**
Creating dashboards and interactive visualizations with R Shiny and Power BI**
Rigorous interpretation of results**
Creation of charts, graphs and visualizations tailored to your results**
Support in the presentation and dissemination of analyses** in the form of reports, dissertations, theses or scientific publications

Support tailored to your project

Each assignment is carried out with **rigor, pedagogy, and confidentiality**. The objective is not only to obtain statistical results, but also to enable you to **understand the methods used, correctly interpret the results, and present them clearly and relevantly**.

I can intervene in the following areas:

🎓 Academic Projects
Dissertation • Thesis • Scientific article • Research project • Questionnaire analysis

💼 Professional projects
Quantitative studies • Data analysis • Modeling • Reporting • Dashboards • Visualization

Do you want to become self-sufficient in analyzing your data?

For those who wish to go further, I also offer a complete and progressive course enabling you to learn how to explore, manipulate, visualize and analyze your data independently.

Do you have a specific project or issue? Contact me, briefly describing your needs, data, and the tools you wish to use. Together, we can determine the most suitable support.

Yacine

5.0

(3)

Introduction to Databases

Learn about the importance of databases in the digital world, their role in managing and exploiting data, and the fundamental concepts of structured storage.
SQL for Beginners

Learn the basics of SQL: SELECT, INSERT, UPDATE, DELETE queries, joins, aggregate functions and more to effectively interact with a database.
MySQL and WAMP Server

Install and configure WAMP Server to create and manage MySQL databases locally. Learn how to use phpMyAdmin for easy management.
DBever and SQL Server

Introduction to professional database management tools: Get started with DBever and SQL Server to administer, analyze and optimize your databases.
Database Management and Operation

Learn best practices for database management: indexing, query optimization, data security and backup.
Database Administration

Understand the roles of a database administrator (DBA): user management, access rights, maintenance and performance monitoring.
Practical DBMS Project

Apply your knowledge to a real-world database management project, from design to deployment, optimization and administration.

Amin

5.0

(3)

Data skills can change your career, and you don't need to be a "math person" or have a technical background to learn them. If you can use a computer and you're curious, you can do this. In just 10 hours of one-to-one lessons, you'll go from "I don't know where to start" to analyzing real data on your own.

Maybe you're a student who needs to analyze data for a course or a thesis. Maybe you're looking for your first job in data, finance or business and want a skill that employers ask for. Maybe you already use Excel every day, but your reports take hours and you suspect there's a faster way. Or maybe you've never written a line of code and the idea feels intimidating. This class is built for all of you, and every lesson starts from where you are today.

I'm an engineer, and I work with data, statistics and programming (SQL, Python, R, Excel) every day. I don't teach theory for its own sake. I teach the way I use these tools in real work: you get a real question, a real dataset, and a clear method for turning one into the other.

In 10 hours, you will be able to:

Write SQL queries on your own. Select, filter, sort and group data, combine several tables with JOINs, and answer real questions such as "which product sold the most each month?"
Clean and analyze data in Excel. Use lookup formulas, conditional calculations and PivotTables, and build clear charts, instead of spending hours on manual work.
Build your first Power BI dashboard. Import data, clean it with Power Query, create interactive visuals, and share a report that looks professional.
Explain your results. Turn a business question into a query or a dashboard, check that your results make sense, and present them to someone who doesn't know the data.
Show a finished project. Leave with a portfolio-ready analysis you can use in an interview or in your thesis.

How the 10 hours are organized (we adapt this to your level and goal)

Hours 1-2: Foundations. We define your goal, check your level, and cover your first SQL queries (SELECT, WHERE, ORDER BY).
Hours 3-4: SQL in depth. Grouping and summarizing data, JOINs across tables, and cleaning messy data.
Hours 5-6: Excel for analysis. Advanced formulas, PivotTables, and charts.
Hours 7-8: Power BI. Importing and cleaning data, building visuals, and creating an interactive dashboard.
Hours 9-10: Your project. We put everything together on a realistic dataset (sales, finance, HR or your own data), and I give you feedback and a plan for what to practice next.

If you already know some Excel or SQL, we skip what you know and spend more time on what you need. If you want to go deeper later (for example advanced DAX, Python or statistics), we can continue from the same foundation.

How the lessons work

Every lesson is one-to-one and tailored to you. You practice on your own screen with my guidance, so you learn by doing rather than by watching. Between sessions I can give you short exercises if you want extra practice, and you can send me questions anytime. If you have your own files or work data (anonymized, of course), we can use them, which makes the learning much more relevant. Otherwise I provide practice datasets.

I explain in English or French (or Arabic if that's easier for you), and I'm patient. There are no silly questions. If something doesn't click, I'll explain it another way until it does.

Who this class is for

Students in business, economics, engineering, science or social sciences
Job seekers and career changers who want a first step into data analysis
Professionals who want to automate reports and work faster
Complete beginners. No previous experience with SQL or Power BI is needed.

Jude

5.0

(3)

My lessons are designed to take you from simply following code to genuinely understanding how data science works.

We can cover the complete data science process, including data cleaning, exploratory data analysis, feature engineering, visualisation, statistics, machine learning, model evaluation and communicating results.

Depending on your goals, lessons can include:

Python, pandas, NumPy and scikit-learn
Data cleaning and exploratory analysis
Regression and classification
Decision trees, random forests and boosting
Clustering and dimensionality reduction
Cross-validation and model evaluation
Feature engineering and model interpretation
Neural networks and deep learning foundations
Bayesian modelling and PyMC
Portfolio and interview preparation
Support understanding university modules and projects

I use diagrams, analogies and practical demonstrations to make difficult ideas easier to understand. We will normally begin with an intuitive explanation, look at the underlying logic or mathematics, and then implement the concept in Python.

Lessons are personalised around your level. Complete beginners receive a structured learning path, while experienced students can focus on advanced topics, project guidance, debugging or interview preparation.

You will be encouraged to explain ideas back to me, interpret results and make your own modelling decisions. My goal is not only to help you produce working code, but to help you become an independent and confident data scientist.

Jebabli

5.0

(3)

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

5.0

(3)

Are you studying DAM, DAW, ASIR, Computer Engineering or other technological training and need help with SQL or databases?

The classes are online, one-on-one, and fully tailored to your syllabus, level, and goals. We can start from scratch, prepare you for a subject or exam, help you with practice problems, work on a project, or delve deeper into more advanced topics.

We can work on content such as:

* database design and modeling;
* entity-relationship diagrams;
* relational model;
* standardization;
* creation and modification of tables;
* SQL queries;
* JOIN and relationships between tables;
* subqueries;
* aggregation and grouping functions;
* views;
* procedures and functions;
* triggers;
* transactions;
* PL/SQL;
* query optimization and debugging;
* Connecting databases to applications.

We can work with **MySQL, MariaDB, PostgreSQL, Oracle** and other database management systems depending on the technology you use in your subject or project.

My goal is not for you to memorize queries. We will work to help you learn to analyze what information you need, which tables are involved, how to relate them, and how to build the solution step by step.

We can also work on your own exercises, practices, databases or projects, as well as prepare exams and assignments for vocational training or university.

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

Mustafa

5.0

(3)

Data Mining Algorithms and Techniques Training Course - Beginner and Intermediate Level, for Computer Science Professionals and Non-Professionals.

The course content is titled: Advanced Analysis and Data Mining.
The book can be searched for using its name or the author's name.

Table of Contents

Chapter 1: Introduction to Advanced Analysis and Data Mining
1-1 What is data mining, its procedures and tools
1-2 What type of data is mined?
1-3 What are databases?
1-4 Relational Database
1-5 Query Language
1-6 Benefits of Database Mining
1-7 months data mining applications
A - Business Intelligence (Business Intelligence)
B - Internet search engines

Chapter Two: Data Recognition
2-1 Data Types, Characteristics, and Features
2-2 Statistical Description of Data
2-3 Visualization of Data
2-4 Measuring data similarity and difference
Chapter Three: Preparing Data for Analysis and Mining
3-1 The importance of preparing data for analysis and mining
3-2 Data Cleanup
3-3 Data Integration
3-4 Data Reduction
3-5 Data Transformation and Data Individualization

Chapter Four: Pattern Discovery and Exploration, Dependency and Correlation Rules
4-1 Basic Concepts
4-2 Shopping basket analysis (example)
4-3 Evaluating the dependency and correlation rules being explored
4-4 Mining Multi-Level Dependency and Linkage Rules
4-5 Mining multidimensional dependency and correlation rules
4-6 Rules of nominal and quantitative dependency and correlation
4-7 Exploring and identifying rare and negative patterns
4-8 Exploring and Determining the Rules of Dependency and Conditional Linkage
4-9 Evaluating dependency and correlation rules and distinguishing between useful and unhelpful ones
4-10 Measuring the type and strength of the relationship in dependency and correlation rules
4-11 Applications of pattern mining in practical life

Chapter Five: Analysis and Mining Using Classification and Prediction Algorithms
5-1 Basic Concepts
5-2 Classification using decision tree extrapolation
5-3 Classification using probability theory (hypothetical theory)
5-4 Classification using hypothetical network theory
5-5 Classification using correlation rules extrapolation
5-6 Classification using neural network algorithm
5-7 Classification using the nearest neighbor algorithm
5-8 Multi-category classification algorithms
5-9 Evaluating the efficiency and selection of classification algorithms

Chapter Six: Analysis and Mining Using Cluster Hashing Algorithms
6-1 Basic Concepts
6-2 Clustering by Division
6-3 Hierarchical Clustering
A. Hierarchical clustering
b. Hierarchical fission
6-4 Probability Clustering
6-5 High-Dimensional Clustering
6-6 Clustering of graphs and network data
6-7 Conditional Clustering
6-8 Cluster Segmentation Assessment

Chapter Seven: Analyzing and Mining Outliers and Complex Data Types
7-1 Basic Concepts
7-2 Types of extreme values
7-3 Ways to Explore Extreme Values
7-4 Complex Data Analysis and Mining

Chapter Eight: Planning Data Mining Operations and Their Applications in Society
8-1 Planning Data Mining Operations
8-2 Data Mining in the Community
8-3 Data mining applications in vital areas of society
8-4 Practical Application: Recommendation System Usage Scenario

Appendix 1: Database Fundamentals
Appendix 2: Data Warehouse Fundamentals
Appendix 3: Glossary of Data Mining Terms

Mayssa

5.0

(3)

I specialize in tutoring programming and software development, with a focus on Java, Spring Boot, Angular, SQL. My goal is to help students build a strong understanding of programming while keeping lessons practical, engaging, and appropriately challenging—not overwhelming. This class is designed for students and aspiring developers who want to strengthen their programming skills or start their journey in software engineering. We can work on programming fundamentals, web development, databases, APIs, backend and frontend development. I use practical examples and hands-on exercises to help you understand concepts and apply them to real-world projects.

Hadeer

5.0

(3)

Modern biological research relies heavily on computational tools to analyze complex genomic, transcriptomic, and proteomic data. This course offers practical, hands-on tutoring in bioinformatics for university students, researchers, and biological science professionals looking to gain strong computational and analytical skills.

Drawing on an extensive academic background in biological sciences and computational methodologies, I guide students through core computational workflows:
Sequence Alignment & Search: BLAST algorithms, multiple sequence alignment (Clustal Omega, MUSCLE), and pairwise alignment techniques.
Genomics & Transcriptomics: Next-Generation Sequencing (NGS) data processing, variant calling, and differential gene expression analysis.
Structural Bioinformatics: Protein structure prediction, molecular visualization (PyMOL, Chimera), and macromolecular interaction analysis.
Biological Databases & Programmatic Access: Extracting and parsing data from NCBI, UniProt, Ensembl, and PDB using Python/R scripting.
Phylogenetics & Systems Biology: Building phylogenetic trees, evolutionary distance calculations, and metabolic network modeling.

Sessions are tailored to your specific coursework, thesis project, or research needs, helping you transition seamlessly from raw biological data to meaningful biological insight.

Feel free to reach out with your project details or course outline to discuss how we can structure your lessons!

Ivana

5.0

(3)

I am an experienced computer science teacher with many years of teaching experience and a university degree in Mathematics and Computer Science.

I offer individual online lessons in programming and computer science for school students, as well as support for university students in selected subjects. Lessons can cover Python, MATLAB, SQL and databases, algorithms and programming fundamentals, computer systems, and web development with HTML, CSS and JavaScript.

My lessons are adapted to each student's previous knowledge, current curriculum and individual goals. I explain concepts step by step and focus on understanding the logic behind programming rather than simply memorizing code.

We can work on current school or university topics, programming exercises and assignments, fill gaps in knowledge, prepare for tests and exams, or develop practical programming skills.

Lessons are taught online in Serbian, Bosnian or Croatian, which can be particularly helpful for students from families from the former Yugoslavia who live and study in Germany, Austria, Switzerland or other countries.

Cedric

5.0

(3)

Do you want to learn SQL, better understand databases, or get support with your exercises and projects?
As a computer science teacher, I have taught databases at the university level. I offer progressive support tailored to each learner's level.
We can work on data modeling, relational databases, tables and relationships, primary and foreign keys, as well as SQL queries: SELECT, WHERE, JOIN, GROUP BY, subqueries and other concepts depending on your level.
The sessions emphasize practical application: explanation of concepts, concrete examples, exercises, and then problem-solving.
The course can also serve as support to understand a course, prepare for an assessment or progress on a personal or academic project.

Nourhan

5.0

(3)

Welcome! Whether you are a complete beginner or a university student aiming to strengthen your technical foundation, this course is tailored to help you master Python programming, database design, and SQL queries effectively.

In our sessions, we focus on hands-on practical learning rather than passive theory. Here is what we can cover:
• Python Programming fundamentals, data structures, and logic building.
• Relational Databases design, schemas, and ER diagrams.
• Writing clean, optimized SQL queries (SELECT, JOINs, aggregations, subqueries).
• Hands-on practice with real-world datasets and troubleshooting common errors.
• Assistance with university coursework, exam prep, and personal projects.

Lessons are tailored to your pace and goals, ensuring you build confidence in writing code independently. Feel free to reach out with any questions before booking!

Ana

5.0

(3)

Soy Ingeniera Informática por la Universidad Carlos III de Madrid y trabajo como Data Engineer, construyendo plataformas de datos en la nube con Snowflake y Azure. En mis clases aprenderás lo que de verdad se usa en el mundo profesional, explicado de forma clara y práctica.

Puedo ayudarte con:
- Programación desde cero: lógica, Python, Java o C
- Bases de datos y SQL, desde consultas básicas hasta nivel avanzado
- Análisis de datos, Excel y herramientas digitales
- Apoyo en asignaturas de Bachillerato, FP y universidad
- Orientación para quienes quieren reconvertirse al sector de datos

Cada clase se adapta a tu nivel y objetivos, con ejercicios y pequeños proyectos prácticos para que lo aprendido se quede. Doy clases en español e inglés (viví 4 años en EE. UU.).