Fundamentals

Database Basics (CK105)


Description
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database.
Content
  • Section 1
  • Mysql Installation
  • Installation
  • Section 2
  • Introduction to Database
  • Database Introduction
  • Introduction to Database
  • assessment1
  • Section 3
  • DDL Commands
  • DDL Command part1
  • DDL Command part2
  • assessment2
  • Section 4
  • DDL Commands Cont_s
  • DDL Commands part3
  • assessment3
  • Section 5
  • DML Commands
  • DML Commands
  • assessment4
  • Section 6
  • TCl Command
  • TCl Commands
  • assessment5
  • Section 7
  • Aggregate Functions and Special Operators
  • Aggregate Functions and Special Operators
  • assessment6
  • Section 8
  • SQL JOIN
  • SQL JOIN
  • SQL Index and View
  • SQL Index and View
  • assessment7
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: 1 year
Prerequisites