Packt
Master C# and SQL by Building Applications

Give your career the gift of Coursera Plus with $160 off, billed annually. Save today.

Packt

Master C# and SQL by Building Applications

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

7 hours to complete
3 weeks at 2 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

7 hours to complete
3 weeks at 2 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Create and manage databases using SQL Server

  • Develop complete C# applications integrated with SQL databases

  • Apply SQL commands, views, stored procedures, and database connections

  • Analyze and implement advanced features like Dapper and JSON handling

Details to know

Earn a career certificate

Add to your LinkedIn profile

Recently updated!

October 2024

Assessments

3 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 6 modules in this course

In this module, we will introduce you to the course, outlining its objectives and providing an overview of what you can expect to learn. This foundational introduction will set the stage for your journey through the material.

What's included

1 video1 reading

In this module, we will guide you through the essential setup process, including downloading and installing the necessary software tools. By the end of this section, you'll have your development environment ready and be informed about recent updates relevant to the course.

What's included

4 videos

In this module, we will dive into the development of a Customer Order Viewer application. You'll start by understanding customer requirements and progress through creating and managing database objects, building the application's data access components, and finally integrating and testing the complete solution. This hands-on module is designed to solidify your skills in working with SQL Server and C#.

What's included

14 videos1 assignment

In this module, we will expand the Customer Order Viewer to version 2.0, focusing on advanced database modifications, including altering tables and implementing UDDTs and SPROCs. You'll also learn to use Dapper for efficient data access and integrate these enhancements into the application before thoroughly testing the final product.

What's included

10 videos

In this module, we will build a Course Report Emailer application from the ground up. You'll begin by creating the foundational database and progress to implementing advanced features such as JSON handling, document generation with Open XML SDK, and automated email distribution. The module culminates in the integration and testing of all components to ensure a fully functional application.

What's included

14 videos

In this module, we will develop the Course Manager application, focusing on advanced UI design with WPF and XAML, and the MVVM pattern. You'll learn to alter necessary database tables, create SPROCs, and build and enhance ViewModels and Views, culminating in a comprehensive application that meets customer specifications. The module concludes with the integration and thorough testing of all components.

What's included

12 videos2 assignments

Instructor

Packt - Course Instructors
Packt
372 Courses10,422 learners

Offered by

Packt

Recommended if you're interested in Software Development

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Software Development? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions