Ultimate SQL Bootcamp

7 Reviews

2450 Enrolled

9 Courses & 68 Hours

$39.99$81.00

Save 50% -Sale ended

What's Included

$9.00 Value

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

Tom Owsiak

86 Lessons (14h)

Lifetime

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

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
Have questions on how digital purchases work? Learn more here

$9.00 Value

SQL Database for Beginners

LearntoProgram

55 Lessons (6h)

Lifetime

$9.00 Value

SQL Tutorial: Learn SQL with MySQL Database

Pradnyankur Nikam

115 Lessons (9h)

Lifetime

$9.00 Value

From 0 To 1: Heavy Lifting with SQL & Databases

Loony Corn

67 Lessons (14h)

Lifetime

$9.00 Value

Learn Beginner PHP & MySQL the Easy Way

Simon Sez IT

84 Lessons (12h)

Lifetime

$9.00 Value

An Introduction to MySQL Database Development

EDUmobile Academy

20 Lessons (2h)

Lifetime

$9.00 Value

SQL for Marketers

Justin Mares

26 Lessons (2h)

Lifetime

$9.00 Value

SQL Database MasterClass: Go from Pupil to Master

Bill Sims

49 Lessons (6h)

Lifetime

$9.00 Value

Complete WAMP & MySQL Course

Bill Sims

46 Lessons (3h)

Lifetime

Terms

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

Your cart is empty. Continue Shopping!

Processing order...