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.
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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024