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

From 28.39 € /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.39 € /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.97 € /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.

4.85

(13)

Engineer and senior professor of engineering sciences provides support courses in analog and digital electronics at all levels, engineering schools. having a scientific and technical knowledge, five years of experience in the field of teaching, teaching and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they have difficulties. for more info please contact me

Amin

4.85

(13)

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.

Youssef

4.85

(13)

doctoral student in engineering sciences provides support courses in analog and digital electronics at any DEUG level and engineering schools. having scientific and technical knowledge, three years of experience in the field of teaching, pedagogy and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they are having difficulty. for more info please contact me

Jean-Baptiste

4.85

(13)

Flutter is the mobile app development framework from Google, based on Dart.

You will learn:
- How to develop a mobile app from scratch on iOS and Android
- How the use Riverpod, the best state management system
- How to use Google Firebase (Authentication, Firestore, Cloud Functions, Cloud messaging, ...)
- Testing automation

I'm a software engineer with 4 years of experience coding with Flutter and more than 10 years working for IT companies.

Oussama

4.85

(13)

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

(13)

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

(13)

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

(13)

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

(13)

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

(13)

Welcome to my Programming Projects Support class!

Are you facing hurdles with your programming projects? Let's tackle them together!

As a Geophysics PhD student, I rely heavily on programming tools like Matlab, Python, and R for data analysis, mathematical modeling, plot results and much more.

After a lot of requests from students I created this course which is specifically meant to give you support completing your final programming projects.

Here's what you can expect:

- We'll review your project's background and requirements.
- Analyze your coding progress and identify areas for improvement.
- Collaborate to overcome obstacles, debug your code and advance your project.
- Tailored sessions based on your project's complexity and your skill level.

Whether you require a single session or a series of in-depth consultations, my goal remains the same: to help you break through programming barriers and achieve your goals.

Ready to level up your programming skills? Let's get started!

Please note:
This is a support course only ! While I'm here to guide you, the project's success lies in your hands and I will not finish your project for you.

Alex

4.85

(13)

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.

Konan

4.85

(13)

💻 Computer skills: an essential 21st-century skill

Today, mastering computer skills is no longer a luxury, it is a necessity.
Not having the basics can quickly become a hindrance to school, academics or career.

👉 Contact me now to:

• acquire a solid foundation in computer science
• deepen the fundamentals of programming (for advanced levels)
• Strengthen your skills in a clear, structured and sustainable way

📘 Mathematics – Secondary Level
Are you experiencing difficulties? I will guide you step by step to raise your level, understand and progress methodically.

📍 Lessons at home or remotely (video conference)
🎯 Objective: to understand, reason, and succeed
📞 Available for customized support.

Baia

4.85

(13)

Code Your Ideas Into Reality 💻🚀
Want to build your own website or start a tech career? This class is perfect for absolute beginners who want to learn Python and use it to build real, working web apps with Django. You'll go from writing your first line of code to deploying complete projects - step by step, clearly explained, and handsOn.

✨ No experience needed.
🧠 Learn by doing - real apps, real logic.
🌍 Build skills for school, work, or freelance life.

Let’s turn your curiosity into code. First session gets you started!

Mohamed

4.85

(13)

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

Ioannis

4.85

(13)

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

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

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

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

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

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

Υποστήριξη σε:
• Προγραμματισμό (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.