This course is designed to immerse you in the world of C# and SQL, guiding you step by step through the process of creating robust applications. You will start by setting up your development environment with tools like Visual Studio 2022 and SQL Server 2019. From there, you'll delve into the core concepts of SQL Server database objects, mastering the creation of tables, views, and stored procedures while learning to manage data effectively.
Give your career the gift of Coursera Plus with $160 off, billed annually. Save today.
Recommended experience
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
Skills you'll gain
Details to know
Add to your LinkedIn profile
October 2024
3 assignments
See how employees at top companies are mastering in-demand skills
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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
Offered by
Recommended if you're interested in Software Development
Xi'an Jiaotong University
Google Cloud
Why people choose Coursera for their career
New to Software Development? Start here.
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
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.