

from24.97GBP/ h
Introduction to SQL. Designed for managing data held in a relational database management system (RDBMS).
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.
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 LaptopLocation
Online via webcam
General info
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 |
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 – FranceMaster’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
Reviews (1)
Mr. Samir is really at the top! His passion for teaching and his subject shines through in every lesson. He has a unique way of making lessons captivating and accessible, which facilitates learning and motivates his students to excel. He is always ready to help and provide additional explanations when necessary. His classes are not only informative but also incredibly inspiring. A real pleasure to have been his student!
Translated by Google. Click to view original.
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.
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.
In our Introduction to Python course, you’ll learn about powerful ways to store and manipulate data, and helpful data science tools to begin conducting your own analyses.
Python Basics
An introduction to the basic concepts of Python. Learn how to use Python interactively and by using a script. Create your first variables and acquaint yourself with Python's basic data types.
Python Lists
Learn to store, access, and manipulate data in lists: the first step toward efficiently working with huge amounts of data.
Functions and Packages
You'll learn how to use functions, methods, and packages to efficiently leverage the code that brilliant Python developers have written. The goal is to reduce the amount of code you need to solve challenging problems!
NumPy
NumPy is a fundamental Python package to efficiently practice data science. Learn to work with powerful tools in the NumPy array, and get started with data exploration.
An excellent logistics system delivers the right product to your customer at the right price, so understanding logistics is critical to your success. In this course, instructor Samir shows you why logistics is important, what it is, and how logistics supports your company and your customers. Samir discusses how logistics must be effective and efficient. He explains steps to improve how a customer’s order is filled. The course covers both outbound and inbound logistics and also goes over reverse logistics. More money is spent on transportation than on all other logistics functions combined, so Samir specifically takes you through different modes of transportation and how they often work together. He also shares the four cost tradeoffs in warehousing and goes into specific cost-efficient and value-added distribution center activities. The course steps through how logistics supports your marketing strategy, cuts across departments, and touches your customers.
Ask a question
Send a message explaining your needs and Samir will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | Saturday at 7:00 | Sunday at 7:00 |
8 | Monday at 8:00 | Tuesday at 8:00 | Wednesday at 8:00 | Thursday at 8:00 | Friday at 8:00 | Saturday at 8:00 | Sunday at 8:00 |
9 | Monday at 9:00 | Tuesday at 9:00 | Wednesday at 9:00 | Thursday at 9:00 | Friday at 9:00 | Saturday at 9:00 | Sunday at 9:00 |
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 |
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 |
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 |
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £24.97Online via webcam
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since September 2023
- Phone number verified
- Google connected
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | Monday at 7:00 | Tuesday at 7:00 | Wednesday at 7:00 | Thursday at 7:00 | Friday at 7:00 | Saturday at 7:00 | Sunday at 7:00 |
8 | Monday at 8:00 | Tuesday at 8:00 | Wednesday at 8:00 | Thursday at 8:00 | Friday at 8:00 | Saturday at 8:00 | Sunday at 8:00 |
9 | Monday at 9:00 | Tuesday at 9:00 | Wednesday at 9:00 | Thursday at 9:00 | Friday at 9:00 | Saturday at 9:00 | Sunday at 9:00 |
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 |
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 |
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 |
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from £24.97Online via webcam
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Similar classes
Private coding / programming lessons with python
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.
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is Welcome
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.
From Zero to Web Hero - Learn Python & Django Step by Step
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!
Python Power: Master Data Science Skills for the Future!
This course is designed to equip you with the essential Python skills needed to excel in data science. You will learn how to work with industry-standard libraries such as NumPy, pandas, and Matplotlib to analyze, clean, and visualize data effectively. Through hands-on projects and real-world examples, you’ll gain the ability to transform raw data into meaningful insights and compelling stories. By the end of the program, you’ll not only master the fundamentals of Python for data science but also develop practical skills that are highly valued in today’s data-driven world.
Data Engineering & Science: Packaging Python Projects & deployment tools either on premise or on Cloud (Amazon AWS)
In this course, you will learn how to efficiently package, containerize, and deploy Python applications and microservices using Docker. The course covers fundamental Docker concepts, best practices for structuring Python projects, and strategies for building scalable and portable applications. Through hands-on projects, you will gain practical experience in creating Docker images, managing containers, and orchestrating microservices, enabling seamless deployment across different environments.
Contact me if you want to have more information about the course!
Computer courses for curious and/or experienced students
This course is designed for students who want to gain a solid understanding of basic computer science concepts. It covers the logic behind computer systems, starting with the inner workings of a computer and progressing to topics such as networking, operating systems, and basic programming.
Whether you're considering a career in technology or simply want to better understand the digital world around us, this course will give you the tools you need to navigate the information age.
Computer Science and Programming Courses – Learn to Code and Master Information Technology
Do you want to learn computer science, programming or deepen your knowledge in information technology? I offer courses adapted to all levels, from beginner to advanced.
👉 Introduction to Computer Science and Operating Systems
👉 Introduction and improvement in object programming (solid experience in the Java language)
👉 Web development and databases (HTML, CSS, Javascript, SQL)
👉 Cybersecurity and information systems management
👉 Support for your projects and help with homework
Personalized courses, interactive teaching and guaranteed progress! Available online or in person. Contact me to discuss your goals and start your learning.
Programming and robotics in English for children (8-12 years old) in English, French or Spanish
We use Minecraft Education, Scratch, and virtual robots to build, program, and have fun, in English, French, or Spanish.
In this class, children will learn the fundamentals of programming and computer science in a fun and engaging way, and discover how soft and hard skills can be used in their personal and professional lives. Through interactive lessons and hands-on projects, children will explore the world of code and create their own digital creations.
Throughout the course:
They will learn the basic concepts and terms of programming
They will experiment with different programming languages and platforms
They will create simple programs and applications using code
They will collaborate with their classmates and share their creations.
They will develop problem-solving skills, logical thinking, and other valuable skills that will be useful in any field.
By the end of the class, you'll have the knowledge and confidence to continue exploring the exciting world of programming and computer science, and you'll understand how code can be a powerful tool for achieving success in any field. You'll be able to choose any future career you want or even start your own company. Contact me
💻 Web Programming Course – HTML, CSS, Terminal & WordPress – Beginners Welcome!
Do you want to create your own website, understand how the code works, or master WordPress to become self-sufficient? I offer personalized online courses to help you learn step by step, with clarity and pedagogy.
👩🏫 What I propose:
* Introduction and improvement in HTML & CSS
* Using the Terminal (basic commands, Git, working environment)
* Creation of sites with WordPress (installation, themes, extensions, pages, basic SEO)
* Support for your personal or professional projects
* Advice on best practices and organization of your code
🎯 For whom?
* Complete beginners
* Freelancers, coaches, content creators
* Students or people in digital retraining
* Anyone curious to learn how to create a website
💡 Method: Interactive video lessons (Zoom/Meet), screen sharing, practical exercises, and flashcards. You progress at your own pace, with real support and simple explanations.
⏰ Flexible hours – 1 hour, 1.5 hour or 2 hour sessions
💶 Available packages
🌍 100% Online Courses – Wherever You Are!
See you soon.
Sandrine.
HTML, CSS & JavaScript – Create your website like a pro
Do you dream of creating your own website but don't know where to start? 🙋♂️🙋♀️ This course is for you! Together, we'll dive into the exciting world of web development by learning the basics of the three essential languages: HTML 🧱 to structure your pages, CSS 🎨 to make them beautiful and well-presented, and JavaScript ⚙️ to add interaction and dynamism to your projects (like drop-down menus, click effects, or responsive forms).
No need to have any previous experience coding! 💡 This course is designed for beginners, the curious, or even those considering a career change. The goal is simple: by the end, you'll know how to create a complete, clean, modern, and mobile-friendly website 📱💻. We progress step by step, with clear explanations, small, concrete projects, and a relaxed but serious atmosphere. 🎯
The course is remote via webcam (Zoom, Google Meet, etc.) 📍💻. All you need is a laptop and a code editor like Visual Studio Code (free). I provide all the files needed to follow the exercises and build your site step by step 🧑💻📂.
This course is taught in French 🇫🇷 and is aimed at everyone, from teenagers to seniors, motivated to learn something new and useful. Sessions last 60 or 90 minutes, whichever suits you best ⏱️. Whether you want to create a personal website, discover coding or even start a professional project, you've come to the right place! 💬✨
See you soon to create your first website together! 😄👨🏫👩🏫
Learn Excel VBA from Scratch: Automate Excel Even with Zero Experience!
This course is designed for complete beginners who want to learn Excel VBA programming from the ground up. Whether you're a student, professional, or freelancer, you’ll learn how to automate tasks, create intelligent macros, design simple forms, and manage data efficiently within Excel.
🔧 What You Will Learn:
The basics of programming: variables, loops, conditions, and procedures.
How to record and edit simple macros.
Automating tasks across cells, worksheets, workbooks, and named ranges.
Creating interactive forms (UserForms) for data entry and display.
Automating repetitive tasks like formatting, reporting, and even sending emails.
Exploring advanced tools: events, error handling, and integration with other applications.
🎯 Who Is This Course For?
Students, employees, or freelancers who work with Excel and want to save time.
Professionals looking to build custom tools tailored to their workflow.
No previous coding experience is required!
🛠️ Course Methodology:
Step-by-step, hands-on learning.
Clear explanations with real-life examples.
Tips on writing clean, understandable, and reusable code.
Statistics. Machine Learning. Mathematics. Clarity & Competence from Bern – For Swiss Students
Data science, statistics & mathematics – clearly explained, personally supported.
My name is Kian, an experienced tutor from Bern. I support students, career starters, and professionals on their journey into the data-driven world—whether in their studies, projects, or everyday work.
With my structured, understandable, and motivating approach, I'll help you not only solve problems but also understand data, recognize connections, and make informed decisions. My lessons are personalized, efficient, and at eye level.
Who I am – and why I teach:
I teach in Bern and successfully completed the MAS program in Statistical Data Science at the University of Bern, focusing on statistics, mathematics, and data science. For several years, I have been passionately teaching, both in academic contexts and for professionals who want to think and work more data-driven.
In parallel to my teaching, I have implemented numerous data science projects – from exploratory analysis and data modeling to decision support in a business context. This combination of theory and practice makes my teaching particularly close to reality while remaining accessible.
I love making complex topics tangible, creating aha moments, and empowering people to handle data confidently. For me, tutoring isn't just about imparting knowledge—it's about developing their minds on equal terms.
-What you can expect from me:
One-to-one lessons with a focus on data comprehension, statistics & analytical thinking
Support with projects, assignments, exams or getting started in the data world
Practical explanations – step by step and adapted to your everyday life
Teaching modern methods for data analysis, modeling & interpretation
Long-term strategies for problem-solving & structured thinking
Flexible lessons in Bern or online – personal, competent & reliable
Why I can help you understand data science:
Because I work at the interface between science and practice. I know how quickly you can get lost in formulas and tools—and I'll help you see the common thread:
How data tells stories, how you analyze it, and how you make smart decisions.
With me, you won't just learn methods—you'll learn how to think with data. Whether in your studies or in your career, I'll guide you in truly understanding data and applying it confidently.
Learn data analysis.
Analyze and model complex data sets – understandable, practical and with structure.
If you're ready to get to grips with data, I'm ready to guide you.
Artificial Intelligence & Machine Learning Course for Kids
This is a 15-week adventure for kids aged 11-15 to explore AI and machine learning. Students will learn to build AI-powered apps, code with drag-and-drop tools, train AI models, and solve real-world problems. The course includes hands-on projects, and a project showcase to build confidence and tech skills.
ASSOCIATE PROFESSOR I TEACH: MICROCONTROLLER PROGRAMMING: PIC 16F8XX 18FXX 14FXX ARDUINO ...
I am an associate professor of electrical engineering I offer courses in everything related to the discipline of electrical engineering:
CPGE / BTS / DUT / IUT / DTS / UNIVERSITY / Technical high school
ARCHITECTURE OF A PROGRAMMED SYSTEM
INTERNAL AND EXTERNAL APPEARANCE
INPUT/OUTPUT MANAGEMENT
timeouts
timers, watchdog
PIC 16F8X 16F8XX PROGRAMMING
INTERRUPTIONS MANAGEMENT
ASSEMBLER PROGRAMMING
PROGRAMMING IN C
MACHINE CONTROL
SOFTWARE SIMULATION
MPLAB
MIKROC
ISIS/PROTEUS
Support course in Python (For all levels, CPGE)
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.