Database Systems: All Concepts of Graduate Level for CS Graduates

من 74.92 QAR /س

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.

المكان

عبر الانترنت من باكستان

السن

الكبار (18-64 سنة)

مستوى الطالب

مبتدئ

متوسط

المدة

45 دقيقة

الدرس يدور باللغة

الإنجليزية

مهارات

قاعدة البيانات

Mysql

الجاهزية في الأسبوع العادي

(GMT -05:00)

نيويورك

على الانترنت عبر كاميرا ويب

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

71.17 QAR /س

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.

إقرأ المزيد

Houssem

5.0

(3)

Afin d'améliorer vos compétences ou de découvrir dès le début le domaine de bases de données relationnelles, langage SQL et Administration Bases de Données, il vous faut un expert dans ce domaine ainsi que dans le domaine éducatif en général, en mettant à votre disposition des cours bien intégrés et bien structurés avec des exercices théoriques et pratiques:
- La sélection simple (SELECT)
- Fonctions de ligne et fonctions de groupe
- Regroupement
- Jointure
- Sous requête simple
- Sous requête corrélée
- Algèbre relationnelle
- Etc.

Said

5.0

(3)

This course is designed to introduce you to computer science and programming. You will learn basic computer science concepts, including algorithms, data structures, and programming paradigms. You will also learn how to write simple programs using Python or C, popular programming languages.

Throughout the course, you will work on several projects, including creating a game or program that solves math problems, to help you apply what you have learned. You will also have access to a variety of resources, including online tutorials, discussion forums, and programming blogs, to deepen your understanding of the course material.

Emna

5.0

(3)

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)

Abdelatif

5.0

(3)

I am a data expert, and I offer you a complete 8-hour training course in business intelligence (Data analyst). The training will be organized as follows:
- Courses (summary slides) to master the life cycle of a business intelligence project (ETL, data integration, modeling, reporting)
- Theoretical exercises on modeling business intelligence problems (star diagram, snowflake diagram).
- practical case study using SQL server tools: SSIS, SSAS, SSRS
- reports with QlikView

Oussama

5.0

(3)

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

(3)

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

(3)

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.

Mohamed

5.0

(3)

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

(3)

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.

Abraham

5.0

(3)

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

(3)

💻 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

(3)

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.

Amine

5.0

(3)

◾ Tools

RStudio • SQL • SPSS • SAS • Jamovi • JASP

◾ Statistical Methods & Tests

Student's t-test • ANOVA • MANOVA • ANCOVA • Regression (linear & logistic) • Correlation • Chi-square • Nonparametric tests • PCA • MCA • Exploratory factor analysis • Classification / Clustering • Mediation • Moderation • Interpretation

◾ Data analysis & decision support

- Data preparation, structuring and validation using SAS, R and SQL
- Descriptive, exploratory and multivariate statistical analyses on business data
- Production of performance indicators and actionable analyses to support decision-making

◾ Selection and implementation of methods

- Preparation and structuring of databases
- Hypothesis testing and univariate, bivariate and multivariate analyses (ANOVA / ANCOVA)
- Linear and logistic regressions
- Factor analyses (PCA / MCA)
- Mediation and moderation models
- Classification / clustering

1) Academic support

- Lectures, tutorials, projects and assignments in statistics
- Help in understanding and interpreting the results
- Preparation for exams and academic presentations

2) Statistical analysis

- Descriptive statistics (univariate and bivariate)
- Multivariate analyses
- Data exploration and outlier detection

3) Statistical tests

- Correlations (Pearson, Spearman, Cohen's Kappa)
- t-tests (one and two samples, independent or paired)
- Chi-square, binomial tests
- z-scores and associated indicators

4) Statistical modeling

- Linear regressions (simple and multiple)
- Logistic regression
- Interpretation of coefficients, diagnostics and validation of models

5) ANOVA & ANCOVA

- One- or multi-factor ANOVA
- Repeated measures ANOVA
- Fixed and random effects
- Post-hoc tests and effect sizes

6) Factor analyses

- ACP / PCA (scree plot, factor scores, matrices)
- Exploratory factor analysis
- Factorial rotations
- Validation and interpretation of structures and clusters

◾ Reporting & communication

- Clear, structured and concise reporting of results
- Visualizations tailored to decision-makers
- Support for strategic and operational decision-making

Chrayet

5.0

(3)

Specialized in using Power BI and able to configure you on demand, whether you are a beginner who wants to understand the basics of data analysis or a professional seeking to master building advanced reports and dashboards.

Microsoft Power BI is considered one of Microsoft's most powerful business intelligence tools, and is widely used in the fields of industry 🏭, finance 💰, commerce 📊, project management 📈, human resources 👥, supply chains 🚚 and more.

With Power BI you can:

Linking multiple data sources (Excel, ERP, SQL, SharePoint...).

Cleaning and transforming data professionally using Power Query.

Creating powerful data models using DAX.

Interactive and easy-to-read dashboard design.

Track Key Performance Indicators (KPIs) in real time.

Supporting decision-making through in-depth and accurate data analysis.

I offer practical training based on real-world scenarios from your work environment, simplifying technical concepts like Data Modeling and DAX in a systematic and accessible way. The goal is to empower you to transform raw data into strategic insights that help you make smart, fast decisions.

Mastering Power BI gives you a strong added value in the job market, and enables you to lead the digital transformation within your organization 🚀

A customized training program can be set up according to your level and professional needs.

Amine

5.0

(3)

✓ Tools

RStudio • SQL • SPSS • SAS • Jamovi • JASP • Excel

✓ Statistical Methods & Tests

Student's t-test • ANOVA • MANOVA • ANCOVA • Regression (linear & logistic) • Correlation • Chi-square • Nonparametric tests • PCA • MCA • Exploratory factor analysis • Classification / Clustering • Mediation • Moderation • Interpretation

✓ Data analysis & decision support

- Data preparation, structuring and validation using SAS, R and SQL

- Descriptive, exploratory and multivariate statistical analyses on business data

- Production of performance indicators and actionable analyses to support decision-making

✓ Selection and implementation of methods

- Preparation and structuring of databases

- Hypothesis testing and univariate, bivariate and multivariate analyses (ANOVA / ANCOVA)

- Linear and logistic regressions

- Factor analyses (PCA / MCA)

- Mediation and moderation models

- Classification / clustering

1) Academic support

- Lectures, tutorials, projects and assignments in statistics

- Help in understanding and interpreting the results

- Preparation for exams and academic presentations

2) Statistical analysis

- Descriptive statistics (univariate and bivariate)

- Multivariate analyses

- Data exploration and outlier detection

3) Statistical tests

- Correlations (Pearson, Spearman, Cohen's Kappa)

- t-tests (one and two samples, independent or paired)

- Chi-square, binomial tests

- z-scores and associated indicators

4) Statistical modeling

- Linear regressions (simple and multiple)

- Logistic regression

- Interpretation of coefficients, diagnostics and validation of models

5) ANOVA & ANCOVA

- One- or multi-factor ANOVA

- Repeated measures ANOVA

- Fixed and random effects

- Post-hoc tests and effect sizes

6) Factor analyses

- ACP / PCA (scree plot, factor scores, matrices)

- Exploratory factor analysis

- Factorial rotations

- Validation and interpretation of structures and clusters

✓ Reporting & communication

- Clear, structured and concise reporting of results

- Visualizations tailored to decision-makers

- Support for strategic and operational decision-making