Skip to content
UdemySQLPaid courseIntermediate levelCertificate

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course (Udemy.com)

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!

Created by: T O

Last updated August 2022

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
Course Description

Who Should Join: 

1. 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 kindly refrain from enrolling until this very important step is complete.

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

3. You are interested in real coding.

4. You enjoy detailed explanations at an introductory level. Please answer the questions in the quizzes based on the course content, and not external knowledge you might already have. This is very important in order for the quizzes to work correctly.

    Very important note: this course is a general overview of many topics, so not every topic can be explored in great depth and at         every level of subtlety.

5. You can take videos that are 13 minutes on average.

6. You enjoy seeing how different technologies interact.

7. You understand that most of the SQL is done in the Microsoft Management Studio, and not Visual Studio.

9. You're NOT looking for fancy graphics, a talking head, or entertainment. 

9. You're looking for practical, carefully explained examples, where the code is written line by line.

10. I made all the code in a fairly big font to be sure it's easy to see.

11. If you use SQL Server versions below 2014, some of the code will not work. You must use versions 2014 and above. 

12. This course uses ASP.NET and C# and not MVC. 

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

14. I don't have an intense amount of energy in my videos because they are made after I've been at work for many hours already. 

Major benefits of the course: 

1) Learn query writing by using the Microsoft Management Studio

2) Learn how to create database connected web pages using SQL and ASP.NET controls

4) Get PDF's that depict difficult concepts in pictures for improved understanding

5) Get 210 quiz questions so you can feel confident you're making true progress.

6) Learn the basics of database connecting code using Microsoft's  premier  programming language: C# 

7) Get exposure to modern SQL language features like Lag/Lead 

8) Build a dashboard system with SQL Server, ASP Web Forms, C# and JQuery (bottom of course)

Given the number of videos, PDF's, variety of teaching methods, quizzes, and a project that is designed to give you a feeling of what to expect in the real world, we're confident this is by far the best deal on this site. Join today, and learn truly valuable skills. 

jQuery and related marks are trademarks of the JS Foundation, and this course is not affiliated with or endorsed by the JS Foundation.

Parts of promo background licensed from Presenter Media . com

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

T O

I love computers , math and programming.

I teach because it gives me great joy to understand things deeply and to share that knowledge with others.


My education: 

1. Master's degree in Statistical Computing

2. BA in mathematics


3. Professional development certificates from Microsoft in each area below: 

     1. Deep learning with Python

     2. Introduction to Artificial intelligence

     3. Data science with Python

     4. Math for machine learning

     5. Data science research methods with Python 


4. Professional certificates from other schools: 

    1. Columbia university certificate in introduction to corporate finance

    2.  MIT certificate in introductory economics

icon
More courses by T O

$13.99

$13.99

$69.99

$11.99

$59.99

$19.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.3

1,546 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By William R. Smith on 12/6/2020

The course was quite thorough on many levels. I learned a good many concepts. The instructor was meticulous at covering the topics and coding techniques. I would highly recommend this course to others. I would like to see it be updated for the current version of Visual Studio for Section 15. There are just too many differences which forced me to install older versions in order to get the system to run correctly.

By Osline Mutoba on 11/1/2020

yess very good

By Ron Ron M Bosque on 10/18/2020

I like how fast paced the teaching mode is, fast but telling everything you need to know! You wont get bored with the professor! :-)

By Mario Ortiz on 10/10/2020

explanation are good and clear

By Ivana Christmas Giordano on 8/24/2020

questo corso strutturato benissimo. ci sono quiz per ogni lezione fatta e questo aiuta molto a capire se effettivamente hai appreso ci che stato spiegato. Ci sono inoltre file riepilogativi di ogni lezione. Fantastico!
Avrei preferito per un test alla fine.

By Wendy Alcius on 8/17/2020

Good starting. awesome Course

By Michelle Aldag on 8/3/2020

This was a great course to learn more SQL techniques than just the basics. I'm not as strong in Visual Studio or C# so instructor was good about talking through what he was doing. Really happy with course.

By Komal Malshikare on 7/11/2020

Complete explanation for each and every SQL functionality.Amazing Course

By Larry McDermott on 7/8/2020

Very clear and great build from basics

By Kristin Dangler on 6/26/2020

Very thorough

By Malloy, H. Christopher on 6/24/2020

Well organized and good content. Really dived into the SQL section to the point that it helped me understand the functions under the hood and build a stronger understanding of its application. Highly recommend the course.

By Willem Pitel on 6/8/2020

Excellent course - taught me a lot, specially SQL - quite a few tricks I didn't know. Well presented.

Showing 12 of 273 reviews