SQL and Database Course – From Design to Queries - Vilvoorde

Translated by GoogleSee original

SQL and Database Course – From Design to Queries

From 48 C$ /h

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.

Extra information

A laptop is recommended. No prior knowledge is required to get started.

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

Excel Course – From Beginner Level to Advanced Functions

48 C$ /h

Do you want to learn Excel, become more independent, or improve your skills for your studies or work?
As a computer and office skills teacher, I offer Excel courses tailored to your level and objectives.
We can work on creating and formatting tables, formulas and functions, relative and absolute references, sorting and filtering, conditional functions, data searching, charts, pivot tables and other features as needed.
The courses are practice-based: we work directly on exercises and concrete situations so that you can reuse the skills acquired independently.
The sessions can also be adapted to a professional need, a school course or the preparation for an assessment.

Python and programming course – Beginner to intermediate

48 C$ /h

Do you want to learn Python, discover programming, or strengthen your basic skills?
As a computer science teacher with a Master's degree in Computer Science, specializing in Data Science, I offer courses tailored to your level and objectives.
We can work specifically on the basics of Python, variables and data types, conditions, loops, functions, data structures, files, as well as problem-solving and first projects in Python.
My approach is primarily practical: I explain concepts gradually, with simple examples, and then we apply them through exercises. The content and pace are tailored to each learner's difficulties and objectives.
The courses are aimed at beginners, students or adults wishing to learn Python or consolidate their programming knowledge.

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!

Antonios

5.0

(24)

Python is not just another programming language.
It's a tool that empowers its users to innovate, analyze, and solve complex problems, making it one of the most sought-after skills in today's digital age.

As an Electrical & Computer Engineer with a Master's in Artificial Intelligence, I have an in-depth understanding of both the theoretical and practical aspects of computer science & programming.

Whether you're a curious child eager to grasp the basics or an adult aiming to dive deep into advanced concepts, I am equipped and enthusiastic to guide you on this enlightening journey!

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!

Abderrahim

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.