

from28.91CHF/ 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 28.91FrOnline 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 28.91FrOnline 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
Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is WelcomeMaster 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.
Arianit
MATLAB Programming (Modelling, Simulation, Control Systems)Struggling with MATLAB? Whether you're a beginner or tackling advanced simulations, our one-on-one online tutoring is here to help you master MATLAB step-by-step. We offer personalized lessons tailored to your level, covering:
Basics of MATLAB programming
Data analysis & visualization
Numerical methods & simulations
Signal processing & control systems
MATLAB for engineering, math, and science courses
Help with assignments, projects, and exam prep
Abdelrhman
Computer programming in Python, artificial intelligence, and machine learningBy the end of this lesson, the learner will be able to:
Getting to know the Python language
Understand what Python is and its most important uses.
Distinguishing Python from other programming languages.
Preparing the work environment
Install and run a Python development environment (such as Python IDLE or VS Code).
Running your first Python program.
Dealing with variables and data types
Defining and dealing with variables.
Understanding different types of data
Use input and output operations (input() and print()).
Perform arithmetic and logical operations.
Understanding the basic structures of programming
Using if-else statements.
Applying loops (for, while).
Working with functions in Python
Following naming and commenting conventions in Python.
Huzaifa Muhammad
LATEST Next-Gen Python-3 Programming: From Fundamentals to MasteryABOUT THE LESSONS
- Tailored according to your skill level
- Latest version of python
- Extremely interactive
TAKEAWAYS
- Well-structured Notes
- Programming Problems of all levels with Solutions
- Lecture Recording
- Complete Roadmap
ABOUT ME
- Five years of experience in Python Programming
- Worked on several real-world Python projects
- Have the ability to break down complex Python concepts in simple words
- Have the ability to explain Python on any level
PYTHON
I can teach you:
- concepts at a deep level of understanding
- how to use python for practical applications
- how to solve programming problems using python
- data structures and algorithms in python
Albert
Mathematics, Physics & Programming Tutorials, High School + UndergraduatesAre you a high school or high school student and have difficulty understanding and solving math or physics problems? Then I am someone who would like to help you with that. I often see that in standard classroom teaching is succinctly taught. As a result, the student misses out on the whole picture, making the teaching material and the problems vague and unclear. My goal is to take the time for each student to complete the whole picture and guide them through complex problems, so that the student can not only take tests and exams with ease, but also enjoy learning the material.
Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and FrameworksWhat You Will Learn:
Core Principles: Introduction to programming, algorithms, and data structures to build a strong foundation.
Advanced Libraries and Frameworks: NumPy, Pandas, and Django to create web applications and perform efficient data analysis.
Practical Projects: Real-world applications to strengthen your skills and build an impressive portfolio.
How You Will Benefit:
Students: Gain the necessary skills to excel in academic projects and lay the groundwork for your career.
Self-Taught Learners: Avoid common mistakes and fast-track your progress with clear, hands-on guidance.
Professionals: Enhance your skill set to meet industry demands and open up new career opportunities.
Why Choose My Courses?:
Personalized Approach: Each course is customized to your level and learning pace, ensuring tailored guidance and support.
Theory and Practice: You’ll combine theoretical concepts with hands-on exercises for a comprehensive and lasting understanding.
Solving Real-World Problems: Learn how to tackle the common challenges faced in programming, from debugging to performance optimization.
Baia
Master Front-End Development | Build Stunning Websites with HTML, CSS, JavaScript & ReactAre 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!
Mohamed
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!
Rony
Learn App Development for Teens! Features three fun beginner, intermediate and advanced levels!Empower young minds to create their own mobile apps with this fun and interactive course! Designed for children aged 9 to 13, this course introduces app development using MIT App Inventor, a beginner-friendly platform that makes coding easy and exciting. Students will learn the basics of programming, user interface design, and problem-solving as they build their own functional Android apps. Through hands-on projects and creative challenges, they will develop logical thinking and digital skills while bringing their ideas to life. No prior experience is needed—just curiosity and a passion for technology!
Gaëlle
AI for children: discover how to use artificial intelligence in English, French and SpanishWould you be interested in learning how to use Artificial Intelligence in your daily life? In my AI classes for kids, you will learn how to use this advanced technology in a practical and fun way!
During our sessions, we'll explore different ways AI can improve our everyday lives, from shopping online to playing video games. In addition, you will learn to code and create your own AI applications.
My classes are suitable for children from 8 years old and are held online via video calls. No previous programming experience is required!
If you are interested in learning about AI and how to use it in your life, feel free to contact me! I'm looking forward to teaching you everything I know about this amazing technology.
Younes
Master Python at All Levels with Personalized Lessons - SUP SPE Program includedStart with the fundamentals like variables, loops, and conditionals, and progress to more advanced concepts including manipulating files, images, and using Python libraries like Numpy, Scipy, Pandas, and Matplotlib. Also explore the fundamentals of object-oriented programming.
Why choose this Course?
By opting for these courses, you will have the opportunity to consolidate your knowledge through practical exercises and concrete mini-projects which will strengthen your Python skills. Each session will be interactive, allowing you to ask questions and receive constructive feedback on your code.
You will be able to benefit from personalized support. Lessons are tailored to your level, whether you're looking to pursue a career in programming or just want to learn for fun. Sessions are tailored to your goals, and ongoing support is provided to overcome any challenges you may encounter.
Benito
Python and/or Machine/Deep Learning Classes at your place or Online!I am currently working as an independent consultant, technical writer, online teacher 🧑🏫 and course content developer in Python, and a wide range of Machine/Deep Learning topics 🧑💻. My experience enables me to offer lessons ranging from beginner to advanced levels. I can tailor the classes to your specific needs and schedule, providing a well-structured learning path 🚀.
What do you get from me?
👉 Learn at your own pace without any pressure
👉 Well-documented tutorials
What topics do I usually cover at the beginning for people without Python experience?
✔️ Understanding the basic concepts (variables & types)
✔️ Math & Statistics (explained easily)
✔️ Data Manipulation (data cleaning, preprocessing...)
What topics do I cover for people with Python experience?
✅ Classic libraries: Pandas, NumPy, Scikit-learn, TensorFlow
✅ Data Analytics/Visualization: Plotly, Seaborn, Matplotlib
✅ Domains: Regression, Classification, NLP, LLM, RAG, Computer Vision, Neural Networks, Ensemble Methods, Clustering, Dimensionality Reduction
✅ MLOps: MLflow, Prefect, GCP, AWS
Whether you are new to the field, seeking to enhance your skills, or require assistance with a work/school project, feel free to reach out to me! 😉
Mahmoud
Explaining the basics of programming and artificial intelligence for children using Scratch and PythonExplaining the basics of programming and artificial intelligence for children using Scratch and Python
To teach kids the basics of programming and artificial intelligence using Scratch and Python, start with simple concepts with fun applications:
Scratch:
Introduce kids to visual programming using colorful blocks.
Start with projects like creating an interactive story or a simple game.
Teach them concepts like loops, variables, and conditions using animations.
Python:
Python is introduced as an introduction to scripting.
Use easy libraries like turtle to draw or random to create random games.
Introduce them to AI with a library like Teachable Machine to easily classify images or sounds.
Practical example:
Create a simple game in Scratch, then use Python to develop a similar game to illustrate the difference between visual and textual programming.
Mohamed
Artificial Intelligent _ Machine Learning _ Neural Networks using MatlabNeural Network is a powerful machine learning tool used for classification & prediction. It works as function approximation from experienced data of inputs and outputs entered to the training process to create the model. The concept of neural network can be thought theoretically by mathematics, but the course will include also a practical coding using Matlab Software.
Mouad
Support course in Python (For all levels, CPGE)Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills.
The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching.
With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career.
Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.