facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from25.78GBP/ 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.
I am Certified Professional Data Analytics Expert with extensive experience in Cognos, Oracle BI, 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. 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.
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.
Cognos report Studio is a web-based application designed to allow users to easily create complex reports utilizing many different sources of data. The purpose of this training guide is to introduce Report Studio. The course objectives are: • Access Report Studio • Identify key areas in Cognos Consumer • Explore Report Studio • Build and format queries in Report Studio

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 -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2            Saturday at 2:00  Sunday at 2:00
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5              
6            Saturday at 6:00  Sunday at 6:00
7            Saturday at 7:00  Sunday at 7:00
8            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 £25.78Online 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
  • 1 repeat student
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2            Saturday at 2:00  Sunday at 2:00
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5              
6            Saturday at 6:00  Sunday at 6:00
7            Saturday at 7:00  Sunday at 7:00
8            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 £25.78Online 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


Matías
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.

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.

Pingla
Passionate Educator: Unlocking Potential Through Tailored Tutoring
I am an experienced and qualified teacher and tutor with expertise in Mathematics, Afrikaans, English and other subjects. I hold a teaching degree as well as a 120 hour TEFL certificate and have over 5 years of teaching/tutoring experience across various age groups, including elementary, middle, and high school students. I have a proven track record of enhancing students' academic performance and building their confidence. My teaching philosophy emphasizes that every student can succeed with appropriate guidance, and I tailor my approach to meet individual needs, focusing on strengths and areas for improvement. Services offered include one-on-one tutoring, homework assistance, test preparation, study skills development, and customized lesson plans.

Ahmed
The field of computer science in general, whether theoretical, lectures or practical, as I am a doctor in the university, Department of Computer Science
All lectures or practical computer sciences in general, whether the university course or less, as I received an excellent grade in college and was appointed as a teaching assistant there, and now I am a doctor and I have a talent for conveying and simplifying information. I find myself able to convey information and explain it in a truly professional manner, in addition to my excellent practical experience.

Aymen
Programming: Introduction to Python (Beginner level)
In this class, you’ll embark on an exciting journey into the world of programming with Python. You’ll start by writing your very first Python program, gaining hands-on experience from the get-go. As you progress, you’ll delve into the core fundamentals of Python, including variables, data types, control structures, functions, and modules.

George
Python for beginners: Learn an amazing coding language!
Python is a very useful and dynamic coding language which is very useful to learn. I'm here to help you along your journey to learn the basic coding techniques and put them into practice. Even if my younger age of 17 I still hold an impressive knowledge of Python, using it for over 3 years! We will go over Python basics such as syntax reading and variable, and move up to some slightly more advanced techniques like loops and functions.

Divine
Introduction to JavaScript Programming, for Web Development
JavaScript is a versatile programming language that plays a crucial role in creating dynamic and interactive web pages. It's primarily used for client-side scripting, meaning it runs directly in the user's web browser, making it essential for building features like animations, form validation, and real-time updates. In this class, you'll learn the basics of JavaScript data types & functions, DOM manipulation, handling user interactions, asynchronous programming, familiarity with popular JS Libraries like jQuery, Node.js, and much more!

Abdelbast
Learn Latex from A to Z from installation to implementation
Join me for this exciting lesson as we explore the world of LaTeX, the perfect tool for creating professional, high-quality documents. We’ll start by learning how to install Latex on your computer, then we’ll get into the basics, like coding and formatting, and how LaTeX can make it easier for you to write organized, publishing-friendly articles and research papers. During the session, I’ll show you how to use different packages, how to insert mathematical equations, and how to design advanced charts and tables. The lesson will be presented in clear detail, with practical examples, so you can easily follow along. Don’t miss the opportunity to develop your academic writing skills and improve the quality of your work by learning LaTeX in an interactive and supportive environment.

Riadh
Introductory Course in Computer Science, Computer Networks and Telecommunications.
The course will cover the following points: - Office automation (Word, Excel) - Network administration - CCNA Training (This program provides the foundation for IT professionals who are familiar with the Cisco networks and operating systems) - Teaching network courses (LAN, MAN, WAN, TCP/IP protocols) - Practical work (Packet tracer) - Some notions on computer security

Viswambher
AI Mastery: Unleash the Power of Artificial Intelligence Tools
Are you ready to unlock the immense potential of Artificial Intelligence (AI) tools (ChatGPT, DallE, invideo etc.)? Join our tutoring class, "AI Tools Mastery: Harness the Power of Artificial Intelligence Tools," and dive deep into the world of AI technologies that are shaping the future to stay ahead of your competition. In today's fast-paced digital landscape, AI tools are revolutionizing how we approach problems, analyze data, and make decisions. This course is your key to mastering these AI tools and staying at the forefront of technological advancement. Throughout this course, we'll focus exclusively on AI tools, equipping you with the knowledge and practical skills needed to leverage these technologies effectively. Just as a photographer relies on Photoshop to enhance images, you'll learn to harness the power of AI tools to supercharge your projects and remain relevant in a rapidly evolving world.

Ayoub
Academic Excellence: Physics-Chemistry, Maths Courses
It is important to me to teach my students while adopting an active teaching method. I put all my experience acquired as a head teacher and also that of my academic career to the service of their success. - Mathematics - Chemical Physics, - Technology. My courses are aimed at students in the French system from 6th to 12th grade (Speciality: Mathematics, PC).

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.

Hamza
Support and strengthening lessons in mathematics, physics and computer science subjects
I hold a PhD in Mathematical Physics (Theoretical Physics), and I specialize in providing educational support lessons in physics and mathematics. I provide my services to high school and university students, and I have the ability to teach in French, Arabic, and English. Thanks to my eight years of experience in providing private lessons, I have developed a flexible teaching methodology that adapts to the needs of each individual student. With my experience of more than six years as a professor within the French Mission Program, I have mastered the requirements of this educational system and its special methods. My experience in the field of entrance examinations for graduate schools constitutes an additional advantage for students wishing to continue their studies in prestigious educational institutions. My passion for physics and mathematics and my strong academic background enable me to explain complex concepts in a clear and understandable way. My goal is to develop students' understanding academically and build their self-confidence, helping them reach their full potential. I am committed to providing high-quality education, tailored to each student's pace and learning styles, and I strongly believe that every student can excel with the right guidance and support.

Aniket
Oracle Certified Tutor/Trainer For Java, Python and Web with 300+ Reviews
- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

Benito
Python, SQL and/or Machine/Deep Learning Classes at your place or Online!
I am currently working as an online teacher 🧑‍🏫 and course content developer in Python, SQL 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 👉 Free support between lessons What topics do I usually cover at the beginning for people without Python/SQL experience? ✔️ Understanding the basic concepts (variables & types) --> Python/SQL ✔️ Math & Statistics (explained easily) --> Python ✔️ Data Manipulation (tables, dataframes, joins,...) --> Python/SQL What topics do I cover for people with Python/SQL experience? ✅ Classic libraries: Pandas, Numpy, Scikit-learn, Tensorflow, Pytorch ✅ Data Analytics/Visualization: Plotly, Seaborn, Matplotlib ✅ Domains: Regression, Classification, NLP, LLM, Computer Vision, Generative AI, Time Series, Neural Networks, Ensemble Methods ✅ MLOps: MLflow, Prefect, Mage, 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!😉