Section 1 : Introduction- Get the Needed Software

Lecture 1 About Certification Pdf
Lecture 2 Get Microsoft Visual Studio Express 2013 for Web
Lecture 3 Configure the Layout of Panels in the Management S 5:47
Lecture 4 Update VS with SQL Server Tools 1:44

Section 2 : Querying Basics

Lecture 5 - Create a Table and Write a Simple Query and Disp
Lecture 6 Write a Query with a Where Restriction 6:34
Lecture 7 Write a Query with a Where and an Order By 7:8
Lecture 8 Using Between and Not Between 7:51
Lecture 9 Aliasing Columns 5:15
Lecture 10 Aliasing Computed Columns 7:59
Lecture 11 Use The Query Designer 6:9
Lecture 12 Make An ASP.NET Webpage with SQL Server 15:16
Lecture 13 Group By 8:54
Lecture 14 Having Clause 7:49
Lecture 15 Select Into 9:17
Lecture 16 Add Multiple Parameters to an ASP.NET Page 18:18

Section 3 : Table Manipulation

Lecture 17 Table Creation and Data Insertion 7:50
Lecture 18 Updating and Deleting Records 5:17
Lecture 19 ASP.NET Page with Updating and Deleting 20:50
Lecture 20 1st Normal Form 12:21
Lecture 21 Second Normal Form 9:44
Lecture 22 Third Normal Form 6:39

Section 4 : Table Joins

Lecture 23 Inner Join 9:13
Lecture 24 Inner Joins with Editor Window and Where Statement 5:51
Lecture 25 Left Join 8:28
Lecture 26 Left Joins with Editor and Where Statment 4:17
Lecture 27 Right Join 8:22
Lecture 28 Right Joins with Query Editor and Filtering Condit 6:15
Lecture 29 Full Joins with The Query Editor 8:2

Section 5 : Build an ASP.NET Page With Multiple Tables and Controls

Lecture 30 Generate the Tables in SQL Server with Query Edito 5:58
Lecture 31 Create the User Interface and Add Logic with C# 19:40

Section 6 : Create an XML Powered ASP.NET Page

Lecture 32 Create a Table Suited For XML Output
Lecture 33 Create a Page With a Control That Connects to the 7:51

Section 7 : Using SQL Server Functions and Operators

Lecture 34 In Logical Operator 4:35
Lecture 35 Like and And
Lecture 36 Scalar Functions 11:35
Lecture 37 Aggregate Functions 9:49
Lecture 38 Understanding the Over Clause 7:38

Section 8 : Subqueries

Lecture 39 Subqueries in Select Clauses 4:42
Lecture 40 Subqueries in From 6:22

Section 9 : Stored Procedures and Programming Constructs

Lecture 41 Write and Execute a Simple Stored Procedure 8:15
Lecture 42 Add Parameters 7:46
Lecture 43 Add IF-Else Blocks and Begin-End 10:8
Lecture 44 Case and When Statements with Functions 10:9
Lecture 45 While Blocks, Variables and Casting 10:29
Lecture 46 Stored Procedures with Output Parameters 7:17
Lecture 47 Try-Catch Error Handling 9:30
Lecture 48 Call a Stored Procedure from an ASP.NET Page 6:16
Lecture 49 Common Table Expressions 12:31
Lecture 50 Comparing Values Between Records with the Lag Func 10:24
Lecture 51 Using the Lead Function with Grouped Data and CTE' 12:7
Lecture 52 CTE with Inner Join and Aggregating Functions 15:18
Lecture 53 Nesting Functions and Pivoting Tables 12:9

Section 10 : User Defined Functions

Lecture 54 Scalar Valued Functions 10:24
Lecture 55 Table valued Functions 12:42
Lecture 56 Table Variables 9:22
Lecture 57 Write a View 10:19

Section 11 : Triggers and Views

Lecture 58 Write a Trigger 18:5

Section 12 : Transactions

Lecture 59 Begin Transaction and Committ Transcation
Lecture 60 Rollback Transaction 9:35
Lecture 61 aving Transactions 6:0
Lecture 62 Make the Table, and Write the Stored Procedure 13:16
Lecture 63 Add C# Code and Make a Simple Interface 21:46

Section 13 : Build a Simple, Secure Data Entry System with Validation an

Lecture 64 Improve the Interface with Ajax, JQuery and CSS 17:53
Lecture 65 Make One Small Change 1:38

Section 14 : Administration

Lecture 66 Adding Logins and Users 8:35
Lecture 67 Database Roles with Users 10:24
Lecture 68 Backups, Restores, Detaching and Attaching 8:3
Lecture 69 Importing Data From Excel 5:44

Section 15 : Make a Dashboard Website

Lecture 70 Make the Names Table, Create a VS Project, Add JQu 13:53
Lecture 71 Add a Second Table with Nested While Loops 15:27
Lecture 72 Add a Trigger and a Stored Procedure and Try the R 9:47
Lecture 73 Add a Grid View to Synchronize with the Details Vi 9:47
Lecture 74 Add A Summary Table and a New Dashboard Control 11:43
Lecture 75 Add Charting and Centralize Formatting Using a Sty 7:52
Lecture 76 Make the Panels Stay in Place with AJAX 8:56
Lecture 77 Add A Trigger to Delete Records 9:37
Lecture 78 Add a Panel for Adding New Sales Records 13:55
Lecture 79 Add Theme Switching For Greater User Friendliness 16:3
Lecture 80 Centralize JavaScript and JQuery Files and Add Imp 22:21
Lecture 81 Add Saving to Local Storage in HTML 5 For a Better 9:22
Lecture 82 Adding Validation 10:30
Lecture 83 Printing GridViews to Printers, Google Drive, and 10:27
Lecture 84 Sticky with Keyup Function in JQuery 5:38