Course programme
Introduction To Databases
12 lectures 02:22:22
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Cardinality Of Relationships
One-to-one, one-to-many or many-to-many? The nature of the relationships between entities determines how the corresponding data will be represented in a database
The Entity Relationship (E-R) Model - Relationships
We are almost ready to make the leap from modeling data to setting up a database. But first, let's delve a bit deeper into modelling relationships.
Mapping E-R Theory to the world of databases
All of that E-R model stuff we just learnt is really useful! Let's put it to work immediately, by figuring out how we can translate E-R models into database tables.
Introduction To Databases.
12 lectures 02:22:22
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Cardinality Of Relationships
One-to-one, one-to-many or many-to-many? The nature of the relationships between entities determines how the corresponding data will be represented in a database
The Entity Relationship (E-R) Model - Relationships
We are almost ready to make the leap from modeling data to setting up a database. But first, let's delve a bit deeper into modelling relationships.
Mapping E-R Theory to the world of databases
All of that E-R model stuff we just learnt is really useful! Let's put it to work immediately, by figuring out how we can translate E-R models into database tables.
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Data Is A Big Deal
Life - and business - is becoming more and more data-driven, and data-intensive.
Life - and business - is becoming more and more data-driven, and data-intensive.
Life - and business - is becoming more and more data-driven, and data-intensive.
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
Why Do We Need A Database?
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
As the scale of your data grows, file systems (the most famous of which is - Excel!) struggle to keep up. Databases are carefully engineered to do the heavy lifting
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
MySQL - Installed and Introduced (Mac OS X)
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
Setting up MySQL and the Workbench (Mac OS X)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The Mac OS X version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
MySQL Server and Workbench installed (Windows)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it. (The windows version)
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Entities And Attributes - Things And Stuff Which Describe Them
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Databases are like all computer systems - garbage in, garbage out. To make sure that what goes in makes sense, we need to model real-world entities and the relationships between them.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
Identifying Entities Using Keys
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
What's a key? It is a set of defining attributes. Once you have the key, you have captured the essence of an entity, as it were.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
The Entity Relationship (E-R) Model - Entities And Attributes
We dig deeper into the world of entities and relationships.
We dig deeper into the world of entities and relationships.
We dig deeper into the world of entities and relationships.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Relationships - What Connects Entities
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Entities could be modeled even with flat files, but relationships can only be modelled in a database.
Entities could be modeled even with flat files, but relationships can only be modelled in a database tuff we just learnt is really useful! Let's put it to work immediately, by figuring out how we can translate E-R models into database...