Databases Basics – MS SQL Server – September 2017

Spread the love

Databases Basics - MS SQL Server - September 2017

14 september 2017

duration 6 weeks

give 9 credits

ABOUT COURSE

Databases are the standard way to use dynamic information in modern applications, making them an integral part of almost every application.
Intensive course basics of 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, selection, projection, joining, aggregation, grouping, modification, deletion and insertion). 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.
The course is part of the overall program with C # courses and tutorials for the “C # programmer” training at the University of Software.

SKILLS, WHO YOU RECEIVED

Fundamental knowledge of databases

Relationship Management in DB

Create Basic Back-End Architectures

Transaction management and understanding of the ACID model

ABOUT COURSE

RESOURCES

COURSE INTRODUCTION

DATABASES INTRODUCTION

DATA DEFINITION AND DATATYPES

EXERCISE:DATA DEFINITION & DATATYPES

BASIC CRUD

EXERCISE:BASIC CRUD

BUILT-IN-FUNCTIONS

EXERCISE:BUILT-IN FUNCTIONS

DATA AGGREGATION

EXERCISE: DATA AGGREGATION

TABLE RELATIONS

EXERCISE: TABLE RELATIONS

SUBQUERIES & JOINS

EXERCISE: SUBQUERIES & JOINS

FUNCTIONS,TRIGGERS & PROCEDURES

EXERCISE: SUBQUERIES & JOINS

FUNCTIONS,TRIGGERS & PROCEDURES

EXERCISE: FUNCTIONS,TRIGGERS & PROCEDURES

TRANSACTIONS

EXERCISE: TRANSACTIONS

EXAM PREPARATION

EXERCISE: TRANSACTIONS

EXAM PREPARATION |

EXAM PREPARATION ||

PRACTICAL EXAM

TEACHERS

people-avatar
Vladimir Stoinov

Vladi is engaged in 8th grade programming. Graduate of Mechanical Engineering “Nikola Y. Vaptsarov” in Vratsa with excellent diploma and profession “Computer Technician 3rd Grade”. Has experience with C #, Java, JavaScript, PHP and the most diverse web technologies that surround these languages. He started his studies at the Software Foundations in 2015, and after about a year he became a trainee there and managed to further develop his lecturing skills. In his spare time, he likes to develop software projects and electronic music. In her experience as a lecturer she lurks her passion for programming to give her students the best possible training they can.

people-avatar
Dimitar Valentinov

Dimitar has an interest in programming from early years. He enrolled in Automation and graduated with a silver medal. During his training his passion for programming fuses and turns into a leading direction. He has over 2 years of experience as a software developer. With top results at Software Foundations, he has been chosen as a lecturer for teaching.

people-avatar
Bojidar Tenchev

Bojidar from early years has a strong interest in technology and programming, but in high school he spends all his free time on professional sports. In 2016 his passion was again fired and he began his studies as a student at the  of Software Foundations. Thanks to top results and strong desire, he is elected lecturer. His interests include smart technology, artificial intelligence and gaming.