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

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

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 8h 06m | 3.30 GB

Learn C# 6. With SQL Server/ Intro to C# 7.0

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.

What You Will Learn

  • Understand how to create and run simple Console program and use variables
  • Operate on variables using basic mathematical operators, and see when this is not possible, Control program
  • flow with simple if/else blocks, while loops, switch blocks
  • Understand the difference between for loops and for each loops
  • Understand how to use unary and binary operators and the ternary operator
  • Learn how to construct methods, the dynamic keyword, and var keywords to save time, construct simple
  • classes and instantiate them, use constructors, properties and static and object fields
  • Understand why virtual methods are needed, and how to create them
  • Learn how to create abstract classes, and why they matter
  • Get a small preview of the power of lists, and generics with LINQ
  • Understand how many methods inside the string class can be used
  • Learn how to group related functionality together with name spaces
  • Learn the basics of HTML, C# 7.0
  • Learn how to use SQL Server 2014, write stored procedures and how to save, and read records, manipulate data directly in C# with Linq, make practical use of Interfaces
  • Learn how to make applications more stable with the nullable keyword, create and read XML files, save and reconstruct objects using serialization, write basic C# unity scripts
Table of Contents

Introduction to Visual Studio
1 Customizing Visual Studio to Make It Feel More Personal
2 Introduction – Why C#, and Downloading and Installing Visual Studio Community Edition

File Access – Web Forms Version
3 Create a Page That Saves Text to Disk
4 Create a Page That Uses the File Upload Control
5 Having a Little Fun with Images with Pixel Manipulations
6 Saving an Image to SQL Server
7 Serializing and Deserializing Objects

XML Basics – Web Forms Version
8 Creating and Using an XML File
9 Creating XML Files with C#
10 Querying XML Documents with Linq

C# through Console Apps
11 Blocks, Statements, and Variable Scope
12 Computed Variables and Basic Math
13 Create and Run your First Program
14 Create and Use One Variable
15 Describe the World Better with More Variables
16 Describe the World More Accurately with Different Data Types
17 Formatting Output Strings to Make Them Look Professional
18 Interacting with Users through Command Prompt
19 Make, Install, and Run a Simple Application

Controlling Program Flow, Console Version
20 Checking One Condition with If_Else Constructs
21 Controlling Loops with Break and Continue Statements
22 Do_While Loops
23 Examining Multiple Variable Values with Switch Blocks
24 Improving Input Processing with TryParse
25 Iterating through Collections with ForEach Loops
26 Making Decisions with Multiple If_Else Blocks
27 Repeating Blocks of Code with For Loops
28 Repeating Blocks of Code with While Loops

Operators – Console Version
29 Compound, Prefix, and Postfix Operators
30 Logical “AND” Operator
31 Logical “OR” Operator
32 The Ternary Operator

Fundamentals of Arrays – Console Version
33 Looping Through Arrays with For and ForEach Loops
34 Multidimensional Arrays
35 Reference Type and Value Type Variables
36 What Are Arrays, and How to Fill and Read Them

Introduction to Functions, or Methods – Console Version
37 Create a Single, Static Method
38 More Flexible Code with Dynamically Typed Variables
39 Out Keyword for Returning Multiple Values
40 Passing Arrays as Function Arguments
41 The Ref Keyword for Passing Simple Types by Reference
42 Using Enumerations to Make Lists of Named Constants
43 Using the Params Keyword in Function Headers

Object-Oriented Programming – Console Version
44 A Small Sample of the Power of Generics and Linq
45 Abstract Classes, Methods, and Why They Are Used
46 Create a Simple Class, Add a Constructor, and Add One Behavior
47 Handling Exceptional Situations with Try_Catch_Finally
48 How to Make and View Arrays of Custom Types
49 Instance Variables, and Accessing Them through Properties
50 Interfaces, and What Purpose They Serve
51 Namespaces Used to Group Related Functionality
52 Overloading Operators, and Why It’s Necessary to Do So
53 Static Fields, Properties, and Methods
54 String Class and Cleaning Strings
55 Understanding the Purpose Of Inheritance
56 Using the Class Designer and the Object Class
57 Virtual Methods, and Why They Are Needed
58 Writing Less Code with Polymorphism

Intro to C# 7.0
59 Get Visual Studio Community 2017
60 Learn how to use the out keyword with C# 7.0
61 Returning multiple values with tuples
62 Switch blocks with when clauses and expression bodied members
63 Switch statements with different types of objects
64 Throwing exceptions from anywhere in code
65 Tuples as fields and property types
66 Using local functions

Learning the Fundamentals of Visual Studio and C#
67 Computed Variables and Basic Math
68 Creating and Running a Page that Incorporates C#
69 Creating and Running Your First Page
70 Creating and Using a Single Variable
71 Formatting Output Strings for More Professional Results
72 Interacting with Users through the Web Page
73 Updating Visual Studio with C# 6.0
74 Using Method Chaining to Write More Compact Code
75 Using Variables and Data Types to Describe the World around Us

Controlling Program Flow
76 Examining Multiple Variable Values with Switch Blocks
77 Improving Input Processing with TryParse
78 Iterating Over Collections with ForEach Loops
79 Making a Variable Grow by Adding 1
80 Reacting to a Single Condition with If_Else Blocks
81 Repeating Blocks of Code with For Loops
82 Repeating Blocks of Code with While Loops
83 Replacing If_Else Blocks with the Ternary Operator

Operators
84 Checking Two Conditions with the Logical AND Operator
85 Checking Two Conditions with the Logical OR Operator
86 Operators That Evaluate and Assign in Place

Array and Method Basics – Web Forms Version
87 Combining the Ref Keyword and Out Keyword to Write Flexible Functions
88 Creating and Using a Simple Method
89 Creating More Flexible Functions with the Out Keyword
90 Creating More Flexible Methods with the Params Keyword
91 Declaring, Setting, and Reading Arrays
92 Iterating over Arrays with ForEach and For Loops
93 Multidimensional Arrays
94 Passing Arrays into Methods
95 Reference Type and Value Type Variables
96 Writing Easier Code with Var and Dynamic

Fundamentals of Objected Oriented Programming – Web Forms Version
97 Building More Stable Apps with Exception Handling
98 Centralize Common Code with Inheritance
99 Centralize Default Code with Virtual Functions
100 Create a Class with a Constructor and a Function
101 Create a Class with a Static Method
102 Create a Class with an Object Property
103 Create a Class with Static Fields, Functions, and Properties
104 Creating and Using Namespaces
105 Declaring, Creating, and Using Delegates
106 Iterating over Instances with Indexers
107 Model Concepts with Abstract Classes
108 Overloading Operators to Perform Custom Operations
109 Structs, Random Points, and Sleeping Threads
110 Using Custom Types as Return Types
111 Using Enumerations to Represent Named Constants
112 Using Interfaces to Express Common Behaviors
113 Using Lists to Operate on Data Efficiently
114 Using Named and Optional Parameters
115 Using the Null Coalescing Operator to Write More Stable Applications
116 Writing Less Code with Polymorphism

Generics, Web Forms Version
117 Create a Generic Method
118 Create a Simple Generic Class
119 Creating and Using Generic Dictionaries
120 Implementing a Generic Interface to Accomplish Sorting
121 Making Delegates More Flexible with Generics

Lambda Expressions and Linq – Web Forms Version
122 Anonymous Methods and Objects That Run Their Own Delegates
123 C# with Linq and Built-in Types
124 C# with Linq and Custom Data Types
125 Connection between Delegates and Lambda Expressions
126 Expression Bodied Lambdas and Expression Bodied Members
127 Joining Datasets with Inner Joins
128 Queries That Perform Aggregation Functions
129 Summarizing Results with Grouping
130 Using Linq to Summarize Tuples
131 Using Query Syntax to Construct Queries

Working with SQL Server 2014
132 Connecting a Chart Control to SQL Server
133 Download, Install, and Run SQL Server 2014
134 Inserting Records into Tables Using Stored Procedures
135 Using Linq to Operate on Tables from SQL Server
136 Using the Nullable Feature to Make Apps More Stable
137 Write Code to Manually Connect to a Table and Retrieve Records