Skip to content

Latest commit

 

History

History
163 lines (119 loc) · 7.76 KB

README.md

File metadata and controls

163 lines (119 loc) · 7.76 KB
Raw

MS SQL

 

Databases are the standard way of using dynamic information in modern technology, making them an indispensable part of almost every application. The intensive database fundamentals course 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 focuses heavily on 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). Provides fundamental knowledge of working with ACID transactions and transaction processing, and practical tips for performance tuning. This course lays the foundations of working with databases, making it easier to use them in real-world applications and to understand concepts such as converting a database into an object-oriented model (ORM).

 

Topics:

  • CRUD operations
  • Table Relations
  • Built-in Functions
  • Subqueries and Joins
  • Indices and Data Aggregation
  • Functions and Stored Procedures
  • Triggers and Transactions

Acquired skills:

  • Using procedures and functions
  • Fundamental knowledge of databases
  • Transaction management
  • Handling and storing data
  • Creation of basic Back-End architectures
  • Using the ACID model

  Certificate(Click here to preview)  

SoftUni Judge Solved Tasks

 

Database Introduction

Exercises
1 Minions and Towns
2 Create Table People
3 Create Table Users
4 Movies Database
5 Car Rental Database
6 Hotel Database
7 Basic Select All Fields
8 Basic Select All Fields And Order Them
9 Basic Select Some Fields
10 Increase Employees Salary
11 Decreate Tax Rate
12 Delete All Records

 

CRUD (Create, Read, Update, Delete)

Exercises
1 Part I - Queries for SoftUni Database
2 Part II - Queries for Geography Database
3 Part III - Queries for Diablo Database

 

Table Relations

Exercises
1 Part I - Create Table Relations
2 Part II - Design Structures
3 Part III - Peaks in Rila

 

Built-In Functions

Exercises
1 Part I - Queries for SoftUni DB
2 Part II - Queries for Geography DB
3 Part III - Queries for Diablo DB
3 Part IV - Queries for Orders DB

 

Subqueroes and Joins

Exercises
1 Part I - Queries for SoftUni DB
2 Part II - Queries for Geography DB

 

Indices and Data Aggretion

Exercises
1 Part I - Queries for Gringotts DB
2 Part II - Queries for SoftUni DB

 

Functions and Stored Procedures

Exercises
1 Part I - Queries for SoftUni DB
2 Part II - Queries for Bank DB
3 Part III - Queries for Diablo DB

 

Triggers and Transactions

Exercises
1 Part I - Queries for Bank DB
2 Part II - Queries for SoftUni DB

Back to top