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.
Course start: 20 September 2018 Course end: 24 June 2018 Course type: online
- RESOURCES
- COURSE INTRODUCTION
- DATABASES INTRODUCTION
- DATA DEFINITION AND DATATYPES
- EXERCISE:DATA DEFINITION AND DATATYPES
- BASIC CRUD
- EXERCISE: BASIC CRUD
- BUILT-IN FUNCTIONS
- EXERCISE: BUILT-IN FUNCTIONS
- DATA AGGREGATION
- EXERCISE: DATA AGGREGATION
- TABLE RELATIONS
- EXERCISE: TABLE RELATIONS
- SUBQUERIES AND JOINS
- EXERCISE: SUBQUERIES AND JOINS
- FUNCTIONS AND PROCEDURES
- EXERCISE: FUNCTIONS, TRIGGERS AND PROCEDURES
- TRIGGERS AND TRANSACTIONS
- EXERCISE: TRIGGERS AND TRANSACTIONS