Translated by GoogleSee original

Courses in SQL, ORACLE, Database, reporting

From 36 € /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 -04: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

(24)

Trainer for 10 years, I offer to support you in your learning of Photoshop 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.

Zidene

5.0

(24)

Graduate computer engineer offers an individualized pedagogy, professional training, assistance with the preparation of interrogations or exams. My goal is to advance the student without overburdening him. I give practical tests after each lesson and periodically provide progress reports.
Here is the list of courses I propose:
- Programming: JAVA, J2EE, C, C ++
- Web: HTML, PHP, CSS, JAVASCRIPT
- Data base
- Operating systems: Windows, Linux ...
- Software ...

Maria

5.0

(24)

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

(24)

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

(24)

>>> 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

(24)

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

(24)

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

(24)

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 intended for teachers who want to use Scratch in the classroom.

Adam

5.0

(24)

Master the Requirements of Higher Education and Competitive Exams
The transition to higher education (preparatory classes for the Grandes Écoles, first year of university, BUT, PASS) often represents a major leap in quality. Expectations change, the pace quickens, and abstraction becomes the norm. With over 35 years of experience, a PhD, and a State Engineering Diploma, I support students in succeeding in their competitive exams and validating their semesters by providing them with the essential methodology and rigor.

Expertise and Analytical Methodology
At this level, understanding the course material is no longer enough; you must be able to apply it to new problems. We will work directly from your tutorials, lectures, and exam questions to structure your thinking.
The topics covered include:

Analysis, Linear Algebra and Matrix Calculus.

Descriptive statistics, probability, estimation and hypothesis testing.

Functions, optimization and methodology of scientific writing.

The goal is to go beyond simple calculation to build a solid, autonomous mathematical reasoning adapted to the expectations of examiners for competitions and midterms.

Work Environment and Involvement
Studying advanced mathematics remotely requires impeccable technical organization. Therefore, it is essential to specify that the course is conducted via webcam and videoconference with screen sharing. The use of an interactive whiteboard allows us to work through each step of your proofs together in real time.

Preparing for university exams demands total and immediate commitment. Therefore, a first trial lesson or a brief webcam exchange doesn't reflect the intensity of the work required. We get straight to the point and begin a full work session from our very first connection.

Support Formats

60-minute session: The ideal format to unlock a complex tutorial exercise, target a concept of abstract algebra or prepare for a quiz (oral exam).

90-minute session: The recommended format for intensive preparation for midterms, complete treatment of a past exam topic or refresher course on an entire module.

I would be delighted to give you the tools to structure your thinking and excel in your higher education studies.

Victor

5.0

(24)

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.

Mohamed

5.0

(24)

Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.

What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL

Hanae

5.0

(24)

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

(24)

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 :))

Aymane

5.0

(24)

Programming courses for beginners and intermediate learners.
Learning computer logic, the basics of coding and putting it into practice with exercises and mini-projects.
Personalized support according to the student's level.
Opportunity to move towards web or mobile development with a concrete and practical approach.

Caroline

5.0

(24)

The world around us is becoming increasingly digital, and artificial intelligence is playing a growing role in our everyday lives. Yet, it is not always easy to understand how these technologies work or how to use them effectively.

I have a degree in Business Engineering and Information Systems and currently work as a Data Scientist. I am also interested in application development, programming, and artificial intelligence more broadly. Through my courses, I would like to share my knowledge in a simple, practical, and accessible way, adapted to each learner.

The lessons are fully personalized according to your level, goals, and interests. For example, we can:
- introduce a child or teenager to programming;
- learn the basics of programming or explore more advanced concepts;
- discover artificial intelligence and understand how it works;
- learn how to use tools such as ChatGPT or Claude effectively;
- or simply become more comfortable using computers, smartphones, and digital tools.

No prior knowledge is required. Whether you are a complete beginner, already comfortable with technology, or simply curious to learn more, we can create a course together that matches what you want to learn, at your own pace.