Category Archives: CS Courses

Stored Procedures

 

 

 

 

 

SQL Identity Key ,T-SQL

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.

 

Some Resources(Books, Links) for OOAD

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

Polymorphism: Method Overloading and Method Overriding and Method Hiding

Method Overriding:

another good exmple:

this video is good for learning overriding:

Method Hiding:

 

OOP Topics Need To Cover

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

OOP Topics Need To Cover

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

OOP Topics Need To Cover

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

OOP in C#

Calculator.cs

Program.cs

Person.cs

 

SOLID Concepts

Object Oriented Programming Concepts

OOP Clear

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

Training Set, Validation Set, Test Set

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

PHP OOP Project

Basic Simple Project By Me:

By Others:
From OOP Fundamentals udemy Video project:

 

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

PHP OOP example described here from edwin’s video:

Inheritance example:

Constructor:

Access control: Public, Private, Protected

Static Data in Class:

 

Database Interview Questions

 

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