Database Systems: All Concepts of Graduate Level for CS Graduates

From 15.33 £ /h

Database systems class is related to all concepts of database from zero to advance. We will discuss all related concepts of database, Normalization, Entity Relationship diagram, Transactions and also will practice of SQL queries on database like oracle, MYSQL, ms sql serve.

Location

Online from Pakistan

Age

Adults (18-64 years old)

Student level

Beginner

Intermediate

Duration

45 minutes

The class is taught in

English

Skills

Database

Mysql

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

Java from Zero to Hero... A class with concepts of OOP, Data Structures

14.56 £ /h

This java class have all Concepts of java from basic to Object Oriented Programming and then Data Structures to Algorithm designer also. I will deliver lecture of 45 minutes and 5 days a week. Will assist you in assignments, projects, concepts and all related steps.

Jerome

5.0

(5)

Experienced teacher in science and doctor in psychology and cognitive neurosciences graduated from the University of Strasbourg (holder of a master 2 in research in Biology and a professional master 2 in scientific communication), I offer private lessons in psychology (cognitive , social, developmental psychology, neuropsychology etc.), neurosciences as well as in statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous pedagogical approach, specific and adapted to each request, I offer effective methodological assistance (references available) to meet the expectations of the students and to achieve or even exceed the objectives set. My courses also include a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your research dissertations and oral defenses with or without PowerPoint support).

My courses are aimed at students (in psychology, neurosciences, medicine, etc.) wishing to optimize their performance and marks in exams and competitions.

Schools, Universities and teaching institutes: Universities of Strasbourg and Paris 8, CNRS, Ecole Polytechnique, ESSEC Business School, ISTH, IONIS Education Group, EEEA, Institut Tocqueville etc.

Ana

5.0

(5)

I am a Ph.D. student at the University of Luxembourg. For the past 4 years, I taught the University: statistics and probability theory to first-year students, and economics to 3th-year students.

I really enjoy teaching. I am looking forward to helping students when they need reinforcement on different subjects, or anyone interested in learning the following topics:

For maths: System of equations, derivatives, integrals, type of equations, etc.

For statistics: Probability theory, descriptive statistics, regression analysis, multivariate analysis, hypothesis testing, and methods for causal inference.

For young professionals: I have extensive experience in data analysis, data management, and statistical modeling. My class mixes both theoretical and practical parts using financial data as examples.

If you are interested, just write me a message telling me what topics are you interested in learning.

Emna

5.0

(5)

You are a highschool student?
You have a baccalaureate?
You need help with Python (Algorithmic Programming).
I am here to teach you !

I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years.
I am also a teacher and my students love the way I teach with (simple, clear and always funny)

Oussama

5.0

(5)

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

5.0

(5)

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

Salah

5.0

(5)

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.

Philippe

5.0

(5)

Discover "Professional Computing for Adults", a course specially designed to help you master the essential digital tools in the modern workplace. Whether you are a beginner or want to deepen your knowledge, I guide you through the basics of office automation, mastery of Office, Excel, database management, as well as an introduction to programming languages such as SQL and Python. With more than 7 years of experience as a private tutor and a solid background in computer engineering, I adapt each course to your specific needs to guarantee practical, effective learning that is directly applicable in your professional life.

Mohamed

5.0

(5)

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

Hassane

5.0

(5)

Description:
This course is a comprehensive introduction to database management, including design, administration, and integration into applications.

Goals :

Understand relational models and the use of the SQL language.
Create and administer efficient and secure databases.
Integrating foundations into modern applications.
Course methods and format:

Video courses: Guided practice on tools like MySQL or PostgreSQL.
Flexibility: Exercises adapted to your specific projects.
For who ?
Students, developers or professionals wishing to master databases.

Said

5.0

(5)

Master Python / C / C++ / SQL with personalized courses

Discover the art of programming with Python / C / C++ courses tailored to your specific needs. Whether you're 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-life projects that strengthen your understanding and skills.

Ongoing Support: Get unlimited email support for any questions you have between sessions.

As a Python/C/SQL expert, I have a passion for teaching and sharing my knowledge. My goal is to effectively guide you on your learning journey.

Book Your First Lesson:

Start your journey to Python/C++/SQL mastery now by booking your first lesson. Whether you're looking to break into development or hone your existing skills, these courses are designed for you.

Elena

5.0

(5)

I have a Master’s degree in Data Science from a UK university and a background in working with students and professionals who want to improve their skills in Python, SQL, or data analysis. I enjoy teaching in a practical, supportive way and always try to explain complex topics in simple terms. I also work on small real-world projects and guide learners through the logic behind every task. My goal is to help you feel confident and make steady progress.

Abraham

5.0

(5)

I teach a wide range of Data Science courses, including Data Analysis, Databases & SQL, Statistics, and Python, covering topics from beginner to advanced levels. My teaching approach emphasizes hands-on learning with real business datasets, allowing students to directly apply concepts to practical scenarios. I design and deliver curricula, labs, and projects that integrate data cleaning, visualization, machine learning, and predictive modeling. By balancing both theoretical foundations and applied problem-solving, I help learners build strong technical and analytical skills relevant to academic research and industry applications. Additionally, I mentor students on capstone projects and research initiatives, encouraging critical thinking, collaboration, and data-driven decision-making.

Rami

5.0

(5)

💻 Computer Programming Classes – Learn to Code from Scratch!

Description:

Our computer programming classes are designed to introduce students of all levels to the world of coding. Whether you're a complete beginner or looking to improve your skills, our structured lessons will guide you through the core concepts of programming using popular languages such as Python, Java, or C++.

In each class, students will learn:

Fundamentals of programming (variables, loops, functions, conditionals)

Problem-solving and logic building

How to write, test, and debug code

Real-world applications like web development, automation, and games

By the end of the course, students will have built their own mini-projects and gained the confidence to continue exploring the world of technology.

Aya

5.0

(5)

if you've ever looked at a database and thought, "Where do I even start?"—this course is for you. I'm going to teach you SQL from the ground up, no fluff, no jargon, just the real stuff you need to get confident writing queries that actually do something useful. We'll start with the basics—how to pull data from a table—and build up to more advanced topics like joins, aggregations, subqueries, and even window functions. You’ll learn how to ask the right questions, write clean, readable queries, and solve real-world problems with data.

Durga

5.0

(5)

Hello and Welcome!

I am a certified corporate programming trainer specializing in Python and Data Analysis, with over a decade of experience in tutoring and software development. My goal is to make programming approachable and engaging by helping learners build a strong foundation and grow into confident, independent coders.

Over the years, I have trained students across different levels and backgrounds in Python programming, automation, and data analytics. I emphasize hands-on, practical learning supported by clear explanations and real-world examples. My teaching approach focuses on understanding core concepts, writing efficient code, and developing problem-solving skills that can be applied in professional and academic settings.

Courses Offered

1. Basic Python Programming
This course is designed for beginners who want to build a solid foundation in Python.
Topics include:
Introduction to Python and environment setup
Variables and data types
Operators and expressions
Conditional statements
Types of loops and loop control
Functions and scope
Data structures: lists, tuples, sets, and dictionaries
Mini projects and problem-solving exercises

2. Advanced Python Programming
This course is designed for learners who already know the basics of Python and want to explore its advanced features.
Topics include:
Lambda functions and list comprehensions
Generators, yield, and closures
Decorators
Object-Oriented Programming (classes, inheritance, polymorphism, encapsulation)
File handling and exception handling
Mini projects integrating multiple concepts

3. Data Analysis Using Python (NumPy and Pandas)
This course introduces essential tools for data manipulation and analysis using Python libraries.
Topics include:
Working with NumPy arrays
Using Pandas DataFrames and Series
Data cleaning, filtering, and transformation
Handling missing values and duplicates
Grouping, aggregation, and pivot tables
Exporting data to CSV and Excel
Real-world exercises with sample datasets