Category Archives: CS Courses

How do I… Reseed a SQL Server identity column?

Microsoft SQL Server?s identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works.

www.techrepublic.com

Request Rejected

searchsqlserver.techtarget.com

Leave a comment

Posted in Database, MSSQL, SQL, T-SQL

Some Resources(Books, Links) for OOAD

Posted on October 1, 2017 | Leave a comment

https://www.quora.com/What-are-the-best-object-oriented-programming-and-design-pattern-online-courses

https://www.quora.com/Is-there-any-good-online-course-on-Object-Oriented-Analysis-and-Design

https://www.codeproject.com/Articles/1137299/Object-Oriented-Analysis-and-Design

Leave a comment

Posted in OO Analysis and Design, OOP

Polymorphism: Method Overloading and Method Overriding and Method Hiding

Posted on September 9, 2017 | Leave a comment

using System;
using Polymorphism;

namespace Polymorphism
{
    public static class CalCc
    {
        public static int add(int a, int b)
        {
            return a + b;
        }

        public static int add(int a, int b, int c)
        {
            return a + b + c;
        }


        public static float add(float a, float b)
        {
            return (a + b);
        }
    }
}
    

    class ProgramTest
    {
        static void Main(string[] args)
        {
        Console.WriteLine(CalCc.add(12,23));
        Console.WriteLine(CalCc.add(12,23,25));
            Console.WriteLine(CalCc.add(5.6f,7.8f));
            Console.ReadKey();
        }
    }

using System;

using Polymorphism;

namespace Polymorphism

{

public static class CalCc

{

public static int add(int a, int b)

{

return a + b;

}

public static int add(int a, int b, int c)

{

return a + b + c;

}

public static float add(float a, float b)

{

return (a + b);

}

class ProgramTest

{

static void Main(string[] args)

{

Console.WriteLine(CalCc.add(12,23));

Console.WriteLine(CalCc.add(12,23,25));

Console.WriteLine(CalCc.add(5.6f,7.8f));

Console.ReadKey();

}

using System;
using Polymorphism;

namespace Polymorphism
{
    public static class CalCc
    {
        public static int add(int a, int b)
        {
            return a + b;
        }

        public static int add(int a, int b, int c)
        {
            return a + b + c;
        }


        public static float add(float a, float b)
        {
            return (a + b);
        }
    }
}
    

    class ProgramTest
    {
        static void Main(string[] args)
        {
        Console.WriteLine(CalCc.add(12,23));
        Console.WriteLine(CalCc.add(12,23,25));
            Console.WriteLine(CalCc.add(5.6f,7.8f));
            Console.ReadKey();
        }
    }

using System;

using Polymorphism;

namespace Polymorphism

{

public static class CalCc

{

public static int add(int a, int b)

{

return a + b;

}

public static int add(int a, int b, int c)

{

return a + b + c;

}

public static float add(float a, float b)

{

return (a + b);

}

class ProgramTest

{

static void Main(string[] args)

{

Console.WriteLine(CalCc.add(12,23));

Console.WriteLine(CalCc.add(12,23,25));

Console.WriteLine(CalCc.add(5.6f,7.8f));

Console.ReadKey();

}

Method Overriding:

//override mane ektar opor arekta chore bosha
//mane ekta method er opor arekta method chore boshakei bole method overriding
//eta runtime ei hoy
//jei method tay override hoy setay override use korte hoy
//jei method tar opor override hoy seake virtual sombodhon korte hoy
//in this example we are overriding the eat method
using System;

namespace MethodOverride
{
    class Program
    {
        static void Main(string[] args)
        {
            Dog d=new Dog();
            d.eat();
            Console.ReadKey();
        }
    }

    public class Animal
    {
        public virtual void eat()
        {
            Console.WriteLine("Eating Food.");
        }
    }


    public class Dog : Animal
    {
        public override void eat()
        {
            Console.WriteLine("Eating bread");
        }
        
    }

}

//override mane ektar opor arekta chore bosha

//mane ekta method er opor arekta method chore boshakei bole method overriding

//eta runtime ei hoy

//jei method tay override hoy setay override use korte hoy

//jei method tar opor override hoy seake virtual sombodhon korte hoy

//in this example we are overriding the eat method

using System;

namespace MethodOverride

{

class Program

{

static void Main(string[] args)

{

Dog d=new Dog();

d.eat();

Console.ReadKey();

}

public class Animal

{

public virtual void eat()

{

Console.WriteLine("Eating Food.");

}

public class Dog : Animal

{

public override void eat()

{

Console.WriteLine("Eating bread");

}

another good exmple:

using System;

namespace MethodOverrideExample
{
    class Program
    {
        static void Main(string[] args)
        {
            Cars[] c = new Cars[2];
            c[0]=new newCars();
            c[1]=new oldCars();

            foreach (Cars key in c)
            {
                key.printInfo();
            }
            Console.ReadKey();

        }
    }
    
    class Cars
    {
        public virtual void printInfo()
        {
            Console.WriteLine("This is the base class");
        }
    }

    class newCars : Cars
    {
        public  override void printInfo()
        {
            Console.WriteLine("This is new cars class");
        }

    }

    class oldCars : Cars
    {

        public override void printInfo()
        {
            Console.WriteLine("This is the old cars");
        }
       
    }


}

using System;

namespace MethodOverrideExample

{

class Program

{

static void Main(string[] args)

{

Cars[] c = new Cars[2];

c[0]=new newCars();

c[1]=new oldCars();

foreach (Cars key in c)

{

key.printInfo();

}

Console.ReadKey();

}

class Cars

{

public virtual void printInfo()

{

Console.WriteLine("This is the base class");

}

class newCars : Cars

{

public override void printInfo()

{

Console.WriteLine("This is new cars class");

}

class oldCars : Cars

{

public override void printInfo()

{

Console.WriteLine("This is the old cars");

}

this video is good for learning overriding:

Method Hiding:

using System;


namespace Method_Hiding
{
    class FC
    {
        public virtual void Display()
        {
            Console.WriteLine("FC: Display");
        }
    }

    class SC : FC
    {
        public new void Display()
        {
            //base.Display();
            Console.WriteLine("SC: Display");
        }
    }

    class TC : SC
    {
        public new void Display()
        {
            //base.Display();
            Console.WriteLine("TC: Display");
        }
    }



    class Program
    {
        static void Main(string[] args)
        {
            SC p1=new SC();
            p1.Display();

            //((FC) p1).Display(); oobject casting

            FC p2=new FC();
            p2.Display();


            // SC pp = new FC(); it is not possible
            Console.ReadKey();

        }
    }
}

using System;

namespace Method_Hiding

{

class FC

{

public virtual void Display()

{

Console.WriteLine("FC: Display");

}

class SC : FC

{

public new void Display()

{

//base.Display();

Console.WriteLine("SC: Display");

}

class TC : SC

{

public new void Display()

{

//base.Display();

Console.WriteLine("TC: Display");

}

class Program

{

static void Main(string[] args)

{

SC p1=new SC();

p1.Display();

//((FC) p1).Display(); oobject casting

FC p2=new FC();

p2.Display();

// SC pp = new FC(); it is not possible

Console.ReadKey();

}

Leave a comment

Posted in .NET, C#, OO Analysis and Design, OOP

OOP Topics Need To Cover

Posted on July 20, 2017 | Leave a comment

https://www.javacodegeeks.com/2017/05/oops-concepts-need-know.html

Leave a comment

Posted in OO Analysis and Design, OOP

OOP Topics Need To Cover

Posted on July 20, 2017 | Leave a comment

https://www.javacodegeeks.com/2017/05/oops-concepts-need-know.html

Leave a comment

Posted in OO Analysis and Design, OOP

OOP Topics Need To Cover

Posted on July 20, 2017 | Leave a comment

https://www.javacodegeeks.com/2017/05/oops-concepts-need-know.html

Leave a comment

Posted in OO Analysis and Design, OOP

OOP in C#

Posted on July 14, 2017 | Leave a comment

Calculator.cs

namespace ConsoleApp6.Math

{
    public class Calculator
    {
        public int Add(int a,int b)
        {
            return a + b;
        }
    }
}

namespace ConsoleApp6.Math

{

public class Calculator

{

public int Add(int a,int b)

{

return a + b;

}

Program.cs

using ConsoleApp6.Math;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp6
{
    class Program
    {
        static void Main(string[] args)
        {
            Person john = new Person();
            john.FirstName = "John";
            john.LastName = "Smith";
            john.Introduce();

            Calculator calculator = new Calculator();
            var result = calculator.Add(1, 2);
            System.Console.WriteLine(result);
        }
    }
}

using ConsoleApp6.Math;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ConsoleApp6

{

class Program

{

static void Main(string[] args)

{

Person john = new Person();

john.FirstName = "John";

john.LastName = "Smith";

john.Introduce();

Calculator calculator = new Calculator();

var result = calculator.Add(1, 2);

System.Console.WriteLine(result);

}

Person.cs

using System;

namespace ConsoleApp6
{
    public class Person
    {
        public string FirstName;
        public string LastName;

        public void Introduce()
        {
            Console.WriteLine("My name is:"+FirstName+" "+LastName);
        }
    }
}

using System;

namespace ConsoleApp6

{

public class Person

{

public string FirstName;

public string LastName;

public void Introduce()

{

Console.WriteLine("My name is:"+FirstName+" "+LastName);

}

Leave a comment

Posted in C#, OOP

SOLID Concepts

Posted on June 23, 2017 | Leave a comment

Leave a comment

Posted in OO Analysis and Design, OOP

Object Oriented Programming Concepts

Posted on June 23, 2017 | Leave a comment

Leave a comment

Posted in OO Analysis and Design

OOP Clear

Posted on June 17, 2017 | Leave a comment

http://jompesh.com/videos/list/category/76

Leave a comment

Posted in OOP

Training Set, Validation Set, Test Set

Posted on May 28, 2017 | Leave a comment

Training Set is a subset of the dataset used to build predictive models.
Validation Set is a subset of the dataset used to assess the performance of model built in the training phase
– It provides a test platform for fine-tuning model’s parameters and selecting the best performing model
– Not all modeling algorithms need a validation set
Test set or unseen examples is a subset of the dataset to assess the likely future performance of a model.
– If a model fits the training set much better than it fits the test set. Overfitting is probably the cause

Binary Classification(two class classification)

true|false, 1|0, -1|+1, male|female

Multi-class classification problems can be seen as binary classification problems.

Model Evaluation:

https://en.wikipedia.org/wiki/Confusion_matrix

Leave a comment

Posted in Data Mining, Machine Learning

Tagged Model Evaluation

PHP OOP Project

Posted on April 22, 2017 | Leave a comment

Basic Simple Project By Me:

<?php

class Employee
{

    var $first;
    var $last;
    var $stat;
    var $uid;
    var $rate;
    var $hours;

    final public function __construct($f, $l, $st, $ui, $r, $ho)
    {
        $this->first = $f;
        $this->last = $l;
        $this->stat = $st;
        $this->uid = $ui;
        $this->rate = $r;
        $this->hours = $ho;
    }

    public function getALL()
    {
        echo "First Name:" . $this->first;
        echo "</br>";
        echo "Last Name:" . $this->last;
        echo "</br>";
        echo "Status:" . $this->stat;
        echo "</br>";
        echo "USerID:" . $this->uid;
        echo "</br>";
        echo "Pay Rate:$" . $this->rate;
        echo "</br>";
        echo "Housrs Worked:" . $this->hours;
        echo "</br>";
        echo "<b>Paycheck Amount:</b> $" . ($this->rate * $this->hours);
        echo "</br>";
        echo "</br>";

    }

}

class People extends Employee
{

}

$e = new People('JAddian', 'Forte', 'Manager', '521', '19', '40');
$e->getALL();

$e = new People('Victor', 'Davis', 'Assistant Manager', '231', '15', '33');
$e->getALL();

$e = new People('John', 'Clark', 'Worker', '687', '12', '26');
$e->getALL();

?>

<?php

class Employee

{

var $first;

var $last;

var $stat;

var $uid;

var $rate;

var $hours;

final public function __construct($f, $l, $st, $ui, $r, $ho)

{

$this->first = $f;

$this->last = $l;

$this->stat = $st;

$this->uid = $ui;

$this->rate = $r;

$this->hours = $ho;

}

public function getALL()

{

echo "First Name:" . $this->first;

echo "";

echo "Last Name:" . $this->last;

echo "";

echo "Status:" . $this->stat;

echo "";

echo "USerID:" . $this->uid;

echo "";

echo "Pay Rate:$" . $this->rate;

echo "";

echo "Housrs Worked:" . $this->hours;

echo "";

echo "Paycheck Amount: $" . ($this->rate * $this->hours);

echo "";

}

class People extends Employee

{

}

$e = new People('JAddian', 'Forte', 'Manager', '521', '19', '40');

$e->getALL();

$e = new People('Victor', 'Davis', 'Assistant Manager', '231', '15', '33');

$e->getALL();

$e = new People('John', 'Clark', 'Worker', '687', '12', '26');

$e->getALL();

By Others:
From OOP Fundamentals udemy Video project:

<?php

class Employee
{

    const MANAGER = 'MANAGER';
    const ASSISTANT_MANAGER='Assistant Manager';
    const WORKER='Worker';

//attributes
    protected $first;
    protected $last;
    protected $stat;
    protected $uid;
    protected $rate;
    protected $hours;

//class constructor
    final public function __construct($f, $l, $st, $ui, $r, $ho)
    {
        $this->first = $f;
        $this->last = $l;
        $this->stat = $st;
        $this->uid = $ui;
        $this->rate = $r;
        $this->hours = $ho;
    }

//function
    public function getALL()
    {
        echo "First Name:" . $this->first;
        echo "</br>";
        echo "Last Name:" . $this->last;
        echo "</br>";
        echo "Status:" . $this->stat;
        echo "</br>";
        echo "USerID:" . $this->uid;
        echo "</br>";
        echo "Pay Rate:$" . $this->rate;
        echo "</br>";
        echo "Housrs Worked:" . $this->hours;
        echo "</br>";
        echo "<b>Paycheck Amount:</b> $" . ($this->rate * $this->hours);
        echo "</br>";
        echo "</br>";
    }
} //end of employee class

class People extends Employee
{

}

$employee1 = new People('JAddian', 'Forte', People::MANAGER, '521', '19', '40');
$employee1->getALL();

$employee2 = new People('Victor', 'Davis', People::ASSISTANT_MANAGER, '231', '15', '33');
$employee2->getALL();

$employee3 = new People('John', 'Clark', Employee::WORKER, '687', '12', '26');
$employee3->getALL();

?>

<?php

class Employee

{

const MANAGER = 'MANAGER';

const ASSISTANT_MANAGER='Assistant Manager';

const WORKER='Worker';

//attributes

protected $first;

protected $last;

protected $stat;

protected $uid;

protected $rate;

protected $hours;

//class constructor

final public function __construct($f, $l, $st, $ui, $r, $ho)

{

$this->first = $f;

$this->last = $l;

$this->stat = $st;

$this->uid = $ui;

$this->rate = $r;

$this->hours = $ho;

}

//function

public function getALL()

{

echo "First Name:" . $this->first;

echo "";

echo "Last Name:" . $this->last;

echo "";

echo "Status:" . $this->stat;

echo "";

echo "USerID:" . $this->uid;

echo "";

echo "Pay Rate:$" . $this->rate;

echo "";

echo "Housrs Worked:" . $this->hours;

echo "";

echo "Paycheck Amount: $" . ($this->rate * $this->hours);

echo "";

}

} //end of employee class

class People extends Employee

{

}

$employee1 = new People('JAddian', 'Forte', People::MANAGER, '521', '19', '40');

$employee1->getALL();

$employee2 = new People('Victor', 'Davis', People::ASSISTANT_MANAGER, '231', '15', '33');

$employee2->getALL();

$employee3 = new People('John', 'Clark', Employee::WORKER, '687', '12', '26');

$employee3->getALL();

Leave a comment

Posted in OOP, PHP

PHP OOP: Class, Method, Object, Instance, Declare, Echo, Inheritance,Constructor,Access Control,Static!

Posted on April 18, 2017 | Leave a comment

PHP OOP example described here from edwin’s video:

<?php

class Car{
    var $wheels=4;
    var $hood=1;
    var $engine=1;
    var $doors=4;
    
    function MoveWheels(){
        //echo "Wheels move";
        //$this means reference inside the class for outside we need to create instance of a class with object and call by reference with variable or method to show;
        $this->wheels=4;
        
    }
    
    
    function CreateDoors(){
        $this->doors=6;
    }
}

$bmw=new Car(); //instance of the class
$truck=new Car(); //new instance for truck

$bmw->MoveWheels();
//$bmw->wheels=8;
echo $bmw->wheels."</br>";
echo $truck->wheels=10;
echo "<br>";
$truck->CreateDoors();
echo $truck->doors;

//if(class_exists("car", "MoveWheels")){
//    echo "Method Exists";
//}else{
//    echo "No";
//}
?>

<?php

class Car{

var $wheels=4;

var $hood=1;

var $engine=1;

var $doors=4;

function MoveWheels(){

//echo "Wheels move";

//$this means reference inside the class for outside we need to create instance of a class with object and call by reference with variable or method to show;

$this->wheels=4;

}

function CreateDoors(){

$this->doors=6;

}

$bmw=new Car(); //instance of the class

$truck=new Car(); //new instance for truck

$bmw->MoveWheels();

//$bmw->wheels=8;

echo $bmw->wheels."";

echo $truck->wheels=10;

echo " ";

$truck->CreateDoors();

echo $truck->doors;

//if(class_exists("car", "MoveWheels")){

// echo "Method Exists";

//}else{

// echo "No";

//}

Inheritance example:

<?php
class Car{

var $wheel=14;
var $hood=1;
var $engine=1;
var $doors=4;

function MoveWheeels(){
$this->wheels=14;
}

function CreateDoors(){
$this->doors=6;
}
}

class Plane extends Car{
 var $wheels=20;
}
$jet=new Plane();
echo $jet->wheels;
?>

<?php

class Car{

var $wheel=14;

var $hood=1;

var $engine=1;

var $doors=4;

function MoveWheeels(){

$this->wheels=14;

}

function CreateDoors(){

$this->doors=6;

}

class Plane extends Car{

var $wheels=20;

}

$jet=new Plane();

echo $jet->wheels;

Constructor:

<?php

class Car{
    var $wheels=4;
    var $hood=1;
    var $engine=1;
    var $doors=4;
    
    function __construct(){
        //echo "Wheels move";
        //$this means reference inside the class
       echo $this->wheels=4;
        
    }
    
    
    function CreateDoors(){
        echo $this->doors=6;
        echo "</br>";
    }
}


$truck=new Car();
echo "</br>";
echo $truck->CreateDoors();

?>

<?php

class Car{

var $wheels=4;

var $hood=1;

var $engine=1;

var $doors=4;

function __construct(){

//echo "Wheels move";

//$this means reference inside the class

echo $this->wheels=4;

}

function CreateDoors(){

echo $this->doors=6;

echo "";

}

$truck=new Car();

echo "";

echo $truck->CreateDoors();

Access control: Public, Private, Protected

<?php

class Car{
    public $wheels=4;
    protected $hood=1;
    private $engine=1;
    var $doors=4;
    
    function showProperty(){
        //echo "Wheels move";
        //$this means reference inside the class
        echo $this->engine;       
    }
}

$bmw=new Car(); //instance of the class
$semi=new Semi();
Class Semi extends Car{
    
    
}
echo $bmw->showProperty();
//echo $bmw->showProperty();
?>

<?php

class Car{

public $wheels=4;

protected $hood=1;

private $engine=1;

var $doors=4;

function showProperty(){

//echo "Wheels move";

//$this means reference inside the class

echo $this->engine;

}

$bmw=new Car(); //instance of the class

$semi=new Semi();

Class Semi extends Car{

}

echo $bmw->showProperty();

//echo $bmw->showProperty();

Static Data in Class:

Leave a comment

Posted in OOP, PHP

Tagged php OOP

Database Interview Questions

Posted on March 9, 2017 | Leave a comment

http://jompesh.com/videos/1/1760/lesson-26-database-normalization

Theory site: http://www.studytonight.com/dbms/generalization-and-specialization.php
Another Resource: http://www.guru99.com/database-normalization.html

Leave a comment

Posted in Database, SQL

Category Archives: CS Courses

Stored Procedures

SQL Identity Key ,T-SQL

Some Resources(Books, Links) for OOAD

Polymorphism: Method Overloading and Method Overriding and Method Hiding

OOP Topics Need To Cover

OOP Topics Need To Cover

OOP Topics Need To Cover

OOP in C#

SOLID Concepts

Object Oriented Programming Concepts

OOP Clear

Training Set, Validation Set, Test Set

PHP OOP Project

PHP OOP: Class, Method, Object, Instance, Declare, Echo, Inheritance,Constructor,Access Control,Static!

Database Interview Questions

Categories

Recent Comments

About Me & MyBlog

Caution and Tips:

My Facebook

Recent Posts

Archives

Category Archives: CS Courses

Categories

Recent Comments

About Me & MyBlog

Caution and Tips:

My Facebook

Recent Posts

Tags

Archives