Copyright

Ch 2: Relational Database Management Systems

About This Chapter

Reviewing relational database management systems is a snap with help from this informative and easy-to-use chapter. Our short lessons and self-assessment quizzes are specially designed to make preparing for a test or finishing your homework simple and enjoyable.

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

8 Lessons in Chapter 2: Relational Database Management Systems
Test your knowledge with a 30-question chapter practice test
Database Programs: Types & Examples

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.

What is Microsoft SQL Server?

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.

What is SQL Server Management Studio (SSMS)?

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.

What is MySQL? - Overview & Usage

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.

Installing MySQL for Database Programming

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.

Practical Application for Introduction to SQL: Installing Sample Data for MySQL

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.

Installing SQL Server Express Edition for Database Programming

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.

Installing Oracle Database Express Edition for Database Programming

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.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

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.

Support