Introduction to Database Development

Introduction to Database Development, available at Free, has an average rating of 4.5, with 24 lectures, based on 17 reviews, and has 2192 subscribers.

Free Enroll Now

You will learn about Why the databases are so popular How to create database in MS Access, mySQL and MS SQL Server The basic of SQL This course is ideal for individuals who are Any person, interested to make the manipulation with any information faster and easier in more structured manner It is particularly useful for Any person, interested to make the manipulation with any information faster and easier in more structured manner.

Enroll now: Introduction to Database Development

Summary

Title: Introduction to Database Development

Price: Free

Average Rating: 4.5

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Why the databases are so popular

How to create database in MS Access, mySQL and MS SQL Server

The basic of SQL

Who Should Attend

Any person, interested to make the manipulation with any information faster and easier in more structured manner

Target Audiences

Any person, interested to make the manipulation with any information faster and easier in more structured manner

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Why DBs?

Chapter 2: Overview

Lecture 1: Historical overview

Lecture 2: DB Providers

Chapter 3: MS Access

Lecture 1: Tables in MS Access (part 1)

Lecture 2: Tables in MS Access (part 2)

Lecture 3: Forms in MS Access (part 1)

Lecture 4: Forms in MS Access (part 2)

Lecture 5: Add Some Data

Lecture 6: Queries

Lecture 7: Reports in MS Access

Chapter 4: Web Applications and DBs

Lecture 1: Web Applications

Lecture 2: PHP and MySQL

Lecture 3: The Tools: HeidiSQL

Lecture 4: MySQL: tables

Lecture 5: MySQL: data

Lecture 6: MySQL: queries

Lecture 7: MS ASP.NET

Lecture 8: MS SQL Server: tables

Lecture 9: MS SQL Server: queries

Chapter 5: Data Manipulations

Lecture 1: Data Types

Lecture 2: Data Constrains

Lecture 3: Queries

Chapter 6: Thank you

Lecture 1: Thank you

Instructors

Tatiana Minina
Webmaster, Microsoft? Certified Professional

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 4 votes

4 stars: 7 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!