-->
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

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



Students also bought

Learn How to build Applications for SharePoint in easy steps

Master SharePoint 2013 Development

The only LINQ class you will ever need! Both Query and Method Syntaxes are covered in the course!
Advertisement

Read Also:

Blogger
Disqus
Pilih Sistem Komentar

No comments