CIS 100 IT Fundamentals

https://www.youtube.com/watch?v=wR0jg0eQsZA

https://www.youtube.com/watch?v=FR4QIeZaPeM

https://www.youtube.com/watch?v=grAMeLcPv8U

Database Tutorial

Question 1: The video starts with a shop owner using a spreadsheet to organize their data and breaks it down as a straightforward data entry process for small amounts of data but a nightmare once the business grows. Applying some of the basics that you learned in class, surmise a plan to organize the data for the cat store into a database and explain how it would make data retrieval more relevant?

Database Tutorial

Question 2: The video mentions Entity Relationship Diagrams as a visual way of looking at the structure of your database. Whether it is self-coded by an ERD App or manually typed in, ERD helps optimize database data and relationships. Based on your own skills, would you find it easier to code your database yourself or have an Application assist you? List and advantage of both methods.

What is a Database and SQL

Question 3: The video defined a database as a systematic collection of data that helps make data management easier. Through using DBMS, a database can be accessed and manipulated by the end user. Research three programs that can act as a DBMS? Have you ever used any of the programs you found?

What is a Database and SQL

Question 4: SQL or Structured Query Language is the standard language for dealing with relational databases. Research two SQL software and determine which of the two you researched would you find easier to adopt and utilize? Explain your choice?

Database Concepts

Question 5:  The video pointed out the difference between an Excel Spreadsheet as a database and using an actual database. He mentioned that Excel was limited in size and scope and is intended to be used by one person at a time. In your opinion, do you think a functional database can be created solely in Excel? If no, explain why?

Database Concepts

Question 6: The video mentioned many different Database servers like MySQL which is based on the SQL language. The video mentioned that databases are constructed from tables that store common date to be queried. From this, explain in your own words why it would be important to ensure all the data in each of your tables is correct and complete for the database to work?

Database Concepts

Question 7:  The video spoke of the advantage of relational databases for query searching. It stated that hundreds, if not thousands of results, could be queried from a relational database. The video also mentioned non-relational database that are designed to query one thing very fast. Think of an example of a relational database being advantageous and an example of a non-relational database being advantageous.

https://www.youtube.com/watch?v=OW3n4RtCiSA

https://www.youtube.com/watch?v=NTEznm0vuzU

Getting Started in Software Development

Question 1: The video stresses an importance but not a necessity to understanding how a computer works, how files work, how network works ect. Do you feel, in your own experience, that this advice is necessary? What help do you think knowing how hardware works will affect programming?

Getting Started in Software Development

Question 2: The next piece of advice given was to pick a platform and build on that first, He mentioned Wed development as a good starting point. In your opinion, why do you think Web Development is a good beginning platform for software development? What disadvantages do you foresee using Web Development as a start?

Getting Started in Software Development

Question 3: The video mentioned that software development is mostly problem solving more than anything. As your code becomes more complex, you need to find solutions to those complex issues and if you are a beginner, it can be daunting. Find three ways a beginner can solve software development issues without starting all over.

How to get Started in Software Development

Question 4: The video mention how he got started by getting source code to a game he liked and making augments to the game to see the effects. This practice is called reverse engineering and is a long approach to getting software to do what you need. In your opinion, do you think reverse engineering code to see how it works is a good first step for new programmers? If so explain why? If not, what approach would you recommend?

How to get Started in Software Development

Question 5: Through analogies, the video breaks down that software development works best with hands-on learners as opposed to visual or auditory. Liking programming through book learning as reading books on football but never playing the game; making some concepts difficult to visualize. Focus on your learning style. How do you feel you would be best served in learning software development? Explain your reason.

How to get Started in Software Development

Question 6: Another point of advice for new software developers is to look at companies that are hiring programmers and see the job descriptions. Find out what programs are in demand and research ways to start working and practicing on those programs that the market needs as opposed to traditional languages. Do you think this is good advice? What advice would you give for new programmers on how to get started?