Course description

Database Fundamentals + Practical training

Databases are used in applications and devices that store and retrieve information that is submitted and stored in the database by the end user. Applications such as Facebook, Twitter and Instagram store, record and retrieve data from them submitted by end users. They all have the ability to do so, thanks to database applications that store, organize and deliver information to end customers.

Practical part

The practical module will consolidate the accumulated knowledge through tasks set by the lecturer on a real project, and a real work environment will be recreated. The goal is for the students to get as close as possible to the work commitments of a specialist.

More
information

For the exercises and the practical part during the classes each student must carry a personal laptop. The course is taught in Bulgarian, but it is good for students to have a good level of English.

SearchIT course details icon logo

Training program

  • Module 1
  • Module 2
SearchIT Database Fundamentals course

Module 1: Theory

This course will teach you the basics of some basic database concepts. We will learn what RDBMS is, how to store data, what are the benefits of RDBMS and how to use the basic SELECT command to retrieve data from our database, how to combine multiple sets of results, from different tables based on JOINS, how to group data on specific result criteria using the GROUP BY and AGGREGATE functions. The course will also cover concepts such as CONSTRAINTS and WILD CHARACTERS, which we can use to define / limit the results of our queries and other day-to-day activities used in the corporate environment.

SearchIT logo icon

Lessons

  • Lesson 1 Introduction - Basic concepts

    • What is a relational database - why do we need it and how to establish connections in it
    • How data is stored in tables
    • What is the table and how it relates to the data that is stored (columns / fields, rows / records
    • is T-SQL and how it is used to create objects
    • Data Manipulation Language (DML)

  • Lesson 2 Tables and data types - how they are created

    • Purpose of the tables
    • Creating tables in a database
    • Data types, why they are important and how they affect

  • Lesson 3 Data selection – queries

    • Requests to extract data from a table
    • for data extraction using UNION
    • Combining sets of results using UNION

  • Lesson 4 VIEW

    • What VIEW is and why it is used
    • Създаване на VIEW (Creation of VIEW
    • When VIEW is used
    • How to create VIEW using T-SQL or graphic design

  • Lesson 5 Stored procedures

    • What is Stored procedure
    • Creating a Stored procedure
    • Selecting, inserting, updating or deleting data

  • Lesson 6 Constraint

    • What is Constraint?
    • Types and uses of Constraints
    • Primary, Foreign, Composite keys

  • Lesson 7 SUBQUERIES и JOINS

    • Use of SUBQUERIES
    • Nested subqueries
    • When to use JOINS and when SUBQUERIES

  • Lesson 8 BUILT-IN FUNCTIONS

    • Using BUILT-IN FUNCTIONS
    • Creating BUILT-IN FUNCTIONS

  • Lesson 9 Indexes

    • What is an Index
    • Types of Indexes and use of different types

  • Lesson 10 Normalization

    • What is normalization
    • Reasons for normalization
    • Types of normalization and conditions it must meet

  • Lesson 11 Security

    • Database administration
    • Database security concepts
    • Database protection, what objects can be protected, what objects need to be protected, user accounts and roles
    • Archiving

  • Lesson 12 Exam
  • Lesson 13 Preparing for an interview. Preparation of CV.

    • How to prepare a good CV
    • How to prepare for an interview
    • Frequently asked questions during an interview
    • Useful tips in the process of job search

SearchIT Database Fundamentals + Practical image

Module 2: Practical
project

The purpose of this module is to bring students as close as possible to the work processes in the daily life of a Junior Database specialist. The module is held on four consecutive weekends and lasts 1 month.

An error has occurred. This application may no longer respond until reloaded. Reload 🗙