A SQL Server, ASP.NET, CSS, C# & jQuery Course

1 Review

115 Enrolled

14 Hours

$18.00$50.00

You save 64%

86 Lessons (14h)

Introduction: Get the Needed Software
Get SQL Server 2014 Express7:53
Get Microsoft Visual Studio Express 2013 for Web2:59
Configure the Layout of Panels in the Management Studio and Visual Studio5:30
Update VS with SQL Server Tools1:46
Querying Basics
Create a Table and Write a Simple Query and Display the Results11:13
Write a Query with a Where Restriction6:55
Write a Query with a Where and an Order By7:31
Using Between and Not Between
Aliasing Columns
Aliasing Computed Columns
Use The Query Designer
Make An ASP.NET Webpage with SQL Server
Group By
Having Clause
Select Into
Add Multiple Parameters to an ASP.NET Page
Table Manipulation
Table Creation and Data Insertion
Updating and Deleting Records
ASP.NET Page with Updating and Deleting
1st Normal Form
Second Normal Form
Third Normal Form
Table Joins
Inner Join
Inner Joins with Editor Window and Where Statements
Left Join
Left Joins with Editor and Where Statment
Right Join
Right Joins with Query Editor and Filtering Conditions
Full Joins with The Query Editor
Build an ASP.NET Page With Multiple Tables and Controls
Generate the Tables in SQL Server with Query Editor and Select Into
Create the User Interface and Add Logic with C#
Create an XML Powered ASP.NET Page
Create a Table Suited For XML Output
Create a Page With a Control That Connects to the XML Table
Using SQL Server Functions and Operators
In Logical Operator
Like and And
Scalar Functions
Aggregate Functions
Understanding the Over Clause
Subqueries
Subqueries in Select Clauses
Subqueries in From
Stored Procedures and Programming Constructs
Write and Execute a Simple Stored Procedure
Add Parameters
Add IF/Else Blocks and Begin/End
Case and When Statements with Functions
While Blocks, Variables and Casting
Stored Procedures with Output Parameters
Try/Catch Error Handling
Call a Stored Procedure from an ASP.NET Page
Common Table Expressions
Comparing Values Between Records with the Lag Function
Using the Lead Function with Grouped Data and CTE's
CTE with Inner Join and Aggregating Functions
Nesting Functions and Pivoting Tables
User Defined Functions
Scalar Valued Functions
Table valued Functions
Table Variables
Triggers and Views
Write a View
Write a Trigger
Transactions
Begin Transaction and Committ Transcation
Rollback Transaction
Saving Transactions
Build a Simple, Secure Data Entry System with Validation and Trasactions
Make the Table, and Write the Stored Procedure
Add C# Code and Make a Simple Interface
Improve the Interface with Ajax, JQuery and CSS
Make One Small Change
Administration
Adding Logins and Users
Database Roles with Users
Backups, Restores, Detaching and Attaching
Importing Data From Excel
Make a Dashboard Website
Make the Names Table, Create a VS Project, Add JQuery and Make a Dashboard Contr
Add a Second Table with Nested While Loops
Add a Trigger and a Stored Procedure and Try the Results
Add a Grid View to Synchronize with the Details View
Add A Summary Table and a New Dashboard Control
Add Charting and Centralize Formatting Using a Style Sheet
Make the Panels Stay in Place with AJAX
Add A Trigger to Delete Records
Add a Panel for Adding New Sales Records
Add Theme Switching For Greater User Friendliness
Centralize JavaScript and JQuery Files and Add Improved Formatting and a Sticky
Add Saving to Local Storage in HTML 5 For a Better Sticky
Adding Validation
Printing GridViews to Printers, Google Drive, and the Cloud
Sticky with Keyup Function in JQuery
Misc
Adding, Altering and Dropping Stores Procedures
Conclusion
What To Do Next

DescriptionInstructorImportant DetailsReviewsRelated Products

Combine the Power of Various Technologies to Produce Engaging Web-Based Software

Tom OwsiakTom Owsiak is a Web, Math, Stats., and Physics Expert with eight years' experience as a teacher of mathematics, physics, statistics, and programming. He worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and many related technologies.

Description

Why is it beneficial to learn SQL, SQL Server, and Visual Studio? To build apps today, a programmer must know how to combine the power of various technologies to produce next level software. The focus of this course is SQL, but along the way, you'll also learn to use Microsoft Visual Studio and build a real dashboard system powered by SQL, C#, AJAX, CSS, HTML, and jQuery. Enroll today, and give yourself a great competitive advantage in the job market.

Learn essential Web technologies w/ 86 lectures & 14 hours of instruction
Write queries w/ Microsoft Management Studio & Microsoft Visual Studio Query Editor
Create database-connected webpages using SQL & XML data sources
Get color PDFs for easy review of lessons
Learn the basics of database connecting code using C#
Get exposure to modern language features like Lag/Lead
Build a dashboard system w/ SQL Server, ASP Web Forms, C# & jQuery

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Compatibility

Internet required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

1 Review

5/ 5

All reviews are from verified purchasers collected after purchase.

Isaack Nyagweso

Verified Buyer

This content is good but I realized it is old. Especially for the ASP.NET part I realized it is based on webforms which I consider to be a bit obsolete now. I expected this coverage to use ASP.NET Core MVC and/or Razor Pages.

Jun 6, 2019

Your Cart

Your cart is empty. Continue Shopping!

Processing order...