About This Chapter
Relational Database Management Systems - Chapter Summary
Our professionally designed chapter on relational database management systems covers topics such as Microsoft SQL servers, types of database programs, how MySQL is installed for database programming, and more. To help test your knowledge before you move on, take the multiple-choice quiz included with each lesson or the comprehensive test at the end of the chapter. We've made sure these resources are easy to access from any mobile device or computer so you can study when and how it works best for you. Simply reach out to one of our experts through the Dashboard if you have any questions about the material. Once you finish this chapter, you should be able to:
- Outline different database program types with examples
- Identify what a Microsoft SQL server is
- Define SQL Server Management Studio (SSMS)
- Explain what MySQL is used for
- Discuss how to install MySQL and SQL Server Express Edition
- Understand how to install sample data for MySQL
1. Database Programs: Types & Examples
In this lesson you'll learn about databases and database programs. We'll look at examples of various types of database programs and highlight their differences in application.
2. What is Microsoft SQL Server?
This lesson will provide an overview of Microsoft SQL Server. A brief history of the tool is provided, the different products explained, and Microsoft's own flavor of SQL (T-SQL) will be explained.
3. What is SQL Server Management Studio (SSMS)?
Accessing and manipulating information is important these days. In this lesson, we'll take a look at SQL, what it is, how it relates to SQL Server Management Studio, and what you can do with them both.
4. What is MySQL? - Overview & Usage
In this lesson, we will be introduced to a relational database system called MySQL. It is one of the most widely used open-source database systems. Furthermore, we will learn briefly about the history of MySQL and describe its wide usage in web projects.
5. Installing MySQL for Database Programming
This lesson contains step-by-step guide to download, install, and configure the latest version of the free RDBMS, MySQL Community Server. The example executed on a 32-bit Windows 7 computer.
6. Practical Application for Introduction to SQL: Installing Sample Data for MySQL
In this practical lesson, you will learn how to locate and install a sample database for use in MySQL. You will use this database for several of the practical applications throughout this course.
7. Installing SQL Server Express Edition for Database Programming
Microsoft SQL Server Express Edition is from the Microsoft family of database products which is a free downloadable product. This is a step-by-step guide to install MS SQL Server 2017 Express Edition and to test to ensure that the installation is successful.
8. Installing Oracle Database Express Edition for Database Programming
This is a guided lesson where step-by-step instructions are provided to assist students in installing the free version of Oracle Database Express 11g along with the recent release of Oracle SQL Developer.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Other chapters within the Analytics 103: Intro to Relational Databases & SQL course
- Introduction to General & Relational Databases
- Relational Database Design Fundamentals
- Introduction to SQL Syntax & Queries
- Database Table Design & SQL Data Types
- Using SQL to Populate & Retrieve Data
- Modifying Data in Databases With SQL
- Using SQL to Remove Data
- Joins & Subqueries Using SQL
- Using Views, Indexes & Triggers in SQL