Category Archives: LICT

LICT Training Vids Summary

10.12.17: (This is one of the important videos)
AuthenticateLogic is very very important for project works: also the store procedure here is important

<authentication>

</authentication>

<authorization>
<deny users=”?”> //if it is * it means that it is open for all but ? sign means it is only for requested users
</authorization>

What is difference between connection string and appSettings ?

<appSettings>
<add key=””>
</appSettings>

<connectionStrings>

</connectionStrings>

 

LinqToSql Class

12.12.17: (This is one of the important videos)

For project works

LICT .NET Training | Kamal Protap Sir

DDL – Data definition Language(Which deals with database schemas and descriptions that how the data should reside in database) – create,alter,drop, truncate, comment
DML – Data manipulation language(Modify, Update, Delete data in database) – select, insert, update, delete
DCL – Data Control Language(Regarding the rights of the database)  grant,revoke

 

31-10-17 vids

SQL Query

SQL Aggregate functions, slides presentation: This presentation describes SQL Aggregate function covering SQL COUNT(), SUM(), MAX(), MIN(), AVG) functions with examples.

SubQuery:

A query within another query is called subquery or nested query . Inner Query, Outer query is in subquery.

Sub Query are two types they are, co-related sub query and non co-related subquery. They works for both DDL and DML statements
Co-related means relationship/dependent on
Non co-related means independent

There are two queries in sub query. You will see group by, order by is single type query but in sub query it needs multiple query

Non co related: They are two types,
Inner query: It will first execute. It will return some result. Independently it will execute.
Outer Query: Based on the inner query result now outer query will execute. The whole process is known as non co-related

 

= for comapring single value
IN for comparing multiple value

Co-related: It is dependent query. Inner query can’t execute independently. Inner query depends on outer query. Without returning row from the outer query inner can’t execute. In co-related sub query. All execute first.

02.11.17 Vids
Store Procedure:

MS SQL Server store procedure is used to save time write the same code again and again for storing in database and also get the rquired output by passing parameters.

Syntax:

Following the basic syntax of stored procedure creation.

Lots of parameters used in stored procedure:

IN paramater is a paramater whose value is past inside of the procedure
OUT paramater is a paramater whose value is pass outside the parameter
OUT parameter return some value
IN does not return any value
create procedure

 

Here are the store procedure example basic in my blog

Stored Procedures

 

LICT C#, OOP and .NET Syllabus

C# Part:
Objects & Classes

Constructor
Destructor
Static
Polymorphism
Abstraction
Inheritance
Property
Generics
Exception Handling
Access Modifier
Interface
Encapsulation
Commandline
Aggregation
Method Hiding
base
seal
Implicit Explicit Convert
Boxing Unboxing
Ref and Out
Foreach
Array
Enum
String Buffer, String Builder
Partial Class
Partial Method
Delegates
Multicast Delegates
Lambda Expresssion

MVC Part:
HTML
CSS
Master Page
Session
Database Insert, Login, Registration, Logout using visual studio ( SqlData Reader)
Calendar Events
Validation
Ado.net
CRUD automatically(with built in process)
CRUD manually(without builtin toolbox- It was H.W)
Data Bound Control

SQL:(Protap Sir)
DDL, DML
Constraint
Inner Join/Equi Join,
Primary Key, Foreign Key
Aggregate, Group BY
Outer Join – Left Outer Join, Right Outer Join, Full Join,
Self Join

Sub-query, Store Procedure
ADO.NET, Regi System, Login System

Func, Action, Anonymous Function, Object Initializer, Collection Initializer
delegates, Lambda

Advanced ASP.NET, C#:
List Bind Control Postback
State Management

Excel(Ameer Sir):
Min, Max, Average, Count, Present, Past
Vlookup, COUNTIF, Conditional Formatting

 

Assesment:
1 Exam was on OOP basics(50 marks)
2 Assignment:
1st was on basic switch, if else etc.
2nd was on OOP and little more advance topic of C# with out/ref
3rd Class Work by Protap Sir.. To write some sql queries [29.10.2017]
4th Assesment on LINQ  28.11.2017