MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

A 13 Hour SQL Server 2014 /ASP.NET/CSS/C#/JQuery Course

Course Summary

Learn the Fundamentals SQL Server 2014, Visual Studio 2013, JQuery, CSS and HTML. Finish with a real dashboard project.

  • +

    Course Syllabus

    • Introduction: Get the Needed Software
      • Get SQL Server 2014 Express
      • SQL Server Download
      • Get Microsoft Visual Studio Express 2013 for Web
      • Configure the Layout of Panels in the Management Studio and Visual Studio
      • Update VS with SQL Server Tools
    • Querying Basics
      • Create a Table and Write a Simple Query and Display the Results
      • Simple Queries
      • Write a Query with a Where Restriction
      • Adding a Simple Where Restriction
      • Write a Query with a Where and an Order By
      • Order By Clauses
      • Using Between and Not Between
      • Using Between and Not Between
      • Aliasing Columns
      • Aliasing Columns
      • Aliasing Computed Columns
      • Computed Values
      • Use The Query Designer
      • Query Designer
      • Make An ASP.NET Webpage with SQL Server
      • ASP.NET Pages
      • Group By
      • Group By
      • Having Clause
      • Having Statement
      • Select Into
      • Select Into
      • Add Multiple Parameters to an ASP.NET Page
      • Multiple Parameters
    • Table Manipulation
      • Table Creation and Data Insertion
      • Table creation and Data Insertion
      • Updating and Deleting Records
      • Update and Delete
      • ASP.NET Page with Updating and Deleting
      • Updating, Deleting and Inserting Through Web Pages
      • 1st Normal Form
      • First Normal Form
      • Second Normal Form
      • Second Normal Form
      • Third Normal Form
    • Table Joins
      • Inner Join
      • Inner Joins with Editor Window and Where Statements
      • Inner Joins
      • Left Join
      • Left Joins with Editor and Where Statment
      • Left Joins
      • Right Join
      • Right Joins with Query Editor and Filtering Conditions
      • Right Joins
      • Full Joins with The Query Editor
      • Full Joins
    • 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#
      • Multiple Tables
    • 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
      • XML Tables
    • Using SQL Server Functions and Operators
      • In Logical Operator
      • Like and And
      • Like, And and In
      • Scalar Functions
      • Scalar Functions
      • Aggregate Functions
      • Aggregate Functions
      • Understanding the Over Clause
      • Over Statement
    • Subqueries
      • Subqueries in Select Clauses
      • Subqueries in Selects
      • Subqueries in From
    • Stored Procedures and Programming Constructs
      • Write and Execute a Simple Stored Procedure
      • Simple Stored Procedures
      • Add Parameters
      • Procedures with Parameters
      • Add IF/Else Blocks and Begin/End
      • If/Else Blocks
      • Case and When Statements with Functions
      • Case and When
      • While Blocks, Variables and Casting
      • While, Variables, Casting
      • Stored Procedures with Output Parameters
      • Try/Catch Error Handling
      • Try/Catch
      • 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
      • Lead and Lag Functions
      • CTE with Inner Join and Aggregating Functions
      • Nesting Functions and Pivoting Tables
      • Nesting Functions and Pivoting Tables
    • User Defined Functions
      • Scalar Valued Functions
      • User Defined Scalar Functions
      • Table valued Functions
      • Table valued functions
      • Table Variables
      • Table Variables
    • Triggers and Views
      • Write a View
      • Views
      • Write a Trigger
      • Triggers
    • Transactions
      • Begin Transaction and Committ Transcation
      • Begin and Commit Transcation
      • Rollback Transaction
      • Rolling Back and Saving Transactions
      • Saving Transactions
      • Save Points in 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
      • Basic Administration
    • 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
      • Dashboard Intermediate Quiz
    • Conclusion
      • What To Do Next

Course Fee:
USD 100

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top