facebook
Become a Tutor

Private teachers in Sydney NSW

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

Private lessonsPrivate lessons in Sydney NSW

124 private teachers in Sydney NSW

0 teachers in my wish list
|
+–

124 private teachers in Sydney NSW

star icon
active star icon
(2 reviews)
Brahim - Berrechid, MoroccoRecently active$34
$34Introduction 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
(7 reviews)
Isabel - SpainRecently active$30
$30Spanish 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.
star icon
active star icon
(1 review)
Patrick - Katerini, GreeceRecently active$22
$22Come and learn Biology and Chemistry with an expert. Book now and have your best experience.
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
« Previous«
Showing results 276 - 300 of 64621276 - 300 of 64621
Next »»

Our students from Sydney NSW evaluate their teacher.

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

Private math lessons for different ages and levels (Luxembourg)
Armend
rating star
rating green star
There was good communication with Armend and he arrived promptly for the first lesson. He had planned an activity which was appropriate for our boys German level. He was patient and explained aspects of the lesson clearly. The boys were comfortable and were pleased with the lesson. We were all impressed with this first lesson. We recommend him.
Review by JULIE
IB Mathematics (AA or AI, SL or HL) - IB Physics (SL or HL) (Bremen)
Akbar
rating star
rating green star
Akbar is very professional and punctual. He was able to establish a connection with my son which in turn made him comfortable, and gave him a better understanding on the subjects he has difficulty from. I would definitely recommend him. His IB background is a plus to those like us, who wants to get used to the system of the program.
Review by RIZALINE
Private Spanish classes for foreigners. On-line.
Isabel
rating star
rating green star
Isa makes the best out of each class! She knows various teaching approaches and adapts according to my needs in order for me to learn as much as possible :) ! I am happy and grateful to learn from her!
Review by ILINCA

You are here

Private lessons
Private lessons in Sydney NSW
map iconMap