001 WelcomeQueryandManipulationofDatausingSQL.pdf
001 Welcome to Query and Manipulation of Data using SQL Commands
002 CreateTABLE-s-andTempTable-s.pdf
002 Create TABLE(s) and Temp Table(s)
002 ResourceForTableTempTable.txt
003 WhatIsAView.pdf
003 What Is a View
003 view.txt
004 SELECTStatementWithDetails.pdf
004 SELECT Statement in detail
004 selectqueries.zip
005 OperatorsExpressionsandConditions.pdf
005 Operators, Expressions and Conditions
006 WHEREClauseOrderByClauseGroupByClauseHavingClause.pdf
006 WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause
006 selectwithoperators.zip
007 Select from two tables - JOINS
007 Select-from-two-tables-JOINS.pdf
007 SlectFrom2Tables.txt
008 DifferentTypesOfJoin.txt
008 Different Types of JOINS
009 What is a Sub Query
009 subquery.txt
010 INSERTStatementindetail.pdf
010 INSERT Statement in detail
010 insert.txt
011 UPDATEStatementindetail.pdf
011 UPDATE Statement in detail
011 update.txt
012 DELETEStatementindetail.pdf
012 DELETE Statement in detail
012 delete.txt
013 DeleteVSTruncate.pdf
013 Difference between DELETE and Truncate Statement
013 truncate.txt
014 What is a Stored Procedure
014 storedprocedure.txt
015 WhatisAFunction.pdf
015 What is a Function
015 functions.txt
016 WhatisATrigger.pdf
016 What is a Trigger
016 trigger.txt
017 WhatIsAnIndexandItsType.pdf
017 What is an INDEX
018 Clustered ,NonClustered Indexes and Index Design considerations
018 Clustered-NonClusteredIndex.pdf
019 IndexFragmenationAndLab.pdf
019 Index Fragmentation and Lab for Index
019 dmvindexfragmentation.txt
019 index.txt
019 restoreadventureworkstest.txt
-main-resized.jpg)
