Cours de SQL et bases de données – De la conception aux requêtes

From 48 C$ /h

Vous souhaitez apprendre SQL, mieux comprendre les bases de données ou être accompagné dans vos exercices et projets ?
Enseignant en informatique, j’ai notamment enseigné les bases de données dans l’enseignement supérieur. Je propose un accompagnement progressif et adapté au niveau de chaque apprenant.
Nous pouvons travailler sur la modélisation des données, les bases de données relationnelles, les tables et relations, les clés primaires et étrangères, ainsi que les requêtes SQL : SELECT, WHERE, JOIN, GROUP BY, sous-requêtes et autres notions selon votre niveau.
Les séances privilégient la pratique : explication des concepts, exemples concrets, exercices puis résolution de problèmes.
Le cours peut également servir d’accompagnement pour comprendre un cours, préparer une évaluation ou progresser sur un projet personnel ou académique.

Extra information

Un ordinateur portable est recommandé. Aucun prérequis n’est nécessaire pour débuter.

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Vilvoorde, Belgium

At teacher's location :

Goubloemstraat, Vilvoorde, Belgium

Online from Belgium

About Me

Enseignant en informatique depuis plusieurs années, j’aime avant tout rendre les notions complexes plus simples et accessibles. J’accorde beaucoup d’importance à la pratique, à la progression et au rythme de chaque apprenant.
Ma méthode consiste d’abord à identifier les besoins et les difficultés de l’élève, puis à expliquer les notions progressivement à l’aide d’exemples concrets et d’exercices adaptés.
J’ai enseigné à différents publics, notamment dans le secondaire et dans l’enseignement supérieur. Je peux accompagner aussi bien un élève qui rencontre des difficultés qu’un étudiant ou un adulte souhaitant développer de nouvelles compétences.
Mon objectif est que l’apprenant ne se contente pas de reproduire une solution, mais qu’il comprenne réellement ce qu’il fait et devienne progressivement autonome.

Education

Master en Sciences Informatiques – orientation Data Science
Université de Namur
Bachelier en Informatique de gestion
ISFCE(Institut Supérieur de Formation Continue d'Etterbeek), Bruxelles

Formation en informatique, programmation, bases de données, développement logiciel et analyse de données.

Experience / Qualifications

- Enseignement de l’informatique dans le secondaire
- Enseignement des bases de données dans l’enseignement supérieur
- Enseignement de l’informatique et de la bureautique
- Expérience en tutorat et accompagnement individualisé
- Expérience professionnelle en développement Full Stack

Compétences : Python, SQL, bases de données, programmation, analyse de données, développement Web et Microsoft Excel

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Duration

60 minutes

90 minutes

120 minutes

The class is taught in

English

French

Skills

Sql

Database

Computer science

Availability of a typical week

(GMT -04:00)

New York

At teacher's location and via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Cours de Python et programmation – Débutant à intermédiaire

48 C$ /h

Vous souhaitez apprendre Python, découvrir la programmation ou renforcer vos bases ?
Enseignant en informatique et titulaire d’un Master en Sciences Informatiques, orientation Data Science, je propose des cours adaptés à votre niveau et à vos objectifs.
Nous pouvons travailler notamment sur les bases de Python, les variables et types de données, les conditions, les boucles, les fonctions, les structures de données, les fichiers, ainsi que la résolution de problèmes et les premiers projets en Python.
Mon approche est avant tout pratique : j’explique les notions progressivement, avec des exemples simples, puis nous les appliquons à travers des exercices. Le contenu et le rythme sont adaptés aux difficultés et aux objectifs de chaque apprenant.
Les cours s’adressent aux débutants, étudiants ou adultes souhaitant apprendre Python ou consolider leurs connaissances en programmation.

Cours d’Excel – Du niveau débutant aux fonctions avancées

48 C$ /h

Vous souhaitez apprendre Excel, devenir plus autonome ou améliorer vos compétences pour vos études ou votre travail ?
Enseignant en informatique et bureautique, je propose des cours Excel adaptés à votre niveau et à vos objectifs.
Nous pouvons travailler sur la création et la mise en forme de tableaux, les formules et fonctions, les références relatives et absolues, les tris et filtres, les fonctions conditionnelles, la recherche de données, les graphiques, les tableaux croisés dynamiques et d’autres fonctionnalités selon vos besoins.
Les cours sont basés sur la pratique : nous travaillons directement sur des exercices et des situations concrètes afin que vous puissiez réutiliser les compétences acquises de manière autonome.
Les séances peuvent également être adaptées à un besoin professionnel, à un cours scolaire ou à la préparation d’une évaluation.

Renaud

5.0

(24)

Trainer for 10 years, I offer to support you in your learning of Photoshop software by working on concrete examples.

My experience as a trainer allowed me to sharpen my teaching techniques. I adapt to the level of the student to help him master the tools offered by this software.

Hela

5.0

(24)

I adapt my learning method according to subject and student. Some prefer to understand the whole theory before starting the exercises, others prefer to practice to better understand the theoretical part.
I strongly encourage the student because the state of mind and morale have a direct influence on school results.
I am an understandable person and I always try to take each one in his own way, to give remarks that facilitate the work, to give the tips and tricks necessary to have a good note.
I do exercises and exams corrected.
I always try to do my best to make the student fast able to handle his homework.

Himank

5.0

(24)

Currently, I am working at MaaS department in Denso Corporation, Shinagawa, Tokyo.
I have done my masters from the Indian Institute of Technology Hyderabad India recently.
I can teach you Mathematics and science in a simpler way as I have lived with those things for 10 years.

I can teach you coding, Science and Math if you wish to learn new things contact me.

This class is for those who really want to use to learn computer languages like C, C++ in a more innovative manner.

I little bit know Nihon-Go as well.

Robert

5.0

(24)

As a Franco-Belgian management teacher, I give Excel lessons with passion!
Whether remotely or face-to-face, I offer many examples and exercises to accompany you.
I travel without problem throughout the region of Brussels and its surroundings, for lessons of at least 2 hours. For France, courses are only given remotely.

Here are some key words that will be covered in my classes:
Scenario analysis, Year, Rounding, Today, Bdnb, Bdnbval, Bdsum, Search, Column, Copy/paste in values, Copy/paste with transposition, Consolidation, Date, Datedif, Determat, Dollar, Right, Righterg, Equiv, Esterror, Estna, Frequency, Filter (simple and advanced), Format of cells, Left, Large.Value, Printing of documents, Index, Indirect, Inversemat, Day, Weekday, Line, Matrix, Max, Maxa, Max.Si, Min , Mina, Mina.If, Formatting of cells and ranges, Month, Average, Average.If, Nb, Nb.If, Nbval, Naming of cells and ranges, No, Small.value, Product, Productmat, Protection of cells, Lookup (Lookup), Lookupv (VLookup), Lookuph (HLookup), If (If), If.Not.Disp, If.Conditions, Iferror, Sum, Sumproduct, Sum.If, Sum.If.Set, Substitute , Pivot tables, Sorting, Cell locking

Do not hesitate to contact me to organize your lessons according to your needs and availability. Together, we will develop your Excel skills in an efficient and personalized way.

Anas

5.0

(24)

I will help you master all the features of Microsoft Access software.

objectives:
---------------
Acquire the essential bases of Microsoft Access software.
Structure a relational database.
Define queries.
Build forms and reports.
Create simple macros.
Acquire a methodology to design and manage a database.

Whatever your basic level, I will adapt to it in order to help you progress.

Program
-------------------
Module 1: Presentation of Access software

Familiarize yourself with Access
Find your way around the screen: toolbar, status bar, menus, ruler
Methodology for building a database
Creation of a database and DBMS
Importing data from Excel into Access

***

Module 2: Design and organize your database

Organize and distribute your data between different tables
Create tables, define fields
Identify the index primary key
Define relationships, ensure referential integrity
Import, export and link data.

***

Module 3: Relationships

Link tables
The different types of relationships (one to one, one to many)
Referential integrity
Join types
Create a drop-down list
Complex relational schemas: relay tables, star schemas, etc.

***

Module 4: Query your database with queries

Selection queries: choice of fields, sort order, definition of selection criteria
Extract data by setting criteria
Grouping on a field, on an expression
Multitable and cross-analysis queries
Action requests: update, add, delete, create a table.

***

Module 5: Calculated queries

Column calculations
Online calculations: formula syntax, use the expression generator
Some calculation functions: (True false, Extraction of strings, Upper case, Lower case)

***

Module 6: Creating Forms and Entering Data

Create an instant form
Create an instant table form
Manage data: add, delete, modify, search, filter records
Modify the form
Subforms: creation, integration into a form
Editable drop-down lists.

***

Module 7: Creating Reports

Create a label report
Create a report using the wizard
Change state
Creation of column or tabular reports
Sorting and grouping
Direct mail report. Printing a report.

***

Module 8: Creating Complex Forms

Hierarchical organization of forms
Create a form and a subform
Insert action buttons: search list, command buttons
Insert calculations

Valnor

5.0

(24)

💻 Learn IT easily with tailor-made support! 🚀
Do you want to improve your computer skills or discover the basics to better navigate the digital world? I offer courses adapted to all levels, whether you are a beginner or looking to improve.
🌟 Why choose me?
• Adapted teaching: I explain concepts in a simple and clear manner, even for novices.
• Personalized courses: Each session is designed according to your needs and objectives.
• Hands-on learning: Immediately apply what you learn.
📘 Areas covered:
• Introduction to computers (using the computer, browsing the internet, security).
• Office software (Word, Excel, PowerPoint).
• Introduction to programming (Python, HTML/CSS).
• Basics of data management and analysis with tools like Power BI.
🕒 Flexible hours: Classes available on weekdays or weekends, depending on your schedule.
📍 Modalities: In person or online, according to your preferences.
👉 Contact me now to start your adventure in the digital world!

Salah

5.0

(24)

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.

Imane

5.0

(24)

Passionate about the world of programming, I offer courses suitable for beginners of all ages, including children. I am a computer engineer, also with experience in online tutoring with high school and university students, I guided them in understanding their homework and assimilating sometimes complex concepts. In addition, I had the privilege of introducing the basics of programming to young people through fun courses using Python and Scratch software. My goal is to make learning programming accessible, engaging and stimulating, thereby encouraging a lasting passion for this fascinating discipline.

Lionel

5.0

(24)

Always wanted to learn programming but you don't know where to begin? Discover Python programming today with tailor-made courses. Whether you have never programmed in your life, have some knowledge or already program professionally, I adapt my lessons to your needs.

- For beginners, the idea is to first introduce certain key programming concepts while applying these concepts to the Python language.
- For intermediate and advanced levels, we can deepen your knowledge or start a concrete project to fill your knwoledge gaps.

My goal with these courses is to pass on my passion for programming to you and to give you all the tools you need to launch into your projects!

My lessons are adapted to all ages

Mohamed

5.0

(24)

In this course, you will learn how to efficiently package, containerize, and deploy Python applications and microservices using Docker. The course covers fundamental Docker concepts, best practices for structuring Python projects, and strategies for building scalable and portable applications. Through hands-on projects, you will gain practical experience in creating Docker images, managing containers, and orchestrating microservices, enabling seamless deployment across different environments.

Contact me if you want to have more information about the course!

Abdou

5.0

(24)

Do you have a Python project to complete for your studies and you don't know where to start, or are you stuck in your code?
👉 I offer you fast, structured and results-oriented support to help you move forward effectively and succeed in your project.
🚀 What you will get:
Practical support for your university project (practical work, mini-project, dissertation, etc.)
A clear understanding of the code and logic used
Step-by-step solutions explained to help you progress quickly
Clean, structured and functional code
Greater autonomy for your future projects
🔍 My method:
Analysis of your topic and your needs
Breaking down the problem into simple steps
Clear explanations + direct practical application
Correction and improvement of your code
Tips to avoid common mistakes
👨‍💻 For whom?
Students in computer science or scientific fields
Students with projects or practical work in Python
Beginners or intermediates stuck on an exercise
Anyone with a project to finalize quickly
🎯 Objective:
👉 Helping you understand, correct and successfully complete your Python project effectively, while gaining autonomy
📩 Contact me now to move your project forward quickly and achieve concrete results

Hanae

5.0

(24)

Hello! My name is Hanae, and I offer personalized lessons in English, Mathematics, and Computer Science for students of all levels — from primary school to university.

With over 10 years of professional experience in the tech and business world, I combine structured methods with a friendly and supportive teaching style to help students gain confidence and achieve their goals.

👩‍💻 In Computer Science, I teach programming basics (C language), digital logic, and software tools such as Power BI, Excel, and SQL.

Whether you want to improve your grades, prepare for exams, or strengthen your practical skills, my lessons are designed to make learning clear, engaging, and motivating.

Lessons can be given online or in person, and I always adapt the pace and content to the student’s needs.

Frédéric

5.0

(24)

Microsoft Office is now a virtually indispensable software suite for almost everyone, whether during our school years, through PowerPoint presentations, document creation with MS Word, calculations and graph creation in MS Excel, or during our professional lives. In the latter case, we need to get even more out of it in a minimum amount of time.

Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.

The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.

The sky's the limit :))

Aymane

5.0

(24)

Programming courses for beginners and intermediate learners.
Learning computer logic, the basics of coding and putting it into practice with exercises and mini-projects.
Personalized support according to the student's level.
Opportunity to move towards web or mobile development with a concrete and practical approach.

Franki

5.0

(24)

In this course you will learn the basics to create your first IT projects from start to finish, from front-end to back-end. Each concept will be covered step by step.
We'll begin with an introduction and an overview of computer science to first deconstruct any limiting beliefs you may have about it. This will include an introduction to Python, then HTML, then CSS, then Java, then React, and finally SQL.
Depending on your age, the course will be adapted to cover concepts that are relatively simple for your brain to grasp. If you are a complete beginner or young, we will start with creating Python scripts, then building a calculator, and so on.
We can also touch on concepts such as AI if you wish. Learn to Vibe Code, understand how different models work, or learn how to create AI agents.