facebook

Private teachers in Bernau Bei Berlin

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

2 private teachers in Bernau Bei Berlin

0 teachers in my wish list
|
+

2 private teachers in Bernau Bei Berlin

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
French · Teaching · Culture
Showing results 176 - 200 of 65230176 - 200 of 65230

Our students from Bernau Bei Berlin evaluate their teacher.

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

Tutoring at home (privet courses ) /ALL Subject For IG,SAT,IB & National System WITH International Education Academy For IGCSE, SAT, IB (New Cairo)
Eng. Mohamed
rating star
rating green star
Mr. Mohammed is a great teacher. He has been very friendly and patient with my son. He always assigns homework after every lesson and revises with him the previous lesson to make sure that he has fully understood the topic. This has improved my son’s math skills in a short amount of time. His personality is great as he makes the student feel comfortable by asking questions. We are happy to continue to work with him long-term as well.
Review by يحي حسين
Mathematics, Statistics and English Tutoring at Various Levels (The Hague)
Natalia
rating star
rating green star
I have been working with Natalia for quite a while now and I can say every class with her is enlightening, fun, and most importantly super helpful. I study Statistics with her, and it is not at all my strong suit, however, Natalia made it possible for me to pass courses that otherwise I would have not been able to pass. I would 100% recommend her to anyone who is struggling or would like to improve.
Review by SZOFI
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
map iconMap