Dot Net Authorities : 2011

WritePost | Sign-in | Sign-Out

Balls Icons

Posted by dotnetauthorities at 09:33 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: zOthers

Newer Posts Home

Subscribe to: Posts (Atom)

Total Pageviews

Online

Traffic

About Me

dotnetauthorities

View my complete profile

Search This Blog

Blog Archive

► 2013 (35)
- ► December (14)
- ► November (15)
- ► October (2)
- ► July (2)
- ► March (2)

▼ 2011 (1)
- ▼ August (1)
  - Balls Icons

Popular Posts

SqlTutorial-1 : Lesson-7 : Class-1

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Sql-SubQueries: Nested and Co-related

A subquery is a Sub-SELECT nested inside another query. // OR // Defining a SELECT query within another query is called nested query....
SqlTutorial-1 : Lesson-9 : Class-2

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Sql-INDEX Operations:
Creation, Altration, Deletion and Optimization

Index is a performance optimization technique that speeds up the data retrieval process. It is a persistent data structure (Key-Point...
SqlTutorial-1 : Lesson-9 : Class-1

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Overview of Sql-INDEX Operations and Optimizations

Index is a performance optimization technique that speeds up the data retrieval process. It is a persistent data structure (Key-Pointer) ...
SqlTutorial-1 : Lesson-6 : Class-1

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Sql-JOIN operations: INNER, OUTER, CROSS

JOINs are used to access the data that combined together from multiple tables simultaneously. INDEX Introduction ...
SqlTutorial-1 : Lesson-2 : Class-2

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Integrity Constraints: Primary Key and Unique Key Constraints

1. Primary Key Primary key is used to uniquely identifying each row in the table. For a table there can one primary key. Howeve...
INDEXPage-SqlTutorial-1: Microsoft SQL Server Training: Free Tutorials and Online-Learning Classes (OLCs)

Microsoft SQL Server Training: Free On-line Tutorials And On-line Learning Classes(OLCs) Tutorial-1: Database Development Usi...
SqlTutorial-1 : Lesson-5 : Class-1 : Part-2

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Advanced-SELECTs: Pivot / UnPivot operator

Pivot and Unpivot are cross-tabular operators that transform (or rotate) a table column into rows or vice versa respectively. IND...
SqlTutorial-1 : Lesson-1 : Class-1:

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Basic Db-Table Operations:
Creating, droping, finding, and renaming Db-Tables

A database can contain several tables and a table physically stores your information as collection of records. A table can be created using...
SqlTutorial-1 : Lesson-5 : Class-1 : Part-1

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Advanced-SELECTs:
Common Table Expression (CTE) - WITH Statement

CTE is named expression that holds result of Sub-select temporarily. The main advantage of CTE is light-weight and recursion; hence i...
SqlTutorial-1 : Lesson-8 : Class-1

Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL

Temporary Tables(Local-# ,Global-## )

S QL Server supports a greate feature called temporary table , that lets you to hold the result-set of a query for future process. I...

Technologies

Sql Server
WCF
Asp.Net MVC
JQuery
C#
LINQ
.Net Framework
ASP.Net
ADO.Net
Entity Framework
RegEx

Tutorials:

SQL - Tutorial1
SQL - Tutorial2
SQL - Tutorial3
SQL - Tutorial4

FAQs:

FAQs - SQL
FAQs - WCF
FAQs - MVC
FAQs - JQuery
FAQs - C#
FAQs - LINQ
FAQs - .Net Framework
FAQs - ASP.Net
FAQs - ADO.Net
FAQs - Entity Framework