What is a Key? Attribute(s) that idenfity a record uniquely As long as attributes can be removed: superkey If no more attributes can be removed: minimal superky or ke...
Constraints
Integrity Constraints Attribute Constraints, e.g data types on columns Key Constraints, e.g primary keys Referential Integrity Constraints, enforced through foreign k...
Relational Databases
Using information schema SELECT table_schema, table_name FROM information_schema.tables; Taking the look at the columns of a ...
CRUD Operations
CRUD OPERATION CREATE Databases, Tables or Views Users, prermissions and security groups READ Example: SELEC...
Joining Tables
PRIMARY KEYS: A primary key is used to ensure data in the specific column is unique. It is a column cannot have NULL values. It is either an existing table column or a column that is speci...
Aggregating Data
SUM It is used to calculate the total amount of a column. Example: SELECT SUM(affected_customers) AS total_affec...
Introduction to SQL Server
A SQL Server is a relational database system developed by Microsoft. And a Transact-SQL (T-SQL) is a Microsoft’s implemenataion of SQL butwith added functionality. Queries SELECT ...
Convolutional Neural Network (CNN / ConvNet)
Convolutional Neural Networks (CNN/ ConvNet) A Convolutional Neural Network, also known as CNN or ConvNet, is a class of neural networks that specailizes in processing data that has a grid-like to...
Back Propagation
What is Backpropagation? Backpropagation is a supervised learning algorithm, for training Multi-layer Perceptrons (Artificial Neural Networks).It refers to the method of calculating the gradient o...
Artificial Neural Network (ANN / MLP)
To understand the concept of the architecture of an artificial neural network, we have to understand what a neural network consists of. In order to define a neural network that consists of a large ...