Add to Wish List
Add to Wish List
from32.34EUR/ 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 32.34€Online 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 32.34€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
You are here
Similar classes
Amin
Statistical Analysis with Python and R (Rstudio) - Intro to Data ScienceBy delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.
Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.
We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.
If you have any further questions, please do not hesitate to contact us.
Ayoub
Boost your results in Physics-Chemistry and MathematicsIt 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).
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.
Mazuba
Complete IGCSE Computer Science & ICT: From Basics to Advanced ProgrammingThis course is tailored for IGCSE Computer Science and ICT students who want to master all the key topics in their curriculum. With a focus on practical programming skills, theoretical computer science concepts, and hands-on problem-solving, this class will guide you through the essential topics covered in the IGCSE syllabus. Learn the fundamentals of data representation, hardware and software, databases, and Boolean logic, and then build on those concepts with programming and algorithm design. Gain a deep understanding of the inner workings of computers and their applications in real-world scenarios.
By the end of this course, you will have a solid understanding of key computer science concepts and the practical skills to succeed in your IGCSE exams and beyond.
What You’ll Learn:
Data Representation: Learn how computers represent and process data, including binary, hexadecimal, and conversions between number systems.
Data Transmission: Understand how data is transmitted over networks, focusing on packet switching, USB, and data packets.
Hardware & Software: Gain a foundational understanding of computer hardware components and the role of software in running programs.
Boolean Logic: Explore logic gates, truth tables, and Boolean expressions, and apply them to solve complex problems.
Algorithm Design: Learn to design algorithms and solve problems using effective computational methods.
Programming: Master the basics of programming with hands-on coding in Python, C++, and C#.
Databases: Understand database structures, SQL queries, and primary keys. Build single-table databases and learn data management techniques.
Adam
Introduction to Python: Programming Basics and Simple ApplicationsThis course is designed for beginners who want to get started with programming in Python, one of the most popular and accessible languages today. No previous experience is necessary. In one session, students will learn the basics of programming and will be able to create their first Python applications. With clear explanations, practical exercises, and real-world examples, this course is an ideal gateway to exploring computer science and coding.
Online Course: Introduction to Python - Programming Basics and Simple Applications
Duration :
- 60 minutes: intensive format to learn fundamental concepts.
- 90 minutes: In-depth format with more time for practical examples and interactive questions.
---
Educational objectives
At the end of the course, participants will be able to:
1. Understand the basics of programming, including the concepts of variables, data types, conditional structures, and loops.
2. Write and run simple Python scripts.
3. Manipulate inputs and outputs to interact with the user.
4. Solve practical problems with short, functional programs.
---
Course syllabus
1. Introduction (10-15 min)
- Presentation of Python: Why this language?
- Installation and configuration of a programming environment (IDLE, Visual Studio Code, or Jupyter Notebook).
- First program: *"Hello, World!"*.
2. Python Basics (20-30 min)
- Variables and data types (integers, strings, lists).
- Mathematical operations and data manipulation.
- Conditional structures (if/else) and loops (for/while).
3. Practical exercises (20-35 min)
- Write a program to calculate the sum of two numbers provided by the user.
- Create a simple application, like a currency converter or password generator.
- Bonus for 90 min format: Fixed a more complex issue involving lists or loops.
4. Q&A and conclusion (5-10 min)
- Summary of the concepts covered.
- Suggestions for resources to continue learning.
- Feedback on the course.
---
Teaching methodology
- Interactive and engaging: the course combines theoretical explanations with practical exercises.
- Personalized approach: Sessions are tailored to the needs of participants. Students are encouraged to ask questions at any time.
- Learning by doing: examples and exercises are designed to help you assimilate concepts quickly.
---
Target audience
This course is ideal for:
- Complete beginners in programming.
- Students or professionals wishing to acquire skills in Python for their personal or professional projects.
- Anyone curious to discover a powerful and versatile tool for solving problems.
---
Benefits of this online course
- Teaching by an experienced and passionate trainer.
- Interactive sessions adapted to your learning pace.
- Access to educational materials and exercises to continue practicing after the course.
Join us now to discover programming and its applications using Python!
---
Mouncef
Learn Python, Artificial intelligence with me until you become an expertThis Python course teaches you the basics of programming in Python, including variables, data types, operators, control structures (if, for, while), functions, and lists. You will also learn how to manipulate data with libraries such as Pandas and NumPy, create graphs and visualizations with Matplotlib and Seaborn, and even develop simple web applications with Flask or Django.
Pr YSF
Electronics, Control of industrial systems, C/C++ VHDL programming, digital and analog electronics, MATLAB simulationHello, 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
Nancy
Mathematics, Computer Science and Python Tutor for youMany of students find it difficult to understand the mathematical concepts and programming algorithms. But don't worry as I know how to make that easy for you to understand these concepts.
I have completed mathematics honors and pursuing data science and Artificial Intelligence. So, what all you need is my support to ease your learning.
I can help you in any mathematical and computer science concept. Also, I am very familiar with Python
Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions
Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...
Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.
Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...
I am waiting for your message.
Ron
American Harvard and Yale Educated Tutor - Click “Request a Booking” to Book a ClassI am an Ivy League educated tutor ready to help you learn computer science to achieve higher exam scores, gain admission to top universities and advance your career.
I encourage students to explore topics they enjoy and strive to make each lesson entertaining. Learning should be fun, so my approach expands students' horizons, increasing their creativity so they realize their potential.
Please click “Request a Booking” to book a class.
Youness
ASSOCIATE PROFESSOR I TEACH: MICROCONTROLLER PROGRAMMING: PIC 16F8XX 18FXX 14FXX ARDUINO ...I am an associate professor of electrical engineering I offer courses in everything related to the discipline of electrical engineering:
CPGE / BTS / DUT / IUT / DTS / UNIVERSITY / Technical high school
ARCHITECTURE OF A PROGRAMMED SYSTEM
INTERNAL AND EXTERNAL APPEARANCE
INPUT/OUTPUT MANAGEMENT
timeouts
timers, watchdog
PIC 16F8X 16F8XX PROGRAMMING
INTERRUPTIONS MANAGEMENT
ASSEMBLER PROGRAMMING
PROGRAMMING IN C
MACHINE CONTROL
SOFTWARE SIMULATION
MPLAB
MIKROC
ISIS/PROTEUS
Usman
Cambridge IGCSE/O Level/As Level/A Level/Edexcel/IB ICT and Computer Science🎉 Welcome to Awesome Math Adventures with Usman Ashraf! 🎉
Hey there, future math whiz! 📚✨ Are you ready to embark on an exciting journey through the world of numbers, shapes, and problem-solving? Join our IGCSE and O-Level Math class, where learning math is fun, interactive, and super rewarding!
Amine
Mathematics support course for secondary school.Recently graduated from EPFL in communication systems, I would be happy to consolidate your knowledge and provide you with assistance in the fields of mathematics and programming/algorithmics.
We can work together on exercises that are worrying you, or I can select several for you that would target your shortcomings in order to eliminate them. I want to impart an understanding and appreciation of mathematics.
Mathieu
Wordpress private lesson - From beginner to expertWith 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
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.