image

Nigeria Since27 May, 2024
Click to expand
image
Posted By esther
5 months ago
Data types in SQL

The structured query language comprises of several different data types that allow it to store different types of information in a database, the data type chosen for a table column is based on requirements. Numeric data types: FLOAT, INT, BOOLEANCharacter and string type: CHAR, VARCHARDate & Time: DATETIME, DATE, TIME, TIMESTAMP

  • 0
  • 0
image
Posted By esther
5 months ago
Fact and dimension tables

Fact table contains numerical data, it is a numeric attribute of a fact, it contains measures that can be summed up to analyze or to carry out some process and they are primarily joined to dimension table through foreign keys. The fact table contains the description of the primary key of all tables and it is in normalized form Dimension table have qualitative data, they provide context an...

  • 0
  • 0
image
Posted By esther
5 months ago
mySQL

A database in SQL is made up of a collection of tables that stores a specific set of structured data which are organized in such a way that it can be easily accessed, managed and retrievedDatabase consist of different elements which includes tables, fields, rows and columns. Each columns in the table is designed to store a certain type of information e.g names, dates, numbers

  • 0
  • 0
image
Posted By esther
5 months ago
MySQL

SQL (structured query language) is a database computer language designed for managing data in relational database management system, SQL can execute, create, retrieve, insert, update, delete, create(new database, new tables, stored procedures) in a database. We have different query types: INSERT, SELECT, UPDATE and DELETE

  • 0
  • 0