Databases Basics - MS SQL Server - april 2018
03 april 2018
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
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.
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.
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.