29 August 2022
→Algorithm
Algorithm is a sequence of instructions and a procedure or formula for solving problem.It is used to determine the objective the problem , Dividing the process, convert process to flow diagram, writing pseudo code for flow and implementing pseudo code.
→Problem
A question or situation that presents uncertainity , perplexity or difficulty.
→Problem solving
A systematic approach to defining the problem and creating possible solutions.
A typical programming task has divided into 2 phases , Problem solving phase and Implementation phase.
→Flowchart
It is the pictorial representation of the Problem.
This will help us to the clear idea about how the process continues.
→Pseudocode:
It is merely the plain English implementation of an algorithm with annotations and explanatory prose. It has no grammar like any other programming language, making it impossible for a computer to compile or interpret.
30 August 2022
→Software programming using C
C is the basic language which has been invented by Dennis Ritchie.
On this day we basically studied basic coding skills where how the c program works and how the structure should look like.
And practiced by doing many hands on problems . Here we went on to use conditional statements also many character string related problems.
#include <iostream>
using namespace std;
class Power{
int SQ,CB;
public:
Power(int N){
SQ = N*N;
CB = SQ*N;
}
void print(){
cout<<”Square = “<<SQ<<”\nCube = “<<CB;
}
};
int main()
{
int N;
cout<<”Enter the Number: “;
cin>>N;
Power P = Power(N);
P.print();
return 0;
}
#include <iostream>
using namespace std;
class Account{
string Name,IFSC;
long AccountNumber;
public:
Account(){
cout<<”Enter account holder Name: “;
cin>>Name;
cout<<”Enter IFSC code: “;
cin>>IFSC;
cout<<”Enter Account Number: “;
cin>>AccountNumber;
}
void getAccountDetails(){
cout<<”\n\nAccount Details….\n”;
cout<<”Account Number: “<<AccountNumber<<endl;
cout<<”Account holder name: “<<Name<<endl;
cout<<”IFSC code: “<<IFSC<<endl;
}
};
int main()
{
Account account = Account();
account.getAccountDetails();
return 0;
}
01 September 2022
Object Oriented Programming(OOP)
Object-Oriented Programming is a methodology or paradigm to design a program using classes and objects.
→Object: An entity that has state and behavior is known as an object e.g., chair, bike, marker, pen, table, car, etc.
→Classes: A class is a group of objects which have common properties. It is a template or blueprint from which objects are created. It is a logical entity. It can’t be physical.
→Abstraction: Abstraction is a process of hiding the implementation details and showing only functionality to the user.
→Encapsulation: Encapsulation is a process of wrapping code and data together into a single unit, for example, a capsule which is mixed of several medicines.
→Polymorphism: Polymorphism is a concept by which we can perform a single action in different ways. Polymorphism is derived from 2 Greek words: poly and morphs. The word “poly” means many and “morphs” means forms. So polymorphism means many forms .
→Inheritance: Inheritance is a mechanism in which one object acquires all the properties and behaviors of a parent object.
02 September 2022
→Testing
The process of evaluating and verifying that a software product or application does what it is supposed to do.
First we learnt the advantages and disadvantages of testing. Here we also learnt the diff between manual testing and the automation testing.
→Manual testing:
Manual testing is a software testing process in which test cases are executed manually without using any automated tool. All test cases executed by the tester manually according to the end user’s perspective. It ensures whether the application is working, as mentioned in the requirement document or not. Test cases are planned and implemented to complete almost 100 percent of the software application. Test case reports are also generated manually.
→Automation testing:
Automation testing is the process of carrying out the test activities using the assistance of tools, scripts, and software by repeating pre-defined actions. In simple terms, you can understand automation testing as a type of testing that focuses on replacing repetitive, error-prone, and time-consuming manual tasks or activities with automated scripts in order to enhance the performance of the software and efficiency.
There are mainly 3 types of testing: White box, Black box, Grey box.
→White Box Testing:
White Box Testing is software testing technique in which internal structure, design and coding of software are tested to verify flow of input-output and to improve design, usability and security. In white box testing, code is visible to testers so it is also called Clear box testing, Open box testing, Transparent box testing, Code-based testing and Glass box testing.
→Black Box Testing:
Black Box Testing is a software testing method in which the functionalities of software applications are tested without having knowledge of internal code structure, implementation details and internal paths. Black Box Testing mainly focuses on input and output of software applications and it is entirely based on software requirements and specifications. It is also known as Behavioral Testing.
→Grey Box Testing:
Grey Box Testing or Gray box testing is a software testing technique to test a software product or application with partial knowledge of internal structure of the application. The purpose of grey box testing is to search and identify the defects due to improper code structure or improper use of applications.
Then in the afternoon we done a hands on work in jira . Here ranjitha srinivas helped us to build the testing tool. How the test case and the execution of the project will be done in the higher level.
Hands on work in jira. which helped us to increase the practical knowledge about the topic
After the Session completed by ranjitha srinivas , The session was continued by Arun , Who explained us Taking the examples of Hotstar, ICICI PORTAL etc., By this way this was one of the wonderful day with lots of knowledge.
03 September 2022
Database concepts
DBMS- DATABASE MANAGEMENT SYSTEM
RDBMS- RELATIONAL DATABASE MANAGEMENT SYSTEM
Database-->Collection of tables — organized — easy to access
Table → Collection of rows and columns
SQL → Structured Query Language
Normalization:
1) First normal form 1NF
2) Second normal form 2NF
3) Third normal form 3NF
4) Boyce Codd normal form BCNF
5) Fourth normal form 4NF
6) Fifth normal form 5NF
DML,DQL,DDL,TCL,DCL
→DDL — DATA DEFINITION LANGUAGE → create, alter, drop
→DML — DATA MANIPULATION LANGUAGE — Operations/ functionalities/ actions- insert, update, delete
→DQL- DATA QUERY LANGUAGE- VIEW A TABLE- select
→TCL- TRANSACTION CONTROL LANGUAGE- payment options — commit, rollback, savepoint
→DCL- DATA CONTROL LANGUAGE- rights- lead(DML), dev(select)- grant, revoke/deny
use db_training;
create table training
(
tid int,
tname varchar(25),
tdepartment varchar(25)
);
select * from training;
insert into training values(‘1’, ‘ASP.NET’, ‘DOTNET’);
insert into training values(‘2’, ‘JAVA.NET’, ‘DOTNET’);
insert into training values(‘3’, ‘C#.NET’, ‘DOTNET’);
insert into training values(‘4’, ‘L.NET’, ‘DOTNET’);
insert into training values(‘5’, ‘P.NET’, ‘DOTNET’);
update training set tname=’c#’ where tid=4;
delete from training where tid=5;
Constraints- set of rules
Primary key- unique identifier, no null, no-duplication, one primary key in a table.
Unique key- One null, more than one unique column in a table.
Foreign key- Connect table.
Default- To set the the values of the column by default if the data is not inserted during the insertion.
NOT NULL- This needs the value and will not take the null values.
Create table manager
(
manager_id int Primary key,
manager_name varchar(25) not null,
manager_department varchar(25) not null unique,
);
insert into manager values (1,’John’,’.NET’);
insert into manager values (2,’Peter’,’JAVA’);
insert into manager values (3,’Sam’,’TESTING’);
insert into manager values (4,’Mary’,’PYTHON’);
Select * from manager;
Create table employee
(
employee_id int primary key,
employee_name varchar(25) not null,
employee_designation varchar(25) default ‘trainee’,
employee_age int check (employee_age>20),
manager_id int ,foreign key references manager(manager_id)
)
insert into employee values(100,’shaun’,’Developer’,24,1);
insert into employee values(101,’paul’,’Developer’,24,2);
insert into employee(employee_id, employee_name, employee_designation, employee_age, manager_id) values(102,’Lea’,’Developer’,24,2);
insert into employee(employee_id, employee_name, employee_age, manager_id) values(103,’lee’,22,3);
insert into employee values(104,’dwayne’,’Designer’,20,4);
select * from employee;
Relational logical and like operator- where apply condition
Select c_id as ID, c_name as Name from Customers
avoid duplicate values(DISTINCT)
Select Distinct c_mobile from Customers
% and _
Select * from Customers where c_name like ‘N%’
Select * from Customers where c_name like ‘_T’
Select * from Customers where c_name like ‘_H%’
Where
select * from employee where employee_id>102;
All the database concepts and the basics were learnt in this session and We had the task given were we need to do the task according to our understanding.
Summary
This Blog mainly defines the study of following things
i) Learning of algorithm,flowchart and pseudocode.
ii) Learning of basic coding using c language
iii) Learning of oops concept
iv)Testing concepts
v)Database concepts