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

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

Tom O.
New Release!

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!
Mapt Subscription
FREE
$40.00/m after trial
Video
$28.05
RRP $32.99
Save 14%
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$28.05
$29.99 p/m after trial
RRP $32.99
Subscription
Video
Start 14 Day Trial

Frequently bought together


An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video] Book Cover
An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video]
$ 32.99
$ 28.05
Flutter - An Advanced Course [Video] Book Cover
Flutter - An Advanced Course [Video]
$ 18.99
$ 16.15
Buy 2 for $33.65
Save $18.33
Add to Cart

Video Details

ISBN 13 9781789530568
Course Length 18 hours and 51 minutes

Table of Contents

Build an ASP.NET Page with Multiple Tables and Controls

Video Description

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.

Style and Approach

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.

Video Preview

What You Will Learn

  •  Learn SQL and SQL Server. 
  • Learn the basics of Microsoft Visual Studio 2017 Community, Microsoft ASP.NET with SQL Server, enough C# to connect to databases.
  • Learn enough JQuery to make database controls interactive, the fundamentals of SQL Server administration.
  • Learn how to work with built-in functions, how to write joins, how to make web pages for collecting and storing information, how to format data in web pages and tables, how to represent queries with pictures for easier understanding.
  • Learn how to use program flow control features like if/else and more, how to write stored procedures, how to write user-defined functions, how to write views and triggers, how to use the SQL Server debugger.
  • Learn how to create, save, commit and rollback transactions.
  • Learn how to create users, database roles, logins, and work with securables, how to backup, restore, attach and detach databases.
  • Learn how to use and save Table variables, how to create and use common table expressions, how to work with string functions like char, and substring, how to use the lag/lead functions and the over clause. 
  • Learn how to work with date functions like Datename, Datepart, getDate and more.
  • Learn how to build dynamic theme switching with JQuery, how to build a dashboard with C#/CSS/HTML/SQL and JQuery, how to perform data validation, how to print to printers, PDF's, Google Drive, and the Cloud.
  • Learn how to build a web interface layout that can be dragged, dropped and saved between page loads.

Authors

Table of Contents

Build an ASP.NET Page with Multiple Tables and Controls

Video Details

ISBN 139781789530568
Course Length18 hours and 51 minutes
Read More

Read More Reviews

Recommended for You

Flutter - An Advanced Course [Video] Book Cover
Flutter - An Advanced Course [Video]
$ 18.99
$ 16.15
Create a WordPress Website in 24 Hours or Less - Guaranteed [Video] Book Cover
Create a WordPress Website in 24 Hours or Less - Guaranteed [Video]
$ 41.99
$ 35.70
Camtasia Studio Made Easy: The Best Video Editor and Recorder [Video] Book Cover
Camtasia Studio Made Easy: The Best Video Editor and Recorder [Video]
$ 37.99
$ 32.30
The Perfect Recording Studio Setup: Audio, Lighting, Video [Video] Book Cover
The Perfect Recording Studio Setup: Audio, Lighting, Video [Video]
$ 46.99
$ 39.95
Flutter - An Intermediate Course [Video] Book Cover
Flutter - An Intermediate Course [Video]
$ 18.99
$ 16.15
Dart - An Intermediate Course [Video] Book Cover
Dart - An Intermediate Course [Video]
$ 18.99
$ 16.15