Introduction to Software Technologies
Basically we have 3 types of Software,
i) System Software: Used to operating the system and its devices…
Ex: OS (Windows, UNIX etc…), Device Drivers….
ii) Programming Software: Used to develop the Software Applications.
Ex: Java, .NET, Oracle, SAP etc…
iii) Application Software: Used to conduct Business Operations.
Ex: Banking Applications, Insurance Applications, ERP Applications, Ecommerece Applications etc…
1) What is Unix?
UNIX is an operating system which was first developed in the 1960s, and has been under constant development ever since. By operating system, we mean the suite of programs which make the computer work. It is a stable, multi-user, multi-tasking system for servers, desktops and laptops.
UNIX systems also have a graphical user interface (GUI) similar to Microsoft Windows which provides an easy to use environment. However, knowledge of UNIX is required for operations which aren’t covered by a graphical program, or for when there is no windows interface available, for example, in a telnet session.
There are many different versions of UNIX, although they share common similarities. The most popular varieties of UNIX are Sun Solaris, GNU/Linux, and MacOS X.
2) What is C?
The C programming language is a structure oriented programming language, developed at Bell Laboratories in 1972.
The C programming language is used for developing,
Operating system development
Compilers and Assemblers
3) What is C++?
C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications. C++ is a superset of the C language.
A related programming language, Java, is based on C++ but optimized for the distribution of program objects in a network such as the Internet. Java is somewhat simpler and easier to learn than C++ and has characteristics that give it other advantages over C++. However, both languages require a considerable amount of study.
4) What is Java?
Java is a Programming Language and a Platform
Java is used as a programming language (Object oriented pgrogramming) to develop Software Applications, and Java is used as Software Platform to run Java Applications.
Java has 3 important Editions,
i. Java Standard Edition / Core Java (* Old name J2SE)
ii. Java Enterprise Edition / Advanced Java (*Old name J2EE)
iii. Java Micro Edition (* Old name J2ME)
Java is used to develop,
5) What is .NET?
The .Net framework is a software development platform developed by Microsoft. The framework was meant to create applications, which would run on the Windows Platform.
The .Net framework can be used to create both – Form based and Web based applications. Web services can also be developed using the .Net framework.
The framework also supports various programming languages such as Visual Basic and C#. So developers can choose and select the language to develop the required application.
6) What is SQL?
> SQL stands for Structured Query Language
> SQL was initially developed at IBM in 1970s
> SQL is the standard language to communicate with relational database management systems like Oracle, MS Access, MS SQL Server, MySQL, DB2, Sybase Etc…
Purpose of SQL
i. SQL is used to Create New Databases
ii. SQL is used to Create New Tables in a Database
iii. SQL is used to Insert records in a Database
iv. SQL is used to Update records in a Database
v. SQL is used to Delete records in a Database
vi. SQL is used to Retrieve data from a Database
vii. SQL is used to execute queries against a Database
viii. SQL can set permissions on tables, procedures and views
ix. SQL is used to Create stored procedures in a Database
x. SQL is used to Create views in a Database
7) What is SQL Server?
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).
8) What is Oracle?
Oracle database is a relational database management system. It is known as Oracle database, OracleDB or simply Oracle. It is produced and marketed by Oracle Corporation.
Oracle database is the first database designed for enterprise grid computing. The enterprise grid computing provides the most flexible and cost effective way to manage information and applications.
9) What is Python?
Python is an interpreted, object-oriented programming language similar to PERL, that has gained popularity because of its clear syntax and readability. Python is said to be relatively easy to learn and portable, meaning its statements can be interpreted in a number of operating systems, including UNIX-based systems, Mac OS, MS-DOS, OS/2, and various versions of Microsoft Windows.
10) What is Software Testing?
Testing computer Software and or Mobile Software is called Software Testing,
Software Testing can be done in 2 ways,
i. Manual Testing: Testing Computer and or Mobile Software manually without using any Test Tool or Test Script….
ii. Automated Testing or Test Automation: Testing Computer and or Mobile Software using any Test Tool or Test Script…
11) What is SAP?
SAP stands for Systems Applications and Products in Data Processing.
SAP by definition is also named of the ERP (Enterprise Resource Planning) software as well the name of the company.
SAP Software was Founded in 1972, SAP system consists of a number of fully integrated modules, which covers virtually every aspect of the business management.
Other Competitive products of SAP Software in the market are Oracle, Microsoft Dynamics etc.
12) What is Web Service?
A Web Service is can be defined by following ways:
i) Web Service is a client server application or application component for communication.
ii) Web Service is a method of communication between two devices over network.
iii) Web Service is a software system for interoperable machine to machine communication.
iv) Web Service is a collection of standards or protocols for exchanging information between two devices or application.
Note: Java, .NET or PHP applications can communicate with other applications through web service over the network. For example, java application can interact with .Net and PHP applications. So web service is a language independent way of communication.
13) What is Data Science?
Data science, is an interdisciplinary field about scientific methods, processes, and systems to extract knowledge or insights from data in various forms, either structured or unstructured, similar to data mining.