facebook
    Mohamed
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from22.90CAD/ h

    Database (SQL Server, PostgreSQL, MySQL): From Fundamentals to Distributed Systems

    Translated by Google. Click to view original.
    Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.

    What You can Learn:
    - Fundamentals of relational databases and SQL syntax.
    - Designing robust databases using normalization and entity relationships.
    - Writing complex queries, joins, and subqueries.
    - Database optimization techniques for performance tuning.
    - Implementing stored procedures, triggers, and views.
    - Managing transactions and ensuring data integrity.
    - Understanding and working with distributed database systems like Distributed PostgreSQL

    Location

    At student's location: Around Brussels, Belgium

    |
    Use ⊞+wheel to zoom!
    +

    General info

    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:
    60 minutes
    The class is taught in:English, Dutch, Arabic

    About Me

    I am a dedicated software engineer with a Master's and Ph.D. in Computer Science from ULB University. With years of experience in both academia and industry, I specialize in helping students understand complex concepts in programming, algorithms, and software development. My teaching approach is student-centered, fostering critical thinking and problem-solving skills tailored to individual learning styles.

    Whether you are a beginner looking to write your first line of code or an advanced learner diving into data structures, machine learning, or system design, I am here to guide you every step of the way.

    Education

    - PhD in computer Science from the Université Libre de Bruxelles (ULB), Brussels, Belgium
    - Specialized in Big Data Management, Geographical Data Management, Databases, DevOps automation tools.

    Experience / Qualifications

    Database: SQL Server, PostgreSQL, MySQL
    Data Science and Data Engineering tools: Python, GenAI, Data Lake, DBT, Airflow
    Big Data tools: Hadoop, Spark
    Cloud: AWS and Azure Services
    DevOps tools: CI/CD pipelines, GitHub, Docker, Kubernetes,
    Whether you are a beginner writing your first lines of code or an advanced learner tackling complex concepts, I tailor lessons to suit your needs. Together, we will focus on practical skills, problem-solving, and real-world projects to make programming intuitive and rewarding. Let's work together to turn your goals into achievements!
    Dive into the world of Python, one of the most powerful programming languages for Data Engineers and Data scientists. With hands-on projects, real-world examples, and engaging lessons, you'll not only learn the fundamentals of Python but also gain the confidence to tackle complex programming challenges.

    Ask a question

    Send a message explaining your needs and Mohamed will reply soon:
    The more detail, the better.
    Ex. "Hi, when are you available to meet for a lesson?"

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2              
    3              
    4            Saturday at 4:00  Sunday at 4:00
    5            Saturday at 5:00  Sunday at 5:00
    6            Saturday at 6:00  Sunday at 6:00
    7            Saturday at 7:00  Sunday at 7:00
    8            Saturday at 8:00  Sunday at 8:00
    9            Saturday at 9:00  Sunday at 9:00
    10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
    11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
    16              
    17              
    18              
    19              
    20              
    21              
    22              
    23              
    from C$22.90At student's home

    Good-fit Instructor Guarantee


    If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

    Online reputation

    • Instructor since December 2024
    • Phone number verified
    • Google connected

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2              
    3              
    4            Saturday at 4:00  Sunday at 4:00
    5            Saturday at 5:00  Sunday at 5:00
    6            Saturday at 6:00  Sunday at 6:00
    7            Saturday at 7:00  Sunday at 7:00
    8            Saturday at 8:00  Sunday at 8:00
    9            Saturday at 9:00  Sunday at 9:00
    10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
    11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
    16              
    17              
    18              
    19              
    20              
    21              
    22              
    23              
    from C$22.90At student's home

    Good-fit Instructor Guarantee


    If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

    Share


    Salah Eddine
    Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is Welcome
    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.

    Ihor
    Mastering Software Engineering: Personalized, Practical, and Interactive Learning
    Dive into the world of software engineering with a tutor and mentor boasting 3+ years of professional experience and AWS Certified Cloud Practitioner credentials. This class offers a personalized approach tailored to your unique learning style, providing practical, hands-on exercises and interactive lessons. Whether you're a beginner or looking to refine your skills, you'll gain real-world insights, learn best practices, and build confidence to excel in software development and cloud technologies. Unlock your potential with expert guidance in an engaging, supportive environment.

    Mohammad Ait
    Mathematics, Electrical engineering, Computer science, Electronics
    Mathematics, Electrical Engineering, and Computer Science are powerful disciplines for problem solvers and innovators. As a learner, you'll need to master their interconnected concepts to solve real-world problems and build groundbreaking solutions. This course is meticulously crafted as a comprehensive guide to these fields, tailored to equip you with practical knowledge and skills. You'll explore advanced mathematical techniques, delve into the core principles of electrical engineering, and harness the power of computer science. From solving complex equations and designing circuits to developing algorithms and understanding computational systems, this course empowers you not only to enhance your technical skills but also to create innovative solutions that transform industries

    Hamza
    Maîtrisez Python avec un Expert en Programmation et Data Science
    Découvrez la puissance de Python avec un formateur expérimenté en informatique ! Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel. Ce que vous apprendrez : Fondamentaux de Python (variables, structures de contrôle, fonctions) Programmation orientée objet avancée Analyse et visualisation de données avec pandas et matplotlib Développement d'interfaces graphiques avec PyQt Projets pratiques inspirés de cas réels en entreprise Pourquoi me choisir ? Plus de 5 ans d'expérience en formation et mentorat Méthode pédagogique adaptée à tous les niveaux Approche hands-on basée sur des projets concrets Passion contagieuse pour le code et l'innovation technologique Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science. Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché ! Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !

    Robert
    Excel lessons, at your place, at my place or remotely, at your best convenience!
    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.

    Martial
    Graduate teacher gives courses in Physics & Chemistry, Mathematics, many years of experience.
    I am a dynamic and demanding teacher who gives private lessons in Physics-Chemistry as well as Mathematics. I graduated from teaching seven years ago, after a masters in physical sciences with honors, and I teach in college and high school since. I have also been preparing students for the Baccalaureate Science for many years, all of whom have been awarded very good honors. I also prepare my students for different exams (Matu, Bac, preparation for EPFL, etc...) I make sure to rework the basics so that the student can progress quickly. It is important to me that my students acquire a solid foundation of knowledge. I also give effective work methods that will allow him to progress much more quickly and so he can regain self-confidence. I can go to the student's home or also take the course via Skype.

    Dr Zeeshan
    Ethical Hacking and Penetration Testing in 4 Weeks
    Objective: Equip students with foundational skills in ethical hacking and penetration testing to secure web applications, focusing on open-source tools and DVWA (Damn Vulnerable Web Application). (Capstone Project: Website Penetration Testing Report) Throughout the weeks, students will work on a capstone project where they will perform a comprehensive penetration test on a simulated website using DVWA. They will document their findings, create detailed reports, and suggest mitigation strategies. This project will be their portfolio piece to showcase their skills. 1. Week 1: Introduction to Information Security - Topics covered: Cybersecurity Fundamentals, Introduction to Ethical Hacking, Basic Network Security, Introduction to Cryptography, Practical Cybersecurity Tips 2. Week 2: Introduction to Ethical Hacking - Topics covered: Orientation and Course Overview, Setting Up a Virtual Lab, Key Tools and Software, Network Security Basics, Identifying Common Vulnerabilities, Exploring common network vulnerabilities, Hands-on practice with vulnerability scanning using OpenVAS. 3. Week 3: Website Penetration Testing Fundamentals with DVWA - Topics covered: Website Architecture, Overview of how websites function, Introduction to client-server model and HTTP/HTTPS, Setting Up DVWA, Installing and configuring DVWA, Understanding the purpose and use of DVWA in penetration testing, SQL Injection with DVWA, Understanding SQL injection attacks, Practicing SQL injection techniques and defences using DVWA, Cross-Site Scripting (XSS) with DVWA, Understanding XSS attacks, Practising XSS techniques and defences using DVWA, Hands-on OWASP Top 10 with DVWA, Detailed exploration of the OWASP Top 10 vulnerabilities, Practical exercises to identify and exploit vulnerabilities using DVWA 4. Week 4: Advanced Penetration Testing Techniques - Topics covered: Advanced Exploitation Techniques, Techniques for privilege escalation, Using Metasploit for advanced exploitation, Social Engineering Attack, Understanding social engineering, Practical examples of phishing and other attacks, Reporting and Documenting Findings, Importance of documentation in penetration testing, How to create detailed and professional reports, Ethical Considerations and Legal Aspects, Understanding the ethics of hacking, Legal implications and compliance, Project Presentation and Feedback, Students present their penetration testing report, Personalized feedback and improvement tips. --- At the end of the 4 weeks, • Students will have beginner-to-advanced knowledge about ethical hacking and penetration testing using open-source tools and DVWA. • Students will have enhanced professional writing skills, and technical documentation skills along with research skills. • Students will have a capstone project which will serve as a significant portfolio piece, demonstrating their practical skills and readiness for the cybersecurity job market

    Antonin
    Experienced teacher in private lessons gives private lessons in the Geneva region
    Need a catch-up, tutoring, private lessons or help with homework in mathematics? In computer science ? In logic? I'm here for you! I offer you a personalized approach; because there is no one method that works for everyone, I adapt to the needs and requests of each student (and their parents). The first hour of class will be used to define the student's needs, deadlines and strengths. My courses are aimed at secondary school students of all levels, higher education students and anyone wishing to refresh or strengthen their knowledge of mathematics and computer science. I have been helping friends and acquaintances on a voluntary basis for a long time in the success of their studies and I hope to be able to put this experience to the benefit of your success :)

    Paul
    I am a teacher of mathematics and I give extra hours for private lessons in science subjects
    As a math teacher, I offer private lessons in science subjects. My classes are mainly aimed at cycle and college students in Geneva, as well as students from private schools. I can also help people who have already finished their schooling but who need to upgrade their knowledge for professional needs. I am generally available within 3 days of your request and I move around the canton of Geneva using public transport (TPG). Travel costs are included in my rates. For a long-term follow-up, I can give you exercises to do between sessions and correct them at home. I speak and understand English, but my lessons will be mainly in French. I am ready to adapt my teaching according to your specific needs and to provide personalized support to help you progress in scientific subjects. Do not hesitate to contact me if you have additional questions or if you wish to schedule a lesson session. I will be happy to help you in your math learning.

    Mahmood
    Basic IT and computer knowledge / Basic Computer Course
    Technology is advancing at a rapid pace, and we rely more and more on computers for everything from cooking to organizing our taxes. An understanding of computer basics is compulsory nowadays. The goal of this course is to give you a solid foundation on basic IT and computer knowledge. Once you understood these basics, you will have a clear understanding on which to build your future knowledge of an skill with computers and the Internet. COURSE OUTLINES: KNOWING COMPUTER - Introduction and objectives - What is Computer? - Components of Computer system - Concept of Hardware and Software - Concept of computing, data and information - Applications of IECT - Bringing computer to life OPERATING COMPUTER USING GUI BASED OPERATING SYSTEM - Introduction and objectives - Basics of Operating System - The User Interface - Operating System Simple Setting - File and Directory Management UNDERSTANDING WORD PROCESSING - Introduction and objectives - Word processing Basics - Opening and closing Documents - Text Creation and manipulation - Formatting the Text - Table manipulation USING SPREAD SHEET - Introduction and objectives - Elements of Electronic Spread sheet - Manipulation of Cells - Formulas and Function INTRODUCTION TO INTERNET, WWW AND WEB BROWSERS - Introduction and objectives - Basic of Computer Networks - Internet - World Wide Web (WWW) - Web Browsing Softwares - Search Engines - Understanding URL - Surfing the web COMMUNICATIONS AND COLLABORATION - Introduction and objectives - Basics of E-mail - Using E-mails - Document collaboration - Instant Messaging and Collaboration MAKING SMALL PRESENTATIONS - Introduction and objectives - Basics of Making small Presentations - Creation of presentation - Preparation of slides - Presentation of slides - Slide show FINANCIAL LITERACY FOR BANKING SCHEME AND APPLICATIONS - Introduction and objectives - Why Savings are needed? - Drawbacks of keeping cash at home - Why Bank is needed? - Banking products - Banking Service Delivery Channels - Various Schemes - Bank on your mobile - Insurance

    Mouad
    Support course in Python (For all levels, CPGE)
    Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career. Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.

    Azzedine
    Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données pro
    Vous êtes impliqué dans les finances, la gestion, la planification, la gestion de projet, les ressources humaines, ou peut-être même un étudiant ambitieux désireux de perfectionner ses compétences en matière de tableau de bord professionnel. Si vous recherchez une solution qui va au-delà des limitations d'Excel et de PowerPoint, alors vous êtes au bon endroit : permettez moi de vous présenter Power BI. Avec Power BI, je vous propose bien plus qu'un simple outil. C'est une passerelle vers des rapports interactifs, une gestion efficace des données et une analyse avancée. Voici ce que je peux vous offrir : - Création et gestion experte de rapports interactifs. - Transformation et nettoyage minutieux des données pour une précision maximale. - Utilisation des puissantes formules DAX pour une analyse de données avancée. - Création de visualisations personnalisées et de tableaux de bord percutants. - Partage sécurisé et publication de vos rapports pour une collaboration sans heurts. -Automatisation des tâches répétitives avec Power BI & Power Query. Peu importe vos besoins spécifiques - qu'il s'agisse de projets professionnels, d'études ou d'aspirations personnelles - je suis là pour vous offrir une solution sur mesure. Ensemble, nous créerons un programme adapté à vos objectifs, vous guidant à chaque étape de votre parcours d'apprentissage. Que vous soyez un novice cherchant à maîtriser les bases ou un expert désireux d'approfondir vos connaissances en analyse de données, je suis là pour vous fournir l'expertise et le soutien nécessaires pour réussir.

    Younes
    Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!
    With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible. Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning. As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.

    Pierre-Hadrien
    Experienced tutor from EPFL to help with programming projects (Java, C, Python, Scala, VHDL)
    This course is intended for people who need help with their programming, academic or personal projects. I can easily help you develop a project in Java, C, Python, Scala, VHDL, having carried out many of them myself and helped a certain number of students to carry out theirs. I help in particular with the realization of projects from programming courses in the EPFL and UNIL programs, having followed and taught them myself, so I know the program well. I have been programming since I was 14 and have created several projects, from high school to graduate school. This course is therefore intended for all levels, for people wishing to start but also for middle school or high school graduates needing help in their courses. I have already taught programming and project monitoring courses in Java and would be happy to help you achieve your goal, adapting to the level and pace / pedagogy needed by anyone. Classes take place mainly at my home or on the EPFL campus, I can also travel by public transport to your home.

    Jean-Baptiste
    Learn to develop a complete mobile app on iOS and Android ready for production
    Flutter is the mobile app development framework from Google, based on Dart. You will learn: - How to develop a mobile app from scratch on iOS and Android - How the use Riverpod, the best state management system - How to use Google Firebase (Authentication, Firestore, Cloud Functions, Cloud messaging, ...) - Testing automation I'm a software engineer with 4 years of experience coding with Flutter and more than 10 years working for IT companies.