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

Preview in Mapt

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

Tom Owsiak

Learn C# 6. With SQL Server/ Intro to C# 7.0
Mapt Subscription
FREE
$29.99/m after trial
Video
$85.00
RRP $99.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$85.00
$29.99p/m after trial
RRP $99.99
Subscription
Video
Start 30 Day Trial

Frequently bought together


A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video] Book Cover
A 17 Hour C# Course with Intro to SQL and C# 7.0 [Video]
$ 99.99
$ 85.00
Web Security: Common Vulnerabilities And Their Mitigation [Video] Book Cover
Web Security: Common Vulnerabilities And Their Mitigation [Video]
$ 48.99
$ 41.65
Buy 2 for $35.00
Save $113.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Video Details

ISBN 139781788838832
Course Length8 hours 06 minutes

Video Description

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.

Style and Approach

You'll start this course by learning the fundamentals of C# and Visual Studio, including configuring the layout, defining variables, interacting with users, and understanding data types, data conversions, and constants. On the bottom are several lessons on C# 7.0

 

Table of Contents

Introduction to Visual Studio
Introduction - Why C#, and Downloading and Installing Visual Studio Community Edition
Customizing Visual Studio to Make It Feel More Personal
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
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
Operators
Operators That Evaluate and Assign in Place
Checking Two Conditions with the Logical AND Operator
Checking Two Conditions with the Logical OR Operator
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
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
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
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
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
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
XML Basics - Web Forms Version
Creating and Using an XML File
Creating XML Files with C#
Querying XML Documents with Linq
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
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
Operators - Console Version
Logical "AND" Operator
Logical "OR" Operator
Compound, Prefix, and Postfix Operators
The Ternary Operator
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
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
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
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

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

Authors

Table of Contents

Introduction to Visual Studio
Introduction - Why C#, and Downloading and Installing Visual Studio Community Edition
Customizing Visual Studio to Make It Feel More Personal
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
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
Operators
Operators That Evaluate and Assign in Place
Checking Two Conditions with the Logical AND Operator
Checking Two Conditions with the Logical OR Operator
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
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
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
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
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
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
XML Basics - Web Forms Version
Creating and Using an XML File
Creating XML Files with C#
Querying XML Documents with Linq
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
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
Operators - Console Version
Logical "AND" Operator
Logical "OR" Operator
Compound, Prefix, and Postfix Operators
The Ternary Operator
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
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
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
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

Video Details

ISBN 139781788838832
Course Length8 hours 06 minutes
Read More

Read More Reviews

Recommended for You

Web Security: Common Vulnerabilities And Their Mitigation [Video] Book Cover
Web Security: Common Vulnerabilities And Their Mitigation [Video]
$ 48.99
$ 41.65
Kali Linux - An Ethical Hacker's Cookbook Book Cover
Kali Linux - An Ethical Hacker's Cookbook
$ 35.99
$ 25.20
The Complete Google Go Programming Course For Beginners [Video] Book Cover
The Complete Google Go Programming Course For Beginners [Video]
$ 123.99
$ 105.40
Advanced Continuous Delivery Pipeline [Video] Book Cover
Advanced Continuous Delivery Pipeline [Video]
$ 124.99
$ 106.25
DevOps with Kubernetes Book Cover
DevOps with Kubernetes
$ 39.99
$ 28.00
Machine Learning for Data Science [Video] Book Cover
Machine Learning for Data Science [Video]
$ 60.99
$ 51.85