skip to Main Content
Sale

Learn C# With Windows Forms and SQL Server

$99.99 $12.00

4.88 (12 reviews)
Category:

Description

What you’ll 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
  • Learn how to work with rich text boxes, and place variables in the right place to achieve certain effects
  • Learn how to work with radio buttons, index variables and while loops that count up and count down
  • Learn how to use foreach loops to repeat blocks of code
  • Learn how to combine loops and if blocks to create powerful code
  • Learn how to work with combo boxes, and the ternary operator to make decisions
  • Learn about operators, operands, and how to combine them properly
  • Learn how logical conditions are used to perform a variety of checks on operands
  • Use the TryParse method to create stable applications that do not crash
  • Use the Date time constructs to read and produce dates in a variety of formats
  • Use various compound operators like /=, -= and the trackbar control
  • Use date time pickers, and date time objects to make decisions
  • Learn how to use tool tips, switch blocks, check list boxes
  • Create methods using traditional and expression bodied member notation
  • Understand the concept of a parameter and a return value
  • Understand how to work with numeric up/down controls, and class files
  • Understand how the private and public access modifiers matter and why static classes are needed
  • Work with folder browsers, control enabling and disabling
  • Learn how to use arrays, directories and foreach loops with arrays
  • Understand how to work with collections and the datagridview control
  • Work with lists to find the maximum, minimum, average and sum of list entries
  • Work with arrays and convert arrays to lists
  • Learn how to use the out keyword to create methods that can set multiple values so the methods are more useful
  • Learn how to save files, and use try/catch blocks to create stable code
  • Learn how to open files, and work with menu strips
  • Learn how to search for, highlight and replace text
  • Learn how to use font boxes, print preview controls and add ability to print
  • Describe name spaces, classes, the major components of a Windows Forms project
  • Learn how to create multiple document interface programs with multiple layouts
  • Learn how to get and install SQL server and the management console
  • Learn how to work with different database types in SQL server
  • Learn how to use datagrid views, data adapters, data tables and basic SQL queries
  • Learn how to insert records into tables
  • Learn how different data types in SQL work
  • Learn how to use the using statement and parameters
  • Learn how to work with collections, binding sources, data updates
  • Learn how to perform searches of data
  • Learn how to save images and preview enlarged images
  • Learn how to work with microsoft excel in code
  • Learn how to export information from our program to excel using nested for loops
  • Learn how to write records to a text file
  • Learn how to export data to Microsoft word
  • Learn how to download and save internet files using different methods

Show moreShow less

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.

Who this course is for:

  • This is a good course for those who want to learn C# through Windows Forms.
  • This is not a course for those who want to learn C# through Console Applications
  • This is a course for those interested in database projects.

Course content

  • How does this course work
  • Learning the fundamentals
  • Controlling program flow
  • Operators
  • Methods and arrays
  • Creating, Saving, Reading, Previewing And Printing Files
  • Database Project
  • Miscellaneous
  • Search all columns of data grid view project
  • Using nullable data types with databases

12 reviews for Learn C# With Windows Forms and SQL Server

  1. Luis Brito

    I can definitely see this course helping breaking through that initial barrier when it comes to learning a programming language. I’m positive I’ll finish it and hopefully master python by then.

  2. Abdallah Galal Abouhussein

    I would like to share my personnel experience, i`m very pleased and happy for taking this impressive course because Dr. Angela always makes it simple and easy to understand and always makes a precaution section before or after any bug that may appear to some students and also write or record the solution for us, and each word she said is very real and easy to understand.
    Thanks Dr. Angela
    Abdallah Galal

  3. Jiaqing Fan

    Very good course. Dr Angela explains things very clearly. The exercises are interactive and helpful.

    Angela’s voice is like ASMR in most lessons. So you won’t lose focus?

  4. Jaime Sánchez Blanco

    Every concept is very well explained so you can assimilate it, and the teacher insists in practicing daily to get the habit of programming. It really motivates to keep studying and practicing every day.

  5. Bradley Carouthers

    3 days in and I’ve already learned more than other training programs where I’ve put months in. Her teaching style is both efficient and effective.

    Edit: Now on day 29 and the course has held up my expectations and hopes. The rise in complexity is not too sharp, and every day feels like an accomplishment. Angela takes her time to explain things without rushing, yet is able to pack tons of information in nuggets of time.

    Still recommend supplemental exposure for a more wholesome grasp. Though, this should be quite enough

  6. Tommy Prévost

    Very good course.

    PROs: lots of coding exercises, clear explanations, great examples, adapted to 2021’s reality.

    CONs: past the first 30 lessons, many similar coding hands-on.

  7. Quang Tu

    I love all the lectures and challenges of this course. I finally find myself in love with coding. This is definitely a fun course. Thank you Angela for this great course.

  8. Fortunate Eze

    This course is nothing short of AMAZING. The level of love and sincere desire to see students succeed present in this course is a rare sight. This course is fun, it’s challenging, it’s suspense-filled, it makes you feel good about yourself solving those challenges. You don’t take this course and memorise codes, you take it and you know what you’re doing because you literally do it yourself.

    It couldn’t possibly be any more obvious that Angela brought out her whole heart, time, energy and resources to give us a course that if priced based on it’s value, many of us certainly can’t afford. I mean, she kept advising and encouraging us to keep going, because she knows the road could get bumpy, she made a few jokes and used funny animations so we smile along the way keeping it fun. Why some people can’t see this and would rather subscribe to trying to bend courses to fit their own personal preferences is beyond me, but I guess people will always be people.

    Dear Angela, I cannot speak for everyone but I certainly can speak for myself and I’m saying thank you. The efforts you put into making this course outstanding didn’t go unnoticed.

    Let as many of us as appreciate your efforts make you happy and energize you to create more life changing courses for us.

    Cheers.

  9. Chendaniel

    Just the course fits me. Learn by doing, it is easy to start and just follow the flow and at day 15 you realized how to program in Python. Then the magic happen. I am on day 27 and I am looking forward to start a new section everyday.

  10. Caspar Cheng

    Angela is my favourite teacher on Udemy, her courses always come with clear and concise demonstration, make it really easy to understand the content. Meanwhile, she also provide a lot of tips to encourage us moving further on the way of coding. I’m definitely a super fan of her. I had finished her web development boot camp and now I’m learning Python 100 days of code. This course is amazing as she provided one particular project for each day’s learning, which is, really useful and handy. Also, those projects are really interesting and won’t let me feel disappointed about myself. Although some of them are a little bit difficult, they’re still resolvable after some struggling and searching online. I’ll recommend this course for those who really want to learn Python well and write real python projects from scratch!

  11. Jonas Weber

    The course was awesome in the first half! Really helped me to get back to programming and learning new techniques. Also the course got way to much focused on web development in the second half, which I’m not really interested in and is redundand to your dedicated web development course. The lack of videos in the last quarter was rather sad. I really would’ve liked some video explanations for pandas and matplotlib. The challenges and capstone projects were great and challenging!
    All in all I can really recommend this course for beginners and those who want to learn python and/or get back to programming!

  12. Rohit Prasad

    Angela is the best teacher I have ever experienced. The way she explains all the topics and makes use of it in the projects is commendable. Thank you so much Angela for this course.

Leave a customer review

Your email address will not be published. Required fields are marked *

Back To Top