Master C# and SQL by Building Applications [Video]
Video
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterWelcome
-
Setup
-
Customer Order Viewer
- Customer Requirements
- SQL Server Database Objects
- Creating an Application Database and Tables
- Giving Values to Tables
- Quick Side Note
- SQL Views
- Creating an Application View
- Exploring the Server Explorer
- What Is SqlConnection?
- What Is SqlCommand?
- What Is SqlDataReader?
- Creating the Application Models
- Creating the Application Commands
- Putting Everything Together and Testing
-
Customer Order Viewer 2.0
-
Course Report Emailer
- Customer Requirements
- Creating an Application Database and Tables
- Giving Values to Tables
- Creating an Application View
- Creating the Application SPROC
- Creating the Application Models
- Creating the Application Commands
- What Is JSON?
- What Is DataTable?
- What Is Open XML SDK?
- Creating the Worksheet Creator - Part I
- Creating the Worksheet Creator - Part II
- Creating the Emailer
- Putting Everything Together and Testing
-
Course Manager
- Customer Requirements
- Altering the Needed Table
- Creating the Application SPROCs
- What Is WPF and XAML?
- What Is MVVM?
- Cleanup and Creating the Start-up
- Creating the Application Models
- Creating the Application Commands
- Using Mockup to Create View
- Enhancing the ViewModel - Part I
- Enhancing the ViewModel - Part II
- Putting Everything Together and Testing
About this
video
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
- Publication date:
- October 2020
- Publisher
- Packt
- Duration
- 6 hours 4 minutes
- ISBN
- 9781800560093