facebook

Private teachers in Communay\

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

5 private teachers in Communay\

0 teachers in my wish list
|
+

5 private teachers in Communay\

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
Trusted teacher: Hello! I am Marisela, Teacher of English and Spanish for Foreigners ELE. I have a Certificate endorsed by the Instituto Cervantes of Spain. My mother tongue is Spanish (Castilian) and my second language is English and I am perfectly bilingual Spanish and English. I studied English at the University if Nebraska in the United States of America and I have worked in American Schools with Preschool, Elementary, Middle and High School students. In addition, I have also taught university students and adults like doctors, bankers, marketers, business owners, and other adults in general. I have lived and worked in different countries around the world where English and Spanish are spoken. The most spoken languages ​​around the world. I like to organize the classes according to the learning objectives of each student, so my classes will be adapted to the level, needs, interests and rhythm of each student. I have many teaching materials and resources to use in my classes and we can also use the teaching materials and resources the student already has as well. From a very young age, my great passion has always been languages ​​and I have stood out for being a very friendly teacher, with a lot of patience, very friendly and fun at the same time, creating a pleasant and relaxed atmosphere so that students feel comfortable, at ease and confidence for their learning. I have taught many students of all ages, cultures and nationalities and they have all achieved their goals in the shortest possible time. Oral interaction will be a leading agent in each of the classes. Emphasis will be placed on conversational Spanish. In this way, learning and understanding will be facilitated in a relaxed and comfortable environment and conversation will be practiced in the language of instruction, and pronunciation will be corrected. I have extensive international experience working in the field of Education teaching at levels from Beginner (A1) to Advanced (C2) for children, youth and adults in both English and Spanish. I have taught Spanish and English for More thank 20 years and I have taught students from different countries, ages and nationalities at different levels of the English language as well as the Spanish language. In addition, I have a long career working as a Translator and Interpreter of English and Spanish and vice versa also internationally. I currently give private English and Spanish classes online. I will be happy to help you achieve everything that you propose in terms of your level of Spanish or English! Hope to have you in my class! Thank you! Kind regards, Marisela.
Spanish · Communication skills · Public speaking
Trusted teacher: 🎤 Unlock Your Voice with an International opera Singer with over 15 years stage experience Are you ready to discover the true power of your voice? Get ready for personalized voice lessons that will transform your vocal abilities, no matter your age or skill level. 🌬️ Master Your Breath: Learn the secret to breath control! Strengthen your diaphragm and achieve flawless vocal control. 💃 Perfect Your Posture: Discover how proper posture can elevate your singing performance. I will guide you to a posture that maximizes your vocal range and projection. 🎶 Find Your Authentic Voice: Uncover the unique beauty of your voice with expert guidance. Whether you're a beginner or an experienced vocalist, I will help you tap into your true, authentic sound. 👩‍🎤 All Ages and Levels Welcome: No matter your age or skill level, I welcome you with open arms. Whether you dream of singing on the stage or simply want to sing your heart out, these lessons are for you. I am an international opera singer, and perform leading roles on the world’s most important stages. I offer lessons in vocal technique, with a great emphasis on breathing technique, body work, as well as techniques to deal with performance anxiety. You will learn the key fundamental aspects of breath and body alignment techniques, and will be given vocal exercises that can help you to achieve your goals. We will focus on getting rid of unnecessary muscle tension, and finding a released and projected sound. I have sung at houses such as the Hamburg State opera, English National Opera London, Semperoper Dresden, Opernhaus Zürich, Gran Teatre Liceu Barcelona, Dutch National Opera, Salzburg, Rome in leading roles such as Carmen, Isabella, Adalgisa, Ariodante, Orfeo, Radamisto, Cenerentola, Hermia. I also joined the roster of the Metropolitan Opera for thé first time in 2020.
Voice (music) · Opera · Singing
Trusted teacher: With over 8 years of experience as a Solfege, Oriental Solfege, Oud, and Oriental singing teacher, I am a Lebanese musician currently residing in Mönchengladbach, Germany. I honed my skills for 8 years at the Lebanese National Conservatory. Prior to my relocation, I taught at Casa Beethoven Academy in Lebanon and also held private music lessons. As a concertmaster, I performed with the oriental orchestra "Loubnan Assalam" for over 5 years. My move to Germany was motivated by my pursuit of graduate studies at the University of Kamp-Lintfort. Fluent in English, Couramment en français, ولغتي الأم هي اللغة العربية. Aber leider spreche Ich ein bisschen Deutsch. Solfege, the foundation of music theory, is an essential tool for any musician who wishes to understand and create music. It provides a way to identify and communicate notes, intervals, and rhythms, and it is the key to developing musical literacy. In this class, you will delve into the world of scales, exploring the unique characteristics of Western and Oriental scales. We will study the following scales: Rast, Bayet, Siga, Kord, Hijaz, Ajam, Nahawand- Major & Minor Scales. In addition to these Western and Oriental scales, we will also introduce you to the quarter note, which is not traditionally found in Western music. It is a quarter note with a unique and distinct sound. Whether you are a beginner or an experienced musician, this class will provide you with the knowledge you need to use scales effectively for improvisation, singing, and playing any instrument. With this knowledge, you will be able to: * Read and write music (dictation) in solfège notation for both Western and Oriental scales. * Identify and communicate notes accurately in the context of various musical traditions. * Develop a deeper understanding of music theory and rhythmic concepts. * Infuse your musical performances with a broader range of expressive possibilities. We will use the book "المقامات الشرقية by Georges Farah" as the main reference for our study of Oriental solfège. This book is considered the best book in the Middle East to teach Oriental Solfège. Discover the power of solfège to enhance your musical skills and open up a world of new possibilities!
Music theory lessons · Music theory
Trusted teacher: The course module is adapted to the student. The summary will be communicated during the first lesson: 1. Introduction 2. Communication and Psychology 3. Pressure Points 4. Hand to Hand Combat 5. Baton Attack 6. Knife Attack 7. Gun Attack 8. Rifle Attack (Theory) 9. Multiple Attackers 10. Bonus Tips ▪️ The techniques used will improve your confidence level and teach you how to defend against 1, 2, or even 3 attackers in different aggression situations. ▪️ Self Defense is a countermeasure that consists of defending the health and the well-being of oneself against harm. The use of the right of self-defense as a legal justification for the use of force in times of danger is available in many jurisdictions ▪️ I have experience in military and diplomatic missions, giving me a solid background to accompany you, and share with you the best skills on how to defend yourself in various situations. ▪️ I have traveled to many countries and assisted to many self-defense seminars, so, I can share with you the best methods to learn and lessons learned to avoid wasting time and turning in circles. ▪️I can provide you with the knowledge and skills to live independently in security. I can teach you basic and complicated self-defense, body language (yours and others), situational awareness, avoiding potentially dangerous situations and places, and asserting yourselves in risky situations. * For the more sensitive, specifically, parents with children who are victims of harassment. I can accompany your children, and help them to overcome their fears. Myself with a medium height, and considered not too big physically, I developed over the years for myself and my student's multiple skills and methods to defend ourselves whatever the size of our body is. ▪️ 15 years + of experience. ▪️ 7 years of MA Self Defense. ▪️ 4 years of MMA - Mixed Martial Art. ▪️ 4 years of Silat, Systema, Wing Chun, Aikido, Free Style.
Self defense · Martial arts
Trusted teacher: In the CIE (Cambridge International) curriculum, Biochemistry is primarily covered in Biology and partially in Chemistry at both IGCSE and AS/A Level. It focuses on the chemical processes and molecules essential for life. Here's a detailed overview: IGCSE Biology (0610/0970) Biochemistry at the IGCSE level introduces students to basic biological molecules and processes: 1. Biological Molecules - Carbohydrates: - Monosaccharides (e.g., glucose), disaccharides (e.g., sucrose), and polysaccharides (e.g., starch, glycogen). - Role in energy storage and release. - Proteins: - Made up of amino acids. - Functions: enzymes, structural components (e.g., keratin), and hormones. - Lipids: - Fats and oils: composed of fatty acids and glycerol. - Role in energy storage, insulation, and cell membranes. 2. Enzymes - Biological catalysts that speed up reactions. - Factors affecting enzyme activity: temperature, pH, and substrate concentration. 3. Photosynthesis - Biochemical process in plants to produce glucose using light energy, carbon dioxide, and water. - Equation: 6CO2 + 6H2O → C6H12O6 + 6O2. 4. Respiration - Aerobic respiration: Glucose + Oxygen → Carbon dioxide + Water + Energy (ATP). - Anaerobic respiration in humans: Glucose → Lactic acid + Energy. 5. DNA and Protein Synthesis (Basic level) - DNA as the molecule of inheritance. - Role of DNA in carrying genetic information. --- CIE AS and A Level Biology (9700) At the AS/A Level, biochemistry is studied in depth. Key areas include: 1. Biological Molecules - Carbohydrates: Structure and function of monosaccharides, disaccharides (e.g., maltose), and polysaccharides (e.g., starch, glycogen, cellulose). - Lipids: Triglycerides, phospholipids, and cholesterol. Role in membranes and energy storage. - Proteins: - Levels of structure: primary, secondary, tertiary, and quaternary. - Role of proteins in enzymes, antibodies, and transport (e.g., hemoglobin). - Nucleic Acids: - Structure of DNA and RNA. - Role of nucleic acids in protein synthesis. 2. Enzymes - Enzyme structure and mode of action (lock-and-key, induced fit). - Enzyme kinetics and factors affecting enzyme activity. - Competitive and non-competitive inhibitors. 3. Cellular Respiration - Glycolysis, Krebs cycle, and oxidative phosphorylation. - ATP production and its importance as an energy currency. 4. Photosynthesis - Light-dependent and light-independent (Calvin cycle) reactions. - Factors affecting photosynthesis. 5. Molecular Biology - DNA replication, transcription, and translation. - Role of mRNA, tRNA, and ribosomes in protein synthesis. 6. Biochemical Processes in Cells - Role of ATP in metabolism. - Metabolic pathways and enzyme regulation. --- CIE AS and A Level Chemistry (9701) While biochemistry is primarily a biology topic, it also features in chemistry at A Level: 1. Amino Acids and Proteins - Structure of amino acids and peptide bonds. - Protein hydrolysis and analysis. 2. Carbohydrates - Structure of glucose and its isomers. - Reactions of carbohydrates (e.g., oxidation). 3. Lipids - Structure of triglycerides, fatty acids, and phospholipids. - Saponification and ester formation. 4. Biochemical Techniques - Chromatography for separating amino acids and sugars. - Use of enzymes as biological catalysts in industrial processes. --- Summary - At the IGCSE level, biochemistry focuses on basic biomolecules (carbohydrates, proteins, lipids), enzymes, photosynthesis, and respiration. - At the AS/A Level, biochemistry delves deeper into molecular biology, enzyme kinetics, ATP production, protein synthesis, and metabolism.
Biochemistry
Showing results 201 - 225 of 63312201 - 225 of 63312

Our students from Communay\ evaluate their teacher.

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

Photoshop and Digital Art for students, artists and photographers (Athens)
Emer
My 16 year old decided to pursue a career at n fashion and art early on We found Emer and she was exactly what we were looking for and more when Theo applied for fashion Academies Her first extensive background and calm and friendly approach brought out the best in my 16 year old son Together they created an original portfolio crammed with original and artistic work Enthusiast and patient I have no reservations recommending Emer for any art driven personal or group learning sessions My sons testimony says it all She is simply amazing
Review by TONIA
IELTS Coach | Tailored Exam Preparation | General English (Peckham)
Dean
Our first lesson with Dean was productive and an eye-opener. The lesson made me realize there are a few critical areas that I needed to grasp and understand to articulate the IELTS exam preparation. The lesson was fun, and Dean is a good attention detail tutor; he takes time to give a clear explanation of what to focus on. His energy is amicable, and he takes his work seriously. Thank you for the first lesson, and we look forward to our following lessons.
Review by ALDRIDGE
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

You are here