OpenGL

what-is-opengl-and-how-to-start-learning-it

OSI and TCP/IP

OSI and TCP/IP models

DHCP Server: Dynamic Host Configuration Protocol

Whats a DHCP server

68K assembly programming

Motorola 68000 ISA

68000 Loops

Hubs, Switches and Routers

Difference between a Hub, switch and router

Difference between a Modem and a Router

How the DNS works

What is a Dynamic DNS

TCP vs UDP

RAID 0, 1, 5 and 10

RAID 5 and 6

Pseudo Code examples:

Example 1:

Example 2:

Example 3:

Example 4:

MATLAB: Learn and practice

Online MATLAB compiler

MATLAB tutorial

MATLAB with simulink

Matrixlab Matlab

Coursera learn matlab

ARM ISA

The ARM instruction set architecture

Hex calculator

Hex-to-decimal-converter 

Database Schema Design Tool: Data Modelling

Design a database schema online

Flow Charts

XML Schema : Examples

XML schema basics

Advanced XML Schema Data types

Data Mining: The Apriori Algorithm: Finding Frequent Itemset

Apriori Algorithm

Apriori algorithm with example 

Triggers in Oracle

Triggers in Oracle Vs MS SQL


Example of creating a Trigger in Oracle

CREATE OR REPLACE TRIGGER Print_salary_changes
  BEFORE DELETE OR INSERT OR UPDATE ON emp
  FOR EACH ROW
WHEN (NEW.EMPNO > 0)
DECLARE
    sal_diff number;
BEGIN
    sal_diff  := :NEW.SAL  - :OLD.SAL;
    dbms_output.put('Old salary: ' || :OLD.sal);
    dbms_output.put('  New salary: ' || :NEW.sal);
    dbms_output.put_line('  Difference ' || sal_diff);
END;

Testing: Error/mistakes -> some become bugs/faults -> some cause failure

There are two main testing(test case selection) strategies :

1. White box testing or Structural testing(Internal structure of the program is considered)

• Coverage based testing
• Cyclomatic complexity
• Mutation testing

   2. Black box testing or Functional testing (The internal structure of the program is ignored, and attempt is to analyze the code , which produces the outputs for the given input values).

• Boundary-value analysis
• Equivalence partitioning                                                                                                                                

Unit Testing Strategies - 1 IITKH

Unit Testing Strategies - 2 IITKH

State Transition Diagram: Software Engineering

State chart diagram
 https://www.youtube.com/watch?v=KBNSZp2Ysdg&feature=emb_logo

State chart diagram case study https://www.youtube.com/watch?time_continue=124&v=b_LXeysj7RY&feature=emb_logo

State machine diagram IITKH

State machine diagram of a bank ATM by IIT Kharagpur.

Example 1:

Example 2

Example 2

Example 3

Python: Plotting graphs

Plot  graph g(t) = (t^2, t^3 - t) for t(-2,2)

import matplotlib.pyplot as mp
import numpy as np
#Domain
t = np.arange(-2,2,0.001)
# create lists x and y which have all the values of x and y for the given domain
x = []
y = []

for i in t:
  x = x + [i*i]
  y = y + [i*i*i -3*i]
mp.plot(x, y)
  #mp.show()

# naming the x axis
mp.xlabel('x - axis')
# naming the y axis
mp.ylabel('y - axis')

# giving a title to my graph
mp.title('')

# function to show the plot
mp.show()

Output:

You can practice python at colab

System Flow Chart

Understanding System flow chart


System flow chart is not a flow chart for an algorithm.

Sample system flow chart

DFD in Software Engineering

How to build a DFD
DFD modelling technnique
DFD basics

Building blocks of a DFD

How DFD works:

next

finally

DFD rules:

DFD levels:

Level 0 or context diagram: Write the name of the software in just one circle, then draw all system users and connect them to the system.

Example 1: Context level DFD for a tic-tac-toe game we often play

here the player INPUTS his moves and the system OUTPUTS display.

Example 2

Level 0

Level 1

 example1 

example2

Level 2

Example 1

Example 2

Level 3





Synchronous processes: Two processes are connected directly through a arrow

Asynchronous processes : Two processes are connected via a DATA STORE

Output of the system such as a 'printout or display' is shown by a paralellogram

Burst Time of a CPU: OS fundamentals

CPU burst time

Activity Diagram

Activity Diagram : Case Study

Gantt Chart and Pert Chart: Software Engineering Project Scheduling

What is a Gantt Chart

Creating Gantt Chart using MS ExceL

Project Planning : Scheduling

Creating Gantt Chart Manually

PERT Chart:

GANTT Vs PERT

How to create a PERT chart
PERT creation in detail

PERT chart with milestones(days/weeks of completion of that milestone) indicated inside the node circle. As shown below:
PERT chart

 The 'letter' on the edges denote the task names, while the arrows indicate the flow of tasks.

In yet another example below, we also have mentioned the duration of each task along with their names in parenthesis

Cost-Benefit Analysis of Software Projects

What is CBA (cost-benefit analysis)?

UML in SE

UML and Software Engineering

SQL: We need JOINS to fetch combined info from two tables connected by foreign key(s)

Here is an example:

Using the AND operator in the WHERE clause to get a value from both tables each, as shown in query below:

Inserting date in Oracle table, for doing that we need to use the TO_DATE function like: TO_DATE('12/01/2016', 'DD/MM/YYYY'), as shown in example below:

Then SELECT for a specific DATE as given below:

----------------------------------------------------------------------------------------------------------------------
To get 'weekly' data (sum/count) :

suppose there is a 'sales' table having a 'sold_date' field, then

SELECT product_name, SUM(price) FROM sales WHERE sold_date <= (sysdate) AND sold_date >= (sysdate - 7);

Similarly for generating Monthly reports

SELECT product_name, SUM(price) FROM sales WHERE sold_date <= (sysdate) AND sold_date >= (sysdate - 30);


-------------------------------------------------------------------------------------------------------------
We can have multiple AND operator in a SQL query

-----------------------------------------------------------------------------------------------------------
Understanding SQL Transactions

-----------------------------------------------------------------------------------------------------------
You can PRINT text in Oracle using AS clause:

Oracle 11g Database: Online terminal to practice SQL

Oracle 11g Database terminal online
The tables ones created here remains there for ever, so never forget the names of the tables created by you here, else you will not be able to access it again.
If you remember the table names created by you , you can use it again any time in future.

Example I created a table names 'studentsCSE'

I must remember the name 'studentsCSE' to use it again anytime in future.

Once you write a command, then comment that line by prefixing '--', if you do not want that command to be re-executed along with the new commands, in the current execution.

Use case Diagrams:UML diagrams videos by Lucidcharts

Use case diagram
ER Diagrams part1
ER Diagrams part2
Class Diagrams
Sequence Diagrams

Enhanced ER Model: Data Modelling

ER + EER
EER with Example
EER and Data modelling
Object Oriented Data Modelling: UML
Mapping an EER Model Relational Model (Tables) and OO Model 

Android Architecture and OS Internals

Android OS internals

Android apps file structure 

Windows 10 Operating System Internals

Windows Internals Part1, 6th Edition pdf
Learn Windows10 Internals
ebook Windows Internals-part-1and 2, 6th-edition
Windows 10 I/O management