facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from48.43CAD/ 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 -04:00) New York
MonTueWedThuFriSatSun
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 C$48.43Online 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 -04:00) New York
MonTueWedThuFriSatSun
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 C$48.43Online 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.

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!

Nwafor
Comprehensive AI & Coding Guide: Teaching Generative AI (ChatGPT, Claude, LLaMA) with Python, React, Node.js, JavaScript & Beginner-Friendly
This course is designed to introduce students of all levels—ranging from young children to university students—to the exciting world of artificial intelligence and programming. Whether you're a beginner exploring coding for the first time or an advanced student eager to dive into AI development, this course provides a structured and engaging learning experience. What You'll Learn: ✅ AI & Generative Models – Understand and interact with AI models like ChatGPT, Claude, and LLaMA. ✅ Programming Foundations – Learn Python, JavaScript, and beginner-friendly coding concepts tailored for young learners. ✅ Web Development – Build interactive applications using React and Node.js. ✅ Prompt Engineering – Master techniques for crafting effective AI prompts to get the best responses. ✅ Hands-on Projects – Work on real-world projects that reinforce learning and creativity. What to Expect: 📌 Beginner-Friendly & Advanced Tracks – Tailored lessons for different age groups and skill levels. 📌 Interactive Coding Sessions – Learn by doing with engaging exercises and projects. 📌 AI-Powered Applications – Create your own AI-driven chatbots and web apps. 📌 Fun & Engaging Learning – A creative and dynamic approach to programming and AI. By the end of this course, students will have a strong foundation in coding, AI concepts, and web development, empowering them to build innovative projects and explore the future of technology. 🚀

Baia
Front-end development(Html, Css, Javascript, Vue.js, React.js) by professional and experienced developer
Are you ready to craft stunning, interactive websites that captivate audiences and elevate user experiences? Look no further than my dynamic Front-End Development course. From mastering HTML, CSS, and JavaScript to harnessing the power of cutting-edge frameworks like React and Vue, you'll acquire the skills needed to build responsive, intuitive websites that stand out in today's competitive market. But it's not just about learning code—it's about cultivating creativity. My methods fosters a collaborative learning environment where you'll engage in real-world projects, tackle challenges head-on, and refine your design sensibilities to create visually stunning interfaces that leave a lasting impression. If you are stuck with your project, or you want to kearn high-income, future skills, my Front-End Development course is your gateway to success. Enroll now and embark on a journey towards a fulfilling and rewarding career in tech!" For further details, please don't hesitate to contact me!

Yassine
Introduction to Robotics, Electronics and Programming
Discover the world of robotics, electronics, and programming with a course designed for technology and innovation enthusiasts. Whether you are a beginner or already have some basics, this course will guide you through the fundamentals, with a hands-on approach to designing your own projects. You will learn how to use electronic components, program microcontrollers, and assemble robots to perform autonomous tasks.

Gaëlle
AI for children: discover how to use artificial intelligence in English, French and Spanish
Would 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.

Antonio
Marketing, Promotion, Digital Optimization, and SEO
The course module is adapted to the student. You will earn: ▪️ An integrated digital marketing strategy based on your own organizational context. ▪️ Skills to effectively analyze and leverage data to make breakthrough data-driven decisions. ▪️ A future perspective on marketing and an overview of how to use emerging digital channels and technologies, such as artificial intelligence (AI) and chatbots, within your organization. ▪️ Accept the challenges and opportunities of disruptive technology in your digital marketing strategy.

Younes
Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!
With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible. Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning. As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.

Mahmoud
Computer Programing, Coding instructor, Data analyst, Web Development, Software engineer
I specialize in teaching web technology and data analysis for students at all levels, covering and i can learn children from 6 to 18 years old web technology( HTML, CSS, JavaScript, C#, ASP.NET MVC, API development, database management) data analysis( Excel, Power BI, SQL, and Python). My goal is to make complex concepts accessible and engaging, helping students build both foundational skills and industry-relevant expertise. I provide structured lessons with hands-on projects and assign exercises after each session to reinforce learning. Progress is closely monitored, with regular feedback provided to keep students motivated and improving. Whether you're a beginner eager to build your first web page, a student looking to analyze data effectively, or a budding programmer ready to create dynamic applications, my courses are tailored to your pace and goals. You'll develop real-world skills and gain confidence in a supportive learning environment designed to challenge without overwhelming.

Imad
Learn Python from A to Z (Algorithms, OOP, GUI TKinter...)
Python is a popular programming language. Thousands of businesses have built their websites with Python, including Google, Facebook, Dropbox, Instagram, and Reddit. Python is used for all sorts of tasks, such as building websites, gaming, site vacuuming, data analysis, machine learning and natural language processing, or even simple applications. The Python language is designed to be easy to read without sacrificing its power, which makes it a great language for beginners. Why should you learn Python? Python is easy to learn Python is a language of choice, i.e. for general use (application, games, website, etc.) Python is a versatile and cross-platform language Python has one of the most mature package managers Python is a commonly used language in data science Python is cross-platform and open source And the most important reason: If you want to add a language to your existing library, the demand for Python programmers is huge. To take this course you do not need any prerequisites, any development skills! It is also suitable for developers wishing to learn Python. If the adventure tempts you then join the participants who have already trusted me for their learning!!! Who is this course for? Anyone wishing to learn python. University students majoring in computer science. Development novices, because it is the ideal language to start Developers wishing to add a language to their skills

Azzedine
Maîtrisez NinjaTrader: Develop an expert in trading!
Get an expert in trading with NinjaTrader! If you are passionate about trading and souhaitez maitriser on one of the platforms of trading with more people in the market, this announcement is for you! If you are an expert in NinjaTrader, I offer you some training to help you get into this trading platform as an exception. If you want to use the trading manual or automate your strategies to use the C# language and other personal indicators, these configurations will guide you through the process. Advice for all Nivea traders, technicians, and experienced professionals, to see who you can attend: A training app for the use of NinjaTrader, comprenant of navigation in the interface, execution of orders and analysis of operations. Detailed instructions on the creation and optimization of automated trading strategies using the C# language. Conseils pratiques sur l'utilisation des indications personnalisés pour ajouter votre touche analytique et prendre des décisions de trading claires. If you want to generate additional revenues from trading or do trading activities at regular times, you will be able to prepare the necessary concierges and competencies to make profit from your financial markets. I hope you have the opportunity to develop a veritable expert in trading with NinjaTrader! Contact your maintenant to reserve your place and start your purchases over the successful financing.

Mathieu
Wordpress private lesson - From beginner to expert
With 7 years of experience as a developer in a Factory, I now develop Wordpress websites for large groups. In the training program, you will learn to: - Install, configure, and deploy WordPress sites - Develop custom Wordpress themes and plugins - Use powerful tools like ACF Pro, Gravity Forms, WPML, AIOS Security, WP rocket... - Create custom post types and tailor-made taxonomies - Develop pages using the right methods in HTML, CSS, Javascript & PHP - Administer and manage a site database - Contribute to the good natural referencing (SEO) of your site - Use WP-Cli to speed up the maintenance of your sites - Use Docker to containerize your local/prod projects and facilitate their management - Administer your WP sites the right way - And much more... For any questions, you can contact me by PM. See you soon, Matthew

Mazuba
Introducion to Programming with C++ Programming Language.
Take a deeper dive into programming with C++, a language known for its speed and versatility. This class focuses on understanding how code interacts closely with the hardware and teaches the principles of efficient and effective programming. What You’ll Learn: C++ basics: Syntax, variables, data types, and operators. Setting up C++ IDEs: Compilers and linkers. How C++ code is compiled, linked, and executed. Memory management and pointers: An introduction to dynamic memory.

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.

Amin
Programming with Python, with C and database management (Introduction to machine learning)
Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL (CPGE students). Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program. Additionally, upon request, we offer courses in other programming languages such as C, R, and MATLAB. Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs. If you have any questions, feel free to contact us.