TR

Database Fundamentals and SQL Course

Course Audience

PG101
1 DAY

Programmers, system administrators, and IT professionals who want to acquire knowledge in the field of Relational Databases.

Course Prerequsities

Informations that required by participants before course:

  • Basic Computer Literacy

Course Goals

  • Understanding the model by examining any relational database
  • Designing a relational database
  • Retrieving, inserting, and updating data from one or more tables in a database service using the SQL language
  • Using basic SQL queries specific to PostgreSQL

Course Subjects

  • Relational Model
  • Data and Data Types
  • Table and Column Creation
  • Data Modification
  • Retrieving Data from a Single Table (SELECT)
  • Join Concept
  • Subqueries
  • AVG, MIN, MAX, COUNT, SUM
  • PostgreSQL Functions