Databases management systems - conceptual - logical design

From 45.64 $ /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

Baia

4.76

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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

(21)

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.

Soufiane

4.76

(21)

Hello to all motivated post-baccalaureate students (computer science degree, BUT, preparatory classes, engineering schools, career change)!
My name is Soufiane, I have a master's degree in Data Science & AI.

Specializing in programming and development, I offer customized private lessons in: Python (basics, OOP, data structures, real-world projects), Java (advanced OOP, interfaces, project management), R (data analysis, packages, visualization), C (pointers, memory, system algorithms), SQL (complex queries, joins, optimization), Databases (MySQL, PostgreSQL, normalization), HTML/CSS (static web, responsive design, best practices), Algorithms & Data Structures (complexity, trees, graphs), Real-world projects (mini-apps, scripts, websites)

Levels: L1/L2/L3 Computer Science, BUT, ATS/TI preparatory classes, Engineering schools (INSA, EPITA, etc.), Career change

Why my courses?
- 100% practical courses: hands-on exercises, projects, live debugging
- Resources provided: OOP worksheets, Java templates, R/C cheat sheets, solved exercises
- Flexible hours: evenings, weekends, holidays
- At home (Cergy, Pontoise, Sarcelles – free < 15 km) or 100% remote (Zoom + screen sharing)
- Invoices issued

Immediate availability – Limited places
Contact me by message to schedule an appointment.
Respond quickly, I'm only taking a maximum of 8 students to guarantee quality!

See you soon to boost your dev skills!

Wissem

4.76

(21)

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

(21)

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!

Ioannis

4.76

(21)

Υποψήφιος Διδάκτορας Πληροφορικής – Ιδιαίτερα Μαθήματα & Παγκύπριες

Είμαι Υποψήφιος Διδάκτορας Πληροφορικής και προσφέρω ιδιαίτερα μαθήματα Πληροφορικής σε μαθητές Λυκείου (Παγκύπριες Εξετάσεις) καθώς και σε φοιτητές Πανεπιστημίου, με έμφαση στη σωστή κατανόηση και στη μεθοδική σκέψη.

Παγκύπριες Εξετάσεις – Πληροφορική

Συστηματική προετοιμασία με έμφαση:
• κατανόηση της ύλης
• σωστή αλγοριθμική σκέψη
• μεθοδολογία επίλυσης θεμάτων
• ανάλυση παλαιών θεμάτων Παγκυπρίων

Καλύπτουμε ενδεικτικά: ψευδοκώδικα, πίνακες, επαναλήψεις, δομές ελέγχου και συχνά λάθη εξετάσεων.

Φοιτητές & Γενική Πληροφορική

Υποστήριξη σε:
• Προγραμματισμό (C / C++ / Python)
• Λειτουργικά Συστήματα
• Αρχιτεκτονική Υπολογιστών
• Κατανόηση & debugging κώδικα

Μαθήματα δια ζώσης ή online, με έμφαση στην κατανόηση και στη σωστή οργάνωση μελέτης.

English text below

PhD Candidate in Computer Science – Private Tutoring & Pancyprian Exams

I am a PhD candidate in Computer Science offering private tutoring for high school students (Pancyprian Exams – Computer Science) and university students.

Pancyprian Exams – Computer Science

Structured exam preparation focusing on:
• understanding the syllabus
• correct algorithmic thinking
• exam-oriented problem-solving
• analysis of past Pancyprian exams

Topics include pseudocode, arrays, loops, control structures, and common exam mistakes.

University & General Computer Science

Support in:
• Programming (C / C++ / Python)
• Operating Systems
• Computer Architecture
• Code understanding and debugging

Lessons are available in person or online, with emphasis on understanding concepts rather than memorization.

Mohamed

4.76

(21)

This course is designed for students and professionals who want to learn how to analyze data using the R programming language. You will start with the basics of R, including variables, data types, and simple functions, and then move on to real-world data analysis skills such as data cleaning, visualization, and basic statistics.

By the end of the course, you will be able to work with datasets, create clear and professional graphs, and perform meaningful data analysis for projects, studies, or work.