facebook
Become a Tutor

Private lessons are also online!

Find your perfect online private tutor on Apprentus.
Connect and learn online with our teachers today!

Private lessonsOnline lessons

71626 online teachers

71626 online teachers

star icon
active star icon
(2 reviews)
Brahim - Berrechid, Morocco29€
29€Introduction to Relational Database and SQL Language by practise
Trusted teacher: 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
Mysql · Oracle database · Microsoft sql server
star icon
active star icon
(3 reviews)
Mika - Paris, France32€
32€Let's enjoy learning the Japanese language and culture with a native teacher
Trusted teacher: Hello! My name is Mika, and I am a certified Japanese language teacher with over 4 years of teaching experience. I am a native Japanese speaker and hold professional certifications for both Japanese and English. I have been passionate about education since my university days in Japan, where I studied education extensively. ◉Why choose my lessons?◉ 【Certified and experienced】 I hold official certifications to teach both Japanese and English, with over 4 years of experience teaching students of all ages. 【Extensive teaching background】 In Japan, I taught English to students aged 7 to 18, which helped me understand the different needs of students across various levels. 【All ages and levels welcome】 Now in Paris, I teach students as young as 5 years old, as well as retired learning Japanese for fun and as a hobby. 【Tailored lessons】 I customize lessons to meet your needs, whether it's reading, speaking, writing, or grammar. 【Flexible language support】 Lessons are conducted in Japanese or English (as my French is still conversational). 【Friendly and supportive】 I create a relaxed and enjoyable learning environment for all my students. If you're interested in learning Japanese in an engaging and structured way, feel free to message me. I look forward to helping you achieve your language goals, no matter your age or level! -------------------------------------------------- ------------------ Hello ! My name is Mika, and I am a certified Japanese language teacher with over 4 years of experience. I am a native Japanese speaker and hold professional certifications to teach both Japanese and English. I have developed a true passion for education since my university years in Japan, where I studied education extensively. ◉Why choose my courses?◉ 【Certified and Experienced】 I have official certifications to teach Japanese and English, with over 4 years of teaching experience for students of all ages. 【In-depth teaching experience】 In Japan, I taught English to students aged 7 to 18, which allowed me to understand the varied needs of students at different levels. 【All ages and levels are welcome】 Currently in Paris, I teach students from the age of 5, as well as retirees who are learning Japanese for pleasure and as a hobby. 【Courses tailored to your needs】 I tailor lessons to your needs, whether in reading, speaking, writing or grammar. 【Flexible Language Support】 Classes are taught in Japanese or English (my level of French is still conversational). 【Friendly and caring atmosphere】 I create a relaxed and enjoyable learning environment for all my students. If you're interested in learning Japanese in a structured and engaging way, don't hesitate to contact me. I'd love to help you achieve your language goals, regardless of your age or level!
Culture · Tutoring · Japanese
« Previous«
Showing results 3651 - 3675 of 716263651 - 3675 of 71626
Next »»

Our students evaluate their online teacher.

To ensure the quality of our online teachers, we ask our students to review them.
Only reviews of students are published and they are guaranteed by Apprentus. Rated 4.9 out of 5 based on 93 reviews.

Italian private lessons online and offline - Italian language private lessons (Rotterdam)
Davide
rating star
rating green star
I had my first Italian lesson with Davide on 24/9/21. My first impression was very good because he does a very good assessment before he starts of your level and of your goals and based on that he adopts his learning approach perfectly yo your needs. I give Davide a 5 rating after one lesson and would be very surprised if my view of him will change. On top of his ability as a teacher, he is a very nice and modest person. He knows how to drive a conversation and seems have a lot of patience! Looking forward to the next lesson!
Review by VICTOR
Learn the basics of accordion, the basics of music, and IMPROVE your accordion playing skills!
Stefan
rating star
rating green star
Enjoyed his class! He was very detailed in his teaching - particular about the posture and attention to detail in terms of the fingering and pacing, despite it being an online class. His class had very good pacing in his teaching and provide relevant teaching materials for beginner accordion students. He is also very responsive on Apprentus and accommodating to virtual lessons. Highly recommend!
Review by JANICE
✅🏆RECOMMENDED teacher for Tagalog, (+5 other languages) tutor for total beginner students. Has conducted over 11,000 lessons online.
Ma. Concepcion P.
rating star
rating green star
I've been having lessons with Sam for a couple of months now with my brother. She's a great teacher, got good energy and enthusiasm so makes Tagalog lessons fun! Also she was very accomodating in helping to find a time that would work for all of us, which we really appreciated. Would highly reccomend to anyone looking to learn Tagalog :).
Review by LOUISA

You are here

Private lessons
Online lessons
map iconMap