Sharing Is Caring:

Introduction to Database Development

  • 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.

Read Also -->   FREE Complete Beginner Course: Technical Support Overview

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

πŸ‘‡πŸ‘‡πŸ‘‡πŸ‘‡ Click Below to Enroll in Free Udemy Course πŸ‘‡πŸ‘‡πŸ‘‡πŸ‘‡

Go to Course

πŸ‘‡πŸ‘‡ See Also πŸ‘‡πŸ‘‡

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock