off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Learn Fundamental SQL Programming With SQL Server

With Introductions to Visual Studio, IIS Web Server and ASP.NET

What's Inside

SQL is the most popular database programming language on the market today, and has been for many years. In this course, you learn the fundamentals of writing SQL to perform a variety of data manipulations. The whole course takes only 3 hours to complete and you even learn about ASP.NET, IIS and Visual Studio. and, by the end, you'll have a solid grasp of the fundamentals of programming in SQL. SQL is an essential skill for programmers, so it's highly recommended to have at least a passing familiarity with it. Thanks for reading, and let's get coding!

Parts of promo licensed from presentermedia.com

Course Curriculum

Introduction

What we're going to learn
Start

Getting the necessary tools

Get SQL Server
Start
Install SQL Server and Management Console
Start

Learning the Fundamentals

Make a database and add a table from Excel
Start
Select a variety of columns and displays the results
Start
Conceptual Introduction to Where
Start
Filter records with simple "where"
Start
Filter records with more sophisticated "where"
Start
Sort data with "order by"
Start
Conceptual introduction to using "group by" and "over"
Start
Summarize data with "group by"
Start
Summarize data with "over"
Start
Format output to make it look more professional
Start
Understand order of execution of queries
Start

Creating and Changing Tables

Make a table to represent an entity
Start
Add records from a csv file to fill the table
Start
Insert records into a table using SQL
Start
Delete existing records
Start
Update existing records
Start
Create an index to prevent the insertion of duplicate records
Start
Understanding varchar and nvarchar in more detail
Start

Making SQL Server work with Asp.Net

Add IIS Web Server and configure SQL Server
Start
Get Visual Studio and get IIS working with SQL Server
Start
Create a dynamic web page
Start
Edit, Create and Delete records
Start
Search and view restricted results
Start
Work with the grid view control to sort and edit templates
Start
Create and run a stored procedure from a web page
Start

Joining tables

Restore Adventure Works 2014 From Backup
Start
Finding matching records using inner joins
Start
Find matching records using left outer joins
Start
Add a new website to IIS and copy out records with an inner join
Start
Add Validation
Start

Final Thoughts

Next possible steps
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Get started now!

Paid Course Coupon Discount

or pay in installments:

$20

5753+ Students

34 Lectures

0+ Hours of Video

Lifetime Access

24/7 Support

Instructor Rating

Tom Owsiak

Popular Bundles

StackSkills Unlimited
Evan Kimbrell's Business Launching Bundle
Essential JavaScript Coding Bundle
Ultimate Web Developer Bundle
World Travel Hacker Bundle

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Just In

The 2020 Learn to Code Bundle

Hot Bundle

Master Photoshop & The Entire Creative Cloud

Unlimited Learning

Expand Your Mind with StackSkills Unlimited

Course Categories

Learn Fundamental SQL Programming With SQL Server

With Introductions to Visual Studio, IIS Web Server and ASP.NET

What's Inside

Course Curriculum

Introduction

Getting the necessary tools

Learning the Fundamentals

Creating and Changing Tables

Making SQL Server work with Asp.Net

Joining tables

Final Thoughts

Get started now!

Paid Course Coupon Discount

Tom Owsiak