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: A O

Produced in 2021

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

icon
Quality Score

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

Overall Score : 88 / 100

icon
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

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

*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

icon
Instructor Details

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

4.4

276 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

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.

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

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

Very well taught. Easy to understand and good examples.

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!

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

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

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.

Creating websites

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.

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.

/excellent course. I did an entire production website with it with no prior knowledge of sql or ASP.NET