Ultimate SQL Bootcamp

7 Reviews
2437 Enrolled
9 Courses & 68 Hours
$39.00$49.00$408.00
Price Drop - Extra 20% off
Save 90% -

What's Included

A SQL Server, ASP.NET, CSS, C# & jQuery Course
  • Certification included
  • Experience level required: Intermediate
  • Access 86 lectures & 14 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

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

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

TO
Tom Owsiak

Tom 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. For more details on this course and instructor, click here.

Description

Why is it beneficial to learn SQL, SQL Server, and Visual Studio? To build applications 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 learn how to give yourself a great competitive advantage in the job market.
  • Learn essential technologies w/ 86 lectures & 14 hours of instruction
  • Learn to write queries w/ Microsoft Management Studio & Microsoft Visual Studio Query Editor
  • Create database-connected web pages using SQL & XML Data Sources
  • Get color PDF's for many of the lessons for easy reference
  • 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

Terms

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