Skip to content
UdemySQLPaid courseIntermediate levelCertificate

Learn C# With Windows Forms and SQL Server (Udemy.com)

With a real database project!

Created by: T O

Last updated July 2021

icon
What you will learn

  • Create and runs Windows Forms applications
  • Understand blocks of code, curly braces, comments
  • Understand how to use string interpolation, and add new line characters
  • Understand how to represent changing quantities with variables
  • Understand how to use += and = operators
  • Create and use objects like labels and their properties like Text
  • Explain the meaning of a keyword
  • Use several different data types like boolean, decimal, string and others
  • Understand methods and how to use method chaining
  • Use methods that convert values to numerical form for mathematical operations
  • Read and operate on decimal data types
  • Round calculation results and display formatted output
  • Understand how to control the order of operations for mathematical symbols
  • Control the layout of various control on a form

icon
Course Description

Update

8/3/2020: Replaced video 60 on exporting to Excel to clarify or improve some subtle technical details.  

8/8/2020: Added video 63 on how to work with the identity_cache in SQL Server to avoid identity gaps

Thank you for stopping by.

Most important: Before enrolling, please take the time to read the course curriculum, and watch the free preview videos so you can be sure my way of presenting information is one that truly works for you. This will give you a strong indication of what to expect throughout the course. Please kindly do not enroll until you have done this. Also, please remember that I am only one person, and I cannot as one person think of everything that you might want covered. If that's the case, please send me a message and tell me what you feel should be added. Thank you.

  1. Lessons 2-39: Introduction to C# as a review for those who are new to programming in C# or are coming from a different language. 

    1. This is not meant to be exhaustive but to simply prepare you for the database project.

    2. It's a review of basic programming concepts.

  2. Lessons 40-45: Text editor project to illustrate more advanced coding.

    1. This project show more practical applications of C#. 

  3. Lessons 46-62: Variety of advanced techniques used in building a database project.

    1. Here you learn how to combine C# and SQL Server.

    2. The code in these lessons gets quite sophisticated. 

    3. Make sure you have MS Office installed for this part or you will not be able to complete the project.

    4. If you're going to use the code as saved on GitHub for this part, it will be more challenging to configure than the code for the simple lessons.

    5. Make sure you look under lesson resources when you do this project. There are updates stored there.

  4. Lessons 63-66: Miscellaneous small projects that show a variety of possibilities with C#.

It's important that you type and run all the code, as I do. To take it one step further, simply ask and answer this question: how can I make one meaningful modification to the code to produce a new effect? Consistently asking and answering this question as you watch the videos will allow you to improve your skills beyond what I show you. 

Please note I develop the material at a relatively leisurely rate, so if I speak too slowly, please watch the videos at 1.25x. 

I'm the author of "Beginning C# Hands-On The Core Language" and "C# Hands-On The Advanced Features", both from PACKT.

Each video is in HD, and project files can be downloaded from GitHub. The link needed is stored under lesson resources. Thank you for reading, and let's get coding!

Parts of promo video PowerPoint licensed from PresenterMedia.

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

1,328 ratings on Udemy

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

By Yanik Blouin on 2/10/2022

Excellente formation ! Excellent formateur !! J'ai suivi il y a quelque temps la formation portant sur SQL Server et le cours actuel constitue un complément essentiel pour réaliser rapidement et efficacement des interfaces permettant d’interagir avec les données. Il n'est cependant pas nécessaire d'avoir déjà fait une formation sur SQL Server préalablement... Il s'agit d'un point de départ pour découvrir l'utilisation du code C#. Le cours va certainement intéresser les développeurs qui se sont initiés à la programmation avec MS Access et VBA et qui souhaitent passer à un niveau supérieur. Si les applications de base de données vous intéressent, alors n’hésitez pas !

By Michael Anderson on 11/15/2020

The teacher does a good job of pointing out basic ui/ux elements of the visual studio IDE which give the user a lot of information. E.g. intellisense tooltips, where to look for more information about properties, etc. Good job.

By Gregory Chamberlin on 10/12/2020

It was very good. Well organized and explained.

By Core RHCE on 10/3/2020

The course is explained very thoroughly and and I think they are easy to follow along. The author goes into detail explaining what something does and why. A simple thing such as highlighting the SQL query and executing it will only run the highlighted query. I have sadly seen other explanation video's in the past not explain a simple thing as this. Kudo's to the author for a fine tutorial.

By Anonymized User on 9/24/2020

Good match for me.

By Joo Carlos Patron Alves on 9/4/2020

Sim.

By William Coyne on 9/2/2020

Nice no-nonsense course for someone unfamiliar with creating Windows Forms projects in C# and working with SQL databases. I learned what I expected; plenty to get going creating my own projects.

By John Lugar on 8/25/2020

Really enjoying the course. Practical learning and fun examples. Easy to follow.

By Tom Gauden on 8/21/2020

Well done, Thank you for the lessons

By Jim McIlvaine on 8/20/2020

A very good course. Instructor's teaching style suits me perfectly. He is also very responsive to questions.

By Rs on 8/17/2020

Ich muss zugeben, da ich kein C#-Anfnger bin. Ich bin jedoch ein "Datenbank-Anfnger", deshalb ist der Abschnitt 7 "Database Project" bereits den Preis wert. Megamig erklrt, bei mir gingen quasi sekndlich ganze Kronleuchter im Oberstbchen auf, wenn ich das mal so salopp sagen darf. Der Autor erstellt klar und nachvollziehbar ein Datenbankprojekt, auf das man aufbauen kann. 5 Sterne - und kein Stubchen weniger!

By Thiha Ko Ko on 8/15/2020

Understandable

Showing 12 of 272 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 88 / 100