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

From 28.46 € /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.46 € /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.

27.03 € /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.

Gaëlle

5.0

(3)

Most kids think coding is for "smart kids" or "future programmers."
It's not. Coding is how real people solve real problems.
In this class, we skip the theory. Your child creates real things.

What they'll do:
✓ Build real projects in Scratch: a working game, an interactive animation, a story they coded
✓ Program virtual robots: solve real-world challenges (navigate a maze, automate a task, build a system)
✓ Create in Minecraft Education: design worlds, automate constructions, solve logic problems
✓ Experiment with different languages: not just learn "the right way," but understand that there are many ways to think about a problem
✓ Collaborate and share: work with other kids, get feedback, improve their work
✓ Develop logical thinking: not just for coding, but for anything: solving math problems, science challenges, real-world situations

Why this is different:
We don't teach syntax. We teach how programmers think.
Most children's coding courses say "here's the code, copy it." We teach "what problem are we trying to solve? How could we break it into steps? What options do we have?"
When your child learns to think like a programmer, they can learn any language afterward.

What they take home:
A portfolio of 3–4 completed, working projects. The ability to say "I built this." And the deep understanding that code is a tool to make real things happen.

Format: Online or Barcelona | 60–90 min sessions | Flexible pace, no prior experience needed
For curious 8-12 year olds who want to build.

Abdellah

5.0

(3)

I will teach you Java from the basics for better understanding, and you will develop a desktop application linked to database at the end of the course.

This Core Java Course begins by giving a birds-eye view of Java covering everything from Origin of Java to Installing Java and Writing Your First Java Program. Even the most fundamental concepts like compilation & interpretation are explained. All other topics are covered in-depth starting from Language Basics, Object-Oriented Concepts & Design, JVM Internals, Exceptions, IO, Package, Multi-threading, Databases, Nested Classes, and Functional-style Programming via Java 8. You'll also learn about Database Designing, implementation (SQL), and how to interact with them from Java programs (via JDBC).
Our Core Java Training is curated by professionals as per the industrial requirements and demands. This training encompasses comprehensive knowledge of basic and advanced concepts of Core Java (J2SE). Each lecture has been very carefully crafted explaining the motivation behind every concept. Each concept is clearly explained with well thought out examples & illustrations and is demonstrated in code.

Enrique

5.0

(3)

Don't settle for anything less than excellence.
I am an Aerospace Engineer with a Master's degree in Quantum Physics and have completed Ph.D. work at the University of Cambridge in Computational Physics. Additionally, I have 4 years of experience developing MATLAB and possess deep programming skills in MATLAB/Simulink family, C/C++, Fortran, and Python.

With over 12 years of tutoring experience, I have successfully guided more than 50 students worldwide to achieve distinction in various fields. Consistent results are my priority, and I strive for excellence in all aspects of my teaching.

My lessons are customized to meet each student's unique needs and are designed to be engaging and insightful.

Whether you are at a school level or require advanced or professional-level instruction, I offer support in the following areas:
- Preparation for IB/IA, A-Levels, GCSE, University Entry, or equivalent.
- Experience in preparing students to access world-class schools and universities, including Cambridge University, Oxford, Ivy League and other top institutions in the UK and US.
- University levels (undergraduate and postgraduate).
- High school studies and diploma programs.
- Assistance with specific projects at a professional level, including job interview preparation.
- Extensive experience working with children.

Every lesson is meticulously planned in advance to ensure that it aligns with your goals and targets areas for improvement.
I prioritize a dynamic and interactive learning experience, with one-on-one sessions tailored to your individual requirements. Lessons will be conducted via webcam, enabling you to connect from anywhere.

I have a highly flexible schedule and can adapt to accommodate your needs.
If you have any questions about my teaching method, availability, or pricing, please don't hesitate to reach out. I am here to assist you and provide the support you need.

Jean-Baptiste

5.0

(3)

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

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.

Amine

5.0

(3)

Discover programming lessons suitable for children! With a fun and educational approach, my lessons allow young minds to dive into the fascinating world of programming. Provide your children with an enriching learning opportunity in a fun and stimulating environment.

Baia

5.0

(3)

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!

Kevin

5.0

(3)

For many years, I have successfully supported Swiss students in the fields of statistics, data analytics, machine learning, and artificial intelligence. I have gained extensive experience using R as a statistical programming tool and know exactly what students in Switzerland are required to do. I have numerous sample projects, datasets, and exam questions at my disposal and have prepared many students for their assignments and exams in a targeted, sustainable, and highly successful manner. My focus is on explaining complex statistical procedures, algorithms, and data analyses in an understandable way, demonstrating them in a practical way, and building confidence in the secure handling of data. My goal is not only to improve grades, but also, in the long term, to develop a deep understanding of data-driven questions and modern technologies such as machine learning and AI, which are crucial in later professional life.

► How do I teach?

►I attach great importance to ensuring that my students truly understand statistical concepts, data analytics methods, machine learning, and AI models, rather than just applying them mechanically – this is how we achieve sustainable success in statistics, data analytics, and modern technologies.

►My success is based on my ability to flexibly adapt my teaching style to the individual needs of students in statistics, data analytics, machine learning and AI, including topics such as regression methods, logistic regression and other machine learning algorithms.

►I use practical, lively examples from statistics, data science and AI to clearly explain abstract concepts such as hypothesis testing, analysis of variance, linear and nonlinear models and to anchor them deeply in the memory.

►With patience and clarity, I break down complex statistical analyses, machine learning models, and data processes into their essential components so that no student is overwhelmed and can build a solid foundation in statistics, data analytics, and AI.

►I am convinced that trusting collaboration is crucial to reducing uncertainty in statistics or data science and creating a productive learning atmosphere.

►I offer intensive exam preparation and project support in statistics, data analytics, machine learning and AI, develop strategies to combat exam anxiety with my students and train them on real data sets and complex algorithms.

►As an experienced online tutor for statistics, data analytics, machine learning, and AI, I use modern tools such as interactive whiteboards and live coding sessions in R to make teaching as efficient and practice-oriented as possible.

►Locations: I teach statistics, data analytics, machine learning, and AI at your home, online, or by appointment – flexible, professional, and tailored precisely to your needs.

Iman

5.0

(3)

As a Digital Transformation student, I know that programming is a fundamental building skill—whether you are a future engineer or a curious young learner. I designed this course as a practical guide to mastering essential tools and, above all, to developing the creative mindset of a programmer.

You will learn how to break down complex problems into logical steps, turn your ideas into functional code, and view errors (“bugs”) as stimulating challenges rather than obstacles.

5.0

(3)

This course shows students how AI is the engine behind modern video games. It’s an engaging, project-based track ideal for advanced concepts in a fun, relatable environment.

Behavioral AI: Using simple visual programming environments (like Scratch or similar platforms) to program smarter Non-Player Characters (NPCs) that react realistically to the player's actions.

Generative Assets: Learning how game studios use generative AI tools to rapidly create textures, background stories, or simple game environments.

Interactive Storytelling: Exploring decision-tree logic and how AI can adapt game narratives based on player choices, making the game feel dynamic and intelligent.

SEN Alignment: The visual and immediate feedback loop of game design environments is highly effective for kinetic learners and helps maintain focus.

Alexadros

5.0

(3)

FOR CODING LESSONS WE HAVE STRUCTURED PROGRAMS
CHILD - > MINECRAFT CODING-> SCRATCH -> APP INVENTOR -> ROBLOX -> PYTHON ( DEPEND ON CHILD AGE)
ADULT -> PYTHON -> ALGORITHMS - > C++ - > CERTAIN NICHE OF THEIR CHOOSING TO BECOME EXPERT (14+)
AND WE TEACH OLD AND YOUNG PEOPLE BASIC KNOWLEDGE ABT PCS AND SMARTPHONE

Wissem

5.0

(3)

I teach coding to beginners and intermediate students.
Lessons focus on logic, basic programming, and practical exercises.
Classes are adapted to the student’s pace.
Students can choose between website or mobile app development.Hands on dev

Fayza

5.0

(3)

This class is designed for beginners who want to start learning robotics in a simple and practical way.

Students will learn the basics of electronics, Arduino programming, sensors, motors, and how to build small real-world projects step by step. No advanced background is required.

The course focuses on hands-on learning: connecting components, writing Arduino code, understanding how robots work, and creating mini projects such as smart fans, automatic lights, and simple robots.

By the end of the class, students will understand how hardware and software work together and will be able to build their own basic robotic systems.

This class is suitable for students, hobbyists, and anyone interested in robotics and technology.