К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Master C# and SQL by Building Applications · LearnSpace
Назад в каталог
courseraПрограммирование

Master C# and SQL by Building Applications

Курс от Packt
Средний≈ 9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Updated in May 2025. This course now features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. 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. As you progress, you'll apply your knowledge by developing a Customer Order Viewer application. This involves hands-on experience with SQL commands, application modeling, and understanding the intricacies of database connections using SqlConnection, SqlCommand, and SqlDataReader. The course also introduces you to advanced features like Dapper, JSON handling, and the Open XML SDK, enhancing your application’s functionality and user experience. By the end of the course, you'll have built multiple applications, each progressively more complex, solidifying your understanding of C# and SQL. You'll gain the confidence to create, test, and deploy professional-grade applications, making this course an invaluable resource for anyone aspiring to excel in software development and database management. This course is ideal for aspiring software developers, database administrators, and IT professionals looking to deepen their understanding of C# and SQL. A basic familiarity with programming concepts is recommended but not required.

Навыки, которые вы освоите

Application DevelopmentC# (Programming Language)UI ComponentsUser Interface (UI) DesignStored ProcedureDatabase DevelopmentMicrosoft SQL ServersDatabase ManagementIntegration TestingSQLDatabase ApplicationMicrosoft Visual StudioUser Interface (UI)Development TestingApplication DesignMicrosoft Development ToolsSoftware DesignData StoreObject-Relational MappingDevelopment Environment

Программа курса

6 модулей · 64 учебных материалов

01Welcome2 материалов

Welcome

Introduction to the CourseВидеоFull Course Resources Чтение
02Setup5 материалов

Setup

Downloading and Installing the Visual Studio 2022 CommunityВидео

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Master C# and SQL by Building Applications
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 9 ч

6 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Индонезийский, Испанский, Японский, Казахский

Часть программы вашего университета
Downloading and Installing the SQL Server 2019Видео
Downloading and Installing SSMS 18Видео
Few Words about the Recent UpdatesВидео
Installing Visual Studio and SQL ServerDIALOGUE
03Customer Order Viewer16 материалов

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ВидеоBuilding a Simple Console Application in C# with SQL Server IntegrationDIALOGUEAssessment 1Задание
04Customer Order Viewer 2.011 материалов

Customer Order Viewer 2.0

Customer RequirementsВидеоSQL AlterВидеоAltering a TableВидеоSQL UDDT and SPROCsВидеоCreating the Application UDDT and SPROCsВидеоCreating More SPROCsВидеоWhat Is Dapper?ВидеоCreating the Application ModelsВидеоCreating the Application CommandsВидеоPutting Everything Together and TestingВидеоEnhancing a Console Application for Customer Order ManagementDIALOGUE
05Course Report Emailer15 материалов

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ВидеоExcel Automation and Emailing with Open XML in C#DIALOGUE
06Course Manager15 материалов

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ВидеоAssessment 2ЗаданиеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание