facebook
favorite buttonAdd to Wish List
favorite buttonAdd to Wish List
from29.72EUR/ 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.

Extra information

Bring your own Laptop

Location

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 – 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

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?"

Availability of a typical week

(GMT -05:00) Chicago
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  Monday at 6:00
  Tuesday at 6:00
  Wednesday at 6:00
  Thursday at 6:00
  Friday at 6:00
  Saturday at 6:00
  Sunday at 6:00
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
  
  
  
  
  
  
  
13
  
  
  
  
  
  
  
14
  
  
  
  
  
  
  
15
  
  
  
  
  
  
  
16
  
  
  
  
  
  
  
17
  
  
  
  
  
  
  
18
  
  
  
  
  
  
  
19
  
  
  
  
  
  
  
20
  
  
  
  
  
  
  
21
  
  
  
  
  
  
  
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from 29.72€Online 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.

Online reputation

  • Instructor since September 2023
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -05:00) Chicago
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
2
  
  
  
  
  
  
  
3
  
  
  
  
  
  
  
4
  
  
  
  
  
  
  
5
  
  
  
  
  
  
  
6
  Monday at 6:00
  Tuesday at 6:00
  Wednesday at 6:00
  Thursday at 6:00
  Friday at 6:00
  Saturday at 6:00
  Sunday at 6:00
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
  
  
  
  
  
  
  
13
  
  
  
  
  
  
  
14
  
  
  
  
  
  
  
15
  
  
  
  
  
  
  
16
  
  
  
  
  
  
  
17
  
  
  
  
  
  
  
18
  
  
  
  
  
  
  
19
  
  
  
  
  
  
  
20
  
  
  
  
  
  
  
21
  
  
  
  
  
  
  
22
  
  
  
  
  
  
  
23
  
  
  
  
  
  
  
from 29.72€Online 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


Salah Eddine
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.

Elizabeth
Program, Create, and Practice Spanish! Scratch and Scratch Jr. from Scratch (ages 5-18) 🚀💬
Would you like your children to learn programming 💻 while practicing their Spanish 🇪🇸? This is the perfect class for them! 🎯 I'm a programming and science teacher with over 10 years of experience, and I'm also a native Spanish speaker! I know how challenging learning a new language can be—I continue to perfect my English every day—so in my classes, I speak Spanish clearly and slowly, adapting to each student's pace. 🧠✨ In our sessions, we will learn to create games, interactive stories and creative projects using Scratch (ages 6-18) or Scratch Jr (ages 5-6), perfect tools to get started in the world of programming in a fun and educational way. 🎯 What do I offer? 100% individual and adapted classes. Learning programming from scratch. Continuous improvement of Spanish in a natural way. Creative projects that develop logical thinking and digital skills. Learning, creating, and practicing Spanish has never been so much fun! 🚀

Baia
Python & Django Development – From Beginner to Web App Developer
🚀 Learn Python and Django to Build Powerful Applications 🚀 Want to master Python and develop real-world web applications with Django? Whether you're a beginner or looking to enhance your coding skills, this course will guide you step by step! What You’ll Learn: ✅ Python Basics & Advanced Concepts – Learn syntax, data structures, OOP, and algorithms ✅ Django Framework – Build dynamic and scalable web applications ✅ Databases & APIs – Work with PostgreSQL, SQLite, and REST APIs ✅ Project-Based Learning – Apply concepts through hands-on coding and real projects ✅ Debugging & Best Practices – Learn clean coding principles and error handling 🔹 Who is this course for? Complete beginners who want to start coding with Python Developers looking to transition into backend or full-stack development Students and professionals who want to build their own web applications 💻 Class Format: - Live online sessions via Google Meet - Interactive coding exercises & projects - Personalized guidance based on your level 📩 Contact me to start your Python & Django journey today!

Hasmik
Class of statistics, computer programming, R programming
I am a graduate in data science with R programming skills. I am able to help the students with assignments, and analysis with their master thesis. My approach is very student-oriented and I explain the subjects in a detailed way so that the students understand the main idea.

Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and Frameworks
What 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.

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
Code Your Way to Success: A Fun and Interactive Introduction to Programming for Kids
In this class, kids will learn the fundamentals of programming and computer science in a fun and engaging way, and discover how these hard and soft skills can be used in their personal and future professional lives. Through interactive lessons and hands-on projects, kids will explore the world of code and create their own digital creations. Throughout the course, they will: Learn the basic concepts and terminology of programming Experiment with different programming languages and platforms Create simple programs and apps using code Collaborate with peers and share their creations Develop problem-solving skills, logical thinking, and other valuable skills that will be useful in any field By the end of the class, your children will have the knowledge and confidence to continue exploring the exciting world of programming and computer science and will understand how code can be a powerful tool for achieving success in any field. They'll be able to choose the job they want in the future or even build their own company. So, join us and code your way to success!

Izhar
C Language -- Computer Language Course by a trained professional having Master's Degree in Computers.
Do you want to start your career in coding? There are excellent chances of growth in this sector. Do you think it'll be tough to learn this language. No! Not at all! I am an expert in C language having practical work experience. I'll start from the scratch, strengthen your basics and help you to master this language. I am providing you a brief summary of our course which we generally follow but that doesn't mean that I am bound to just this much content. In case you have any doubt for any other specific topic related to the subject, you could always come up to me or you need any help in your assignments or projects, you are always welcome. Here is a brief summary of our course : –Introduction to Programming –Fundamentals in C –Operators and Expressions –Data types –Input-Output Library Functions –Control statements –Function –Storage class –Pointer –Pointer and Function –Array –Pointer and array –Array and function –Dynamic memory allocation –String –String and function –Command line arguments –Preprocessor –Structure –Structure and function –File Handling –ODBC Programming –Process and threads –Graphics In case you have any query, feel free to contact me. Give yourself a chance for a better future. All the best

Jawad
Polytechnician (X) on Master's internship at EPFL gives mathematics lessons at all levels
I am currently an engineering student at the École Polytechnique de Paris and am currently completing my Master's program at EPFL in Lausanne. I offer private mathematics lessons, both in person in Lausanne and online, to high school students and university students (Bachelor's degree). I acquired solid teaching experience through a 6-month internship in colleges and associations (tutoring, homework help, co-facilitating exercise sessions), as well as by regularly giving private lessons. My method My goal is to support each student in a personalized way: understanding of fundamental concepts, strengthening acquired skills, working methods, exam preparation, etc. I adapt to the level and pace of each student, combining rigor, pedagogy and kindness. Typical course outline A class typically begins with a discussion to identify current challenges or goals. We then review key concepts and put them into practice through progressive exercises. I also offer additional materials if needed, and a brief debriefing at the end of the session. What I propose ✅ Mathematics courses in Lausanne (in person) or remotely ✅ For high school students or EPFL students / Bachelor in science or engineering ✅ One-off or regular monitoring (refresher courses, revisions, exams, projects, etc.) ✅ Available weekdays from 6 p.m. and all day on weekends

Pr YSF
Electronics, Control of industrial systems, C/C++ VHDL programming, digital and analog electronics, MATLAB simulation
Hello, I am a doctoral student in electrical engineering and associate professor in engineering sciences, experienced in the field of electrical engineering, I offer support courses in the subjects of engineering sciences (Electronics, automatics, electrical engineering, automation, programming). Digital electronics Analog electronic electromagnetism (propagation of high frequency waves) Automatic (continuous, sampled) electrical engineering (transformers, electrical machines, switching power supply) C / c ++ programming, Assembler, ARM, STM32 renewable energy (wind, PV) engineering Sciences RDM Python,VHDL PIC Microprocessor and Microcontroller Signal processing and data acquisition Engineering Sciences These courses allow the student to get up to speed and regain confidence in all scientific subjects, just as they prepare him effectively for the Baccalaureate, the Preparatory Classes or various examinations of the engineering classes. COURSE OBJECTIVES AND PEDAGOGICAL APPROACH Resumption and deepening of fundamental concepts through exercises with course reminders. Put the student in a situation of questioning and research. Respond to individual issues and questions Exercise training in order to achieve real mastery of the content. Learn to build theoretical reasoning from observable facts or hypotheses. Specific preparation for higher education requirements (in-depth content, increase in work capacity, enrichment of scientific background) This educational approach is effective since it has often led me to interesting results with my students. Associate professor provides support courses in electrical engineering

Dishant
Python, C, C++, Java Programming Classes for Computer enthusiats
Welcome to my immersive - Programming Bootcamp, a comprehensive journey designed to empower you with one of the most versatile and in-demand programming languages of our time! Python and Java stands at the forefront of the technological revolution, fueling advancements in artificial intelligence, automation, and web development. Whether you’re an aspiring developer or a student of any level preparing for exams, this bootcamp is crafted to give you the knowledge and confidence to excel. Starting from the very basics, I’ll guide you through every essential topic with a detailed, hands-on approach. Each session is structured to build a solid foundation, gradually progressing into more advanced concepts to ensure your learning is smooth, intuitive, and rewarding. My commitment to your satisfaction and understanding is absolute—I take pride in creating an environment where every question is welcomed, each concept is clarified, and no one is left behind. With clear explanations and patient guidance, I’m here to help you achieve mastery step by step. The bootcamp doesn’t stop at theory. To make learning meaningful and memorable, I’ve integrated real-world projects that bring to life. You’ll apply your skills in practical scenarios, tackling hands-on projects that simulate industry challenges. By the end, you’ll have a portfolio of applications showcasing your proficiency, making you well-prepared for real-life tech opportunities. With an emphasis on clarity, relevance, and personalized support, my goal is to ensure that your learning experience is both empowering and enjoyable. Whether you’re seeking to advance in your career or simply unlock new skills, I’m here to make this journey as impactful as possible. Join me in this Bootcamp, where your growth and success are my highest priorities, and take the first step toward unlocking your potential in the world of programming.

Muhammad
Your Computer Science Instructor: From Basics to AI & Beyond
Computer Science is more than just code—it's the foundation of innovation in today's world. In this comprehensive live class, I’ll guide you through everything from the basics of Computer Science to Object Oriented Programming (OOP), Data Structures & Algorithms (DSA), and advanced computing concepts. We’ll cover: Core Programming Languages: Python, C, C++, Java, JavaScript, and more AP Computer Science Preparation Hands-on Project Development Artificial Intelligence, Data Science & Machine Learning I can teach in my own structured style or fully adapt to your preferred curriculum, pace, and goals—whatever helps you learn best. Whether it’s exam prep or real-world projects, we’ll build your Computer Science skills your way.

Mohamed
Artificial Intelligent _ Machine Learning _ Neural Networks using Matlab
Neural 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.

Ephraim
Python 101: Master the Language of Programming, From Basics to Advanced Concepts
In this course, you'll learn Python from the ground up, starting with the basics and progressing to more advanced concepts. You'll gain hands-on experience writing Python code, working with data structures, and using libraries to solve real-world problems. By the end of the course, you'll be confident in your ability to write Python programs, automate tasks, and tackle challenges in various domains.