20 Hour C# 6.0 Course with Intro to SQL, Unity and C# 7.0
4.5 (108 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,836 students enrolled
Wishlisted Wishlist

Please confirm that you want to add 20 Hour C# 6.0 Course with Intro to SQL, Unity and C# 7.0 to your Wishlist.

Add to Wishlist

20 Hour C# 6.0 Course with Intro to SQL, Unity and C# 7.0

Learn C# 6. With SQL Server/ Intro to Unity/ Intro to C# 7.0
4.5 (108 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,836 students enrolled
Created by Tom Owsiak
Last updated 3/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 21 hours on-demand video
  • 2 Articles
  • 63 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Understand how to create and run simple Console program
Learn how to create and use variables
Learn about several different data types, and why they are needed
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 foreach loops
Describe how to use several different logical operators
Understand how to use unary and binary operators, and the ternary operator
Learn how to construct methods, and why they help
Understand how to use the dynamic keyword, and var keywords to save time
Learn how to construct simple classes and instantiate them
See how to use constructors, properties and static and object fields
Learn how to polymorphism helps to write less code
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
Learn how to use SQL Server 2014
Learn how to write stored procedures and how to save, and read records
Learn how to manipulate data directly in C# with Linq
Learn how to make practical use of Interfaces
Learn how to make applications more stable with the nullable keyword
Learn how to create and read XML files
Learn how to save and reconstruct objects using serialization
Please read through the curriculum to see many other things
Learn how to write basic C# unity scripts
Learn about the features of C# 7.0
View Curriculum
Requirements
  • You must be able to download and install Visual Studio Community 2015
  • You cannot complete this course with previous versions of Visual Studio
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. Lessons 51-127 give you a view of C# through web programming with Web Forms. This means 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.

Learn C#, Visual Studio, and Object Oriented Programming

Start Using the C# Programming Language to Work with Code and Data

Understand the Microsoft Visual Studio Environment as It Relates to C#

Apply the Fundamentals of Object Oriented Programming to Data

Enhance Your Programming Skills with a Foundation in C#

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.

Contents and Overview

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.

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.

By the end of this course, you'll have a solid understanding of the most important aspects of C#, Visual Studio, and Object Oriented Programming.

You'll be able to use these new skills to advance your career as a programmer, as well as become a C# developer.

There is also a section on applying some of the methods from C# to scripting in Unity.

On the bottom are several lessons on C# 7.0

Note: Promo template licensed from PRESENTERMEDIA

Who is the target audience?
  • This is a course for beginning students
  • This course is a combo pack, so the first 50 are for beginners
  • The lectures numbered 51-127 are for more advanced students
  • Those interested in unity scripting to make games come to life
  • There are some considerably advanced topics towards the bottom of the course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 159 Lectures Collapse All 159 Lectures 20:56:57
+
Introduction
2 Lectures 04:42

Concept: This is an incredibly powerful programming environment. You can develop a full spectrum of applications using this program.

Real Application: Put this on your resume as a valuable skill

Learning Results:

1) Understand how to find, download, and install Visual Studio Community 2015

2) This course also uses Desk Pins to keep the console window on top of other windows.

Preview 01:52

Concept: You can take complete control of Visual Studio

Real Application: Having a custom work space allows you to be as productive as possible

Learning Results:

1) Understand how to configure font sizes in the text editor.

2) Understand how to configure font sizes in the user interface.

3) Learn how to export and import user interface settings.

Preview 02:50
+
Learning The Fundamentals
9 Lectures 55:59

Big Idea: The Internet gets most of its fundamental structure from HTML

Learning Results:

1) Learn how to create a simple web site in Visual Studio

2) Learn how to add a simple web form

3) Review the basics of HTML to understand how documents on the internet are structured

4) See how to run a simple page in a browser

5) Learn how to set the environment font

Preview 05:01

Big Idea: C# is a powerful programming language that adds dynamic features to static web pages

Learning Results:

1) Understand how to add a label

2) Learn how to simplify the existing code in a C# code behind file and what the various features mean

3) Learn how to display the text in a label in a browser window

4) Learn how to make a reusable template

Creating And Running A Page That Incorporates C#
06:27

Big Idea: Variables are named memory locations where the stored data changes

Learning Results:

1) See how to declare a variable

2) Learn how to set a variable

3) Learn how to append a new line of writing to a previous line of writing

4) Learn about the double data type

Creating And Using A Single Variable
07:15

Big Idea: Visual Studio needs to be updated with C# 6.0 so string interpolation can work.

Update Visual Studio With C# 6.0
03:01

Big Idea: Format output results so they look more professional

Learning Results:

1) Learn how to bring variable values into a string

2) Learn the concept of string interpolation

3) Learn how to format strings using formats like currency and percents

4) Learn how to update C# to version 6.0 so new features like string interpolation work


Formatting Output Strings For More Professional Results
06:12

Big Idea: The world of objects is diverse, so use different data types and multiple variables to represent this diversity

Learning Results:

1) Learn why different data types are needed

2) Learn how to work with booleans, decimals and strings

3) Learn how to output these to a web page

Using Variables And Data Types To Describe The World Around Us
08:15

Big Idea: In realistic scenarios, many different kinds of computed quantities are of interest

Learning Results:

1) Understand the concept of a computed variable

2) Learn how to display computed variables

3) Learn how to enlarge the font

4) Watch the supplementary video on converting between data types using casting and rounding

Computed Variables And Basic Math
06:15

Big Idea: Web pages can be more useful when users can interact with them through boxes

Learning Results:

1) Learn how to add a textbox to a web page

2) Learn how to get value from box

3) See how to convert value to numerical form

4) Learn how to display result of calculation in label on page

5) Understand how C# event handlers are connected to HTML code

Interacting With Users Through The Web Page
07:23

Big Idea: Method chaining allows replacing several lines of code with one line of code

Using Method Chaining To Write More Compact Code
06:10
+
Controlling Program Flow
8 Lectures 57:00

Big Idea: Use if/else blocks to check and then react to a single condition

Learning Results:

1) Understand how to add a checkbox and a panel to a page

2) Learn how to make a simple decision using the checked property of a check box

3) Understand how to enable auto postback to ensure the effects checking or not checking a box are visible right away

Reacting To A Single Condition With If/Else Blocks
06:08

Big Idea: This is needed later when we work with loops

Making A Variable Grow By Adding One
03:16

Big Idea: Use while loops to repeat a block of code after a condition is checked a minimum of one time

Learning Results:

1) Learn how to use the while loop to repeat a block of code

2) Learn about counter variables

3) Learn how to control font types in web pages and how to code style information in the head section of a file


Repeating Blocks Of Code With While Loops
09:21

Big Idea: Use for loops to repeat a block of code with an index variable

Learning Results:

1) Learn how to add a list box to a page

2) Learn how to fill a list box with a for loop

3) Understand the details of the operation of a for loop

4) Attached video shows how to execute the loop with complete control using the debugger

Repeating Blocks Of Code With For Loops
07:02

Big Idea: Use ForEach loops when no index is needed

Learning Results:

1) See how to code a for loop

2) Learn how to nest an if block inside a foreach loop block

3) Understand how to examine the characters that make a string one at a time

4) The attached video shows how to run foreach loops with the debugger

Iterating Over Collections With ForEach Loops
06:28

Big Idea: Switch blocks are used to examine variable values

Learning Results:

1) Understand how to code a switch block

2) Learn how to use a drop down list

3) Understand how to connect a switch block to a drop down list

4) Learn how to generate page titles dynamically

Examining Multiple Variable Values With Switch Blocks
06:14

Big Idea: TryParse can be used to build more stable applications

Learning Results:

1)Understand how to use the tryParse method

2) Understand how to use the tryParse method with a if/else to control execution

Improving Input Processing With TryParse
09:25

Big Idea: Use the ternary operator to replace simple if/else blocks

Learning Results:

1) Understand the ternary operator

2) Learn how to combine the ternary operator with TryParse

3) Learn how asp controls like buttons can be added

Replacing If/Else Blocks With The Ternary Operator
09:06
+
Operators
3 Lectures 22:00

Big Idea: Verbose code can be simplified with these more compact versions of the operators

Learning Results:

1) Understand the concept of a post fix operator

2) Understand the concept of a pre fix operator

3) Understand how some operators can evaluate and assign

4) Understand that operators return certain data types, like doubles, and Booleans

Operators That Evaluate And Assign In Place
08:24

Big Idea: Use this operator to check whether two conditions are true at the same time

Learning Results:

1) Learn how to code the basic logical and operator

2) Understand that both conditions must be true for the operator to return true

3) Understand the concept of short circuiting when using this operator

4) There is a flow diagram PDF attached

Checking Two Conditions With The Logical And Operator
06:15

Big Idea: Use this operator to perform a logical or test

Learning Results:

1) Understand how to code a basic or operator

2) Learn how the operator works when both conditions are false

3) Discover how to use breakpoints, and step through code using the debugger

Checking Two Conditions With The Logical Or Operator
07:21
+
Array And Method Basics, Web Forms Version
10 Lectures 01:22:52

Big Idea: Arrays are used to store data sequentially

Learning Results:

1) Learn how to create and size arrays

2) Learn how to store values in arrays

3) Learn how to read values from arrays

4) Learn how to use arrays in calculations

5) Attached is a color PDF with an example showing how to read, split and process lists

Declaring, Setting And Reading Arrays
09:20

Big Idea: For loops and ForEach loops work well with arrays

Learning Results:

1) Learn how to fill an array with a for loops

2) Learn how to read from an array with a foreach loop

3) See how to adjust the index in a for loop so as to start from 1 rather than 0

Iterating Over Arrays With ForEach And For Loops
03:53

Big Idea: Functions represent behaviors, or actions, that can be performed

Learning Results:

1) Understand how to write a function

2) Learn the meaning of several keywords that are used to make functions

3) Learn how to call a function with a value

4) Understand how to execute the code with the debugger

Creating And Using A Simple Method
09:13

Big Idea: Sequential data can be pass into functions, and returned from functions

Learning Results:

1) Learn how to pass an array into a function

2) Learn how to sum an array

3) Learn how to sort arrays

4) Learn how to return arrays from functions

Passing Arrays Into Methods
06:18

Big Idea: Not all variable types are treated the same at the memory level

Learning results:

1) Lear how to create two functions

2) Learn how to pass arguments by reference

3) Learn how arguments are passed by value

4) Learn how to confirm whether an argument is passed by reference or value

5) Value types require the amount of memory for the particular type

6) Reference types require more memory because of overhead information about them

Reference Type And Value Type Variables
08:51

Big Idea: The params keyword allows functions to be more flexible

Learning Results:

1) Learn how to make a function that can operate on a variable number of arguments

2) Learn how to call such a function from client, or calling, code

Creating More Flexible Methods With The Params Keyword
08:32

Big Idea: Functions can return multiple values

Learning Results:

1) Learn how to create a function that can set multiple values using the out keyword

2) Learn how to call a function using the out keyword

3) Learn how to sort arrays using Array.Sort(arrayName)

4) Understand that out variables do not have to be set in the calling code

Creating More Flexible Functions With Out Keyword
09:13

Big Idea: Functions can return multiple values

Learning Results:

1) Learn how to use the ref keyword

2) Review how to use the out keyword

3) Learn the difference between out and ref

Combining The Ref Keyword And Out Keyword To Write Flexible Functions
07:27

Big Idea: Arrays can be extended to multiple dimensions

Learning Results:

1) Understand how to declare a two dimensional array

2) Understand how to set the values in a two dimensional array

3) Learn how to operate on two dimensional arrays

4) Learn how to find the sum of values in a row

5) Learn how to find the sum of all the values inside a 2 by 2 array

Multidimensional Arrays
09:08

Big Idea: Dynamic and var are NOT the same, and serve different purposes

Learning Results:

1) Understand how to use the dynamic keyword

2) Learn how to use the var keyword

3) Learn how var and dynamic differ

Writing Easier Code With Var and Dynamic
10:57
+
Fundamentals Of Objected Oriented Programming, Web Forms Version
20 Lectures 03:25:26

Big Idea: To create an example of a class is to "instantiate" the class

Learning Results

1) Learn how to add a class file to a program

2) Learn the purpose of a constructor and add a function

3) Learn why the access modifier public matters

4) Learn how to declare and instance of a class and call a function on that instance

5) Learn how to add documentation to classes and functions

Create A Class With A Constructor And A Function
11:49

Big Idea: Static functions(or methods) act at the class level

Learning Results:

1) Understand how to create a static method

2) Understand why sometimes it's better to create static methods

3) Learn how to call the static methods directly through the class name

4) Learn how to convert a string to an array

Create A Class With A Static Method
08:20

Big Idea: Instance variables store the "state" of objects in their values

Learning Results:

1) Understand how to add one instance variable

2) Learn how to set the instance variable using a parametrized constructor

3) Learn how to code a simple property to access a backing field

4) Learn how to use parametrized constructors and properties in client code

Create A Class With An Object Property
10:01

Big Idea: A class is a collection of several different features

Learning Results

1) Learn how to make a static field

2) Learn how to set a static field

3) Learn how to make a static property

4) Learn how to use a static property

Create A Class With Static Fields, Functions and Properties
08:49

Big Idea: Centralize common code in parent classes so it does not have to be rewritten

Learning Results:

1) Understand how to make a simple class hierarchy

2) Learn how to use base class constructors

3) Learn how to use base class functions

4) Learn how to view a class diagram with multiple classes

5) Learn how to split a string into individual entries using the Split function

Centralize Common Code With Inheritance
14:26

Big Idea: Centralize common code in virtual functions, and then refine that code in overriding functions

Learning Results:

1) Learn how to make a simple virtual function

2) Learn what purpose virtual functions serve

3) Learn how to override virtual functions

Centralize Default Code With Virtual Functions
11:37

Big Idea: Use abstract classes to represent concepts, but the classes are still related and application specific

Learning Results:

1) Understand how to create an abstract class

2) Understand the purpose of an abstract class

3) Learn how to implement members from abstract classes

Model Concepts With Abstract Classes
11:36

Big Idea: Custom data types can be used as return types, or parameter types

Learning Results:

1) Learn how to create an array instance variable

2) Learn how to create a method that returns a custom type

3) Learn how to do a basic sort

4) Learn how to create a function for the purposes of displaying information

Using Custom Types As Return Types
09:32

Big Idea: Use lists to store and manipulate data efficiently

Learning Results:
1) Learn how to add two new namespaces

2) Learn how to create a list of doubles

3) Learn how to fill a list

4) Learn how to perform several mathematical operations on lists

5) Learn how to use the ForEach construct to operate on each value inside a list efficently

Using Lists To Operate On Data Efficiently
09:54

Big Idea: Use polymorphism to write less code by treating objects as different forms, depending on context

Learning Results:

1) Learn how to build a simple class hierarchy

2) Learn how to create a list of products

3) Learn how different derived types can be added to a list of products

4) Learn how polymorphism works at run time to call the correct method from each derived class

5) Understand that polymorphism allows programmers to write less code

Note: Be sure to put a "<br>" before price inside the product class. This is done in the attached code file.

Writing Less Code With Polymorphism
15:06

Big Idea: Use interfaces to express common behaviors among many different classes

Learning Results:

1) Learn how to make an interface

2) Learn how to make classes that use the interface

3) Learn how to make objects of the interface type

4) Learn how to make and use a list of interface type objects

5) Understand that interfaces are widely applicable, meaning different classes can implement them meaningfully

Using Interfaces To Express Common Behaviors
11:05

Big Idea: Use indexers when dealing with objects that store data in arrays

Learning Results:

1) Learn how to create a class with an indexer

2) Learn how to use the indexer in client code

3) Understand that indexers allow us to treat objects as if they were arrays

Iterating Over Instances With Indexers
06:01

Big Idea: Use exception handling to build more stable applications

Learning Results:

1) Learn how to build a try/catch/finally block

2) Learn how to throw exceptions

3) Learn how to catch exceptions

4) Learn how to use finally to always run a block of code

5) Learn why exceptions are needed, and how they make applications more stable

Building More Stable Apps With Exception Handling
08:27

Big Idea: Named and optional parameters allow the writing of more flexible code

Learning Results:

1) Learn how to create a book class

2) Learn how to use named and optional parameters

3) Learn how to create a list of book

4) Learn how to search the list of books to produce a result set

Using Named And Optional Parameters
12:04

Big Idea: The null coalescing operator can be used to ensure that applications are more stable by ensuring that values exist

Learning Results:

1) Learn how to make automatic properties whose values are set inside a constructor

2) Learn how to simulate null values inside a list

3) Learn how to use the null coalescing operator to ensure values exist before using them

Using The Null Coalescing Operator To Write More Stable Applications
11:59

Big Idea: We can assign meanings to operators as needed, depending on context

Learning Results:

1) Learn how to create a vector class

2) Learn why it's necessary to redefine operator meanings

3) Learn how to write code to define a new meaning for the "+" operator

4) Learn how to use nested for loops to display the sum of several vectors

Overloading Operators To Perform Custom Operations
11:12

Big Idea: Enumerations make working with lists of named constants easier and more natural

Learning Results:

1) Learn how to create a simple enumeration

2) Learn how to use a simple enumeration

Using Enumerations To Represent Named Constants
06:32

Big Idea: Namespaces help to organize code into logically structured hierarchies

Learning Results:

1) Learn how to create a namespace

2) Learn how to place multiple classes inside a namespace

3) Learn how to create a C# class library, a DLL file and how to use them inside client code

Creating And Using Name Spaces
10:21

Big Idea: Use structs to represent simple composite constructs

Learning Results:

1) Learn how to construct a struct

2) Learn that structs can still make use of properties

3) Learn how to create random numbers within a certain range

4) Learn how to sleep a thread

Structs, Random Points, and Sleeping Threads
07:53

Big Idea: Delegates are used in event driven programming in windows. Think of them as function wrappers.

Learning Results:

1) Learn how to create a delegate type

2) Learn how to instantiate delegates

3) Learn how to chain delegates

4) Learn how to invoke a delegate

Declaring, Creating And Using Delegates
08:42
+
Generics, Web Forms Version
5 Lectures 48:14

Big Idea: Generic classes allow us to write code that is more flexible because it can operate equally well on different data types

Learning Results:

1) Learn how to create a simple generic class

2) Learn how to use a ForEach loop with a generic array

3) Learn how to make use of the class to operate on different data types

Create A Simple Generic Class
08:12

Big Idea: Functions can be made more flexible by making them generic

Learning Results:

1) Learn how to create a generic method that swaps values

2) Learn how to create a generic method that compares values

3) Learn how to ensure that a function acts on only certain types by using a constraint

Create A Generic Method
11:04

Big Idea: Interfaces can be generic, and can operate on a variety of data types

Learning Results:

1) Learn how to create code to implement a generic interface

2) Learn how to make objects sortable using CompareTo()

3) Learn how to use the is keyword to check whether an object is of a certain type

Implementing A Generic Interface To Accomplish Sorting
14:42

Big Idea: A single delegate can operate equally well on several different data types

Learning Result:

1) Understand how to create a generic delegate

2) Learn how to assign functions to the delegate

3) Learn how to invoke the delegate to cause a chain of functions to be executed

Making Delegates More Flexible With Generics
06:29

Big Idea: Dictionaries are useful because they allow us to keep track of related information in a simple and organized way

Learning Results:

1) Learn how to create a generic dictionary

2) Learn how to add key/value pairs to the dictionary

3) Learn how to iterate over the KeyValue collection

4) Learn how to launch programs directly from a webpage

Creating And Using Generic Dictionaries
07:47
+
Lambda Expressions And Linq, Web Forms Version
10 Lectures 01:31:47

Big Idea: Delegates can be used in the process of lambda expression creation

Learning Results:

1) Understand how to create several delegates

2) Learn how to instantiate the delegates with lambda expressions

3) Learn how to create an Action with a parameter

4) Learn how to repeatedly invoke an action

Connection Between Delegates And Lambda Expressions
08:53

Big Idea: It's possible to make lambdas represent entire chunks of code so the chunks of code can be passed around

Learning Results:

1) Learn how to create expression bodied members

2) Learn how to create expression bodied lambdas

3) Learn how to use expression bodied lambdas as arguments into functions

4) Learn how to convert array from one type to another

Expression Bodied Lambdas And Expression Bodied Members
11:32

Big Idea: It's possible to inline code so it becomes nameless

Learning Results:

1) Learn how to invoke an action method on each value in a list

2) Learn how to create an anonymous method and call it

3) Learn how to use anonymous methods when creating objects to break the program into separate threads

4) Watch the supplementary video to learn how to make anonymous data types

Anonymous Methods And Objects That Run Their Own Delegates
09:15

Big Idea: Linq is a powerful extension on C# that allows us to manipulate data in a great variety of ways

Learning Results:

1) Learn how to use where, orderby, and contains

2) Learn how to convert an array into a list

3) Learn how to chain function calls

4) Become aware of some of the different return types of extension methods

C# With Linq And Built In Types
09:02

Big Idea: Linq can be elegantly used with custom data types

Learning Results:

1) Learn how to create a simple class

2) Learn how to operate on an array of the custom class objects with linq

3) See how to use a foreach loop to iterate over the results produced by the linq

C# With Linq And Custom Data Types
06:16

Big Idea: Linq can be used to retrieve data from underlying structures like arrays, lists, and dictionaries

Learning Results:

1) Learn how to create a Linq query that operates on arrays

2) Learn how to create a linq query that operates on a dictionary of key/value pairs

3) Understand that these basic queries return IEnumerable<data type> as the result set

4) Understand that linq queries are delayed until the execution of a structure like a foreach loop

Using Query Syntax To Construct Queries
10:53

Big Idea: Besides returning an enumerable construct, Linq can also be used to perform many different aggregation functions

Learning Results:

1) Learn how to average the results of an inline query using query syntax

2) Learn how to average the results of a query using method chaining

3) Learn how to make a list of lists to represent more realistic situations

Queries That Perform Aggregation Functions
09:53

Big Idea: Store related information in tuples

Learning Results:

1) Learn how to return a tuple from a function

2) Learn how to construct a tuple

3) Learn how to make use of a tuple to display it

Using Linq To Summarize Tuples
08:10

Big Idea: Linq provides many ways of grouping data

Learning Results:

1) Learn how to create a class with properties that are set directly in the object initialization stage

2) Learn how to create a query that groups results

3) Learn how to nest foreach loops to iterate over the query and display categorized information

Summarizing Results With Grouping
08:25

Big Idea: Linq allows us to merge records

Learning Results:

1) Learn how to perform an inner join

2) Learn how to ensure two classes are connected through a field

3) Learn how to display the results

4) Become aware of the fact that there are many other joins that can be performed

Joining Data Sets With Inner Joins
09:28
+
Working With SQL Server 2014
6 Lectures 01:02:14

Big Idea: SQL Server is a powerful database management system that is a must on your resume

Learning Results:

1) Learn how to find, download and install SQL Server 2014

2) Learn how to confirm the server is accessible from Visual Studio

3) Learn how to create a simple database, and a simple table with three fields

4) Attached below is a PDF with numbered steps showing how to add records to the table

Download, Install And Run SQL Server 2014
07:03

Big Idea: If necessary, it's possible to write custom code to connect to SQL Server manually

Learning Results:

1) Learn how to use the "using" statement to create, use and dispose of low level resources correctly

2) Learn how to get the SQL connection string

3) Learn how to read database records using C#

Write Code To Manually Connect To A Table, And Retrieve Records
09:35

Big Idea: C# Allows both insertion and reading of records, among many other possibilities

Learning Results:

1) Learn how to create a simple stored procedure

2) Learn how to execute the stored procedure

3) Learn how to write code in C# that inserts column values through parameters

4) Review the important of enclosing low level resources inside using statements

Inserting Recods Into Tables Using Stored Procedures
14:45

Big Idea: The nullable feature of C# allows creating more stable apps that can deal with missing values elegantly

Learning Results:

1) Learn how to create a class with nullable fields

2) Learn how to construct objects based on database inputs

3) Learn how to handle null values coming from a database

Using The Nullable Feature To Make Apps More Stable
10:31

Big Idea: It's possible to configure ASP.NET controls directly through code using simple data readers

Learning Results:

1) Learn how to drag and drop a chart control into a page

2) Learn how to make use of a data reader to set the x values of the chart

3) Learn how to display the table

4) Learn how to use the decimal data type in SQL Server

Connecting A Chart Control To SQL Server
09:14

Big Idea: Linq can be used with SQL Server to produce very elegant results

Learning Results:

1) Learn how to make a data adapter

2) Learn how to make a data table

3) Learn how to covert a table into an enumerable construct to make Linq worth with it

Using Linq To Operate on Tables From SQL Server
11:06
+
File Access, Web Forms Version
5 Lectures 51:04

Big Idea: C# provides many classes for writing and reading files

Learning Results:

1) Learn how to write text to a file

2) Learn how to read a file into a page

3) Review the important of using blocks when dealing with low level resource access

Create A Page That Saves Text To Disk
09:42

Big Idea: There are controls and classes for working with files and folders

Learning Results:

1) Learn how to upload files

2) Learn how to list all the files in a folder

Create A Page That Uses The File Upload Control
09:46

Big Idea: Objects can be saved in a binary format, and then recreated

Learning Results:

1) Learn how to create a serializable class

2) Learn how to serialize an object of that class

3) Learn how to reconstruct objects from a stream

Serializing And Deserializing Objects
11:50

Big Idea: C# allows manipulating images at the level of individual pixels

Learning Results:

1) Learn how to load an image as a bit map

2) Learn how to read each pixel's color

3) Learn how to change each pixel's color

4) Learn how to set the ImageURL property of an image so the image can be displayed

Having A Little Fun With Images With Pixel Manipulations
08:42

Big Idea: It's possible to perform many file related tasks in SQL Server

Learning Results:

1) Learn how to read file paths into a listbox from a hard drive

2) Learn how to read a list box

3) Learn how to use file paths to make images into byte arrays so the pictures can be saved to SQL Server

Saving An Image To SQL Server
11:04
13 More Sections
About the Instructor
Tom Owsiak
4.4 Average rating
1,150 Reviews
15,736 Students
17 Courses
Web, Math, Stats., and Physics Expert
  • I have nine years experience as a teacher of mathematics, physics, statistics, and programming. I worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and others. I'm the publisher of one of the most successful programming courses on udemy, called "Learn C# With Visual Studio 2013". Currently, I work as a mathematics and computer science teacher at a college in NY.
  • Related Education:
  • Master of Science in Applied Statistical Computing, Kennesaw State University
  • Bachelor of Arts, Pure Mathematics, Queens College
  • Associates of Science in Computer Programming
  • Creator of more than 1620 math, physics, statistics and programming videos
  • Programmer of more than 500 educational simulations