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