Book Image

An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video]

By : Tom O.
5 (1)
Book Image

An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video]

5 (1)
By: Tom O.

Overview of this book

<p>Friends, please take the time to review the curriculum carefully before buying so you can see exactly whether this is the right course for you. Please watch the free preview videos so you can see whether the presentation style works for you. Please remember I am just one person, and I make my videos often after I have been working for many hours already. You are interested in real coding. You enjoy detailed explanations. You can take videos that are 13 minutes on average. You enjoy seeing how different technologies interact. You understand that most of the SQL is done in the Microsoft Management Studio, and not Visual Studio. You're not looking for fancy graphics, a talking head, or entertainment. You're looking for practical, carefully explained examples, where the code is written line by line. If you use SQL Server versions below 2014, some of the code will not work. You must use versions 2014 and above. This course uses ASP.NET, and not MVC.</p> <h1>Style and Approach</h1> <p>You understand this is a beginners course, and therefore everything is developed over a period of 18 hours, but by the end, assuming you complete the course, you will have many powerful, practical skills.</p>
Table of Contents (15 chapters)
5
Build an ASP.NET Page with Multiple Tables and Controls
11
Triggers and Views
Chapter 9
Stored Procedures and Programming Constructs
Content Locked
Section 2
Part 1: Write a Parametrized Procedure
In this video, you will: - Understand how to add parameters to a stored procedure header - Understand how use parameters inside the body of a query - Understand how to call a stored procedure with parameters