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
Skills:
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, MySQLData 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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from C$22.90At student's home
100% Satisfaction Guarantee
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
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
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
You are here
Similar classes
Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is WelcomeMaster 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 LearningDive 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, ElectronicsMathematics, 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 ScienceDé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 WeeksObjective: 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 regionNeed 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 subjectsAs 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 CourseTechnology 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 proVous ê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 productionFlutter 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.