Yogesh Mehla

Now concept of logic building is not so complex and not so simple. We will not work on how to make logic program in C ? We will study how to build complex logic in SQL,.NET, JAVA or any other major technologies in market.

Main part in logic building under all technologies is LIBRARY DEFINED FUNCTIONS. This is the main thing I will explain you with different examples in complete lecture.

Note: Example will be common for Java too just syntax changes. Purpose of these example is to show you how to make complex logic easily. SQL library defined functions. C# library defined functions.

Example….

Row_number() Rank() Dense_Rank() Year() Month() Substring() CharIndex(), etc

Example….

.Contains().Where() String.Concat().Count.Length.toUpper().toLower().toString(), etc

Library defined function. You just need to know what this function do. Dont have cram to learn. Just remember, what function do ? Because if you will face any task which has task which match definition of function then you can make easy and right code.

Do practice general sorting and searching function. They will help you in logic building. But now use library defined functions to do that for you. Example…. Orderby(), contains(), etc.

When you are on advance programming platform, then stop using basic programming approach. Make optimized code. Which is easy to understand and more meaning full. Hope this lecture will help you in learning logic building.

Keep learning.