facebook
Become a Tutor

Private teachers in Lefka

Find your perfect private tutor in Lefka.
Learn with our teachers at home or in their studio.

Private lessons

2 private teachers in Lefka

0 teachers in my wish list
+–

2 private teachers in Lefka

(2 reviews)
Brahim - Berrechid, MoroccoRecently activeC$45
C$45Introduction 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
(7 reviews)
Isabel - SpainRecently activeC$40
C$40Spanish online lessons with native spanish teacher for adults and teenagers
Trusted teacher: I am a native Spanish speaker and a general language enthusiast. In addition to Spanish, I speak German and English. I am 100% confident that I will successfully teach you Spanish (while having fun and relaxing)! I've been teaching spanish for 15 years. I am 41 years old, graduated with honors from the University of Salamanca. My main goal in teaching is to make students feel relaxed and comfortable while studying. Do you already know Spanish? No problem! Rather than building the basics, we can design courses to suit your personal needs and preferences. We can write essays together, you can give presentations on topics that interest you or that I present to you, we can discuss current events, engage in debates, you can write summaries of newspaper articles, or we can delve into advanced grammar. Whatever you enjoy and need, we can do it together. All my courses combine speaking, listening and grammar practice in interaction with me. Unless you are a very advanced student, we work with learning materials created by some of the best language learning publishers in Germany. These materials serve as a common thread for our course, introducing new words, grammar and exercises at a good pace and in an interesting way, keeping you engaged and motivated. I also show you German food, music and places. In addition, I will introduce you to the best technological tools (homepages and applications) to boost your language learning and take it to the next level. Another important factor for me is the personal connection. We usually start our lessons with how the weekend or previous weekdays were like. Contact me now to arrange a first lesson in which we can get to know each other so that I can learn more about you, your needs and desires and thus design the optimal course for you.
Spanish · Teaching · Reading (for adults)
Translate this text using Google Translate.
(1 review)
Joseph - Valencia, SpainRecently activeC$25
C$25Math Course: All Levels + Preparation for exams like PSAT and SAT 🎓
Trusted teacher: Are you looking to master math or prepare for important exams like the PSAT and SAT? This course is for you! With over 5 years of experience as a teacher at an international school, I am here to help you achieve your academic goals, whether in English or Spanish. What do I offer? 🔹 Personalized classes: Adapted to your level (basic, intermediate or advanced). 🔹 Strategic preparation for PSAT and SAT: Techniques and exercises focused on obtaining the best results. 🔹 Clear and dynamic explanations: You will understand complex concepts in a simple way. 🔹 Use of modern educational tools: Platforms like Khan Academy, IXL, Kahoot and Quizizz to make learning interactive and effective. Why Choose This Course? ✅ More than 5 years teaching mathematics in an international environment. ✅ Bilingual classes (English or Spanish) according to your needs. ✅ Proven experience in helping students improve their scores on standardized tests. ✅ Methods based on international standards (Common Core) and Bloom's Taxonomy, designed to develop critical thinking. Results that Speak 📈 My students have achieved: Significantly improve your math grades. Successfully pass standardized tests such as the MAP Test, PSAT, and SAT. Who Can Take This Course? ✔️ Elementary, middle and high school students who wish to improve their performance in mathematics. ✔️ Students preparing for the PSAT or SAT. ✔️ Anyone who wants to learn math from scratch or reinforce their knowledge. Together we will make math your best tool to achieve academic success! 🚀
Math · Sat prep · Psat test preparation
Translate this text using Google Translate.
Antonio - Brussels, BelgiumRecently activeC$55
C$55Political Communication, Public Speaking, and Presentation
Trusted teacher: The course module is adapted to the student. The summary will be communicated during the first lesson. I teach you to speak and/or write with an approach to the sciences of political communication, international relations, social and human sciences while convincing the person(s) in front of you with several negotiation techniques. ▪️ Political communication is about the creation and exchange of ideas and opinions between citizens, public officials, political institutions, and related entities, such as the media. It includes discourse throughout the political process in local, state, national, and international political systems, as well as how political information can be exploited for political ends or to achieve political goals. People with a background in political communication may work in policy advice, foreign service, market research, public relations, journalism, and digital media, community organizing, lobbying, political campaigning, or other related fields. ▪️ The techniques used will improve your level of confidence in your public presentations and storytelling. ▪️ BUT! in order to achieve your goal you must master public speaking which is the process or act of giving a speech in front of a live audience. Public speaking is generally understood to be formal, face to face, speaking from a single person to a group of listeners.
Political science · Communication skills · Public speaking
Translate this text using Google Translate.
« Previous«
Showing results 201 - 225 of 63220201 - 225 of 63220
Next »»

Our students from Lefka evaluate their teacher.

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

Arabic language and teaching Arabic to non-native speakers, foreigners and beginners. (Riyadh)
Hiyam
We are absolute beginners and Mrs. Hiyam made it super easy for us to dive in the lessons and in just 3 lessons we learned half of the alphabet and pronounciation. Now I can read most of the signs in the street. We will continue learning with her. We are new in Riyadh and she was so kind to come to our house to teach us. She is very sweet and smart! You will not regret any minute with her .
Review by MIRIAM
IB English Lang/Lit SL/HL tutoring to help you with your essay writing for HL essays and form ideas while speaking coherently in your IOs
Nina
Super patient, always kind, and really knows how to encourage people. No matter how many questions you ask, she never lose her cool and always explain things in a way that makes sense. Truely an amazing teacher and a wonderful person.
Review by STEVE
SPANISH FOR EVERYONE - for BEGINNERS - ADVANCED - PREPARATION FOR LEVEL CERTIFICATION EXAMS.
Óscar
Really enjoyed my 1st lesson with Óscar today. He's very nice, patient and explained how he'll help me with my Spanish. Looking forward to my block of 10 lessons and hopefully I'll book more. 10/10 to Óscar
Review by HELEN

You are here

Private lessons