AI 900 PREP : Understanding essential AI concepts
What is AI? Artificial Intelligence is the name of one of my most favourite movies, and it left a lasting impression on me. I remember feeling deeply moved by the…
AI-900 PREP: Cloud Computing Fundamentals
This article is a combination of my personal takeaways from Microsoft seminars, study notes and research, which help you revise for MS certification exams
DATABASE DESIGN: Evaluate the quality of the design? [Part 2]
So far, we have discussed the top-down approach, which focuses on decomposing raw information of different forms into attributes on data tables and setting criteria that we believe constitute a…
DATABASE DESIGN: Evaluate the quality of the design? [Part 1]
Database design typically involves three main levels: conceptual, logical and physical. At the end of the conceptual stage, an Entity-Relationship Diagram (ERD) can be created, illustrating all identified entities along…
DATABASE DESIGN: what are database constraints ?
Abilities to define and enforce database constraints is one of the advantages that a Database management system provides, along with ability to control redundancy, restrict unauthorized access and persistently store,…
DATA MODELING: How to build Entity-Relationship Diagram?
Data modeling is a critical step of database design. It involves translating business requirements about data into a technical blueprint. Data modeling is applied to build new databases or to…
SQL BASICS : How to manipulate and query relational database?
SQL (Structured Query Language) is used to extract information from data stored in a Relational Database (RLDB). A RLDB consists of multiple tables, each containing rows and columns to record…