Unit 1 SQL Programming

• Introduction to SQL, its role
• key features, and advantages
• Creating simple databases
• retrieving and summarizing data
• deleting, and updating records, and ensuring data security
• Understanding SQL basics: statements
• identifiers (table names
• column names)
• data types
• constants (numeric
• built-in functions
• handling missing data 10 * Problem Based Learning (PBL) aims to accommodate learning beyond syllabus as per clause 9.4 of NBA manual
• Program Name: Bachelor of Engineering Level: UG Branch: Biotechnology Subject Code: BE03004021 Subject Name: Computational Biology (null values), and executing queries

Unit 2 Introduction to Python

10 lecture hours

• Overview of Python
• its history
• features, and development tools
• Writing Python programs
• understanding values and variables including numeric values
• expressions, and variable assignments
• Introduction to operators: arithmetic
• logical, and bitwise
• Exploring core data types: numbers
• booleans, and strings

Unit 3 Functions and Flow Statements

15 lecture hours

• Sequence overview
• common sequence operations
• adding sequences
• minimum, and maximum
• lists: python’s workhorse
• the list function
• basic list operations
• list methods
• tuples: immutable sequences
• the tuple function
• basic tuple operations. control flow statements: simple if statement
• if/else statement
• if/elif statement
• nested if statement
• conditional expressions
• while loop
• for loop
• continue and break statements

Unit 4 Strings and Files Handling

10 lecture hours

• Exception handling, try, except statement
• built-in functions
• commonly used modules. strings
• creating and storing strings
• the str () function
• basic string operations
• string comparison
• concatenation split
• formatting strings. files
• creating and opening text files
• reading and writing data and csv file concepts