facebook
favorite button
super instructor icon
Trusted teacher
This teacher has a fast response time and rate, demonstrating a high quality of service to their students.
member since icon
Since September 2022
Instructor since September 2022
Databases management systems - conceptual - logical design
course price icon
From 38.12 € /h
arrow icon
Learn about:
- Normalization
- Relation data model and its nested relations
- SQL Language, scripts and others
- Dynamic SQL
- Security and User authorization
- Object oriented data model
- Functional dependencies
- Different type of data model, such as Datalog
Extra information
Student laptop required
Location
location type icon
Online from Canada
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
French
Spanish
German
Availability of a typical week
(GMT -05:00)
New York
at teacher icon
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Similar classes
arrow icon previousarrow icon next
verified badge
Oussama
Your project is broken? Deadline approaching? Can't deploy? I help developers and students fix bugs, optimize code, and deploy applications to production.
I Specialize In:

Emergency Debugging: Find and fix errors fast (frontend crashes, backend timeouts, database issues)
Deployment Rescue: Get your app live when nothing works (AWS, Vercel, Netlify)
Performance Optimization: Speed up slow applications (database queries, API responses, bundle size)
CI/CD Setup: Automate your deployment pipeline (GitHub Actions, testing, monitoring)

Common Problems I Solve:

❌ "My app works locally but crashes in production"
❌ "Database queries are too slow"
❌ "Authentication isn't working"
❌ "Can't deploy to AWS / Vercel"
❌ "Getting weird errors I don't understand"
❌ "Payment integration (Stripe) not working"

Technologies I Work With:

Frontend: React, Next.js, TypeScript, Vue, Angular
Backend: Node.js, NestJS, Express, Python (Django, Flask)
Databases: PostgreSQL, MySQL, MongoDB, Redis
Cloud: AWS (EC2, RDS, S3), Vercel, Netlify, Render
DevOps: Docker, CI/CD, GitHub Actions, Nginx

Perfect For:

Students: Fix your project before the deadline
Junior Developers: Debug production issues you can't solve alone
Freelancers: Get unstuck on client projects fast
Startups: Fix and deploy your MVP without hiring a full-time engineer

How It Works:

Live Debugging Session: We fix it together via screen share
Code Review: I show you how to prevent the issue in the future
Documentation: You get a summary of what was fixed and why

Average Resolution Time:

Simple bugs: 1-2 hours
Deployment issues: 2-3 hours
Complex debugging: 3-5 hours

Urgent projects accepted (same-day availability for emergencies).
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
verified badge
Francisco
Hi!

Welcome to my class on Python programming! As a PhD student in Geophysics my main tool is my computer. In order to do science one needs to know how to program. I use Python everyday in order to analyze data, run numerical models, plot results and much more. So, let's embark on the journey of learning Python and explore its diverse capabilities together!

For beginners:
I have designed it for absolute beginners to become at ease with the language within 5 sessions of 1h. Message me to know the 5 classes curriculum and I will be more than happy to share it with you!

For intermediate users:
If you already know the basics of Python but want to go more in-depth on certain packages this is the right place! Message me and we can discuss what your needs are! I am a professional user of Numpy, Pandas, Matplotlib, os, scipy and many more packages!

Are you not sure Python is the right language for you? Check the following out and let me know if you have any questions!

First of all, what is Python? According to its creator, Guido van Rossum, Python is a:

“high-level programming language, and its core design philosophy is all about code readability and a syntax which allows programmers to express concepts in a few lines of code.”

Learning Python is a rewarding experience for several reasons. Firstly, Python is inherently beautiful as a programming language, offering a natural and expressive way to translate your thoughts into code. Its readability and simplicity make coding an enjoyable and intuitive process.

The Python language finds applications across various domains, including data science, web development, machine learning and AI. For example, platforms like Quora, Pinterest, and Spotify leverage Python for their backend web development!

This versatility makes Python a powerful tool for those eager to delve into different aspects of programming. If this caught your curiosity message me and I'll make you a Python hero! Welcome to the community!
verified badge
Ahmed
Hello, My name is Ahmed & I'm working as a TA in Ain Shams University.
I am available for assignments, Homeworks, exams, quizzes, projects, and labs.

Expert Programming & Web Development Tutor | Python, Java, C#, C++, Frontend, Backend, Databases, AI & Data Science

💻 Programming Languages:
✔ Programming: C, C++, Java, Python, PHP, JavaScript, HTML
✔ Mathematics: Linear Algebra, Calculus, Discrete Math, Probability, Optimization
✔ Object-Oriented Programming (OOP): Encapsulation, Polymorphism, Inheritance, Abstraction, Design Patterns
✔ Machine Learning: Neural Networks, Regression, Classification, Clustering, Reinforcement Learning
✔ Data Structures & Algorithms (DSA): Trees, Graphs, Linked Lists, Stacks, Queues, Priority Queues, Hash Tables, Tries, Heaps, Disjoint Sets, Sorting Algorithms (Merge Sort, Quick Sort, Heap Sort, etc.), Searching Algorithms (Binary Search, Linear Search), Dynamic Programming, Greedy Algorithms, Divide & Conquer, Backtracking, Topological Sort, Graph Traversals (BFS, DFS), Minimum Spanning Tree (Prim’s, Kruskal’s), Shortest Path Algorithms (Dijkstra’s, Bellman-Ford, Floyd-Warshall), String Algorithms (KMP, Rabin-Karp, Z-Algorithm), and more!
✔ Assignments, Homework, Labs, Projects, Exams, or Quizzes

🌐 Web Development:
Frontend – HTML, CSS, JavaScript, React, Laravel
Backend – .NET, PHP, Flask, Django

🗄️ Databases:
SQL, MongoDB

🧠 AI & Data Science:
Python for Data Science, Machine Learning, Pandas, NumPy, Data Visualization

✅ What You’ll Get:
Personalized one-on-one sessions
Clear explanations with real-world examples
Hands-on coding practice
Help with assignments, projects, and interview prep
A focus on understanding, not memorizing
No matter your level, I make learning tech engaging and effective. Let’s turn your goals into achievements—one line of code at a time!
message icon
Contact Ecile
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Oussama
Your project is broken? Deadline approaching? Can't deploy? I help developers and students fix bugs, optimize code, and deploy applications to production.
I Specialize In:

Emergency Debugging: Find and fix errors fast (frontend crashes, backend timeouts, database issues)
Deployment Rescue: Get your app live when nothing works (AWS, Vercel, Netlify)
Performance Optimization: Speed up slow applications (database queries, API responses, bundle size)
CI/CD Setup: Automate your deployment pipeline (GitHub Actions, testing, monitoring)

Common Problems I Solve:

❌ "My app works locally but crashes in production"
❌ "Database queries are too slow"
❌ "Authentication isn't working"
❌ "Can't deploy to AWS / Vercel"
❌ "Getting weird errors I don't understand"
❌ "Payment integration (Stripe) not working"

Technologies I Work With:

Frontend: React, Next.js, TypeScript, Vue, Angular
Backend: Node.js, NestJS, Express, Python (Django, Flask)
Databases: PostgreSQL, MySQL, MongoDB, Redis
Cloud: AWS (EC2, RDS, S3), Vercel, Netlify, Render
DevOps: Docker, CI/CD, GitHub Actions, Nginx

Perfect For:

Students: Fix your project before the deadline
Junior Developers: Debug production issues you can't solve alone
Freelancers: Get unstuck on client projects fast
Startups: Fix and deploy your MVP without hiring a full-time engineer

How It Works:

Live Debugging Session: We fix it together via screen share
Code Review: I show you how to prevent the issue in the future
Documentation: You get a summary of what was fixed and why

Average Resolution Time:

Simple bugs: 1-2 hours
Deployment issues: 2-3 hours
Complex debugging: 3-5 hours

Urgent projects accepted (same-day availability for emergencies).
verified badge
Brahim
Module 1: SQL Overview
Outlining SQL as the cornerstone of database activity
Applying the ANSI/ISO standards
Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys

Module 2: Building the Database Schema
- Creating tables and columns
Building tables with CREATE TABLE
Modifying table structure with ALTER TABLE
Adding columns to an existing table
Removing tables with DROP TABLE

- Protecting data integrity with constraints
Guaranteeing uniqueness with primary key constraints
Enforcing integrity with foreign key constraints
Imposing business rules with check constraints

- Improving performance with indexes
Expediting data retrieval with indexes
Recommending guidelines for index creation

Module 3: Manipulating Data
- Modifying table contents
Adding table rows with INSERT
Changing row content with UPDATE
Removing rows with DELETE

- Applying transactions
Controlling transactions with COMMIT and ROLLBACK
Deploying BEGIN TRANSACTION in SQL Server

Module 4: Working with the SELECT Statement
- Writing Single Table queries
Retrieving data with SELECT
Specifying column expressions
Sorting the result with ORDER BY
Handling NULL values in expressions

- Restricting rows with the WHERE filter
Testing for equality or inequality
Applying wildcard characters
Avoiding NULL value pitfalls

Module 5: Querying Multiple Tables
- Applying the ANSI/ISO standard join syntax
Matching related rows with INNER JOIN
Including nonmatched rows with OUTER JOIN
Creating a Cartesian product with CROSS JOIN

- Combining results with set operators
Stacking results with UNION
Identifying matching rows with INTERSECT
Utilizing EXCEPT to find nonmatching rows

Module 6: Employing Functions in Data Retrieval
- Processing data with row functions
Conditional formatting with the CASE expression
Utilizing the CASE expression to simulate IF tests
Dealing with NULL values

- Performing analysis with aggregate functions
Summarizing data using SUM, AVG and COUNT
Finding the highest/lowest values with MAX and MIN
Defining the summary level with GROUP BY
Applying filter conditions with HAVING

Module 7: Constructing Nested Queries
- Applying subqueries in filter conditions
Creating correlated vs. noncorrelated subqueries
Testing the existence of rows

- Including subqueries in expressions
Placing subqueries in the column list
Creating complex expressions containing subqueries
Handling subqueries that return no rows

Module 8: Developing In-Line and Stored Views
- Breaking down complex problems
Selecting data from a query result set
Using subqueries in the FROM clause

- Creating views in a database
Building reusable code
Creating updateable vs. non-updateable views
verified badge
Francisco
Hi!

Welcome to my class on Python programming! As a PhD student in Geophysics my main tool is my computer. In order to do science one needs to know how to program. I use Python everyday in order to analyze data, run numerical models, plot results and much more. So, let's embark on the journey of learning Python and explore its diverse capabilities together!

For beginners:
I have designed it for absolute beginners to become at ease with the language within 5 sessions of 1h. Message me to know the 5 classes curriculum and I will be more than happy to share it with you!

For intermediate users:
If you already know the basics of Python but want to go more in-depth on certain packages this is the right place! Message me and we can discuss what your needs are! I am a professional user of Numpy, Pandas, Matplotlib, os, scipy and many more packages!

Are you not sure Python is the right language for you? Check the following out and let me know if you have any questions!

First of all, what is Python? According to its creator, Guido van Rossum, Python is a:

“high-level programming language, and its core design philosophy is all about code readability and a syntax which allows programmers to express concepts in a few lines of code.”

Learning Python is a rewarding experience for several reasons. Firstly, Python is inherently beautiful as a programming language, offering a natural and expressive way to translate your thoughts into code. Its readability and simplicity make coding an enjoyable and intuitive process.

The Python language finds applications across various domains, including data science, web development, machine learning and AI. For example, platforms like Quora, Pinterest, and Spotify leverage Python for their backend web development!

This versatility makes Python a powerful tool for those eager to delve into different aspects of programming. If this caught your curiosity message me and I'll make you a Python hero! Welcome to the community!
verified badge
Ahmed
Hello, My name is Ahmed & I'm working as a TA in Ain Shams University.
I am available for assignments, Homeworks, exams, quizzes, projects, and labs.

Expert Programming & Web Development Tutor | Python, Java, C#, C++, Frontend, Backend, Databases, AI & Data Science

💻 Programming Languages:
✔ Programming: C, C++, Java, Python, PHP, JavaScript, HTML
✔ Mathematics: Linear Algebra, Calculus, Discrete Math, Probability, Optimization
✔ Object-Oriented Programming (OOP): Encapsulation, Polymorphism, Inheritance, Abstraction, Design Patterns
✔ Machine Learning: Neural Networks, Regression, Classification, Clustering, Reinforcement Learning
✔ Data Structures & Algorithms (DSA): Trees, Graphs, Linked Lists, Stacks, Queues, Priority Queues, Hash Tables, Tries, Heaps, Disjoint Sets, Sorting Algorithms (Merge Sort, Quick Sort, Heap Sort, etc.), Searching Algorithms (Binary Search, Linear Search), Dynamic Programming, Greedy Algorithms, Divide & Conquer, Backtracking, Topological Sort, Graph Traversals (BFS, DFS), Minimum Spanning Tree (Prim’s, Kruskal’s), Shortest Path Algorithms (Dijkstra’s, Bellman-Ford, Floyd-Warshall), String Algorithms (KMP, Rabin-Karp, Z-Algorithm), and more!
✔ Assignments, Homework, Labs, Projects, Exams, or Quizzes

🌐 Web Development:
Frontend – HTML, CSS, JavaScript, React, Laravel
Backend – .NET, PHP, Flask, Django

🗄️ Databases:
SQL, MongoDB

🧠 AI & Data Science:
Python for Data Science, Machine Learning, Pandas, NumPy, Data Visualization

✅ What You’ll Get:
Personalized one-on-one sessions
Clear explanations with real-world examples
Hands-on coding practice
Help with assignments, projects, and interview prep
A focus on understanding, not memorizing
No matter your level, I make learning tech engaging and effective. Let’s turn your goals into achievements—one line of code at a time!
Good-fit Instructor Guarantee
favorite button
message icon
Contact Ecile