Ultimate SQL Bootcamp

7 Reviews
2450 Enrolled
9 Courses & 68 Hours
Deal Price$39.99
Suggested Price
$81.00
50% Off
🔥 1,000+ Sold! Selling Fast
Ultimate SQL Bootcamp
7 Reviews
$39.99$81.0050% OFF

What's Included

A SQL Server, ASP.NET, CSS, C# & jQuery Course
  • 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 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. 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

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
7 Reviews
4.9/ 5
All reviews are from verified purchasers collected after purchase.
DM

Dan McGovern

Verified Buyer

well, the price is the deal of the century, lots for beginners to advanced. content for mySql too. Other languages are shown a companion to SQL. Check it out.

Aug 2, 2021
CL

Cory Long

Verified Buyer

I got a good deal on this course, but I had no idea how good the material is. I really only use SQL at work and only wanted to learn about the few things Ill use it for. I was able to easily dissern which course held that material and within the 1st day had already learned/can do them.

Jan 6, 2021
AC

Ariel Campos

Verified Buyer

I'm looking forward to deep my SQL knowledge I need it to get reports from my crm. So this it's great for that

Dec 14, 2020
Elizabeth Smith profile picture

Elizabeth Smith

Verified Buyer

Ease of access and quality of training, well thought out and detailed instruction,. Good value for the investment

Nov 7, 2020
KA

Kirk Anderson

Verified Buyer

It's exactly as advertised, everything you will likely ever need to know about SQL is in here. I completed one course and got a certificate I needed as an accounting manager. Well worth the money. $mart Money! Also, props to Entrepreneur Store for putting so many resources in our fingertips. Thanks. KJA

Jan 11, 2019
Cruz Cancel profile picture

Cruz Cancel

Verified Buyer

I really like my course

Nov 3, 2018
Your Cart
Your cart is empty. Continue Shopping!
Processing order...