Get $1 credit for every $25 spent!

The Ultimate Microsoft .NET & C# Programmer Bundle

Ending In:
Add to Cart - $29.99
Add to Cart ($29.99)
$1,000
97% off
wishlist
Courses
5
Lessons
316
Enrolled
108

What's Included

Product Details

Access
Lifetime
Content
13.0 hours
Lessons
99

Learn C# By Building Applications

Understand the Concepts of C#6 & C#7 and Use Them to Build Real World .NET Console Apps

By Avetis Ghukasyan | in Online Courses

The C# (C Sharp) programming language allows you to develop games, mobile apps, desktop apps, and web apps. This means that if you know C# well and can build desktop or web applications using it, then you will always be in demand. Not only is it a valuable skill, but C# is also profitable expertise to have. However, before going anywhere, you first need to learn the fundamentals. This course will go over the same fundamentals of C# and a context of an application that you'll be building from scratch.

4.5/5 average rating: ★ ★ ★ ★

  • Access 99 lectures & 13 hours of content 24/7
  • Be able to write programs in C# on your own
  • Write clean code that will make your work more elegant, readable & respectable
  • See how a "for loop" or an "if statement" is used in an actual application
Avetis Ghukasyan | Web Developer

4.5/5 Instructor Rating: ★ ★ ★ ★

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That in turn helps one to write even better software creating an upward cycle for more growth.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Any device with basic specifications

Course Outline

  • Setup
    • Installing Visual Studio 2019 - 5:22
    • How Updates Are Handled - 3:01
    • Visual Studio 2015 vs 2019 And Advice On Self-Troubleshooting - 6:45
    • Correct Mindset For This Course - 4:04
    • Self-Troubleshooting
  • Simple Calculator
    • Acceptance Criteria - 3:10
    • Algorithm - 3:28
    • FlowChart - 4:36
    • Variables - 9:16
    • Expressions & Operators - 3:42
    • Converting String To Number - 4:18
    • Order Of Evaluation - 5:23
    • String Manipulation, Formatting and More - 15:10
    • Conditional Statements - 10:29
    • Objects & Classes - 5:49
    • Methods - 9:16
    • Static Vs Non Static - 5:01
    • Exceptions & Throw Keyword - 9:34
    • Try Catch Finally - 14:40
    • Writing Simple Calculator - 18:37
    • Writing Simple Calculator Unit Tests - 15:07
  • Word Unscrambler
    • Acceptance Criteria - 3:31
    • Algorithm - 6:21
    • FlowChart - 2:52
    • Lists - 3:45
    • Arrays - 7:00
    • Array.Sort & More - 3:32
    • For Loop - 7:28
    • While Loop - 6:30
    • Do While Loop - 5:16
    • ForEach Loop - 2:34
    • Iterating Lists & Arrays - 9:38
    • Reference vs Value Types - 15:10
    • Classes vs Structs - 4:41
    • Out vs Ref Parameters - 5:20
    • Null & Null Coalescing - 6:33
    • Readonly vs Const - 4:40
    • Read & Write to Files - 8:10
    • DRY Principle - 6:06
    • Writing Program Part 1 - 14:25
    • Writing Program Part 2 - 16:43
    • Writing FileReader - 4:46
    • Writing WordMatcher - 11:42
    • Writing Constants - 19:28
    • Writing Word Unscrambler Unit Tests - 19:31
  • Simple Web Scraper
    • Acceptance Criteria - 3:22
    • Algorithm - 4:35
    • FlowChart - 3:58
    • Fields - 5:02
    • Properties - 10:30
    • Constructors - 5:47
    • Object Oriented Programming - 7:33
    • Encapsulation & InternalsVisibleTo - 18:17
    • Using Keyword - 8:13
    • Builder Pattern - 16:30
    • Single Responsibility Principle - 8:05
    • HTML Basics - 4:13
    • Regular Expressions - 11:18
    • Writing Both Builders - 14:12
    • Writing Scraper - 7:56
    • Writing Program Part 1 - 17:15
    • Writing Program Part 2 - 5:34
    • Writing Simple Web Scraper Unit Tests - 10:25
  • Sudoku Solver
    • Acceptance Criteria - 2:36
    • Algorithm - 5:53
    • FlowChart - 4:00
    • StringBuilder - 2:58
    • Jagged Arrays vs Multidimensional Arrays - 5:09
    • Dependency Injection - 4:27
    • Interfaces - 6:00
    • Abstract Classes - 6:39
    • Interfaces vs Abstract Classes - 2:27
    • Polymorphism - 3:54
    • LINQ Introduction - 14:04
    • Writing SudokuFileReader - 14:12
    • Writing SudokuMapper - 10:50
    • Writing SudokuBoardDisplayer - 6:00
    • Writing SudokuBoardStateManager - 5:44
    • Writing SudokuSolverEngine - 12:55
    • Writing SimpleMarkUpStrategy Part 1 - 16:47
    • Writing SimpleMarkupStrategy Part 2 - 11:00
    • Writing NakedPairStrategy Part 1 - 18:08
    • Writing NakedPairStrategy Part 2 - 14:33
    • Fixing Few Bugs - 6:57
    • Writing Program - 9:32
    • Writing Unit Tests Part 1 - 10:20
    • Writing Unit Tests Part 2 - 11:57
  • Updates In C# 7
    • C# 7 Features We Will Be Going Over - 6:45
    • Out Variables - 3:09
    • Throw Expressions - 5:59
    • Binary Literals & Digit Separators - 4:36
    • Expression Bodies - 6:27
    • Ref Locals And Returns - 9:57
    • Deconstruction - 9:21
    • Local Functions - 3:58
    • Pattern Matching Part 1 - 16:32
    • Pattern Matching Part 2 - 6:56
    • Tuples - 16:04
  • Application Code
    • Resources

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
55

Master C# And SQL By Building Applications

Become a Better Software Developer by Learning How to Build Real-World Applications Using C# & SQL

By Avetis Ghukasyan | in Online Courses

It is time for you to master C# and SQL by putting them together and pushing yourself to build real-life applications. There are no shortcuts or magic potions that will make you good. You will have to take the course, dedicate your time and learn all of the information. This course's sole purpose is to challenge you to put multiple technologies together while solving real-life problems. All of the applications written in this course could be used in the real world with enhancement.

4.6/5 average rating: ★ ★ ★ ★

  • Access 55 lectures & 6 hours of content 24/7
  • Use SQL & C# together to build a full stack application
  • Use Dapper in .NET to make SQL database access even easier
  • Build forms using WPF & XAML
  • Use MVVM in order to create forms that are intuitive & easily manageable
  • Create & manipulate Excel worksheets and workbooks via Open XML and C#
Avetis Ghukasyan | Web Developer

4.5/5 Instructor Rating: ★ ★ ★ ★

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That in turn helps one to write even better software creating an upward cycle for more growth.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Any device with basic specifications

Course Outline

  • Setup
    • Download & Install Visual Studio 2019 Community - 4:06
    • Download & Install SQL Server 2019 - 2:09
    • Download & Install SSMS 18 - 4:11
    • Self-Troubleshooting
  • Customer Order Viewer
    • Customer Requirements - 2:43
    • SQL Server Database Objects - 2:59
    • Create Application Database & Tables - 11:30
    • Give Values To Our Tables - 4:20
    • Quick Side Note - 8:22
    • SQL Views - 1:47
    • Create Application View - 7:17
    • Explore Server Explorer - 4:19
    • What Is SQLConnection? - 4:10
    • What Is SQLCommand? - 1:33
    • What Is SqlDataReader? - 3:32
    • Create Application Models - 5:02
    • Create Application Command - 18:58
    • Put All Together & Test - 9:05
  • Customer Order Viewer 2.0
    • Customer Requirements - 0:27
    • SQL Alter - 1:04
    • Alter Our Table - 4:23
    • SQL UDDT and SPROCs - 2:11
    • Create Application UDDT & SPROCs - 21:47
    • Create More SPROCs - 3:01
    • What Is Dapper? - 0:42
    • Creating Application Models - 6:21
    • Creating Application Commands - 12:48
    • Put All Together & Test - 24:34
  • Course Report Emailer
    • Customer Requirements - 1:50
    • Create Application Database & Tables - 2:20
    • Give Values To Our Tables - 0:52
    • Create Application View - 3:01
    • Create Application SPROC - 3:00
    • Creating Application Models - 4:38
    • Create Application Commands - 6:09
    • What Is JSON? - 8:17
    • What Is DataTable? - 6:26
    • What Is Open XML SDK? - 1:30
    • Create WorkSheet Creator - Part 1 - 16:10
    • Create WorkSheet Creator - Part 2 - 10:53
    • Create Emailer - 9:30
    • Put All Together & Test - 6:53
  • Course Manager
    • Customer Requirements - 0:41
    • Alter Needed Table - 2:36
    • Create Application SPROCs - 12:28
    • What Is WPF and XAML? - 1:51
    • What Is MVVM? - 4:32
    • Cleanup And Create Startup - 11:49
    • Create Application Models - 2:46
    • Create Application Commands - 12:28
    • Use Mockup To Create View - 15:15
    • Enhance Our ViewModel - Part 1 - 12:57
    • Enhance Our ViewModel - Part 2 - 16:44
    • Put All Together & Test - 11:15
  • Application Code
    • Resources

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
26

Beginner Object Oriented Programming In C# and .NET Core

Learn Object-Oriented Programming Fundamentals & Climb Up the Developer Hierarchy

By Avetis Ghukasyan | in Online Courses

Object-Oriented Programming (OOP) teaches you how to think clearly about your code by letting you visualize your problems in terms of objects. This allows you to have a high-level view of the problem, which allows you to come up with a strong solution. With 26 lectures, this course will teach you what OOP, its fundamentals, and its applications.

4.5/5 average rating: ★ ★ ★ ★

  • Access 26 lectures & 3 hours of content 24/7
  • Understand the advantage of using OOP
  • Know the 4 main pillars of OOP
  • Utilize each pillar in your own project
Avetis Ghukasyan | Web Developer

4.5/5 Instructor Rating: ★ ★ ★ ★

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That in turn helps one to write even better software creating an upward cycle for more growth.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Any device with basic specifications

Course Outline

  • Your First Program
  • Setup
    • Installing .NET Core SDK - 2:45
    • Installing Visual Studio Code - 7:30
    • Self-Troubleshooting
  • Big Picture
    • What Is A Program? - 1:32
    • How To Write A Program? - 10:39
    • OOP Basics - 3:21
  • Inheritance
    • Down To Earth Definition - 1:33
    • Concrete Class - 8:51
    • Abstract Class - 13:32
    • Interface - Part 1 - 18:24
    • Interface - Part 2 - 6:08
  • Polymorphism
    • Down To Earth Definition - 1:04
    • Static Polymorphism - 16:19
    • Dynamic Polymorphism - Part 1 - 19:09
    • Dynamic Polymorphism - Part 2 - 9:37
  • Encapsulation
    • Down To Earth Definition - 2:13
    • Public - 7:06
    • Private - 2:01
    • Protected - 12:07
  • Abstraction
    • Down To Earth Definition - 1:25
    • Abstraction Through Encapsulation - 4:15
  • All Together
    • Summary Of All Concepts - 13:09
    • Small App - Part 1 - 17:56
    • Small App - Part 2 - 19:38
    • Small App - Part 3 - 3:50
  • Resources
    • Source Code

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
42

Microsoft SQL Server And T-SQL Course For Beginners

Learn about the Benefits of SQL & How SQL Server Stores Data

By Avetis Ghukasyan | in Online Courses

Do you know that SQL developers earn salaries somewhere around 90,000 to $120,000? Knowing SQL is a pretty profitable skill — not just "these days" but today, tomorrow, a year from now, and even further down the road. This course is here to guide your way through SQL. With 42 lectures, you'll learn what SQL servers are, set them up, how data is stored, what DDL, DML, and DCL are, and work with practical SQL scenarios.

4.3/5 average rating: ★ ★ ★ ★

  • Access 42 lectures & 4 hours of content 24/7
  • Be crystal clear on why there are so many kinds of SQLs
  • Know the difference between the query language & the databases
  • Perform tasks similar to ones you would get at an actual company
Avetis Ghukasyan | Web Developer

4.5/5 Instructor Rating: ★ ★ ★ ★

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That in turn helps one to write even better software creating an upward cycle for more growth.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Any device with basic specifications

Course Outline

  • Common Misconceptions
    • What Is SQL? - 4:15
    • What Is SQL Server? - 4:10
    • Self-Troubleshooting
  • Setting Up SQL Server & SSMS
    • Download SQL Server 2017 - 1:19
    • Install SQL Server 2017 - 2:56
    • Download SQL Server Management Studio - 1:00
    • Install SQL Server Management Studio - 0:49
    • Connect to SQL Server - 0:42
  • How Is Data Stored In SQL Server?
    • Simple Hierarchy - 6:51
    • Why Relational? - 10:19
    • Indexes - 10:35
  • DDL In SQL Server
    • Data Definition Language Commands - 1:24
    • How To Create? - 18:08
    • How To Modify? - 5:32
    • How To Truncate? - 1:46
    • How To Drop? - 4:08
    • Normalization - 9:57
    • Download and Import Adventure Works Database - 2:16
    • More On Index Creation - 7:57
  • DML In SQL Server
    • Data Manipulation Language Commands - 1:04
    • Begin With Retrieval - 8:58
    • Scalar Functions - 12:37
    • Sorting - 3:53
    • Column And Row Logic - 13:14
    • Joins - 13:47
    • Distinct Data - 3:08
    • Aggregate Functions - 16:59
    • SubQueries - 18:35
    • Set Operations - 9:01
    • Manipulate Data - 5:32
  • DCL in SQL Server
    • Data Control Language Commands - 2:36
    • Grant And Revoke - 2:36
  • Practical SQL Scenarios
    • Introduction To Section - 0:29
    • Problem 1 - 4:41
    • Problem 2 - 7:51
    • Problem 3 - 12:24
    • Problem 4 - 6:52
    • Problem 5 - 14:30
    • Problem 6 - 5:34
    • Problem 7 - 13:18
    • Problem 8 - 5:35
  • Resources
    • Source Code

View Full Curriculum


Access
Lifetime
Content
15.0 hours
Lessons
94

Learn Web Development By Building A Blog

Angular, Bootstrap, ASP.NET Core & More — Learn Full Stack Web Development by Building A Blog Application

By Avetis Ghukasyan | in Online Courses

In this course, you are going to build a full-stack blogging web application by starting from the very beginning stages of planning and moving ahead into implementing our solutions. You will be using various technologies to accomplish your goals, such as SQL Server, ASP.NET Core, Angular, Bootstrap, and much more. You will be able to see how all of the technologies interact with one another, and that way, gain a better understanding of their inner workings.

4.2/5 average rating: ★ ★ ★ ★

  • Access 94 lectures & 15 hours of content 24/7
  • Learn full stack web development process from beginning to end
  • Learn how to use ASP.NET Core with Visual Studio in order to build API layer
  • Know how to use Angular, Boostrap & Font-Awesome, and other libraries or frameworks to build the front-end
  • Discover ways on how to use SQL Server & SQL Server Management Studio to build the back-end
Avetis Ghukasyan | Web Developer

4.5/5 Instructor Rating: ★ ★ ★ ★

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That in turn helps one to write even better software creating an upward cycle for more growth.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Any device with basic specifications

Course Outline

  • Introduction
    • What Are We Building? - 7:47
    • What Technologies Are Used? - 3:51
  • Setup
    • Installing SQL Server 2019 - 3:33
    • Installing SQL Server Management Studio - 1:06
    • Installing Visual Studio 2019 - 2:09
    • Installing Visual Studio Code - 1:46
    • Installing Git - 2:47
    • Installing NodeJS - 1:17
    • Installing Postman - 2:19
    • Initial Project Setup - Part 1 - 20:44
    • Initial Project Setup - Part 2 - 21:16
  • Outline All Pieces
    • Sketch Out All Needed Pages - 4:49
    • Identify Standalone Components - 6:03
    • Identify All Endpoints - 5:15
    • Identify Database Actions - 5:19
  • Build SQL Back End
    • Going Over What We Need - 1:14
    • Create Application User - 10:22
    • Create Photo - 5:08
    • Create Blog - 5:41
    • Create BlogComment - 5:39
    • Create Schema - 1:03
    • Create Views - 6:10
    • Create Needed Types - 8:47
    • Create Account_GetByUsername - 4:20
    • Create Account_Insert - 6:29
    • Create Blog_Delete - 4:02
    • Create Blog_Get - 2:48
    • Create Blog_GetAll - 4:56
    • Create Blog_GetAllFamous - 10:04
    • Create Blog_GetByUserId - 3:31
    • Create Blog_Upsert - 9:32
    • Create BlogComment_Delete - 13:44
    • Create BlogComment_Get - 2:32
    • Create BlogComment_GetAll - 1:45
    • Create BlogComment_Upsert - 4:58
    • Create Photo_Delete - 1:33
    • Create Photo_Get - 1:45
    • Create Photo_GetByUserId - 0:56
    • Create Photo_Insert - 3:20
  • Build API
    • Going Over What We Need - 1:57
    • Create Models - Part 1 - 14:18
    • Create Models - Part 2 - 7:49
    • Create Models - Part 3 - 11:50
    • Create Account Repository - 21:48
    • Create Photo Repository - 15:13
    • Create Blog Repository - 18:03
    • Create BlogComment Repository - 10:03
    • Create Identity - 14:50
    • Create Photo Service - 17:32
    • Create Token Service - 18:05
    • Update Startup - Part 1 - 20:43
    • Update Startup - Part 2 - 14:02
    • Create Account Controller - 15:43
    • Create Photo Controller - 17:43
    • Create Blog Controller - 14:28
    • Create BlogComment Controller - 8:14
    • Fix Any Errors - 6:23
    • Test Main Parts With Postman - 12:16
  • Build Front End
    • Going Over What We Need - 2:15
    • Create Models - 19:14
    • Create Summary Pipe - 6:36
    • Generate All Components - 6:20
    • Generate All Services - 1:30
    • Generate All Interceptors - 1:54
    • Generate Auth Guard - 1:43
    • Build All Services - Part 1 - 17:26
    • Build All Services - Part 2 - 16:39
    • Build JWT Interceptor - 7:44
    • Build Error Interceptor - Part 1 - 11:55
    • Build Error Interceptor - Part 2 - 15:49
    • Build Auth Guard And Update Routing - 18:17
    • Build NavBar Component - 22:58
    • Build Login Component - Part 1 - 20:03
    • Build Login Component - Part 2 - 14:07
    • Build Home Component - 16:34
    • Build Not Found Component - 3:44
    • Build Register Component - Part 1 - 21:35
    • Build Register Component - Part 2 - 4:45
    • Build Dashboard Component - Part 1 - 20:08
    • Build Dashboard Component - Part 2 - 5:02
    • Build Blog Edit Component - Part 1 - 20:02
    • Build Blog Edit Component - Part 2 - 16:20
    • Build Photo Album Component - Part 1 - 20:07
    • Build Photo Album Component - Part 2 - 22:42
    • Build Blog Component - 15:48
    • Build Blog Card Component - 10:05
    • Build Blogs Component - 21:56
    • Build Famous Blogs Component - 7:00
    • Build Comment System Component - 19:46
    • Build Comment Box Component - 15:20
    • Build Comments Component - Part 1 - 19:14
    • Build Comments Component - Part 2 - 13:50
    • Build And Test Functionality - 12:12
  • Application Code
    • Resources

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.