- See the databases from developer’s point of view. They are just look complicated, it is fun to play with them.
- Free tutorial
- Rating: 3.6 out of 53.6 (11 ratings)
- 1,013 students
- 1hr 48min of on-demand video
- Created by Tatiana Minina
English
What you’ll learn
- Why the databases are so popular
- How to create database in MS Access, mySQL and MS SQL Server
- The basic of SQL
Requirements
- To have web browser
- Nice to have MS Access
- Be able to install applications to the
Description
In this course, we will talk about how information is stored on computers.
There are a lot of clients to consume information like web applications and reporting. Web application needs to track the users, giving them access to the resources. The user information, including the login information, the list of privileges, and the list of resources, must be securely stored, managed and backed up.
Often, we have to collect and save the information which is similar between the entities—the best place is to store it in the Database.
If the pieces of information could be structured to avoid repetitiveness, we call the result tables normalized and the collection of such tables a Rational Database.
This course shows three types of Rational Databases from the inside. It starts with an overview of the history and usage of the databases; then, we build the real Database in MS Access and reproduce the same Database in MySQL and MS SQL Server. After this course, the user will be able not only to create the Database but also to build the form and report in MS Access. You will see how web applications use databases, where to find the documentation, and how to use it. I will show you some development and production databases and how different systems store passwords.
Who this course is for:
- Any person, interested to make the manipulation with any information faster and easier in more structured manner
Show less
Course content
6 sections • 24 lectures • 1h 48m total lengthCollapse all sections
Introduction2 lectures • 6min
- Introduction01:51
- Why DBs?03:41
Overview2 lectures • 4min
- Historical overview01:45
- DB Providers02:30
MS Access7 lectures • 52min
- Tables in MS Access (part 1)08:58
- Tables in MS Access (part 2)06:21
- Forms in MS Access (part 1)04:02
- Forms in MS Access (part 2)09:50
- Add Some Data06:29
- Queries07:42
- Reports in MS Access09:05
Web Applications and DBs9 lectures • 34min
- Web Applications01:50
- PHP and MySQL02:06
- The Tools: HeidiSQL03:55
- MySQL: tables06:04
- MySQL: data05:33
- MySQL: queries02:00
- MS ASP.NET03:38
- MS SQL Server: tables03:53
- MS SQL Server: queries05:18
Data Manipulations3 lectures • 12min
- Data Types02:32
- Data Constrains02:28
- Queries06:35
Thank you1 lecture • 1min
- Thank you00:06
