Training: Databases – Concepts & Modeling

Databases are the core of an application. All information is stored permanently here. To avoid unnecessary slowdowns during runtime, it is necessary to give sufficient thought to the design of data structures. The maintainability and extensibility of software projects are also significantly improved with a clear database design. We will also discuss security aspects in detail and how to protect against SQL injections.

The topic of NoSQL is also covered extensively in this course. In addition to the various application areas of non-relational database systems, examples of how the individual technologies can be applied in projects are also presented.

The seminar ‘Databases – Concepts & Modeling‘ is aimed at programmers, database administrators, and software architects. Experienced developers can easily skip the introduction module. The course content can vary from 2 to 5 days and can be tailored to specific needs through a free preliminary consultation.

The course is conducted entirely virtually/remotely and can also be booked individually for closed groups or individuals. If you’re interested in the course content, schedule a free consultation today. Each attendee receives a login with access to all paid articles for 12 months.

Content:

  • Introduction
    • What is a database management system (DBMS)?
    • Database Servers: Commercial vs. Freely Available
    • Database Drivers: ODBC & JDBC
    • Database Clients for Web and Desktop
  • Introduction to the Relational Database Model
    • Relationships
    • Normalization
    • Data: Tables, Rows, Columns, Schemas
    • Primary, Foreign, and Composite Keys
    • Referential Integrity and Data Consistency
  • SQL Basics
    • Data Queries
    • Data Manipulation
    • Data Definition
    • Data Access Permissions
  • Security Concepts
    • Server Administration
    • Passwords: Salt ‘n Pepper
    • SQL Injections
  • Database Design
    • O/R Mapper (Hibernate)
    • Domain-Driven Development
    • Data Access Object
  • Advanced Techniques
    • Pagination
    • Transactions
    • Performance: Index
  • DevOps & Cloud
    • Distributed Databases
    • Monitoring
    • Versioning
  • NoSQL
    • In Memory: Redis
    • Graphs: Neo4J
    • Documents: MongoDB
  • Big Data & AI
    • Overview of Artificial Intelligence
    • Classification
    • Vectorization
    • Stemming Algorithms
    • Lemmatization