Zakaria
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from23.00EUR/ h

SQL / relational database courses, analysis, design.

Translated by Google. Click to view original.
Graduate in IT management, with at least two years of experience as an IT trainer.

I offer support courses and my private lessons in SQL programming and database management (analysis, design, etc.).

Location

Online via webcam

General info

suitcase iconSkills:
Age:
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, English, Arabic

About Me

Translated by Google. Click to view original.
Graduated in IT Management from the Haute Ecole Léonard De Vinci in Brussels,
having an experience of more than 3 years as a Teacher of private lessons in Computer Science.

Education

Translated by Google. Click to view original.
- Upper secondary school diploma (Sciences)
- Technician Diploma Specialized in Computer Development.
- Bachelor's degree in IT management.

Experience / Qualifications

Translated by Google. Click to view original.
Experience:
- Analyst Programmer.
- Computer tutor.
- Computer teacher.
Qualification
- Programming
- Database analysis
- Data base management

Reviews (2)

Excellent teacher, listens and provides very good explanations.
Translated by Google. Click to view original.
Very good teacher and clear explanations
Translated by Google. Click to view original.
I offer support courses in Computer Science suitable for students or professionals. Having a Bachelor's degree in Computer Science and a first professional experience in Company, I put my know-how and knowledge at your service to help you, in particular, in learning computer programming, carrying out your IT projects, whether as part of your study or job. Subjects : - Algorithms - Principles of Object Oriented Programming - Modeling UML, Merise. - Analysis and design of relational databases. - SQL data query language - Programming languages: Java, C #, SAS.

Ask a question

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

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
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              
19              
20              
21              
22              
23              
from 23€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.

Online reputation

  • Instructor since September 2018
  • Phone number verified

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
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              
19              
20              
21              
22              
23              
from 23€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


Abdelhak
IT engineer with more than 15 years of experience specializing in SQl, PL/SQL.PostgreSQL and Oracle.
Hello everyone, I am delighted to be here today to introduce myself as a trainer. As a computer engineer with over 15 years of experience, I have worked in various industry sectors. During my career, I have developed solid programming skills especially in SQL and PL/SQL language, and I am passionate about sharing my knowledge with you and putting my professional experience and technical skills to good use in this role . Database: - SQL, PL/SQL - Oracle, PostgreSQL, MySQL

Amin
Programming with Python, with C and database management (Introduction to machine learning)
Looking to master programming and become a skilled developer? In this course, you will learn the basics and tools to manipulate python and other programming languages as well as using them to build machine learning models. We also provide assistance to students specializing in programming and database management using SQL (CPGE students). Under special request, we provide courses on other programming languages such as C, R studio, MATLAB, ... If you have any further questions, feel free to contact us. Python is a powerful general-purpose programming language. It is used in web development, data science, software prototyping, etc. Fortunately for beginners, Python has a simple and easy to use syntax. This makes Python a great language for learning programming for beginners. In this course, you will learn the basics and tools for manipulating python as well as its use to build machine learning models. We also provide assistance to students specializing in python programming and database management using SQL (CPGE students). On special request, we organize courses on other programming languages such as C, R studio, MATLAB, ... If you have any further questions, please do not hesitate to contact us.

Aniket
Certified Trainer For SQL, Excel and Html (Web Development) with 300+ Reviews
- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

Nick
Master Data Analytics: Microsoft Excel, SQL, PowerPoint & Others
As an educator specializing in Data Analytics, I provide expert instruction in essential tools and techniques, including Excel, SQL, PowerPoint, and PowerBI. These applications have emerged as critical components across various industry landscapes as well as in personal ventures, making the mastery of such skills immensely valuable. Additionally, I place an emphasis on soft skills training - areas such as data storytelling, presentation, and communication, which are often overlooked by many instructors, yet crucial in today's data-driven world. Bringing rich experience in teaching a diverse age spectrum, I steadfastly adhere to fundamental teaching principles. These encompass segmentation for digestible understanding, visualization for tracking progress, tangible results as benchmarks of learning, and real-world applications to refine acquired skills. Recognizing that effective learning strategies can differ greatly among individuals, I understand that there is no universally successful method. The true spirit of private tutoring lies in its adaptability to meet unique needs. Consequently, my pledge is to identify and implement the most conducive strategies that will invigorate and facilitate each of my students' learning journeys.

Youssef
Basics of Données and language SQL (Structured Query Language)
SQL (Structured Query Language) courses are a training designed to learn the basic principles and progress in relational database processing. Get a general description of the topics covered in the SQL course Introduction to database and SQL: Understand the basic concepts of database related. A presentation of SQL as the standard request language for interacting with databases. Language Definition Data (LDD): Explore domain-specific languages to define and manage data structure in a database. For example: DDL (Data Definition Language) in the context of SQL to define database objects such as tables, views and index. Data Manipulation Language (LMD): Ordering processes: Explore commands that allow you to obtain additional, specific information from the database. Use the SELECT instruction to query and retrieve data based on specified criteria. Editing operations: Use UPDATE, INSERT, and DELETE instructions to make modifications to existing data. Understanding transactions to ensure data consistency during modification operations. data collection : Use aggregate functions (SUM, AVG, COUNT, MIN, and MAX) to perform calculations on data sets. Combine data with the help of GROUP BY to regroup results based on specific criteria. Filtration and tripartite: Use sentences that tell us where to filter results based on specific conditions. Use ORDER BY to sample results based on specific criteria. Joints: Apply JOIN instructions to combine data from additional tables based on the specified relationships. Understand the different types of joints (INNER JOIN, LEFT JOIN, RIGHT JOIN) to get accurate results. Help requests: Use suborders to enable additional and complex operations to merge printed orders. Data control language (LCD): Introduction to the languages used to define data management rules and security policies. For example: DCL (Data Control Language) in SQL to manage authorizations and data access rights. Merez method: Method steps: Needs analysis: Collect and understand information system needs. Identification of representatives, information flow and professional rules. Model of inferiority concept (MCD): Use entity diagrams to represent entities, relationships, and attributes. Define safety constraints at a conceptual level. Trait Concept Model (MCT): Representing the features necessary to respond to the needs of the system. Identify different processes and the interactions between them. Conceptual Model of Flow (MCF): Model the flow of information between actors and attributes. Illustration of information changes in the system. Concept details: Passing the conceptual model through logical and physical models. Modeling tools: Use graphic tools to create different diagrams of MERISE. Example of a tool: PowerAMC. Advantages of Merez's method: Structuring the pregnancy process. Clear separation between different project steps. Make visual models easier to understand.

Pardeep
Mastering MS SQL Server: Database Development and Management
Mastering MS SQL Server: Database Development and Management Description: Unlock the full potential of database development and management with our comprehensive MS SQL Server course. Whether you're a budding database administrator, software developer, or IT professional, this course is designed to equip you with the skills and knowledge needed to harness the power of Microsoft SQL Server. What You'll Learn: Introduction to MS SQL Server: Understand the fundamentals of relational databases. Explore the architecture and components of MS SQL Server. Database Design and Normalization: Design efficient and normalized database structures. Learn best practices for creating scalable and maintainable databases. SQL Querying: Master Transact-SQL (T-SQL) for querying and manipulating data. Implement stored procedures, functions, and triggers. Data Modeling and Indexing: Create effective data models for optimal performance. Implement and optimize indexes for fast query execution. Advanced Querying and Reporting: Explore advanced querying techniques for complex data retrieval. Generate meaningful reports using SQL Server Reporting Services (SSRS). Data Security and Permissions: Implement robust security measures to protect sensitive data. Manage user roles and permissions effectively. Backup and Recovery Strategies: Develop comprehensive backup and recovery plans. Learn to restore databases in the event of data loss. Real-World Projects: Database Development: Design and implement a fully functional database for a real-world scenario. Performance Optimization: Identify and optimize slow-performing queries and database structures. Why Choose Our Course: Hands-On Labs: Apply your knowledge through hands-on labs and real-world scenarios. Expert Instructors: Learn from experienced database administrators and SQL Server professionals. Career Guidance: Receive insights into career paths in database development and administration. Certification Preparation: Prepare for Microsoft SQL Server certifications to boost your credentials. Who Is This Course For: Database Administrators Software Developers IT Professionals Students and Enthusiasts interested in database management Join us in this immersive journey to become a master of MS SQL Server. Enroll now to acquire the skills needed to build and manage robust databases that drive business success!

Abir
Learning Basic computing and Merise quickly and easily
In this class, you will have an overview of basic computing in general and also in SQL language, Merise My goal is to keep students challenged, but not overwhelmed. I assign homework after every lesson and provide periodic progress reports. You will learn quickly and easily

Arpan
Learn basics of SQL programming with no prior knowledge
Do you want to learn SQL but feel overwhelmed by the amount of knowledge present on the internet? Would you like to learn SQL from the very basics to a respectable level with hands-on practice? My goal is to exactly do that. You need no prior knowledge, all you need is the will to learn(which you already have, otherwise you wouldn't be here!) My modules on SQL(which I will provide you with) will help you get up and running with SQL in absolutely no time. I will personally assist you through downloading all the required software and then teach you how to use them so that you do not feel lost or overwhelmed. So what are you waiting for, contact me and let's start collaborating!

Navid
Your Coding Adventure Begins Here: Master Python or SQL with Me
Hi there! I'm an experienced Python and SQL professional, and I'm inviting you to join me on an exciting journey into the world of coding. Don't worry about your age, background, or experience level - all you need is curiosity and a thirst for learning! In my class, I'll guide you through Python or SQL, as if we're embarking on an adventure. We'll start from the basics, making sure you feel confident, and then gradually dive deeper into the fascinating world of these powerful languages. Throughout our journey, I'll share my experiences and insights from years in the industry, and we'll use real-world examples to make learning more relatable. We'll solve fun quizzes and puzzles along the way to keep things interesting, and I'll be there to answer all your queries and provide feedback. By the end of this course, you'll not just learn Python or SQL, you'll experience them. You'll transform from a coding enthusiast to a confident coder ready to conquer new challenges. So come aboard this coding adventure. Let's learn, grow, and have fun together! Sign up today and let's script the future!

Enrique
SQL - Basics / Intermediate / Advanced + Assessment on demand
Standard language for accessing databases. Queries, clauses, dynamic executions, traces, execution plans, inserts, updates, inserts, deletes, merges, joins, unions, intersections, complex cases, direct data loads, temporary data sets, queues, embedded queries in programming languages ( C, Python, etc.), most common SQL interfaces (SQL Developer, Toad, DBeaver, etc.).

Shalini
Learn SQL scripts, stored procedures, stored functions
In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.

Sneha
Basic Understanding of SQL commands: Theory and practical lessons
*** Do you want to step your career into IT career as a Backend Developer? **** You can be from any background. ***** We will teach you everything, from basic. ****** Database is like a backbone of any software development, thus a backend developer has equal demand as software developer. ---- Simple and easy learning of SQL.(Practical and theory classes) SQL ( structured query language) is a language used to communicate to the database. It is used to manage data stored in relational databases, which store structured data in tables. In this tutorial you will learn how to create and query relational databases using SQL and basic SQL command practical theory sessions.

Mohamed Amin
Learn SQL programming - Create SQL Queries - Beginner
good morning, You'll want to save more on SQL! You can use the SQL assignment that you can't compile! With my money, I want you to use SQL, so you can use the appropriate database to download it. All is well Create your own donation base or interface with the donation bases Log SQL pool requests around plusieurs tables

Carl
SQL Training - Learn the basics of SQL to advance your career in Data
SQL is a powerful data profiling tool, which allows users to be able to understand the type of data that they have, and see their data in a way that allows filters to be applied. It is an important skill for any individual who wants to go into a career working with Data and will instantly boost your job prospects.

Nish
Offering lessons in Computer Science and programming - SQL, Database
I am an IT professional having a great passion towards teaching. I have done Masters and bachelors in computer Application and programming. I completed Masters in 2007. I believe that teaching is an art and a smart teacher should understand how an individual students understand well. What is the best teaching approach that suits the individual teacher? I customise the teacing approach based on the student's need and this comes from years of experiece teaching varieties of students across different countries. My teaching methodology is a gentle approach which 100% ensures the subject matter is understood to the student - - Teach the subject matter - Practice exercises based on subject matter - Explain any doubts/queries the student may have - And revise Thanks