Ayoub
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from38.72CAD/ h

SQL relational databases (oracle, mysql, sql server ...)

Translated using Google Translate. Click to view original.
A relational database is a collection of data organized as formally defined tables, from which data can be accessed and assembled without having to reorganize the tables in the database.

Relational databases are the most used in the software industry around the world, in this course I will explain exactly how to manipulate data in an RDBMS in an optimal way, how to connect an application with a data store of your choice and I will answer all your questions in detail.
Yours truly.

Location

At teacher's location: Maarif, Casablanca, Maroc
At teacher's location: Hôtel de Ville, Marseille, France
At teacher's location: Societe Du Patrimoine Urbain, Québec, QC, Canada
At teacher's location: Paris, France
Online via webcam

|
Use ⊞+wheel to zoom!
+

General info

Skills:
Age:
Children (7-12 years old)
Teenagers (13-17 years old)
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:French, Arabic, English

About Me

Translated using Google Translate. Click to view original.
I am a computer engineer with 2 years of experience in the software industry.

From my point of view, learning is done by doing. It is therefore on this key element that each of my courses is based. To give you an example, each session begins with the recap of the previous one. The student is then invited to perform one or more exercises varying according to the level. They are guided and all can be modified if necessary. The session ends with ten questions and answers allowing me to prepare for the next class. This method has been and continues to prove itself.

- My goal is to support or train you on the basis of IT but also on programming languages.

- I can train you on the basics of IT but also teach you the best practices of the IT profession. My tips and advice will be your allies in your career as a student or professional.

- I can also teach you front-end languages if necessary and teach you the good development methods.

We can therefore see together:
- Machine language (Binary / Hexadecimal)
- The Basics of Programming Languages (Java, Python, C #, C)
- Initiation to the algorithm
- UML modeling
- Object oriented concepts
- Unit and integration tests
- Test driven development (TDD)
- Databases (SQL)
- Application development
- Creation of mini-games
- Web concept and front language (HTML / CSS)

Do not hesitate to contact me and I can teach it to you!

Education

Translated using Google Translate. Click to view original.
Engineering degree: Faculty of Science and Technology Mohammedia, Morocco
Professional license diploma: Higher School of Technology Essaouira, Morocco

Experience / Qualifications

Translated using Google Translate. Click to view original.
- Research and development engineer in a multinational company.
- Contribution in open source
- Teaching

Reviews (3)

Ayoub is a calm and thoughtful tutor who really cares about our difficulties (me in JAVA). He helped me through my final exams and I would highly recommend!
Disponibilité, ponctualité avec une pédagogie permettant à tout apprenant de mieux comprendre .
Bonne compréhension du cours
Building web applications with Java EE seems complicated to many newbies. A huge nebula of acronyms of all kinds revolves around the platform, a significant number of different technologies and approaches exist: servlet, JSP, Javabean, MVC, JDBC, JNDI, EJB, JPA, JMS, JSF, Struts, Spring, Tomcat, Glassfish, JBoss, WebSphere, WebLogic ... The list does not end, and for a novice not to suffocate under such an avalanche is often mission impossible! The objective of this course is to guide your first steps in the Java EE universe: after a few explanations on the general concepts and the good practices in force, you will get to the heart of the subject and discover how to create a web project, by adding complexity as the course progresses. At the end of the course, you will be able to create a web application that respects recognized standards in the field and you will have the basics necessary to use most technologies based on Java EE.
Object-oriented programming is a model of programming language that revolves around objects and data, rather than actions and logic. The challenge of programming was to write the logic, not to define the data. Object-oriented programming has changed the perspective: what matters is the objects to be manipulated rather than the logic required for this manipulation. In this course, we will try to describe what object-oriented programming is (often abbreviated as OOP). We will try to get to the point and stay close to the practice.
👉 I offer distance learning courses, programming languages such as JAVA, Python, C #, C ... from basic to advanced level, individual or small group 📌 With nearly 2 years of experience as a Full Stack Developer, I participated in many projects in several different fields for French, American, Australian clients, ... I hope to bring you not only the theoretical knowledge but also practical experiences drawn from my personal experiences. 💯 The program based rather on the practical applications side will give you the opportunity to acquire knowledge, practice and hone your skills in the most comprehensive way! ⏰ Study time: weekday evenings from 8:00 a.m. and weekends 📨 Those with any needs don't hesitate to message me for specific study program advice
Computer programming is one of the most popular jobs in the market today. in this course you will learn the basics and paradigms of computer programming. whether you are a beginner or an intermediate, we are going step by step towards a deep understanding of the different notions of programming. A session can take several forms: - Explanation of the school course and answers to questions - Applications and exercises - Make copies of the exams (that the student brings them with him) My goal is to help the student get used to solving problems on their own. be motivated, be curious!
Elasticsearch is a NoSQL database whose particularity is to be able to index strongly text-oriented documents. You could think of it as a search engine, but you could set it up to exactly match your search needs. Elasticsearch is therefore a search engine capable of storing a large quantity of documents and which can be queried in real time. In addition, its query language provides interesting interrogation possibilities that can be exploited to extract statistics in real time. In this course I explain how you can design your Elasticsearch cluster in an efficient way and also use it to index / search your data.

Ask a question

Send a message explaining your needs and Ayoub will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

MonTueWedThuFriSatSun
7              
8              
9              
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  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23  Monday at 23:00  Tuesday at 23:00  Wednesday at 23:00  Thursday at 23:00  Friday at 23:00  Saturday at 23:00  Sunday at 23:00
from C$38.73At teacher's location
from C$38.73Online 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 August 2020
  • Phone number verified
  • Google connected
  • Linkedin connected

Availability of a typical week

MonTueWedThuFriSatSun
7              
8              
9              
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  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23  Monday at 23:00  Tuesday at 23:00  Wednesday at 23:00  Thursday at 23:00  Friday at 23:00  Saturday at 23:00  Sunday at 23:00
from C$38.73At teacher's location
from C$38.73Online 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


Jerome
Course and help with the statistical analysis of data in psychology
Professor and doctor of psychology and cognitive neuroscience graduated from the University of Strasbourg (holder of a master 2 research in Biology and a master 2 professional in science communication), I offer private lessons in psychology (cognitive, social, developmental psychology, neuropsychology, etc.), neuroscience as well as statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous teaching approach, specific and adapted to each request, I propose an effective methodological aid (available references) allowing to answer to the waitings of the students and to reach or even exceed the fixed objectives. My classes also integrate a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your oral exams with or without powerpoint support). My courses are aimed at university students, engineering schools, BTS wishing to optimize their performance and exam and exam scores (courses in psychology, neuroscience, medicine, etc.). I receive a lot of requests from students from Paris 8 University (IED or not), University Paris 5 and Nanterre because I know very well the program and the expectations of the jury for the research paper. Schools, Universities and teaching institutes offered: ESSEC Business School, Universities of Strasbourg and Paris 8, ISTH, IONIS Education Group, EEEA, Acadomia etc.

Pascal
COMPUTER COURSE - Database - Intermediate - Expert
Currently studying at school 42, I propose computer courses in Paris for databases: MySQL PostgreSQL Database Architecture, Database Design, Stored Procedures, etc. I can also help for AI, algorithm, git as well as on the UNIX system. I remain at your disposal for any questions.

Rahma
Private lessons in computer science: Programming, Database, office automation ...
Senior consultant with a degree in computer engineering gives private lessons in computer science (Java, C, C ++, BD, Programming, database ...). I have 5 years experience in teaching in the computer field. See you soon, I hope :

Zen
Train yourself in the Merise method and design your information system from the abstract model to the Microsoft Access or Oracle database.
The merise training teaches you both an analysis method and an information system construction process. It consists of carrying out the studies of the processing and the data at the same time, and then making them coincide. The merise training teaches you an approach based on 3 levels of concern: conceptual, organizational and physical. Merise training and Project management Merise training is particularly suited to the management of a project in the field of new technologies. Merise training: physical level The answers provided by the Merise method at this last level make it possible to establish the concrete way of setting up the system. The Physical Data Model (or PDM or MPhD) makes it possible to specify the storage systems used. The Operational Processing Model (or MOT or MOpT) allows the functions to be specified as they will then be performed by the programmer. This step is the culmination of the Merise method. Merise training: organizational level Did the merise training teach you to do conceptual analyzes? At this level of concern, the conceptual models are specified to be the subject of organizational choices. The merise training then teaches us the construction: - a Logical Data Model (or LDM), which takes the content of the previous CDM, but specifies the volume, structure and organization of the data as they can be implemented. - a Logical Processing Model (or MLT), which specifies the actors and the means that will be implemented. It is here that the treatments are divided into functional procedures (or PF). The organizational level of the merise method focuses on specifying the organization of company data (MLD) and tasks or procedures (MLT). Merise training: conceptual level In Merise training, the conceptual level is subdivided into two levels: the Conceptual Data Model (CDM) and the Conceptual Processing Model (MCT). A company's MCD and MCT are stable, modeled once and for all, and do not depend on the choice of one software package or another.

Badr
Méthode merise de conception des bases de données.
Merise is a general-purpose modeling methodology in the field of information systems development, software engineering and project management. First introduced in the early 1980s, it was widely used in France, and was developed and refined to the point where most large French governmental, commercial and industrial organizations had adopted it as their standard methodology. Merise proceeds to separate treatment of data and processes, where the data-oriented view is modelled in three stages,

William
Fundamentals of SPSS: A step by step approach to doing more with SPSS
SPSS is a statistical tool that can be used for analyzing data. It is used by researchers, data scientists, and students for recording, analyzing, and interpreting data in order to create useful information which can be used for creating solutions in various settings. In this course, I will teach you the fundamentals of SPSS in a manner that can be easily understood by people from various backgrounds.

Ashington
STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALS
This class covers statistics and statistical methods for data analysis which cuts across all industry and disciplines. Sample topics, Statistical calculations Statistical methods Statistical analysis Quantitative analysis Quantitative analysis techniques Non Quantitative data analysis Research methods Research methods paper section Mathematical analysis Statistical software and spreadsheets like Rsutdio, Excel, SPSS, and many others. and any statistical topic requests by students

Md Mafizur
Web development with a real project development and assignment
If you are looking for a professional tutor you are in right place. I will teach you web designing and development on your desktop using TeamViewer or in person. Complete course : html and html5 (including assignments) css and css3 (including assignments) Bootstrap (including a project) .Net core (including assignments) mySQL/MSSQL (including assignments) using mysql with .Net core A Final Project

Houssein
Computer Science Tutoring for beginners and professionals
Lectures in Computer Science (Optimization, Graphs, Data Structures, Data Base, Data Mining, Computer Architecture, Image Processing, Numerical Simulation, Office, ..) and programing (C, C++, Java, R, Matlab, MIPS, ..) for beginners and professionals

Beheddine
Relational and non-relational database (SQL / NoSQL) (MongoDB)
I offer courses in spring and .Net frameworks, java, php and c # courses basic web development technologies such as html, css and javascript relational and non-relational database and NoSQL SQL (MongoDB) courses

Alaa
Postgresql Computer Courses For Students and Professionals
Engineer in computer systems and networks with extensive professional experience in various essential sectors, offers courses on the Postgresql DBMS for students to strengthen the level or for professionals to use with Odoo or others ...

Dhruva
Learning Data Visualisation and Analytics with Tableau
Tableau is one of the easiest introductions to the world of data science. Within hours, you can be creating attractive and informative dashboards to elevate your visualisations far beyond Microsoft Excel's charting tools. You can build professional-looking visuals to present to stakeholders and also for independent research projects you might be conducting. It's also hugely beneficial for the process of exploratory data analysis, where you might have a large dataset, but are unsure how to begin analysing it. By the end of this class, you will be able to create and publish high quality visualisations on any dataset or data stream. We'll look through how to perform initial data analysis, build sophisticated dashboards, create calculated fields using Tableau's simple native language and get your project ready to release to your intended audience.

Ramesh
Computer Programming, English, Science, Management, IT related topics!
I have 20 plus years in the IT service delivery and AGILE delivery approach. I have worked in many countries with many different distributed teams and multiple vendor partners and hence have a unique insight into the IT industry process and deliveries

Issa
Math, statistics, programing and computer science tutoring
I specialize in tutoring computer science classes such as: 1- java- basic programing 2- data structure- advanced programing 3- python- Artificial intelligence programing 4- html- web programing 5- php- advanced web programming 6- database- manage your data I start from scratch with the students so even if they don't have an IT background or new to programing world, they can feel comfortable with the way I teach, using best practices, and lot of exercises.

Alex
SQL For Anyone - A Complete Course for Start Working with Relational Databases
Most of applications nowadays have to work with different storages. One of the most popular types is Relational Database Storage (PostgreSQL, MySQL, Oracle, Microsoft SQL Server and so on). To work with data contained in it, you will need to use SQL - Structured Query Language. This course will help you to: - learn the concepts of making queries in SQL - become familiar with the most common operations in Data processing - obtain a practical experience in SQL using one of popular DB engines.