Databases management systems - conceptual - logical design

From 38.12 € /h

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

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

Skills

Oracle database

Database

Computer programming

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Matías

4.88

(84)

Python is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.

This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.

As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.

I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.

Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.

Mathieu

4.88

(84)

With 7 years of experience as a developer in a Factory, I now develop Wordpress websites for large groups.

In the training program, you will learn to:

- Install, configure, and deploy WordPress sites
- Develop custom Wordpress themes and plugins
- Use powerful tools like ACF Pro, Gravity Forms, WPML, AIOS Security, WP rocket...
- Create custom post types and tailor-made taxonomies
- Develop pages using the right methods in HTML, CSS, Javascript & PHP
- Administer and manage a site database
- Contribute to the good natural referencing (SEO) of your site
- Use WP-Cli to speed up the maintenance of your sites
- Use Docker to containerize your local/prod projects and facilitate their management
- Administer your WP sites the right way
- And much more...

For any questions, you can contact me by PM.

See you soon,
Matthew

Wissam

4.88

(84)

I created this course especially for students having difficulty progressing in their computer programming courses/projects. I support students of all university levels. My help covers many others:
- Analysis and planning of projects
- Technological choice in languages and tools/framework
- Algorithmic and programming support
- Assistance with debugging and code correction
- Data modeling (MCD/MLD diagram, UML diagrams)

Why choose my courses?
My method is different and more adapted than that of traditional teachers because it is:
* Personalized: Adapted to your level and your specific needs.
* Interactive: Promotes interaction and visualization of concepts.
* Practical: Oriented towards practice with concrete exercises and projects.
* Proven: I have already managed to help more than 200 students in the space of 2 years.

Baia

4.88

(84)

Are you ready to create interactive, visually appealing websites that stand out in today’s competitive market? In this course, you’ll master the essential front-end development skills:

✅ HTML, CSS, and JavaScript – Build responsive and modern web pages
✅ React & Vue.js – Learn cutting-edge frameworks for dynamic UIs
✅ Real-World Projects – Work on hands-on projects to strengthen your skills
✅ Problem-Solving & Creativity – Develop intuitive, user-friendly interfaces

🔹 Who is this course for?

- Beginners who want to break into web development
- Developers struggling with front-end concepts
- Anyone looking to level up their skills and build real projects

🚀 Stuck on a project? Want to learn high-income tech skills?
This course will help you gain confidence, land opportunities, and grow in the tech industry.

📩 Contact me for more details and start your front-end journey today!

Amin

4.88

(84)

By delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.

Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.

We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.

If you have any further questions, please do not hesitate to contact us.

Oussama

4.88

(84)

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).

Brahim

4.88

(84)

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

Giuliano

4.88

(84)

Python is a very powerful and multi purpose tool. Image analysis, data analysis. Do you want to create your own software?
Do you want to manage your own hardware?
For who may want to learn Python or need help for a project I would gladly help you with that!

Salah

4.88

(84)

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.

Francisco

4.88

(84)

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!

Patrick

4.88

(84)

Need professional support for your data analysis?
I offer you a personalized service, adapted to your academic or professional needs.

Whether you are a student, researcher, consultant or professional, I put my expertise at your disposal to help you:
Prepare and organize your databases,
Perform reliable statistical analyses with R, Stata, SPSS...
Interpret your results rigorously,
Present your work in the form of clear reports, graphics and publications.
Each project is handled with rigor, pedagogy, and confidentiality. You benefit from tailored support, whether for a professional assignment, a dissertation, a thesis, or a publication.

For those who wish to train in parallel, I have also designed a complete course to learn how to explore, manipulate and analyze your data independently.

Alex

4.88

(84)

Mathematics is the best way to enhance your intellect but also work on your intuition and your ability to see patterns.

Good day, my name is Alex, I have been teaching math for over 10 years to hundreds of students. I will teach all grades from elementary school all the way to high school and IB/GCSE etc.

My philosophy revolves around these three values:
-Encouragement
-Inspiration
-Discipline

I specialize into teaching mathematics and programming, but in some occasions I teach physics too.
Feel free to contact me.

Abdelhak

4.88

(84)

I offer computer courses suitable for all levels.
The program may include:

Basics of computing and use of digital tools
Introduction to programming and computer logic
Web or software development concepts according to your needs
Practical exercises to progress at your own pace

The course is personalized according to your objectives to allow you to acquire solid computer skills.

Wissem

4.88

(84)

I teach coding to beginners and intermediate students.
Lessons focus on logic, basic programming, and practical exercises.
Classes are adapted to the student’s pace.
Students can choose between website or mobile app development.Hands on dev

Ahmed

4.88

(84)

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!