Book Image

A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]

By : Tom Owsiak
Book Image

A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]

By: Tom Owsiak

Overview of this book

This comprehensive C# course is designed for beginner programmers, as you won't be rushing through code. It focuses on the C# language rather than the graphical aspects of Windows programming. You will also learn HTML, basic CSS and how to use a variety of controls like buttons, text boxes, drop downs lists and others. You'll learn in a detailed and deliberate way so you can set a foundation and move from basic to more advanced concepts easily. In addition to learning C#, you'll also cover the Microsoft Visual Studio programming environment, which will serve as the perfect complement to your newfound C# skills. To work with code in a more advanced way, you'll tackle how to check simple conditions using if/else blocks, as well as how to use loops to do things like repeat blocks of code to work more efficiently. After covering various operators to evaluate and assign control structures, you'll learn how to use arrays to store collections of data. Moving on to Object Oriented Programming, you'll create objects that contain both data and functions to make your job even easier.Throughout this course, you'll learn the core concepts of C#, which can then be applied directly to other popular programming languages, including C++, C, Java, and JavaScript.To put what you're learning to the test as you move through the course, you'll also complete a variety of programming assignments for hands-on practice.

Related Content you might be interested in

Current Title:

Small book image
A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]
Tom Owsiak
Sep, 2017 | 8 hours 6 minutes
No titles found
Table of Contents (18 chapters)
Free Chapter
1
Introduction to Visual Studio
Introduction - Why C#, and Downloading and Installing Visual Studio Community Edition
Customizing Visual Studio to Make It Feel More Personal
2
Learning the Fundamentals of Visual Studio and C#
Creating and Running Your First Page
Creating and Running a Page that Incorporates C#
Creating and Using a Single Variable
Updating Visual Studio with C# 6.0
Formatting Output Strings for More Professional Results
Using Variables and Data Types to Describe the World around Us
Computed Variables and Basic Math
Interacting with Users through the Web Page
Using Method Chaining to Write More Compact Code
3
Controlling Program Flow
Reacting to a Single Condition with If/Else Blocks
Making a Variable Grow by Adding 1
Repeating Blocks of Code with While Loops
Repeating Blocks of Code with For Loops
Iterating Over Collections with ForEach Loops
Examining Multiple Variable Values with Switch Blocks
Improving Input Processing with TryParse
Replacing If/Else Blocks with the Ternary Operator
4
Operators
Operators That Evaluate and Assign in Place
Checking Two Conditions with the Logical AND Operator
Checking Two Conditions with the Logical OR Operator
5
Array and Method Basics - Web Forms Version
Declaring, Setting, and Reading Arrays
Iterating over Arrays with ForEach and For Loops
Creating and Using a Simple Method
Passing Arrays into Methods
Reference Type and Value Type Variables
Creating More Flexible Methods with the Params Keyword
Creating More Flexible Functions with the Out Keyword
Combining the Ref Keyword and Out Keyword to Write Flexible Functions
Multidimensional Arrays
Writing Easier Code with Var and Dynamic
6
Fundamentals of Objected Oriented Programming - Web Forms Version
Create a Class with a Constructor and a Function
Create a Class with a Static Method
Create a Class with an Object Property
Create a Class with Static Fields, Functions, and Properties
Centralize Common Code with Inheritance
Centralize Default Code with Virtual Functions
Model Concepts with Abstract Classes
Using Custom Types as Return Types
Using Lists to Operate on Data Efficiently
Writing Less Code with Polymorphism
Using Interfaces to Express Common Behaviors
Iterating over Instances with Indexers
Building More Stable Apps with Exception Handling
Using Named and Optional Parameters
Using the Null Coalescing Operator to Write More Stable Applications
Overloading Operators to Perform Custom Operations
Using Enumerations to Represent Named Constants
Creating and Using Namespaces
Structs, Random Points, and Sleeping Threads
Declaring, Creating, and Using Delegates
7
Generics, Web Forms Version
Create a Simple Generic Class
Create a Generic Method
Implementing a Generic Interface to Accomplish Sorting
Making Delegates More Flexible with Generics
Creating and Using Generic Dictionaries
8
Lambda Expressions and Linq - Web Forms Version
Connection between Delegates and Lambda Expressions
Expression Bodied Lambdas and Expression Bodied Members
Anonymous Methods and Objects That Run Their Own Delegates
C# with Linq and Built-in Types
C# with Linq and Custom Data Types
Using Query Syntax to Construct Queries
Queries That Perform Aggregation Functions
Using Linq to Summarize Tuples
Summarizing Results with Grouping
Joining Datasets with Inner Joins
9
Working with SQL Server 2014
Download, Install, and Run SQL Server 2014
Write Code to Manually Connect to a Table and Retrieve Records
Inserting Records into Tables Using Stored Procedures
Using the Nullable Feature to Make Apps More Stable
Connecting a Chart Control to SQL Server
Using Linq to Operate on Tables from SQL Server
10
File Access - Web Forms Version
Create a Page That Saves Text to Disk
Create a Page That Uses the File Upload Control
Serializing and Deserializing Objects
Having a Little Fun with Images with Pixel Manipulations
Saving an Image to SQL Server
11
XML Basics - Web Forms Version
Creating and Using an XML File
Creating XML Files with C#
Querying XML Documents with Linq
12
C# through Console Apps
Create and Run your First Program
Create and Use One Variable
Blocks, Statements, and Variable Scope
Formatting Output Strings to Make Them Look Professional
Describe the World Better with More Variables
Describe the World More Accurately with Different Data Types
Computed Variables and Basic Math
Interacting with Users through Command Prompt
Make, Install, and Run a Simple Application
13
Controlling Program Flow, Console Version
Checking One Condition with If/Else Constructs
Repeating Blocks of Code with While Loops
Making Decisions with Multiple If/Else Blocks
Repeating Blocks of Code with For Loops
Iterating through Collections with ForEach Loops
Do/While Loops
Examining Multiple Variable Values with Switch Blocks
Controlling Loops with Break and Continue Statements
Improving Input Processing with TryParse
14
Operators - Console Version
Logical "AND" Operator
Logical "OR" Operator
Compound, Prefix, and Postfix Operators
The Ternary Operator
15
Fundamentals of Arrays - Console Version
What Are Arrays, and How to Fill and Read Them?
Looping Through Arrays with For and ForEach Loops
Reference Type and Value Type Variables
Multidimensional Arrays
16
Introduction to Functions, or Methods - Console Version
Create a Single, Static Method
Passing Arrays as Function Arguments
Using the Params Keyword in Function Headers
Out Keyword for Returning Multiple Values
The Ref Keyword for Passing Simple Types by Reference
More Flexible Code with Dynamically Typed Variables
Using Enumerations to Make Lists of Named Constants
17
Object-Oriented Programming - Console Version
Create a Simple Class, Add a Constructor, and Add One Behavior
Using the Class Designer and the Object Class
Instance Variables, and Accessing Them through Properties
Static Fields, Properties, and Methods
Understanding the Purpose Of Inheritance
How to Make and View Arrays of Custom Types
Virtual Methods, and Why They Are Needed
Abstract Classes, Methods, and Why They Are Used
A Small Sample of the Power of Generics and Linq
Writing Less Code with Polymorphism
Interfaces, and What Purpose They Serve
Overloading Operators, and Why It's Necessary to Do So
String Class and Cleaning Strings
Namespaces Used to Group Related Functionality
Handling Exceptional Situations with Try/Catch/Finally
18
Intro to C# 7.0
Get Visual Studio Community 2017
Learn how to use the out keyword with C# 7.0
Returning multiple values with tuples
Switch statements with different types of objects
Switch blocks with when clauses and expression bodied members
Using local functions
Throwing exceptions from anywhere in code
Tuples as fields and property types
Chapter 12
C# through Console Apps
Content Locked
Section 8
Interacting with Users through Command Prompt
Here will see how programs, like computers, are machines. They accept input, process that input, and produce output, for example, Excel. You will parse input to convert it to numerical form. Attached is a PDF explaining the window width and window height properties.
Previous Section
End of Section 8
Next Section