Enable contrast version

Tutor profile: Erika B.

Inactive
Erika B.
Senior Systems Analyst at Indiana University of Pennsylvania
Tutor Satisfaction Guarantee

Questions

Subject: SQL Programming

TutorMe
Question:

Explain the anatomy of a sql statement

Inactive
Erika B.
Answer:

SQL statements have 3 main components. First, the SELECT portion of the statement contains the columns from the tables that you want to display as output to the query. Second, the FROM portion defines the database tables in which you will be selecting data from. Finally, the WHERE clause defines both the joins between the databases tables using foreign keys but also any criteria that will result in the outputted data being correct. SQL statements can have more advanced options, such as GROUP BY, ORDER BY, HAVING etc but all need a SELECT, FROM and WHERE clause.

Subject: Microsoft Excel

TutorMe
Question:

Please explain to to set up a spreadsheet in MS Excel that will track money going Into and out of an account.

Inactive
Erika B.
Answer:

Excel is a good tool for tracking finances. In order to set this up, first you would need to create some column headings. These could include items such as transaction date, transaction description and transaction amount. Begin by inputting the starting balance of the account into the spreadsheet. A formula for a running balance can be created within the transaction details that uses the beginning (or running balance for transactions after the first) and either add or subtracts the transaction amount.

Subject: Databases

TutorMe
Question:

Please differentiate between a foreign key and a primary key in a database table.

Inactive
Erika B.
Answer:

A table's primary key is what makes the record in the table unique. This key can be one or a combination of a number of columns within the table that constitute uniqueness within the record. It is important to reference the primary key with attempting to do maintenance on the record so as to ensure the correct data is being maintained. A foreign key is a column in a database table that is used to link that table to another table within the database. For example, a table of people may link to a table of addresses via a person identifier. The use of this foreign key is important when joining more than one database table that have related data.

Contact tutor

Send a message explaining your
needs and Erika will reply soon.
Contact Erika

Request lesson

Ready now? Request a lesson.
Start Lesson

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 Lesson" 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.
BEST IN CLASS SINCE 2015
TutorMe homepage
Made in California by Zovio
© 2013 - 2022 TutorMe, LLC
High Contrast Mode
On
Off