Visual Studio 2017 Course (Udemy.com)

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

( 47 Reviews )

Created by: A O

Produced in 2022

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
Learn how to create, save, commit and roll

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a visual basic .net course? Or looking for more detail on A O's A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

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 . comWho this course is for:

This course is for those who appreciate fine levels of detail.
This course is intended for SQL Server novices
This course is intended for ASP.NET novices
This course is intended for Visual Studio novices
This course is intended for those who are intermediate or above in C#
This course is NOT for those who want to be entertained.
This course is NOT for those who want 5 minutes videos.

Time: 19h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

A O

4.2 Rating
47 Reviews

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

Reviews

4.2

47 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Raj Pradhan on

Awesome! Like the course. Learn so many good stuff. Now my next course will be develop Window application with VS and SQL. Will be back soon.

By Tory McClymonds on

I cannot get my certificate after I have completed all the stuff.

By Jimmy Clay on

I'm learn a lot of stuff. The lectures are very good and interesting.This course is very deep, while also being very clear.

By Mark Bland on

Very well taught. Easy to understand and good examples.

By Adiv Abramson on

I have completed a couple of courses presented by Tom, the instructor. He is a very good teacher who takes a very hands on and practical approach to the subject matter so that you can understand the concepts and techniques in a real world context. He shows numerous examples of a given concept throughout the course, demonstrating its practical application.I feel that I have gained a lot of useful knowledge from the courses I have studied so far from this instructor and I am looking forward to gaining more understanding and practical skills in SQL Server Application Development by completing this course.Having now finished this course I am amazed at the breadth of material covered. Many of the individual lectures could serve as the basis for an entire course. When covering so many different topics, it is impossible in one course to explore all of them in depth. Fortunately, the instructor has additional courses available that provide a deep dive into particular topics.The instructor responds quickly to queries and comments and provides clarifications of arcane and difficult to grasp concepts so that students can gain a better understanding of the material being presented.The instructor sometimes will deliberately do something that will cause an error or unexpected behavior, so that students will be aware of common "gotchas" and learn to avoid them when coding their own projects. This is a very useful and effective pedagogic tool.I highly recommend this course and am looking forward to taking many more courses with this instructor. You should, too!

By Karbagamoorthy Durairajan on

FIRST EXPLAIN WHAT IS NORMAL FORM AND EXPLAIN THE WHICH PURPOSE TO USERWHAT IS FIRST NORMAL FORM WHAT ARE THE DIFF BETWEEN SECOND NORMAL FORM

By Srikanth Manchala on

this was a very good course and got lot of information from this.

By Oleg Zarevennyi on

Advantages: I used this course to recover my knowledge of SQL. I have not been working with relational databases for several years, but these skills were necessary for a new job. For this purpose, this course approached me, so I mark it as 4 stars.Disadvantages: however, the author is not very competent, does not adhere to the naming convention (very bad!), does not understand the C# (what was the reason for doing some examples in C#?), and few more inaccuracies, especially in the quizzes. Many videos have been recorded since the first attempt, due to which they have errors that the author simply signed the comments.Also, and as a result, the course has a problem with positioning for whom exactly was it created? Therefore, from this side, I mark it as 3 stars.

By W Ren on

Creating websites

By Adelmira Martinez on

This course has not been updated since 2014, so you are not able to use VS 2017, it is not available to download. Then the start of VS 2019 does not have the same items as 2014 when you start. Hard to follow, took me 2 days to get VS installed and able to run.

By Peter Stark on

This course is excellent! Explains a lot of what is going on with SQL and why. I do suggest not to watch the closed captions, as they are sometimes incorrect. I found it best to listen in headphones, with SSMS in one window with adventureworks loaded, and the class in the other. I found myself replaying some of the lectures for better understanding and trying things on my own. I think this course is good for the novice but also for the more advanced who are looking to strengthen their skills.

By Juan Manuel Tamez Vela on