Skip to content

SanRob1325/Databases-Basics---MS-SQL-Server---2017

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

50 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

*

Databases-Basics---MS-SQL-Server---2017

SoftUni logo


                                             About the course

Databases are the standard way to use dynamic information in modern applications, making them an integral part of almost every application. Databases 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 on relational modeling, data modeling with ER charts (tables and relational links) and SQL language handling (data mining, selecting, projecting, joining, aggregating, grouping, modificating, deleting and inserting). Fundamental knowledge about ACID transactions and transaction processing and practical tips for adjusting productivity are provided. This course sets the basics of working with databases, making it easier to use them in real-world applications, and understanding concepts such as database transformation into object-oriented (ORM) modeling.

This is the system in which I'm submiting and testing the exercises - https://judge.softuni.bg/

Exercises.

  1. EXERCISE: DATA DEFINITION AND DATATYPES
  2. EXERCISE: BASIC CRUD
  3. EXERCISE: BUILT-IN FUNCTIONS
  4. EXERCISE: DATA AGGREGATION
  5. EXERCISE: TABLE RELATIONS
  6. EXERCISE: SUBQUERIES AND JOINS
  7. EXERCISE: FUNCTIONS, TRIGGERS, PROCEDURES AND TRANSACTIONS
  8. EXERCISE: EXAM PREPARATION
  9. EXERCISE: PRACTICAL EXAM

About

My education in SoftUni

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • SQLPL 81.9%
  • PLpgSQL 12.9%
  • PLSQL 5.2%