-->
A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course, Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!
  • Created by A O
  • English
  • English [Auto-generated], Italian [Auto-generated]


PREVIEW THIS COURSE  - GET COUPON CODE

What you'll learn
  • Learn SQL
  • Learn SQL Server
  • Learn the Basics of Microsoft Visual Studio 2017 Community
  • Learn the Basics of Microsoft ASP.NET with SQL Server
  • Learn Enough C# To Connect to Databases
  • Learn Enough JQuery to Make Database Controls Interctive (jQuery is used on the bottom of the course)
  • Learn the Fundamentals of SQL Server Administration
  • Learn how to work with built in functions
  • Learn how to write joins
  • Learn how to make web pages for collecting and storing information
  • Learn how to format data in web pages and tables
  • Learn how to represent queries with pictures for easier understanding
  • Learn how to use program flow control features like if/else and more
  • Learn how to write stored procedures
  • Learn how to write user defined functions
  • Learn how to write views and triggers
  • Learn how to use the SQL Server debugger
  • Learn how to create, save, commit and roll back transactions
  • Learn how to create users, database roles, logins, and work with securables
  • Learn how to backup, restore, attach and detach databases
  • Learn how to import data into SQL Server from other programs
  • Learn how to bring tables into first, second and third normal form
  • Learn how to work with XML in SQL Server and ASP.NET Controls
  • Learn how to use and save Table variables
  • Learn how to create and use Common Table Expressions
  • Learn how to work with string functions like char, and substring
  • Learn 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
  • Learn how to build dashboard with C#/CSS/HTML/SQL and JQuery
  • Learn how to perform data validation
  • Learn how to print to printers, PDF's, Google Drive, and the Cloud
  • Build a web based data entry system with C#/SQL, CSS and VS
  • Understand how to use begin/end/go and ;
  • Learn how to build a web interface layout that can be dragged, dropped and saved between page loads

Also read:

Blogger
Disqus
Select Comment System
-->