SQL 101: Master the Language of Data, From Fundamentals to Advanced Techniques

من 30.43 AED /س

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.

المكان

عبر الانترنت من الهند

السن

الأطفال (7-12 سنة)

شباب (13-17 سنة)

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

الكبار (65 سنة فأكثر)

مستوى الطالب

مبتدئ

متوسط

متقدم

المدة

60 دقيقة

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

الإنجليزية

مهارات

Microsoft sql server

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

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

(GMT -05:00)

نيويورك

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

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Python 101: Master the Language of Programming, From Basics to Advanced Concepts

30.43 AED /س

In this course, you'll learn Python from the ground up, starting with the basics and progressing to more advanced concepts. You'll gain hands-on experience writing Python code, working with data structures, and using libraries to solve real-world problems. By the end of the course, you'll be confident in your ability to write Python programs, automate tasks, and tackle challenges in various domains.

إقرأ المزيد

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.

Basel

5.0

(3)

I specialize in administering and teaching Windows Server 2022 Administration Fundamentals to small, medium, and large enterprises. My goal is to keep trainees constantly challenged to learn how to set up and manage servers efficiently without overwhelming them. I cover topics such as Active Directory management, DNS and DHCP configuration, and Virtual Machine setup. After each lesson, I provide hands-on assignments to ensure full understanding and provide periodic reports to track trainees’ progress.

This class is for aspiring IT administrators who want to learn how to set up and manage Windows Server 2022 effectively. The focus is on learning how to set up servers, optimize their performance, and provision virtual infrastructure for enterprises. If you are a beginner, don’t worry, all concepts are explained clearly from the beginning to ensure complete understanding.
It is preferable for each student to have a laptop with the ability to run programs such as VmWare.

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.