Ahmed S.

Business Intelligence Analyst, MBA, Computer and Systems Engineering

Tutor Satisfaction Guarantee

Numerical Analysis

TutorMe

Question:

Imagine you have a sequence of 3 numbers 1,17,8,.. what is the next number ?

Ahmed S.

Answer:

To answer questions like that you should generalize a formula to solve any kind of 3 number sequences. Let's assume that the three numbers form a linear equation of a straight line where you have 2 points (1,17) and (17,8). Here I assumed a linear relation where ,it is not forbidden here and applicable, and the relation between each number and the previous one is the same, Now you have 2 points where you can easily a straight line equation of y=mx+b by solving the two equations in m and b 17=m+b and 8=17m+b solve for m and b then you have straight line equation where you can substitute with the same method by 8 to get y or the next number y=8m+b (Solved!)

Databases

TutorMe

Question:

What is the maximum number of inner sub-queries you can use in SQL ?

Ahmed S.

Answer:

In SQL there is no maximum number for inner or subqueries. You can have a subquery inside a subquery inside a subquery and so forth. For Example: SELECT NAME_B FROM ( SELECT NAME AS NAME_B FROM (SELECT NAME FROM EMPLOYEE) A) B; The above query although it is doable but it is not the best engineering practice as with more records in a table you can face performance issues and you should always check the explain plan prior running or committing an SQL script.

Data Engineering

TutorMe

Question:

What does ETL stands for and give an example for a tool you can use to do ETL?

Ahmed S.

Answer:

ETL stands for Extract-Transform-Load, there is also another model which is the ELT or Extract-Load-Transform. The ETL model is the most used. There are several tools that can help do this process from many vendors, one of the most popular tools is the IBM - InfoSphere DataStage. To help imagine what is ETL, assume you have lots of food everywhere and you have an afternoon party that you have to prepare food for. So you take the needed ingredits from everywhere (Extract) and then put it the kitchen where you can use the oven, add some sauces, etc (Transform) and then you will put the final deliverable food on the table (Load).

Send a message explaining your

needs and Ahmed will reply soon.

needs and Ahmed will reply soon.

Contact Ahmed

Ready now? Request a lesson.

Start Session

FAQs

What is a lesson?

A lesson is virtual lesson space on our platform where you and a tutor can communicate.
You'll have the option to communicate using video/audio as well as text chat.
You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.

How do I begin a lesson?

If the tutor is currently online, you can click the "Start Session" button above.
If they are offline, you can always send them a message to schedule a lesson.

Who are TutorMe tutors?

Many of our tutors are current college students or recent graduates of top-tier universities
like MIT, Harvard and USC.
TutorMe has thousands of top-quality tutors available to work with you.