Ayoub
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from22.17USD/ 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: Paris, France
At teacher's location: Societe Du Patrimoine Urbain, Québec, QC, Canada
At teacher's location: Hôtel de Ville, Marseille, France
At teacher's location: Maarif, Casablanca, Maroc
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
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!
👉 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
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.
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.
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.

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 $22.17At teacher's location
from $22.17Online 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
  • 2 repeat students
  • 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 $22.17At teacher's location
from $22.17Online 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


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.

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 :

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.

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

Rania
SQL relational databases (oracle, mysql, sql server ...)
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.

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,

Maham
Database Systems: All Concepts of Graduate Level for CS Graduates
Database systems class is related to all concepts of database from zero to advance. We will discuss all related concepts of database, Normalization, Entity Relationship diagram, Transactions and also will practice of SQL queries on database like oracle, MYSQL, ms sql serve.

Iliya
Mathematics lessons with MathematicsMathematicsMathematics
MathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematicsMathematics

Corinne
Course of use and creation of databases with Access
Learn how to use and create a database with Access in a simple way using logic rather than memorization. - creation of tables - the different types of controls with their properties and their input masks - choice lists - the 1st and 2nd keys - creation of relationships between tables - referential integrity - filtering and sorting - creation of queries (selection, table addition, update, deletion, table addition, cross analysis) - calculated fields - different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...) - creation of forms - creation of reports - external data (import and export) - compaction - linked source tables - etc ...

Andrea
PhD candidate Data Science, Data Analysis, Quantitative Methods, Python, Matlab, Statistical Packages/Software, Stata, R, Database, SQL, Ora
SERVICES I can offer my assistance with Data Analysis, Data Science, Quantitative Methods, Analysis, Statistical Modelling, Forecast, Regression, Coding, Python, Matlab, Excel statistical software and packages such as Stata, R and Database languages such as SQL, Oracle, MySql and other Business-related subjects (with coding and programming if you are interested in it). I understand that there are different kinds of learning methods, so as long as you can find your style and the appropriate method, I believe that you can get twice the result with half the effort. I have been told to be good at breaking down complex statistical and modelling concepts, explaining them in diagrams, and also relating them to their uses in our daily lives. I can help you to understand statistics, econometrics, linear regression, forecast modelling, statistical modelling, quantitative methods, as well as introducing you to the fast-growing field of Data Analysis and Data Science. I can teach how to use Python, Matlab, Stata, R, Sas, R, Excel, SQL, Oracle, MySql and many more. - Statistics - Machine Learning - Deep Learning - Probability - Linear Regression - Statistical Modelling - Analysis - Data Analysis/Science - Modelling - Forecasting model - Time Series Analysis - Quantitative Methods - Python - Matlab - Stata - R - Sas - Excel EXPERIENCE AND EDUCATION - PhD Candidate, current research focused in Machine Learning for Asset Pricing (Finance) - Financial Management University Teaching Assistant - Strong Analytical background with extensive classroom and online teaching experience. - MSc in Quantitative Finance, Bachelor of Science in Economics and Finance - 4 years of experience as a Financial Analyst in a Fintech company - For the last 2.5 years I have tutored, in Hong Kong and online, Statistics, Mathematics, Data Analysis and Italian language, both with private face-to-face tutoring as well as small groups, with students ranging from 5 years old to adult learners - Excellent material available including slides, videos, tutorials and reading material. Extensive experience in research methods and software including Python, Jupyter notebook, Matlab, Sas, Stata, R, Sql/Oracle and Excel. - I thoroughly enjoy helping others, as my patience and friendly nature makes it easier to be in an educational environment. - I have learnt to adapt to different needs and learning styles according to the student, in order to optimise their success in turning their weaknesses into strengths. - Since my academic background is Economics and Finance, I would be more than happy to assist you with substantive work too in that field. - I'm patient, friendly and understanding. I am proficient in research and development and it’s my day to day work. I am a photography enthusiast and an insatiable learner. GREETINGS My goal is also to inspire further study that will lead to an interesting and successful career. If you need further information about myself or my services, please do not hesitate to contact me. Feel free to send me a message and I'd be happy to give you an informal consultation. Thank you for looking at my profile and hope to hear from you soon, Andrea

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.

Panagiotis
Competent tutoring in computer science, English, German and Greek
Hello! I am a graduate of the MSc in business informatics (FH Technikum Wien) and have been working as a systems engineer in Vienna for several years. I also have IT tuition experience in diploma theses as well as in exam preparation (HTL). I like to teach fluently in German, English and Greek. I mainly offer tutoring in: systems administration, big data, databases (PostgreSQL, MySQL), MS Office, application servers (JBoss, Tomcat, Apache), networks, OS applications (such as Linux, Windows, MacOS), web design and development, programming for beginners and hardware. I also like to teach German (as a foreign language), English (mother tongue) and Greek (mother tongue).

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

Ifrah
Computer Science software architecture, Data science
Some students will know how to use technology tools (such as texting) better than their teachers. But to really understand computing, including the science behind it and the ways to manipulate it, students need to take classes related to computer science taught by certified teachers who can express themselves well and who may have worked in the computing field before they became educators. In addition to explaining the fundamentals of computing, these teachers will be showing their students the merits of problem-solving, collaboration, and creativity. It’s a challenging and rewarding profession. Computer science teachers are always looking forward. They keep their eyes on the latest advances, the newest tools and breakthroughs. And they always keep the future in mind while teaching because, if they do their job right, some of their students may be inspired to become tomorrow’s engineers, system administrators, and innovator.

Enrico
Microsoft Excel for any application [ITA/ENG] 100% Practical
Finance professional with 6 years working experience offering courses in Italian/English on Microsoft Excel for financial application & database management. I enjoy teaching, students of any level are welcome. If you're looking at anything ranginfg from basic formulas, graphs, pivots up to a complete automation of spreadsheets via complex formulas or VBA macros, hit me up. The course can also be helpful in preparation for internships at top tier investment banking / consulting firms. 100% practical session with extensive examples. Google Meet / Skype or any other software is fine.