Add to Wish List
Add to Wish List
from48.52CAD/ 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.
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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from C$48.52Online 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 -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from C$48.52Online 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
Matías
Private coding / programming lessons with pythonPython 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.
Ayoub
Specialized Courses for Higher Education Students - CPGE, INSA, INP, ECE...This preparation session is dedicated to students aiming for preparatory classes for scientific Grandes Ecoles (CPGE), with a particular focus on the subjects of Physics and Engineering Sciences. The goal is to strengthen the foundations and deepen the knowledge to succeed.
1. Mechanics:
Kinematics: Study of rectilinear and circular movements, position vectors, speed and acceleration.
Dynamics: Newton's laws, work and energy, kinetic energy theorem.
2. Electromagnetism / Electrokinetics:
Electrostatics: Electric charges and fields, electric potential, capacitance.
Magnetostatics: Magnetic fields, Lorentz forces, electromagnetic induction.
Alternating Currents: RLC circuits, resonance, impedance.
3. Thermodynamics:
Principles of thermodynamics: Internal energy, heat, work, first and second principles.
Ideal and real gases: Equations of state, thermodynamic transformations.
4. Industrial sciences:
Automatic Linear, Kinematic, Static.
For more information and to register for the preparation session, please contact me.
Good preparation and success in your studies!
.
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.
Volodymyr
Programming and Applied Problem Solving, by a Cambridge GradFor whom:
- You have a University Class in Programming
- You are at School/Uni and want to get better at coding
- You have an assignment or need to write a program for your project but don't know where to start
What you will learn:
- How to think algorithmically
- How to better use AI/ChatGPT for your coding
- Leetcode
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.
Gaëlle
Code Your Way to Success: A Fun and Interactive Introduction to Programming for KidsIn 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!
Pavlos
Maths, Data Science and AI, Computer Programming, Physics classes – Online or In-Person. Mathematical and Engineering background.I hold two MSc degrees: the first in Mathematical Engineering from KU Leuven (Belgium) and the second in Industrial Engineering from Duth (Greece).
I offer courses on a wide variety of subjects, for Univerisity or High-school students, ranging from applied math
and artificial intelligence, up to physics, programming languages like python, C++ and Fortran.
In my teaching approach, I rely heavily on visual aids such as videos and illustrations to ensure that students get a clear understanding of the various concepts, along with personalized exercises.
Pingla
Passionate Educator: Unlocking Potential Through Tailored TutoringI 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.
Latifa
Mathematics, physics, Python and SQL courses: Middle school, high school & beginner programming levelMathematics:
Master the fundamental concepts: algebra, geometry, statistics and functions.
Solve complex problems to prepare for tests, exams or competitions.
Physics:
Understand the basic principles: mechanics, electricity, optics and thermodynamics.
Learn how to solve practical exercises and apply formulas effectively.
Python and SQL programming:
Python: Introduction to programming, algorithms, data manipulation and practical projects.
SQL: Introduction to databases, writing simple queries to extract and manipulate data.
This course offers detailed explanations, practical exercises and projects adapted to each level for optimal progress.
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
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!😉
Sally
Teaching programming in Scratch to children from beginning to professionalismHello
Hello, I'm Sally, a Software engineer and online Math and programming Teacher
With over 3 years of international tutoring experience using Zoom, Google Meet,
I offer tutoring services in
Teaching programming for Scratch
From the beginning to professionalism and developing complete games
Education will have levels of
* introduction
* define the tools and components of the program
* write the code
* control the game design
* implement a complete game
Note
A personal profile will be created for the child on the official Scratch website to display the games he has performed
The full explanation is online on Zoom.
A remote control is created for the student to implement the programming code himself and to control the entire device
Gaëlle
Maths for High achievers, in English, French or SpanishMaths classes for high achievers.
In this class we will build up your observation skills, logic and problem solving.
You will improve your calculations skills, logics and velocity.
Get to understand maths as a tool to understand and describe the world not as a subject.
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.
Mohamed
Computer science for beginners and those who are looking to start to learn csas an engineering student i learned for 3 semesters computer science and coding but at a basic level which you can use to make your own projects and starts your journey in the language of the future learning and gives you a starting step to start your cs path
Gaelle
Python Programming for beginners, power skills, logics, and practical knowledgeExplore the World of Coding with Python!
Are you curious about the exciting world of programming?
Join our Python programming class and embark on a journey into the realm of coding and computational thinking.
Python is a versatile and beginner-friendly programming language used by developers, data scientists, and tech enthusiasts worldwide. In this class, you'll learn the fundamentals of Python programming, from basic syntax to more advanced concepts. Our experienced instructors will guide you through hands-on exercises and real-world projects, giving you the skills you need to build your own programs and applications.
Whether you're a complete beginner or have some coding experience, our Python programming class is designed to accommodate all skill levels. By the end of the course, you'll have a solid understanding of Python and the ability to tackle coding challenges with confidence.
Join us and unlock the power of Python programming today! Get ready to code, create, and bring your ideas to life.