SQL Server Module
Learn step by step
This is the module of sql server
Basic Query
Learn more
01 Getting Started
001 Introduction
002 SQL Server Express Installation
003 Download Sample Database
004 Attaching Sample Database to SQL Server
005 SQL Server Utilities Statements
006 Using Transact-SQL Comments
02 Miscellaneous Functions (Transact-SQL)
007 CAST Function
008 CONVERT Function
009 ROUND Function
010 SUBSTRING Function
011 CASE Expression
03 Transact-SQL (T-SQL) Aggregate Functions
012 Introduction to Aggregate Functions
013 AVG Aggregate Functions
014 MIN Aggregate Functions
015 MAX Aggregate Functions
016 SUM Aggregate Functions
017 COUNT Aggregate Function
018 GROUPING Aggregate Function
019 VAR Aggregate Functions
020 VARP Aggregate Functions
04 Ranking Functions (Transact-SQL)
021 Introduction to Ranking Functions
022 Rank Functions
023 NTILE Functions
024 DENSE_RANK Functions
025 ROW_NUMBER Functions
026 Using Multiple Ranking Functions
05 Analytic Functions (Transact-SQL)
027 Introduction to Analytic Functions
028 Basic Analytic Function Syntax
029 LEAD Function
030 LAG Function
031 LAST_VALUE Function
032 FIRST_VALUE Function
033 PERCENT_RANK Function
034 CUME_DIST Function
035 PERCENTILE_DISC Function
036 PERCENTILE_CONT Function
06 SET OPERATORS ( Transact-SQL)
037 Introduction To SET Operators
038 EXCEPT SET Operators
039 INTERSECT SET Operators
040 UNION SET Operators
07 Stored Procedures (Transact-SQL)
041 Introduction To Stored Procedures
042 Creating Stored Procedures
043 Modifying Stored Procedures
044 Properties page of a stored procedure
045 Viewing dependencies of a stored procedure
046 Deleting a stored procedure
047 Viewing the definition of a stored procedure