Course

MS SQL - Coming Soon

12 credits

Fundamentals

Databases are the standard way to use dynamic information in modern technologies, making them an integral part of almost every application. The intensive course on database fundamentals will introduce you to one of the most widely used database management systems (DBMS) used in the development of modern information systems - Microsoft SQL Server. The course pays serious attention to the relational model, data modeling with ER diagrams (tables and relational relationships) and working with the SQL language (data extraction, selection, projection, joins, aggregation, grouping, modification, deletion and insertion). Fundamental knowledge of working with ACID transactions and transactional processing is provided, and practical tips for tuning performance. This course lays the foundations for working with databases, making it easier to use them in real-world applications and understanding concepts such as turning a database into an object-oriented model (ORM).

Skills which you will acquire

Working with databases
Managing transactions
Using procedures and functions
Manipulating and storing data
Creating Basic Back-End Architectures
Using the ACID model

Topics

Resources
Resources

No description yet

Resources

There are no resources for this lecture yet
Databases Introduction
Databases Introduction

• Data Management
• Database Engines
• Data Types
• Database Modeling with SSMS
• Basic SQL Queries.

Resources

There are no resources for this lecture yet
Exercise: Databases Introduction
Exercise: Databases Introduction

No description yet

Resources

There are no resources for this lecture yet
CRUD
CRUD

• Query Basics
• Retrieving Data
• Writing Data
• Modifying Existing Records.

Resources

There are no resources for this lecture yet
Exercise: CRUD
Exercise: CRUD

No description yet

Resources

There are no resources for this lecture yet
Table Relations
Table Relations

• Database Design
• Table Relations
• Cascade Operations
• E/R Diagrams

Resources

There are no resources for this lecture yet
Exercise: Table Relations
Exercise: Table Relations

No description yet

Resources

There are no resources for this lecture yet
Built-in Functions
Built-in Functions

• Function Overview
• String Functions
• Math Functions
• Date Functions
• Other Useful Functions
• Wildcards.

Resources

There are no resources for this lecture yet
Exercise: Built-in Functions
Exercise: Built-in Functions

No description yet

Resources

There are no resources for this lecture yet
Subqueries and Joins
Subqueries and Joins

• Joins
• Subqueries
• Common Table Expressions.

Resources

There are no resources for this lecture yet
Exercise: Subqueries and Joins
Exercise: Subqueries and Joins

No description yet

Resources

There are no resources for this lecture yet
Indices and Data Aggregation
Indices and Data Aggregation

• Indices
• Gruouping
• Aggregate Functions
• Having Clause
• Pivot Tables.

Resources

There are no resources for this lecture yet
Exercise: Indices and Data Aggregation
Exercise: Indices and Data Aggregation

No description yet

Resources

There are no resources for this lecture yet
Functions and Stored Procedures
Functions and Stored Procedures

• Functions
• Stored Procedures;
• Stored Procedures with Parameters
• Error Handling.

Resources

There are no resources for this lecture yet
Exercise: Functions and Procedures
Exercise: Functions and Procedures

No description yet

Resources

There are no resources for this lecture yet
Triggers and Transactions
Triggers and Transactions

• Transactions
• ACID Model
• Triggers.

Resources

There are no resources for this lecture yet
Exam Preparation
Exam Preparation

No description yet

Resources

There are no resources for this lecture yet
Exam Preparation
Exam Preparation

No description yet

Resources

There are no resources for this lecture yet
Regular Exam
Regular Exam

No description yet

Resources

There are no resources for this lecture yet
Retake Exam
Retake Exam

No description yet

Resources

There are no resources for this lecture yet

See all topics

Who is the target audience for the course?

The course is suitable for everyone who knows how to work with linear data structures, as well as classes and objects and knowledge of the principles of object-oriented programming in the C# language. The required level of English required for the course must meet B2.

How to enroll in the course?

To sign up for the course, click the INFORM ME button and provide your name and email. You will be notified via email when the course is open for enrollment.

What is the deadline for enrolling in the course and when does it start?

Enrollment in the course will be open in 2026. The training will start in 2026. You will find a detailed schedule of classes in the Topics section when the enrollment is open.

How and where are the classes be held?

You can study online in real time. Immediately after each lesson, you also get access to the lesson recording and learning resources.

What is the date of the exam and what does it include?

The exam will be held online and includes practical exercises. The dates of the exam will be published in 2026.

Do I get a certificate after the exam?

After passing the exam, you acquire a certificate issued by SoftUni if your score is above 70%.