Introduction to SQL. Designed for managing data held in a relational database management system (RDBMS).

From 28.21 € /h

Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.

In this two-hour introduction to SQL, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test. SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results. PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course you’ll have some hands-on experience in learning SQL and the grounding to start applying it on projects or continue your learning in a more specialized direction.

Relational Databases
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.

Querying
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.

Extra information

Bring your own Laptop

Location

Online from United Arab Emirates

About Me

I am Certified Professional ERP, WMS, Data Analytics Expert with extensive experience in IBM Cognos, Oracle BI, Microsoft Power BI, DAX and Python.
I specialize in handling and analyzing large datasets and am highly skilled in data visualization.

I am excited to help you get started on your project! Let's touch base and begin the process.

Education

SUPINFO International University, Paris – France
Master’s Degree, Computer Software Engineering
________________________________________________________________

Experience / Qualifications

• Digital Transformation Analytics/ Informatica/ Boomi/ Microsoft SSIS/ Python
• Project & Budget Management
• Business Intelligence (IBM Cognos, Oracle BI, Microsoft Power BI)
• ERP Implementation and Upgrades
• Business Process Analysis
• Troubleshooting and Problem Solving
• System Design and Development
• Networking and Active Directory group policy
• Vendor Management
• Procurement Management
• Database Management
• Project Management
• Process Automation
• Ecommerce & B2B
• Demand & Supply Chain Management
• Warehouse Management System
• Logistics distribution and routing solutions

Oracle University
• Oracle BI Analysis & Dashboard
• Oracle BI Publisher 11G R1
• ERP Foundation & Address Book
• ERP Financial Modules (General Accounting, Accounts Payable, Accounts Receivable, Fixed Assets)
• ERP Distribution Modules (Inventory Management, Procurement, Sales Order Management, Advance Pricing)
• ERP Enterprise Report Writer
• ERP One World CNC
• ERP One World System Administration
• ERP One World Workflow & Tools Management
IBM
• Cognos Application Development
• Cognos BI Powerplay Certification
• Cognos Impromptu Report Building
Microsoft
• Administrating Windows NT
• Supporting Windows NT Core Technologies
• Networking Essentials 1 & 2
• SQL Server System Administration
Infor
• WMS System Administration

Age

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

90 minutes

120 minutes

The class is taught in

English

French

Arabic

Skills

Computer programming

Microsoft sql server

Reviews

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

Microsoft Power BI Course. Digital Analytics to drive innovation

28.21 € /h

Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises.

Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive. You've got the power!

Getting Started with Power BI
Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis.

Transforming Data
In this chapter, you'll learn how to shape and transform your data before the data analysis using Power Query Editor.

Visualizing Data
It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports.

Filtering
In the final chapter, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report.

Microsoft Excel – Excel from Beginner to Advanced.

26.8 € /h

In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights.
You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks.
We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.

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

Amin

4.88

(84)

Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL.

Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program.

Additionally, upon request, we offer courses in other programming languages such as C, JAVA, R, and MATLAB.

Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs.

If you have any questions, feel free to contact us.

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!

Zakaria

4.88

(84)

* This digital training aims to introduce you to the Scratch tool and through the game world, and gradually, to discover programming concepts such as loops, conditions or variables. It is aimed at anyone who is new to Scratch and who wants to create games and animations.

* Learning programming will allow students to develop their skills and will certainly allow them to meet the expectations of the future working world and emerging careers.

* In addition, learning programming allows the development of algebraic, algorithmic and computational thinking. Programming also helps to improve and develop students' sequencing ability, as well as their communication skills. Thus, there are several advantages to teaching programming, but the important thing is to remember that this learning teaches students that digital is not only for entertainment, but that it is possible to become creators. active and creative content.

Oussama

4.88

(84)

Learn to add AI features to your applications using ChatGPT API. Taught by a Full-Stack Engineer who's integrated AI into real client projects.

What You'll Learn:
ChatGPT API Integration: Add AI chat, content generation, or text analysis to any web app
Prompt Engineering: Write effective prompts that give consistent, quality results
Production Implementation: Rate limiting, cost management, error handling, security
Real-World Deployment: Deploy AI features to AWS with proper monitoring and logging

Technologies:
OpenAI API (ChatGPT-4)
React/Next.js frontend integration
Node.js/NestJS backend
Secure API key management
Cost optimization (don't waste money on API calls)

Perfect For:
Developers: Add AI to your portfolio (instant differentiation from other candidates)
Freelancers: Offer AI integration services
Students: Build an AI-powered projects that stands out
Entrepreneurs: Add AI features to your product without hiring an AI engineer

What We'll Build:
AI chatbot for your website (customer support, FAQ assistant)
Content generation tool (blog posts, product descriptions, social media)
Text analysis features (summarization, sentiment, keyword extraction)
Custom AI assistant for your specific use case

Real Examples:

E-commerce: AI product description generator
Real estate: AI property listing writer
Marketing: AI social media content creator
Education: AI study assistant

What's Included:
Working code you can deploy immediately
Cost management strategies (API calls can get expensive!)
Error handling and fallback strategies
Production deployment checklist

No AI experience needed - just basic JavaScript/React knowledge.

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.

Mouad

4.88

(84)

We are a team of engineers passionate about programming. We offer Python tutoring courses suitable for all levels (beginners, advanced students, CPGE students, or anyone looking to develop their skills).

Our courses combine essential foundations, practical examples and clear teaching to ensure solid and useful progress for both studies and careers.

Francisco

4.88

(84)

Hi!

Welcome to my class on Matlab 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 often use Matlab in order to analyze data, run numerical models, plot results and much more. So, let's embark on the journey of learning Matlab 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 Matlab 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!

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.

Mohamed

4.88

(84)

This fun and interactive course introduces kids and teens to the fundamentals of coding using Scratch, a visual programming language developed by MIT. Students will learn to create games, animations, and interactive stories while developing problem-solving, logical thinking, and creativity skills—all in a playful, drag-and-drop environment!
Who Should Join?
✔ Kids & teens curious about coding and game design
✔ Young learners who enjoy storytelling, art, or technology
✔ Future coders looking for a fun introduction to programming

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.

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!