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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Design and Implement SQL Server Tracking Systems · LearnSpace
Назад в каталог
courseraIT и технологии

Design and Implement SQL Server Tracking Systems

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

О курсе

Learners will gain the ability to design, implement, and manage a complete samples tracking system using VB.NET and SQL Server, including database design, transaction processing, reporting, stored procedures, and operational workflows. This course provides hands-on, case-study–driven learning focused on building a real-world Samples Tracking System from the ground up. Learners explore how to design SQL Server tables, create core database functions, configure entities and menus, and manage products, transactions, and running balances. As the course progresses, learners work with entity relationships, sample transfers, transaction reporting, and advanced SQL logic using stored procedures. A key benefit of this course is its end-to-end system perspective: learners do not study isolated SQL or VB.NET concepts, but instead see how frontend forms, backend logic, and database operations work together in a production-style application. Advanced topics such as stored procedure optimization, manufacturing workflows, and transfer execution prepare learners for real industry scenarios involving inventory and process tracking. This course is unique in its practical focus on system architecture, backend troubleshooting, and operational accuracy, making it ideal for learners seeking applied SQL Server and VB.NET experience through a complete, integrated case study.

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

Microsoft SQL ServersTransaction ProcessingData ManagementDebuggingDatabase DevelopmentData IntegrityDatabase ManagementStored ProcedureDatabase DesignSQLVisual Basic (Programming Language)Database Architecture and AdministrationProcess Driven DevelopmentOperational DatabasesRelational DatabasesUser Interface (UI)Transact-SQL

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

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

01Foundations of the Samples Tracking System12 материалов

System Overview and Database Design

Samples Tracking System OverviewВидеоDatabase Table DesignВидеоSystem Overview and Database DesignЗадание

Core Database Logic and Configuration

Core Database FunctionsВидео

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

EDUCBA

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

Design and Implement SQL Server Tracking Systems
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7.8 ч

3 модулей

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

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

Часть программы вашего университета
Menu and Entity ConfigurationВидео
Core Database Logic and ConfigurationЗадание

Product and Transaction Basics

Product and Transaction ManagementВидеоRunning Balance ReportingВидеоProduct and Transaction BasicsЗаданиеDesigning Tables and Menus for a Samples Tracking SystemDIALOGUEFoundations of the Samples Tracking SystemЗаданиеBuilding the Core Foundation of a Samples Tracking SystemDIALOGUE
02Entity Architecture and Transaction Processing12 материалов

Sample Transfer and Entity Architecture

Sample Transfer WorkflowВидеоEntity Architecture BasicsВидеоSample Transfer and Entity ArchitectureЗадание

Entity Relationships and Master Data

Entity Relationships and LogicВидеоAdvanced Entity ImplementationВидеоProduct Master SetupВидеоEntity Relationships and Master DataЗадание

Data Initialization and Reporting

Initial Data PopulationВидеоTransaction ReportingВидеоAdvanced Transaction ReportingВидеоData Initialization and ReportingЗаданиеSample Transfer and Entity ArchitectureЗадание
03Advanced SQL Processing and Manufacturing Workflows13 материалов

Running Balance and Stored Procedures

Running Balance Calculation FunctionВидеоStored Procedure FundamentalsВидеоRunning Balance and Stored ProceduresЗадание

Advanced Stored Procedure Design

Advanced Stored ProceduresВидеоStored Procedure OptimizationВидеоAdvanced Stored Procedure DesignЗадание

Manufacturing and Transfer Operations

Manufacturing Process OverviewВидеоManufacturing Process ExecutionВидеоTransfer Process DesignВидеоTransfer Process ExecutionВидеоManufacturing and Transfer OperationsЗаданиеAdvanced SQL Processing and Manufacturing WorkflowsЗадание
Stabilizing a Pharma Samples Tracking System in VB.NET and SQL ServerDIALOGUE