TR

Database Fundamentals and SQL Course

Course Audience

MY101
1 DAY

Developers, system administrators, and IT professionals who want to acquire knowledge in Relational Database Concepts.

Course Prerequsities

Informations that required by participants before course:

  • Basic computer literacy

Course Goals

  • Being able to understand the model by examining any relational database,
  • Designing a relational database,
  • Using the SQL language to retrieve, insert, and modify data from one or more tables in a database service.

Course Subjects

  • Relational Model
  • Data and Data Types
  • Creating Tables and Columns
  • Data Modification
  • Retrieving Data from a Single Table (SELECT)
  • Concept of Join
  • Subqueries
  • AVG, MIN, MAX, COUNT, SUM