Autoplay
Autocomplete
Previous Lesson
Complete and Continue
A SQL Server, ASP.NET, CSS, C# & jQuery Course
Introduction: Get the Needed Software
Lesson 1: Get SQL Server 2014 Express (5:14)
Lesson 2: Get Microsoft Visual Studio Express 2017 (5:26)
Lesson 3: Configure the Layout of Panels in the Management Studio and Visual Studio (3:50)
Lesson 4: Update VS with SQL Server Tools (1:46)
Querying Basics
Lesson 5: Create a Table and Write a Simple Query and Display the Results (13:58)
Lesson 6: Write a Query with a Where Restriction (4:25)
Lesson 7: Write a Query with a Where and an Order By (9:08)
Lesson 8: Using Between and Not Between (9:05)
Lesson 9: Aliasing Columns (11:03)
Lesson 10: Aliasing Computed Columns (10:38)
Lesson11: Use The Query Designer (6:40)
Lesson 12: Make An ASP.NET Webpage with SQL Server (22:05)
Lesson 13: Group By (11:30)
Lesson 14: Having Clause (7:10)
Lesson 15: Select Into (8:03)
Lesson 16: Add Multiple Parameters to an ASP.NET Page (19:26)
Table Manipulation
Lesson 17: Table Creation and Data Insertion (8:18)
Lesson 18: Updating and Deleting Records (6:19)
Lesson 19: ASP.NET Page with Updating and Deleting (16:49)
Lesson 20: 1st Normal Form (12:12)
Lesson 21: Second Normal Form (9:57)
Lesson 22: Third Normal Form (8:25)
Table Joins
Lesson 23: Inner Join (11:49)
Lesson 24: Inner Joins with Editor Window and Where Statements (8:12)
Lesson 25: Left Join (10:45)
Lesson 26: Left Joins with Editor and Where Statement (15:24)
Lesson 27: Right Join (10:14)
Lesson 28: Right Joins with Query Editor and Filtering Conditions (10:19)
Lesson 29: Full Joins with The Query Editor (6:42)
Build an ASP.NET Page With Multiple Tables and Controls
Lesson 30: Connect Gridview to SQL Server with C# (19:38)
Lesson 31: Programming the C# Connection to SQL Server (25:05)
Create an XML Powered ASP.NET Page
Lesson 32: Create a Table Suited For XML Output (12:41)
Lesson 33: Create a Page With a Control That Connects to the XML Table (11:00)
Using SQL Server Functions and Operators
Lesson 34: In Logical Operator (8:40)
Lesson 35: Like and And (10:45)
Lesson 36: Scalar Functions (12:20)
Lesson 37: Aggregate Functions (12:04)
Lesson 38: Understanding the Over Clause (16:58)
Subqueries
Lesson 39: Subqueries in Select Clauses (6:30)
Lesson 40: Subqueries in From (13:04)
Stored Procedures and Programming Constructs
Lesson 41: Write and Execute a Simple Stored Procedure (8:22)
Lesson 42, Part 1: Stored Procedure with Parameters (17:37)
Lesson 42, Part 2: Asp.NET with Parametrized Page (18:05)
Lesson 43: Add IF/Else Blocks (13:11)
Lesson 44: Case and When Statements with Functions (16:50)
Lesson 45; While Blocks, Variables and Casting (13:32)
Lesson 46: Stored Procedures with Output Parameters (9:24)
Lesson 47: Try/Catch Error Handling (10:24)
Lesson 48: Comparing Values Between Records with the Lag Function (15:39)
Lesson 49: Common Table Expressions (9:11)
Lesson 50: Using the Lead Function with Grouped Data and CTE's (11:35)
Lesson 51: CTE with Inner Join and Aggregating Functions (16:00)
Lesson 52: Nesting Functions and Pivoting Tables (11:04)
User Defined Functions
Lesson 53: Scalar Valued Functions (13:00)
Lesson 54: Table valued Functions (15:06)
Lesson 55: Table Variables (12:26)
Lesson 56: SQL with Linq (22:57)
Triggers and Views
Lesson 57: Write a View (12:38)
Lesson 58: Write a Trigger (13:19)
Transactions
Lesson 59: Begin Transaction and Commit Transaction (14:45)
Lesson 60: Save and Rollback Transactions (8:30)
Build a Simple, Secure Data Entry System with Validation and Trasactions
Lesson 61: Make the Table, and Write the Stored Procedure (19:41)
Lesson 62: Make a Simple Interface (19:57)
Lesson 63: Add C# Code (30:15)
Lesson 64: Add CSS Formatting (14:24)
Lesson 65: Add jQuery Code (14:24)
Lesson 66: Refine jQuery and Understand IIS Express (20:57)
Lesson 67: Add AJAX and a Check Box (23:56)
Lesson 68: Port Site to IIS (15:48)
Lesson 69: Add jQuery Drag,Drop, Save (19:14)
Administration
Lesson 70: Adding Logins and Users (8:18)
Lesson 71: Database Roles with Users (9:58)
Lesson 72: Backups, Restores, Excel (10:11)
Lesson 73: Backup Devices/Restores/SQL Logs (10:43)
Make a Dashboard Website
Lesson 74: Create IIS SIte and Page (11:10)
Lesson 75: Create a Table in SQL Server and Connect Page (13:33)
Lesson 76: Add CSS and jQuery to Make Elements Draggable, Droppable and Saveable (15:52)
Lesson 77: Make Element Expandable and Add AJAX (18:35)
Lesson 78: Add Sales Table with Nested Loops (21:06)
Lesson 79: Add Trigger for Adding Sales Records (9:53)
Lesson 80: Add Foreign Key Constraint for Deleting Records (7:53)
Lesson 81: Synchronize Gridview and Details View (16:34)
Lesson 82: Add a Summary Grid View (18:01)
Lesson 83: Add Theme Switching (10:32)
Lesson 84: Add Sticky (16:03)
Lesson 85: Printing (23:24)
Lesson 86: Project Review (21:06)
Conclusion
What To Do Next
Lesson 50: Using the Lead Function with Grouped Data and CTE's
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock