Databases

• Theory

  • Basic concepts
    • General information about databases. History of the development of Database Management Systems (DBMS)
    • Functions of Database Management Systems (DBMS)
    • The concept of a database system. Database schema. Data. Hardware and software. Database users
    • Single user and multi user systems. The concept of centralized data management
    • Persistent data. Transient data
    • Data independence. Basic concepts. Structures for storing mutable data
    • The Entity-Relationship model (ER-model)
      • The concept of ER-model. The concept of entity. Attributes. Attribute type
      • Entity subtypes. Supertype. Example. Advantages and disadvantages of using subtypes of entities
      • ER-model. The concept of relationship. The relationship capacity. Types of relationships. Examples
      • Strong and weak relations between entity types. Unary relations. Recursive relation
    • Relational data model
      • Basic concepts of the relational data model
      • Relational databases. The concept of a key. Types of keys. Relations. Master table and detail table
    • Normalization
      • Normalization. Concept and necessity of using. Modification anomalies. Examples
      • First normal form (1NF). Converting the table to first normal form. Examples
      • Functional dependencies. Building functional dependency diagram. Example
      • Second normal form (2NF)
  • Structured Query Language (SQL). Transact-SQL (T-SQL)
    • Creating tables. Statement CREATE TABLE. Examples
    • Table modification. The ALTER TABLE statement
    • Removing tables. The DROP TABLE statement
    • Data types
      • Numeric data types. Review. Examples

• Practice

  • Working with the Microsoft SQL Server database server in Microsoft Visual Studio
    • 001 – An Example of creating the local Microsoft SQL Server (SQLEXPRESS) database in Microsoft Visual Studio.
  • The databases of Microsoft SQL Server, which are located in the “*.mdf” files
    • 001 – An example of creating/connecting local Microsoft SQL Server database located in the “*.mdf” file
    • 002 – An example of creating a table in the local Microsoft SQL Server database located in the “*.mdf” file
    • 003 – Creating an autoincrement field (counter) in the MS SQL Server database table, which is located in the “*.mdf” file
    • 004 – Creating a “one-to-many” relationship between tables in Microsoft SQL Server database
    • 005 – An example of creating the “*.mdf” file of local database Microsoft SQL Server in MS Visual Studio
    • 006 – The “Connection String” string of connection with database. An example of using in applications
    • 007 – An example of creating a query in the database
    • 008 – An example of creating a view in a database. Creating a calculated field
  • The Microsoft Access databases
    • Creating a database in Microsoft Access 2016. Creating a table with calculation field
  • Microsoft SQL Server Management Studio 2018
    • Microsoft SQL Server Management Studio 18. Example of creating a simple query