056004 - Open Source Technology


    On completion of the following units of syllabus contents, the students must be able to
    Understand the need, advantages and disadvantages of Open Source software.
    Understand the general concepts and modes of Linux Operating ?System.
    Understand the advanced concepts like Scheduling, Time Accounting,Personalities and coning.
    Know the basic concepts of Open Source Database.
    Know how to connect MY SQL database and closing connection. ?Write Simple MY SQL Programs.
    Creating database and tables in MY SQL. ?Manipulate database tables in MY SQL.
    ?Understand the concepts of Record Selection technologies ?Install and Configure of PHP on Windows.
    Understand the basic concepts of PHP.
    Understand the String and Array concepts in PHP.
    List the advanced features of PHP. Discuss the Memory Management, Parameter Handling and Variables in
    PHP. Understand how to access a database using PHP
    Discuss about the advanced Database techniques.
    Discuss about the Apache Web Server and Configuring the server.
    Explain the History and Architecture of Eclipse IDE Platform.
    Understand the basics of Python Knowing the building blocks of python language
    Knowing the development process of a Python program,
    Understanding file handling using python

Introduction : Need of Open Sources – Advantages of Open Sources – Applications – FOSS –– Free Software Movement, Commercial aspects of Open Source movement -.Application of Open Sources Network operating systems – LINUX – features of linux– Linux advanced concepts

What is PHP? - Basic Syntax of PHP - programming in web environment - Common PHP Script Elements - Using Variables - Constants – Data types - Operators; Statements - Working With Arrays –Using Functions – OOP - String Manipulation and Regular Expression File and Directory Handling - Including Files - File Access Working With Forms -Processing Forms -Form Validation – Introduction to advanced PHP concept Simple programs Using PHP

Introduction of MYSQL - Setting up an account - Starting, Terminating and writing your own MySQL Programs – Record Selection Technology - Working with Strings – Date and Time - Sorting Query Results module – Generating Summary - Working with Metadata - Using Sequences – MySQL and Web PHP and SQL database: PHP and LDAP ; PHP Connectivity ; Sending and receiving emails PHP Database Connectivity: Retrieving data from MySQL - Manipulating data in MySQL using PHP

Overview – Installing – Running in windows/Linux Variables and Strings: Data types - Operators – Decision Control – Conditional Statements - Loops – Example Programs Sequences: Lists: Introduction –Fixed size lists and arrays – Lists and Loops – Assignment and references –Identity and equality – Sorted lists – Tuples: Tuples and string formatting – String functions - Sets: Unordered Collections – Simple programs Dictionaries, Sets) Using modules – File Handling -Exception – Handling exception

Apache Web server – Working with web server – Configuring and using apache web server WAMP and Xamp server

PHP
1. Write a program to create Student registration form
2. Write a program to perform EB bill calculation
3. Write a program to perform Student grade manipulation
4. Write a program to perform String operations in PHP
5. Write a program to create Book master form
6. Write a program to perform Form validation – Railway ticket reservation
7. Write a program to perform Date and time operations in PHP
8. Write a program to Identify the web browser
9. Demonstrate the Database – Insert operation
10. Demonstrate the Database – Delete operation
11. Demonstrate the Database - Update operation

MYSQL
12. Demonstrate the Queries Record selection operation
13. Write the queries to demonstrate the working with date and time functions

PYTHON
14. Demonstrate the Simple Programming and File handling operation
Contributions are welcome!
If you find any issues or want to add new features, feel free to submit a pull request on GITHUB

To Download Privious Year Question Papers of all Semester (CSE) Follow and DM on -


Website Developed by