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