Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Master C# and SQL by Building Applications
Master C# and SQL by Building Applications

Master C# and SQL by Building Applications: Become a better software developer by learning how to build real world applications using C# and SQL

Arrow left icon
Profile Icon Programming Resources
Arrow right icon
€82.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (2 Ratings)
Video Oct 2022 6hrs 4mins 1st Edition
Video
€82.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Programming Resources
Arrow right icon
€82.99
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (2 Ratings)
Video Oct 2022 6hrs 4mins 1st Edition
Video
€82.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€82.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Delve into the advanced concepts of SQL and C#
  • Identify the best situation to use SQL views, SQL stored procedures, and SQL user-defined data type
  • Enable smooth communication between C# code and SQL server

Description

C# is the backbone of many popular video games, web, mobile, and desktop applications. And without SQL, the creation and management of the database will be handicapped. Imagine what can be achieved in the world of technology if both C# and SQL are merged! This video course will teach you how to bring C# and SQL together to build robust, powerful, real-world applications. The course begins with an overview of the course objectives and explains the process of installing Visual Studio 2019, SQL Server 2019, and SSMS 18. Next, you will create a customer order viewer application in C# to understand the SQL commands, tables, database, and server in detail. Moving ahead, you will use SQL Alter, user-defined data types, stored procedures, and Dapper, to enhance the application that you created. You will also test the application to ensure that it is working smoothly as per the requirement. Toward the end, you will create a course report emailer application in C# to email worksheets with SQL data and build WPF forms and use Dapper to make the communication between C# code and SQL server seamless. By the end of this course, you will have developed essential C# and SQL skills needed to build real world applications. All the code and supporting files for this course are available on GitHub at: https://github.com/PacktPublishing/Master-C-Sharp-And-SQL-By-Building-Applications

Who is this book for?

If you are a software developer who is looking to use C# and SQL together to build powerful applications, then this video course is for you. To get started with this course, it is recommended to have a basic understanding of C# and SQL server.

What you will learn

  • Build a full-stack application with C# and SQL
  • Use Dapper in .NET to make SQL database access even easier
  • Create forms using WPF and XAML
  • Create and manipulate Excel workbooks through Open XML and C#
  • Send emails programmatically using SmtpClient in C#
  • Find out how to use the SQL Merge statement

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Last updated date : Oct 31, 2022
Publication date : Oct 19, 2020
Length: 6hrs 4mins
Edition : 1st
Language : English
ISBN-13 : 9781800560093
Vendor :
Microsoft
Languages :
Tools :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Last updated date : Oct 31, 2022
Publication date : Oct 19, 2020
Length: 6hrs 4mins
Edition : 1st
Language : English
ISBN-13 : 9781800560093
Vendor :
Microsoft
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total €139.96 €164.97 €25.01 saved
Clean Code in C#
€38.99
C# 9 and .NET 5 – Modern Cross-Platform Development
€62.99
Master C# and SQL by Building Applications
€82.99
Total €139.96€164.97 €25.01 saved Stars icon
Banner background image

Table of Contents

6 Chapters
Welcome Chevron down icon Chevron up icon
Setup Chevron down icon Chevron up icon
Customer Order Viewer Chevron down icon Chevron up icon
Customer Order Viewer 2.0 Chevron down icon Chevron up icon
Course Report Emailer Chevron down icon Chevron up icon
Course Manager Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(2 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Michael May 09, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Really good walk through how to use SQL in combination with C#
Subscriber review Packt
Iosif May 19, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Very useful and practical. I highly recommend this course as you will learn very good and practical techniques.
Subscriber review Packt
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail [email protected] with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.