Translated by GoogleSee original

Courses in SQL, ORACLE, Database, reporting

From 43.17 $ /h

SQL is the reference language for querying databases. It is used to update the database data.

- General diagram of a database.
- Principles of tables and relationships between data.
- The role of integrity constraints.
- Primary and foreign keys.
- Creation of a database.
- Creation of tables.
- Learn the different types of bases (integer, real, string, date).
- Modify the structure of a table.
- Deleting a table
- Data insertion (insert).
- The update.
- The deletion of information (delete).
- The select queries.
- Sort data
- Grouping and condition
- The joints.
- The views
- Stored procedures.
- The triggers.
- Constraints.

Extra information

a PC otherwise for the theory we will need only a paper: D

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Brussels, Belgium

Age

Children (7-12 years old)

Teenagers (13-17 years old)

Adults (18-64 years old)

Student level

Beginner

Intermediate

Duration

60 minutes

The class is taught in

French

English

Skills

Computer science

Reviews

Availability of a typical week

(GMT -05:00)

New York

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Renaud

5.0

(23)

Trainer for 10 years, I offer to support you in your learning of Illustrator software by working on concrete examples.

My experience as a trainer allowed me to sharpen my teaching techniques. I adapt to the level of the student to help him master the tools offered by this software.

Maria

5.0

(23)

Hello everyone !

Use 2 fingers to type a document or something else? this keystroke will consume you a lot of time!
The typing course that I propose will allow you to acquire a certain speed of typing without looking at the keyboard, because your fingers will recognize, by default, their places on the keyboard.
Do not waste time, learn to type quickly for your use!

Hela

5.0

(23)

I adapt my learning method according to subject and student. Some prefer to understand the whole theory before starting the exercises, others prefer to practice to better understand the theoretical part.
I strongly encourage the student because the state of mind and morale have a direct influence on school results.
I am an understandable person and I always try to take each one in his own way, to give remarks that facilitate the work, to give the tips and tricks necessary to have a good note.
I do exercises and exams corrected.
I always try to do my best to make the student fast able to handle his homework.

Anas

5.0

(23)

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Himank

5.0

(23)

Currently, I am working at the MaaS department in Denso Corporation, Shinagawa, Tokyo.
I have done my masters from the Indian Institute of Technology Hyderabad India recently.
I can teach any subject of Computer Engineering. I will give you class from very basic to advanced level.

I have cracked Graduate Aptitude Teset (GATE) in India and score AIR 1456 among 100000 students. I have in-depth knowledge of Computer Science subjects.

I can teach you coding, Science and Math if you wish to learn new things contact me.

This class is for those who really want to use to learn computer subjects like Computer Networks and Algorithms in a more innovative manner.

I can help you in deciding on your final year project in Computer Science Domain as well.

I little bit know Nihon-Go as well.

Robert

5.0

(23)

As a Franco-Belgian management teacher, I give Excel lessons with passion!
Whether remotely or face-to-face, I offer many examples and exercises to accompany you.
I travel without problem throughout the region of Brussels and its surroundings, for lessons of at least 2 hours. For France, courses are only given remotely.

Here are some key words that will be covered in my classes:
Scenario analysis, Year, Rounding, Today, Bdnb, Bdnbval, Bdsum, Search, Column, Copy/paste in values, Copy/paste with transposition, Consolidation, Date, Datedif, Determat, Dollar, Right, Righterg, Equiv, Esterror, Estna, Frequency, Filter (simple and advanced), Format of cells, Left, Large.Value, Printing of documents, Index, Indirect, Inversemat, Day, Weekday, Line, Matrix, Max, Maxa, Max.Si, Min , Mina, Mina.If, Formatting of cells and ranges, Month, Average, Average.If, Nb, Nb.If, Nbval, Naming of cells and ranges, No, Small.value, Product, Productmat, Protection of cells, Lookup (Lookup), Lookupv (VLookup), Lookuph (HLookup), If (If), If.Not.Disp, If.Conditions, Iferror, Sum, Sumproduct, Sum.If, Sum.If.Set, Substitute , Pivot tables, Sorting, Cell locking

Do not hesitate to contact me to organize your lessons according to your needs and availability. Together, we will develop your Excel skills in an efficient and personalized way.

Ilias

5.0

(23)

Are you dreaming of creating your own games, animations or interactive stories? This course aims to enagage learners regardless of their programming experience.

The course for beginners starts with a description of the interface and how you can import or create various backgrounds or objects. An introduction to basic command blocks follows, and as the course progresses, learners are given many opportunities to be creative, practise analytical and critical thinking, and combine various command blocks to add functionality to their programs.

The course also aims to foster effective communication, as learners have the opportunity to share their creations on Scratch community, receive feedback and exchange ideas with other members.

This course is suitable for children and teenagers.

Victor

5.0

(23)

Two types of courses are possible:

(1) On the one hand, support courses for the elderly. How to facilitate his access to his emails? How to configure your computer hardware? How to create a simple and robust IT environment over time.
(2) On the other hand, I teach programming to people who would like to discover this field. I can teach several programming languages, but Python is probably the one I recommend to start with.

Thanks to the Zoom software, possibility for me to unlock your computer problems remotely in case of emergency!

My accompaniment:

• Available H24, 7/7, via message/email outside of class to answer urgent questions, or to solve an unforeseen computer problem.
• Provide additional exercises if necessary.
• Possibility of giving lessons to two students at the same time if they are in the same class.

Valnor

5.0

(23)

💻 Learn IT easily with tailor-made support! 🚀
Do you want to improve your computer skills or discover the basics to better navigate the digital world? I offer courses adapted to all levels, whether you are a beginner or looking to improve.
🌟 Why choose me?
• Adapted teaching: I explain concepts in a simple and clear manner, even for novices.
• Personalized courses: Each session is designed according to your needs and objectives.
• Hands-on learning: Immediately apply what you learn.
📘 Areas covered:
• Introduction to computers (using the computer, browsing the internet, security).
• Office software (Word, Excel, PowerPoint).
• Introduction to programming (Python, HTML/CSS).
• Basics of data management and analysis with tools like Power BI.
🕒 Flexible hours: Classes available on weekdays or weekends, depending on your schedule.
📍 Modalities: In person or online, according to your preferences.
👉 Contact me now to start your adventure in the digital world!

Salomé

5.0

(23)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Ajay

5.0

(23)

I can teach mathematics (from primary to bachelor level), computer science, coding, and high school level physics.
Available to teach online/offline.
I make sure to adapt to the needs of the students, preparing specific exercises according to their knowledge and interest levels while not compromising on the learning aspects. I can also be flexible with the availability and timings so as to suit the needs of all concerned.
Born and raised in India; fluent in English and Hindi, currently learning French. I have been living in Brussels for more than a year now. I have Bachelor of Technology in Computer Science and a Master of Science (Mathematics) from India. Currently pursuing Master in Mathematics from KU Leuven (2nd year).
My dream is to become a high school teacher and I see tutoring as a big and important step in that direction.

Mohamed

5.0

(23)

This course provides a hands-on approach to mastering Apache Airflow, a powerful open-source workflow automation tool widely used in ETL (Extract, Transform, Load) processes. You will learn how to build, schedule, monitor, and optimize data pipelines, ensuring data reliability and efficiency in production environments. Through real-world examples and projects, you will gain the skills required to become a proficient Data Engineer capable of handling complex workflows in modern data ecosystems.

This course will allow you to build multiple real-world ETL workflows using Apache Airflow. Let me know if you would like additional information! 🚀

Said

5.0

(23)

Are you preparing for your Digital and Computer Science (NSI) exams and want to maximize your chances of success? "NSI Booster: Intensive Preparation to Shine in Your Exams!" is the course you need to revise effectively, fill in your gaps, and excel on the big day! This comprehensive and intensive program is specially designed for students in Première and Terminale to master all the key concepts of the NSI program and pass with flying colors.

Why choose this NSI preparation course?
Optimize revision time: Focus on the essential concepts to save time and revise efficiently.
Deep understanding of concepts: Don't just memorize, really understand the basics of computing to succeed in the most complex exercises.
Intensive practice: Practice with corrected exercises, exam questions and past papers to be fully prepared.
Exam Methodology: Learn how to manage your time, structure your answers, and avoid common NSI question pitfalls.
Confidence and serenity: Work in a progressive and structured manner to arrive calm on the day of the exam.
What you will learn:
This course covers the entire NSI program for Première and Terminale, focusing on the concepts most often covered in exams:

1. Algorithms and Programming:
Advanced algorithms: Algorithmic complexity, recursion, sorting and searching (quick sort, dichotomous sort).
Programming in Python:
Advanced syntax: list comprehension, lambda, decorators.
Data structures: lists, tuples, dictionaries, sets.
Functions and modularity: Decomposition of the problem, reuse of code.
File Management: Reading and writing files to process real data.
Object-oriented programming: Classes, objects, inheritance, polymorphism in Python.
Practical projects: Development of complete programs to apply the concepts covered.
2. Data Structures and Algorithms:
Lists, Stacks, Queues, and Trees: Implementation, Manipulation, and Use in Problem Solving.
Graphs: Representation (adjacency matrix, neighbor list), breadth-first (BFS) and depth-first (DFS) traversal.
Sorting and searching algorithms: Merge sort, quick sort, binary search.
Algorithmic complexity: Big-O notation, analysis of algorithm performance.
3. Databases and SQL:
Data modeling: Relational model, database design with the Entity-Relationship model.
SQL:
Select, insert, update and delete queries.
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).
Aggregate functions and subqueries.
Optimizing queries for better performance.
Practical projects: Creation and management of databases for concrete applications.
4. Computer and Network Architecture:
Hardware architecture: Processor, memory (RAM, cache), input/output devices.
Computer operation: Instruction cycle, execution of programs in memory.
Computer networks:
OSI model and TCP/IP.
IP addressing, routing, protocols (HTTP, FTP, SMTP).
Network security: firewall, encryption, VPN.
5. Web and Front-End Development:
HTML/CSS: Structure and formatting of web pages.
JavaScript: Dynamics of web pages, manipulation of the DOM, events.
Practical projects: Creation of interactive websites to apply the skills acquired.
Methodology and educational approach:
Targeted and structured revisions: Each module is designed to cover the key concepts of the NSI program while adapting to your level and your needs.
Practical exercises and exam questions: Practice with targeted exercises and past exam questions to familiarize yourself with the exam format.
Detailed correction and personalized feedback: Each exercise is corrected in detail with a thorough explanation of the solutions.
Exam methodology: Advice on how to read and understand the statements, structure your answers and manage your time on the day of the test.
Interactive Online Classes: Classes are conducted online with the use of audio and screen sharing, ensuring seamless communication and interactive learning.
For who ?
This course is aimed at:

NSI students in their first and final year of high school who want to pass their exams with intensive and targeted preparation.
Computer science students wanting to strengthen their foundations in programming and algorithms.
Self-taught people passionate about programming and computer science looking to deepen their knowledge.
Parents who wish to support their children in their academic success in computer science.
Why choose this course?
An experienced teacher: The course is led by a computer engineer with a perfect command of the NSI program, with a clear and motivating teaching approach.
An intensive and comprehensive program: Each concept is covered in depth, with varied exercises to practice all types of questions.
Personalized support: The content and pace of the course are adapted to your level and your objectives.
Flexibility and accessibility: Learn from home at your own pace, with additional resources to deepen your knowledge.
How does it work?
Initial assessment: A personalized assessment to identify your objectives and your starting level.
Interactive online courses: Learn from home with live explanations, demonstrations and practical exercises.
Intensive training: Series of exercises and past papers to prepare you for written and practical tests.
Personalized monitoring: Receive regular feedback on your progress and advice to continuously improve.
Register now !
Don't leave anything to chance when it comes to your NSI exams. Join "NSI Booster" for intensive and targeted preparation, and give yourself every chance of excelling in your exams!

Hanae

5.0

(23)

Hello! My name is Hanae, and I offer personalized lessons in English, Mathematics, and Computer Science for students of all levels — from primary school to university.

With over 10 years of professional experience in the tech and business world, I combine structured methods with a friendly and supportive teaching style to help students gain confidence and achieve their goals.

👩‍💻 In Computer Science, I teach programming basics (C language), digital logic, and software tools such as Power BI, Excel, and SQL.

Whether you want to improve your grades, prepare for exams, or strengthen your practical skills, my lessons are designed to make learning clear, engaging, and motivating.

Lessons can be given online or in person, and I always adapt the pace and content to the student’s needs.

Frédéric

5.0

(23)

Microsoft Office is now a virtually indispensable software suite for almost everyone, whether during our school years, through PowerPoint presentations, document creation with MS Word, calculations and graph creation in MS Excel, or during our professional lives. In the latter case, we need to get even more out of it in a minimum amount of time.

Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.

The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.

The sky's the limit :))