Mô tả

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.

Bạn sẽ học được gì

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

Yêu cầu

  • Students must have Visual Studio Community 2015 Downloaded and Installed
  • Please be sure to read the curriclum before enrolling so you can feel confident this course meets your needs.
  • Please watch the free preview videos to be sure my style of presentation agrees with your learning style.

Nội dung khoá học

11 sections

How does this course work

1 lectures
Course overview
02:11

Learning the fundamentals

9 lectures
Create and run the first program
06:30
Display a message with a label
09:02
Creating and using a single variable
09:55
Describing objects with multiple data types
10:36
Reading input, applying methods, and producing output
08:28
Reading, converting and displaying values
08:11
Doing practical math on two variables
11:15
Representing unchanging quantities with constants
11:47
General Visual Studio usage tips
06:43

Controlling program flow

12 lectures
Using if/else blocks with check boxes
05:56
Using if/else blocks with strings and methods
10:13
Changing variable values using "x++" and "++x", Part 1
07:54
Changing variable values using "x++" and "++x", Part 2
09:11
Printing 1,2,3,4,5 with while loops and radio buttons, Part 1
10:27
Printing 5,4,3,2,1 with while loops and radio buttons, Part 2
05:25
Updating progress bars with for loops
09:19
Iterating over collections with foreach loops, Part 1
10:12
Iterating over collections with foreach loops, Part 2
05:24
Using the ternary operator, Part 1
07:35
Using the ternary operator, Part 2
11:34
Creating more stable programs with TryParse
11:45

Operators

5 lectures
Operators that evaluate and assign in place
07:21
Checking two conditions with the logical and operator
10:06
Checking two conditions with the logical or operator
11:16
Combining logical operators to express more complex logic
09:01
Making decisions with switch blocks and methods, Part 1
12:51

Methods and arrays

12 lectures
Making decisions with switch blocks and methods, Part 2
13:26
Create a static class for storing utility methods, Part 1
09:51
Create a static class for storing utility methods, Part 2
08:46
Folder browser project with arrays, Step 1
09:16
Folder browser project with arrays, Step 2
08:01
Datagrid view control project with loops, Step 1
12:56
Datagrid view control project with loops, Step 2
05:55
Using lists and out keyword, Part 1
13:04
Using lists and out keyword, Part 2
12:41
Making use of the Split method with params
09:39
Using Linq methods, Part 1
08:11
Using Linq methods, Part 2
10:55

Creating, Saving, Reading, Previewing And Printing Files

6 lectures
Create the interface and add ability to save files
11:31
Add the ability to read files and prevent crashes
09:33
Add menu items that allow locating and highlighting a word
11:44
Add features to change font, preview and print
12:49
Add professional printing to printers and files
06:55
Break from programming: High level overview of the many pieces of a project
10:29

Database Project

19 lectures
Get SQL Server 2014 with management console
04:58
Install SQL Server 2014
03:58
Make the database to be used with the project
11:16
Create the main form and the business forms
08:23
Add interface components to the business contacts form
06:25
Create the database model
07:45
Write code to connect to the database
12:57
Write code to save new records
16:54
Write code to edit existing records
11:08
Write code to delete existing records
16:12
Write code to search for records
08:56
Write code to save images, Part 1
10:11
Write code to save images, Part 2
08:57
Exporting the project as an installable file
06:32
Add ability to export to excel, updated 8/3/2020
21:08
Add ability to export records to text files
07:49
Add ability to export data to Microsoft Word
17:23
Making SQL Server keep the ID sequential using Identity_Cache
07:41
Update to working with @ in the parameter names, 8/2/2020
10:50

Miscellaneous

4 lectures
Download files synchronously and asynchronously
11:37
Image viewer project
19:03
File copier project, Part 1
11:51
File copier project, Part 2
13:12

Search all columns of data grid view project

3 lectures
Update to SQL Server 2019
05:58
Setup the database in local DB
06:03
Finish the mini project
11:47

Using nullable data types with databases

4 lectures
Create a small table in SQL Server
09:41
Create a small class in C#
05:40
Write complete code using decimal nullables
13:13
Add ability to display results in a label
06:32

Project on copying between two datagridview objects

4 lectures
Project overview
00:33
Make interface and connect to tables in Local DB
03:37
Add SQL Query
04:43
Write the code
06:44

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.