Oussama
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from21.18CAD/ h

Mastering Relational Database Management: Personalized Courses with SQL, DBSM, MySQL, and PostgreSQL

I offer personalized courses that cover a wide range of topics, from the basics of relational database management to advanced data manipulation using query languages such as SQL and tools such as DBSM, MySQL, and PostgreSQL. My courses are tailored to the needs and learning styles of each student, and I am committed to helping my students achieve their individual learning goals.

Whether you are a beginner or looking to improve your skills, I can help you develop your relational database management skills and take your expertise in this field to the next level. I am excited to guide you through the world of relational database management and help you master the skills necessary to succeed in this field. Please do not hesitate to contact me for more information about my services and how I can help you achieve your relational database management goals.

Location

At student's location: Around Tunis, Tunisia
Online via webcam

|
Use ⊞+wheel to zoom!
+

General info

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
The class is taught in:French, English, Arabic

About Me

Hello everyone,

I am Oussama, a full-stack developer with a bachelor's degree in computer science and multimedia and in the process of obtaining a master's degree in multimedia and business intelligence. With several years of experience in software development, I offer private computer and programming lessons for those who want to learn programming and development.

In addition to teaching Python for over two years and having helped many students succeed in their careers, I also offer training in web and mobile development for those who wish to acquire the skills necessary to become a programmer and developer. The training I offer is composed of a theoretical part (algorithms and data structures, databases, system architectures...) and a practical part (HTML5, CSS3, JAVASCRIPT, SQL, React js, NODE JS, EXPRESS JS, Python...).

As a Full-stack developer, I am available to create or support websites, but also to help correct errors. Whether it's for a graduation project, a professional training or as a freelancer, I'm here to help you learn.

Feel free to contact me to learn more about my training and tutoring offerings in the computer field. I will be happy to help you achieve your professional and academic goals.

Education

+ Master in Multimedia and Business Intelligence Computing
+ certified python instructor
+ Bachelor's degree in computer science and multimedia (at the higher institute of multimedia arts of la manouba)
+ High school degree in mathematics

Experience / Qualifications

+ Python programming language instructor for 2 years
+ fullstack developer for 2 years
+tutor in web development ( fullstack)

Reviews (5)

I have no prior experience in this area and I took lessons with Ousamma. He has enough patience and a knack in guiding you step by step through the lessons and exercises in a very simple way to understand them well. He is an invested teacher that is kind and polite. He will help you to develop your abilities and to feel confident in order to achieve your goals. I warmly recommend him and extend my gratitude his great support throughout my learning journey.
Awesome experience
He is well organized and very kowledgable of the material teach.
Oussama is a very good teacher with great knowledge and patience. He explains in a way that makes understanding easy.
Just beginning, difficult to review
Hello everyone ! I'm oussama, a web developer and certified Python instructor with 1 year experience as a fullstack developer. I am passionate about programming and love teaching students of all skill levels how to create professional websites. I've helped many students develop their programming skills, from beginners to advanced levels, and I'd love to help even more people achieve their web development goals. With a solid background in programming and development, I am able to provide my students with theoretical and practical training in algorithms and data structures, as well as in website development languages such as HTML, CSS, JavaScript , React JS, Bootstrap and others. My classes are designed to meet the individual needs of each student and are suitable for different learning styles. Whether you are just starting out or looking to improve your developing skills, my classes can help you achieve your career goals. Do not hesitate to contact me for more information on my web development courses. I look forward to helping you become a competent web developer and succeed in this exciting field!
Hello everyone, I am oussama, a Python instructor with 2 years of experience teaching this programming language to students of all levels. I am passionate about programming and I love sharing my knowledge with others. I got a bachelor's degree in computer science and multimedia, which gave me a solid foundation in programming principles and software development. Over the years I have gained a lot of experience in explaining complex programming concepts in an easy to understand way. I offer personalized courses that cover a wide range of topics, from programming basics to advanced Python libraries and frameworks such as NumPy, Pandas, and Django. My classes are tailored to the needs and learning styles of each student, and I am committed to helping my students achieve their individual learning goals. Whether you are a beginner or looking to improve your skills, I can help you develop your Python skills and take your programming know-how to the next level. I am delighted to accompany you in the discovery of the world of programming in Python!

Ask a question

Send a message explaining your needs and Oussama 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  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00    Friday at 3:00  Saturday at 3:00  Sunday at 3:00
4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00    Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00    Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00    Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7              
8  Monday at 8:00  Tuesday at 8:00  Wednesday 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    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    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    Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12              
13              
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              
16              
17              
18              
19              
20              
21              
22              
23              
from C$21.18Online via webcam
from C$21.18At student's home

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 June 2022
  • 2 repeat students
  • Phone number verified
  • Google connected
  • Linkedin connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00    Friday at 3:00  Saturday at 3:00  Sunday at 3:00
4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00    Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00    Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00    Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7              
8  Monday at 8:00  Tuesday at 8:00  Wednesday 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    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    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    Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12              
13              
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              
16              
17              
18              
19              
20              
21              
22              
23              
from C$21.18Online via webcam
from C$21.18At student's home

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


Brahim
Introduction to Relational Database and SQL Language by practise
Module 1: SQL Overview Outlining SQL as the cornerstone of database activity Applying the ANSI/ISO standards Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys Module 2: Building the Database Schema - Creating tables and columns Building tables with CREATE TABLE Modifying table structure with ALTER TABLE Adding columns to an existing table Removing tables with DROP TABLE - Protecting data integrity with constraints Guaranteeing uniqueness with primary key constraints Enforcing integrity with foreign key constraints Imposing business rules with check constraints - Improving performance with indexes Expediting data retrieval with indexes Recommending guidelines for index creation Module 3: Manipulating Data - Modifying table contents Adding table rows with INSERT Changing row content with UPDATE Removing rows with DELETE - Applying transactions Controlling transactions with COMMIT and ROLLBACK Deploying BEGIN TRANSACTION in SQL Server Module 4: Working with the SELECT Statement - Writing Single Table queries Retrieving data with SELECT Specifying column expressions Sorting the result with ORDER BY Handling NULL values in expressions - Restricting rows with the WHERE filter Testing for equality or inequality Applying wildcard characters Avoiding NULL value pitfalls Module 5: Querying Multiple Tables - Applying the ANSI/ISO standard join syntax Matching related rows with INNER JOIN Including nonmatched rows with OUTER JOIN Creating a Cartesian product with CROSS JOIN - Combining results with set operators Stacking results with UNION Identifying matching rows with INTERSECT Utilizing EXCEPT to find nonmatching rows Module 6: Employing Functions in Data Retrieval - Processing data with row functions Conditional formatting with the CASE expression Utilizing the CASE expression to simulate IF tests Dealing with NULL values - Performing analysis with aggregate functions Summarizing data using SUM, AVG and COUNT Finding the highest/lowest values with MAX and MIN Defining the summary level with GROUP BY Applying filter conditions with HAVING Module 7: Constructing Nested Queries - Applying subqueries in filter conditions Creating correlated vs. noncorrelated subqueries Testing the existence of rows - Including subqueries in expressions Placing subqueries in the column list Creating complex expressions containing subqueries Handling subqueries that return no rows Module 8: Developing In-Line and Stored Views - Breaking down complex problems Selecting data from a query result set Using subqueries in the FROM clause - Creating views in a database Building reusable code Creating updateable vs. non-updateable views

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

Marouane
Business intelligence, data warehouse, Etl, SQL server, star schema or snowflake, power bi
As a data scientist with in-depth expertise in artificial intelligence, machine learning, deep learning, time series and data mining, I put my skills at your disposal as a data engineer specializing in Business Intelligence within a large company. I offer you comprehensive training covering the entire Business Intelligence pipeline, from data collection to visualization. During these sessions, you will learn: • The conception and design of data warehouses adapted to your specific needs. • Data models such as star schema and snowflake to optimize your data structure. • Practical use of SQL Server as well as other SQL databases to efficiently manage your data. • Advanced Extraction, Transformation and Loading (ETL) techniques with SSIS to automate processes. • Creating interactive reports and impactful dashboards with Power BI and DAX or IBM Cognos. In-depth presentations, based on solid practical experience and up-to-date theoretical knowledge, covering all aspects of the Business Intelligence pipeline. Concrete and relevant examples, taken from real use cases, to illustrate theoretical concepts and facilitate their understanding. Please feel free to contact me to discuss your specific needs and to schedule training sessions tailored to your schedule and goals. With this training, you will be ready to take full advantage of your data and make informed strategic decisions.

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

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.

Emna
The basics of computer science, programming for beginners, students or adults wanting to change their field
I give basic computer science courses for primary school, high school, university students or for people who want to change their field and start computer science from scratch. Html, css, javascript, database, algorithmic. During the first session we discuss with the participant and prepare the program according to their needs. And during the second session we install together what is necessary for the course.

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

Jerome
PhD in cognitive psychology and statistician teaches psychology, neurosciences and statistics
Experienced teacher in science and doctor in psychology and cognitive neurosciences graduated from the University of Strasbourg (holder of a master 2 in research in Biology and a professional master 2 in scientific communication), I offer private lessons in psychology (cognitive , social, developmental psychology, neuropsychology etc.), neurosciences as well as in statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous pedagogical approach, specific and adapted to each request, I offer effective methodological assistance (references available) to meet the expectations of the students and to achieve or even exceed the objectives set. My courses also include a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your research dissertations and oral defenses with or without PowerPoint support). My courses are aimed at students (in psychology, neurosciences, medicine, etc.) wishing to optimize their performance and marks in exams and competitions. Schools, Universities and teaching institutes: Universities of Strasbourg and Paris 8, CNRS, Ecole Polytechnique, ESSEC Business School, ISTH, IONIS Education Group, EEEA, Institut Tocqueville etc.

Ana Sofia
Python Programming for Data Science: From Beginners to Advanced
Presentation : Data Science and Data Analytics. Data Scientist in Banking for 3 years. A comprehensive course designed to equip you with the fundamental skills and knowledge needed to thrive in the dynamic field of data science using Python programming language. My classes offer a structured and hands-on approach to mastering Python's powerful tools and libraries for data manipulation, analysis, and visualization. Methodology : - Online course or presencial - Hands-on course with exercises and guidance to solve them - Presentations with theory and examples

Zara
Power BI, data analysis, Data science and deep learning algorithms
I'm an IT engineer, with double master in software engineering ad 6 year do teaching experience. I'am found of english, french languages and IT development teanching. Giving private courses arround the world , is what I love doing in my free time for keeping me socially active! I love giving languages' courses in a new ways of pedagogy and for any students' age : Songs, projects, Poetry, Presentations, films etc.. As for teaching IT developement, my pedagogy is always teaching by practical projects and tutorials. Such as. developping games and usefull virtual services or application, depends of the technology we work on. Be ready for your best english and IT experience with me , it's not like any old way of teaching methodologies! Don't hesitate to reach out for me , if you wish to give it a try! I'll be the very happy to give more than I can to get you to your hopes.

Ana Cecilia
Statistics, Data Analysis, Math, Economics all levels
I am a Ph.D. student at the University of Luxembourg. For the past 4 years, I taught the University: statistics and probability theory to first-year students, and economics to 3th-year students. I really enjoy teaching. I am looking forward to helping students when they need reinforcement on different subjects, or anyone interested in learning the following topics: For maths: System of equations, derivatives, integrals, type of equations, etc. For statistics: Probability theory, descriptive statistics, regression analysis, multivariate analysis, hypothesis testing, and methods for causal inference. For young professionals: I have extensive experience in data analysis, data management, and statistical modeling. My class mixes both theoretical and practical parts using financial data as examples. If you are interested, just write me a message telling me what topics are you interested in learning.

Luis Angel
IT, Databases, Office Automation and Information Technologies
Dynamic and interactive learning methodology, development of educational material. Practical development of classes where the main actor is the student as the learning activities are developed in real time with the teacher's instructions.

Emna
[PYTHON - Data Science - AI] Learn Python & Data Science & Artificial Intelligence from beginner to advanced
You are a highschool student? You have a baccalaureate? You need help with Python (Algorithmic Programming). I am here to teach you ! I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years. I am also a teacher and my students love the way I teach with (simple, clear and always funny)

Noshima
Foundation of Data Science -- For Beginners students.
Hi Students, Foundation of Data Science is for complete Beginners. This course is In-depth knowledge and hands-on tools to use and work with different kinds of data. Gaining practical experience across the data science pipeline by acquiring proficiency in the data science coding language R. Foundations of Data Science is for those who work with both structured – spreadsheets and data tables – and unstructured data and who need to understand how to automate data to gain insights, contribute to strategic discussions and make data-driven decisions. With my Course you’ll gain a broad understanding of the tools and techniques used to work with data. 1. What is Data: Learn about data types, structures and frameworks 2. Interacting with Data: Understanding how data is used and how to use data 3. Where Data comes from: The processes for acquiring and sharing Data 4. Storing & Structuring Data: Working with different types of databases and data sets 5. Cleaning Data: Working with messy or incomplete data sets 6. Analyzing Data: Gaining insights with data science techniques and tools 7. Visualizing Data: Best practices and tools for data visualization and presentation 8. Machine Learning & Artificial Intelligence: How data is used by machines 9. Working as a Data Scientist: What do data scientists really do? 10. Data & Society: Ethics and the uses of data in society

Andrea
PhD graduate 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 graduate in Finance, with 5 years of research experience and scientific contribution in the field of empirical asset pricing with focus on equity factor models, machine learning for asset pricing, regime switching models, sentiment analysis, and portfolio construction - Freelance tutor and consultant in Finance, Data Science, Python, Statistics, and Econometrics for 3 years with 1500+ hours delivered to 150+ students and customers internationally - Former financial analyst with 4 years of experience in design and realization of prototypes of several financial algorithms of a proprietary software for portfolio management, analysis, and consulting - Experienced in written and oral communication to various audiences, from academic students to financial industry leaders and professionals through reviewing, editing, teaching, consulting, and oral presentations - Former University Teaching Assistant, strong analytical background with extensive classroom and online teaching experience, MSc in Quantitative Finance, Bachelor of Science in Economics and Finance - 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. - 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