Orientation_class_15.03.19.pdf

ORACLE RDBMS RDBMS-Relational Database Management System

Some Relational Database System are: 1. Oracle Database 2. IBM DB2 3. Microsoft SQL SERVER 4. SAP Sybase ASE 5. TERADATA 6. ADABAS 7. My SQL 8. FileMaker (Apple) 9. Microsoft Access 10. Informix 11. SQLite 12. PostgreSQL 13. Amazon RDS 14. Redis 15. CouchDB 16. Neo4j 17. OrientDB 18. Toad 19. phpMyAdmin

1

SOFTWARE Software - Software is a set of instructions or programs written by programmers/developers on various languages for computer to perform some specific task Software is often divided into two categories. 1) System Software - It is a base for application software which responsible for managing hardware. In other words we can say that system software is a intermediator between user and hardware. System software is also known as Operating System Example - MS-Windows, UNIX, Linux, Sun Solaris 2) Application Software - or simply applications, are often called productivity programs or end-user programs because they enable the user to complete tasks, such as creating documents, spreadsheets, databases and publications, doing online research, sending email, designing graphics, running businesses, and even playing games! Application software is specific to the task it is designed for and can be as simple as a calculator application or as complex as a word processing application.

2

Frontend VS Backend Frontend Development is talking about the part that users can really see and interact with of the website or web application. Basically every component from buttons, menus, dropdowns or even images. Mostly involves development from editing images in Photoshop, to coding HTML pages and styling with CSS. Even Using JavaScript or any other UI library based on it is Considered Front End Development. Backend Development is divided into three parts: server, application and database. These three parts perform the business logic. For example, if you ordered a meal from a restaurant, you enter the required information in the frontend and the backend stores it, verify if any wrong information entered, bypass your order to the kitchen, notify you with more information, etc.. All this processes run on server's backend where users can't see what happens.

SDLC SDLC – Software Development Life Cycle. Step of SDLC: 1. Requirement Collection 2. Analysis 3. DFD (Data Flow Diagram) 4. ERD (Entity Relationship Diagram) 5. Coding 6. Testing 7. Implementation 3