We may earn an affiliate commission when you visit our partners.

Building Basic Relational Databases in SQL Server Management Studio

Mark Veljkov

In this one-hour based project you will apply the basics of working with relational databases within the SQL Server Management Studio (SSMS) environment. You will use the tools in SSMS to diagram an existing database and to create and run some SELECT and CREATE TABLE structured query language commands. You will also acquire the basic terminology that applies to all relational databases. By successfully completing the hands-on practices assigned, you will be better prepared for applying these basic concepts in SSMS in SQL Server classes.

Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

Relational Databases in SQL

In this one hour-long project, you will apply the basics of working with relational databases within the SQL Server Management Studio (SSMS) environment. You will use the tools in SSMS to diagram an existing database and to create and run some very simple SELECT and CREATE TABLE structured query language commands. You will also acquire the basic terminology that applies to all relational databases. By successfully completing the hands-on practices assigned, you will be better prepared for applying these basic concepts in SSMS in SQL Server classes.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides the opportunity to use tools in SSMS to diagram an existing database

Introduces basic SQL language commands

Suitable for beginners with little to no experience in working with relational databases

May require learners to have some prior understanding of relational database terminology

Completion prepares learners for applying basic SQL Server concepts in future classes

Save this course

Save Building Basic Relational Databases in SQL Server Management Studio to your list so you can find it easily later:

Save

Reviews summary

Introduction to sql databases

Based on 38 reviews, students say this course gives a good introduction to building relational databases in SQL Server Management Studio. It is especially helpful for beginners who have no prior experience with SQL. The course uses a guided project format that includes tasks and quizzes to help learners apply what they learn.

Uses a guided course format.

"It is a guided project that is useful for beginners."

"The guided project was helpful and allowed me to build on my knowledge of SQL."

Covers basic concepts in building relational databases.

"This course gives a good introduction to the basic concepts to building relational databases in SQL Server Management Studio."

"I've appreciated this course :)"

Some students found the course too simple.

"It was too easy."

"The content was less than the time."

Activities

Coming soon We're preparing activities for Building Basic Relational Databases in SQL Server Management Studio. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Building Basic Relational Databases in SQL Server Management Studio will develop knowledge and skills that may be useful to these careers:

Data Architect

Data Architects design and manage data architectures for organizations. They work with stakeholders to understand the organization's data needs, and they design and implement data architectures that meet those needs. Coursework in relational databases will help you to build a foundation in data architecture as you learn how to create and manage databases, as well as resolve performance issues.

See salaries and explore the career path for Data Architect

Database Administrator

Database Administrators ensure that databases are available, reliable, and efficient. They work with database software, hardware, and operating systems to ensure that data is stored and retrieved quickly and securely. Coursework in relational databases will help you to build a foundation in database administration as you learn to create and manage databases, as well as resolve performance issues.

See salaries and explore the career path for Database Administrator

Data Integration Specialist

Data Integration Specialists integrate data from different sources into a single, unified data store. They work with data engineers and other stakeholders to design and implement data integration solutions. Coursework in relational databases will help you to build a foundation in data integration as you learn how to create and manage databases, as well as resolve performance issues.

See salaries and explore the career path for Data Integration Specialist

Data Scientist

Data Scientists use data to solve business problems. They collect, analyze, and interpret data to help businesses make data-driven decisions. Coursework in relational databases will help you to build a foundation in data science as you learn how to work with data, identify trends, and draw conclusions.

See salaries and explore the career path for Data Scientist

Data Analyst

Data Analysts translate complex data into simpler terms that can help stakeholders make informed decisions. They work closely with stakeholders to understand their business needs, gather and analyze data, and present their findings in a clear and concise way. Coursework in relational databases will help you to build a foundation in data analysis as you work with data, identify trends, and draw conclusions.

See salaries and explore the career path for Data Analyst

Database Marketing Manager

Database Marketing Managers use data to create and execute marketing campaigns. They work with marketing teams and data analysts to identify target audiences, develop marketing messages, and track the results of marketing campaigns. Coursework in relational databases may be useful for Database Marketing Managers who need to work with data in their marketing campaigns.

See salaries and explore the career path for Database Marketing Manager

Business Analyst

Business Analysts help businesses to improve their operations by identifying and solving business problems. They work with stakeholders to understand their business needs, gather and analyze data, and present their findings in a clear and concise way. Coursework in relational databases may be useful for Business Analysts who need to work with data in their business analysis projects.

See salaries and explore the career path for Business Analyst

Software Engineer

Software Engineers design, develop, and maintain software systems. They work with a variety of programming languages and technologies to create software that meets the needs of users. Coursework in relational databases may be useful for Software Engineers who need to work with databases in their software development projects.

See salaries and explore the career path for Software Engineer

Project Manager

Project Managers plan, execute, and close projects. They work with stakeholders to define project scope, develop project plans, and manage project resources. Coursework in relational databases may be useful for Project Managers who need to work with data in their project management projects.

See salaries and explore the career path for Project Manager

Forensic Analyst

Forensic Analysts investigate computer crimes and other digital evidence. They work with law enforcement and other agencies to collect and analyze evidence, and they write reports that summarize their findings. Coursework in relational databases may be useful for Forensic Analysts who need to work with data in their investigations.

See salaries and explore the career path for Forensic Analyst

Quality Assurance Analyst

Quality Assurance Analysts test software to ensure that it meets the quality standards of the organization. They work with developers to identify and fix bugs, and they write test cases to ensure that the software is working as expected. Coursework in relational databases may be useful for Quality Assurance Analysts who need to work with data in their testing projects.

See salaries and explore the career path for Quality Assurance Analyst

Information Security Analyst

Information Security Analysts protect organizations from cyberattacks. They work with security teams to identify and mitigate security risks, and they develop and implement security policies. Coursework in relational databases may be useful for Information Security Analysts who need to work with data in their security projects.

See salaries and explore the career path for Information Security Analyst

Risk Analyst

Risk Analysts identify and manage risks for organizations. They work with stakeholders to understand the organization's risks, and they develop and implement risk management plans. Coursework in relational databases may be useful for Risk Analysts who need to work with data in their risk management projects.

See salaries and explore the career path for Risk Analyst

Compliance Analyst

Compliance Analysts ensure that organizations comply with laws and regulations. They work with stakeholders to understand the organization's compliance obligations, and they develop and implement compliance programs. Coursework in relational databases may be useful for Compliance Analysts who need to work with data in their compliance projects.

See salaries and explore the career path for Compliance Analyst

Technical Writer

Technical Writers create documentation for software and other technical products. They work with developers and other subject matter experts to understand the product, and they write clear and concise documentation that helps users to understand how to use the product. Coursework in relational databases may be useful for Technical Writers who need to write documentation for software that uses databases.

See salaries and explore the career path for Technical Writer

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Building Basic Relational Databases in SQL Server Management Studio.

Database Systems: The Complete Book