TechSapphire Friday, 2018-09-21, 9:02 PM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • How to improve logic building ?

    Note: Watch video before reading text below.
    Concept:

    • 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:

    • 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.

    Example to cover:

    • 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.

    Different SQL library defined functions:

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

    Different .NET library defined functions:

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

    So start learning:

    • Library defined function. You just need to know what this function do. Don’t 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.

    Data Structure:

    • 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.

    Conclusion:

    • 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.

    click here to download files.

    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2018