We may earn an affiliate commission when you visit our partners.
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/5sun9k/building
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
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
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
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Building Basic Relational Databases in SQL Server Management Studio with these
activities:
Organize study materials
Show steps
Stay organized by compiling your notes, assignments, and practice materials.
Show steps
-
Create a dedicated folder or binder for course materials.
-
File and organize materials neatly according to topic or module.
Recall SQL syntax and commands
Show steps
Revisit SQL syntax and commands before diving into the course content.
Browse courses on
SQL Syntax
Show steps
-
Go through your notes or textbooks to recall SQL syntax and commands.
-
Try solving simple SQL queries to practice.
Review basics of relational databases
Show steps
Refresh your understanding of the basics of relational database, SQL, and structured query language to ensure you have a strong foundation for this course.
Browse courses on
SQL
Show steps
-
Review notes or online resources on relational database concepts
-
Practice writing simple SQL queries
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Practice writing additional SELECT and CREATE TABLE queries
Show steps
Solidify your understanding of SELECT and CREATE TABLE queries through regular practice.
Show steps
-
Find practice problems or exercises online or in textbooks.
-
Attempt to solve the problems on your own.
-
Compare your solutions to the provided answers.
Review basic relational database concepts
Show steps
Refresh your memory on fundamental relational database concepts before starting the course.
Show steps
-
Review your notes or textbooks on relational database fundamentals.
-
Take an online quiz or assessment to test your understanding.
Practice SELECT and CREATE TABLE queries in SSMS
Show steps
Strengthen your skills in writing SELECT and CREATE TABLE queries by practicing in SSMS, the environment you will be using in this course.
Browse courses on
SQL Server Management Studio
Show steps
-
Follow the instructions in the course syllabus to connect to SSMS
-
Create a new database and table
-
Write a SELECT query to retrieve data from the table
-
Write a CREATE TABLE query to create a new table
Develop a SELECT query
Show steps
Create a simple SELECT query to retrieve data from a database.
Browse courses on
Structured Query Language (SQL)
Show steps
-
Identify the data you want to retrieve.
-
Write a SELECT query to retrieve the data.
-
Execute the query.
Create a relational database diagram
Show steps
Start by drawing a diagram of an existing database to solidify your understanding of database relationships.
Show steps
-
Review the course materials on relational database concepts.
-
Choose an existing database to diagram.
-
Use the tools in SQL Server Management Studio to create a diagram.
Create a diagram of an existing database
Show steps
Develop a deeper understanding of database structure by creating a diagram of an existing database using SSMS.
Show steps
-
Choose an existing database to diagram
-
Use SSMS to connect to the database
-
Use the SSMS diagramming tools to create a diagram of the database
-
Review the diagram to ensure it accurately represents the database structure
Design and create a new table
Show steps
Gain hands-on experience in designing and creating a new table in a relational database.
Show steps
-
Determine the purpose and requirements of the new table.
-
Design the table structure, including columns and data types.
-
Write a CREATE TABLE statement to implement the design.
-
Execute the statement to create the new table.
Create a simple database application using the skills learned in this course
Show steps
Apply the skills and knowledge you have gained in this course by creating a simple database application that solves a real-world problem.
Browse courses on
Database Applications
Show steps
-
Identify a problem that can be solved using a database
-
Design a database schema to store the data
-
Write SQL queries to create the database and populate it with data
-
Develop a user interface for the application
-
Test and debug the application
Organize study materials
Show steps
Stay organized by compiling your notes, assignments, and practice materials.
Show steps
Show steps
Show steps
- Create a dedicated folder or binder for course materials.
- File and organize materials neatly according to topic or module.
Recall SQL syntax and commands
Show steps
Revisit SQL syntax and commands before diving into the course content.
Browse courses on
SQL Syntax
Show steps
Show steps
Show steps
- Go through your notes or textbooks to recall SQL syntax and commands.
- Try solving simple SQL queries to practice.
Review basics of relational databases
Show steps
Refresh your understanding of the basics of relational database, SQL, and structured query language to ensure you have a strong foundation for this course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review notes or online resources on relational database concepts
- Practice writing simple SQL queries
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Practice writing additional SELECT and CREATE TABLE queries
Show steps
Solidify your understanding of SELECT and CREATE TABLE queries through regular practice.
Show steps
Show steps
Show steps
- Find practice problems or exercises online or in textbooks.
- Attempt to solve the problems on your own.
- Compare your solutions to the provided answers.
Review basic relational database concepts
Show steps
Refresh your memory on fundamental relational database concepts before starting the course.
Show steps
Show steps
Show steps
- Review your notes or textbooks on relational database fundamentals.
- Take an online quiz or assessment to test your understanding.
Practice SELECT and CREATE TABLE queries in SSMS
Show steps
Strengthen your skills in writing SELECT and CREATE TABLE queries by practicing in SSMS, the environment you will be using in this course.
Browse courses on
SQL Server Management Studio
Show steps
Show steps
Show steps
- Follow the instructions in the course syllabus to connect to SSMS
- Create a new database and table
- Write a SELECT query to retrieve data from the table
- Write a CREATE TABLE query to create a new table
Develop a SELECT query
Show steps
Create a simple SELECT query to retrieve data from a database.
Browse courses on
Structured Query Language (SQL)
Show steps
Show steps
Show steps
- Identify the data you want to retrieve.
- Write a SELECT query to retrieve the data.
- Execute the query.
Create a relational database diagram
Show steps
Start by drawing a diagram of an existing database to solidify your understanding of database relationships.
Show steps
Show steps
Show steps
- Review the course materials on relational database concepts.
- Choose an existing database to diagram.
- Use the tools in SQL Server Management Studio to create a diagram.
Create a diagram of an existing database
Show steps
Develop a deeper understanding of database structure by creating a diagram of an existing database using SSMS.
Show steps
Show steps
Show steps
- Choose an existing database to diagram
- Use SSMS to connect to the database
- Use the SSMS diagramming tools to create a diagram of the database
- Review the diagram to ensure it accurately represents the database structure
Design and create a new table
Show steps
Gain hands-on experience in designing and creating a new table in a relational database.
Show steps
Show steps
Show steps
- Determine the purpose and requirements of the new table.
- Design the table structure, including columns and data types.
- Write a CREATE TABLE statement to implement the design.
- Execute the statement to create the new table.
Create a simple database application using the skills learned in this course
Show steps
Apply the skills and knowledge you have gained in this course by creating a simple database application that solves a real-world problem.
Browse courses on
Database Applications
Show steps
Show steps
Show steps
- Identify a problem that can be solved using a database
- Design a database schema to store the data
- Write SQL queries to create the database and populate it with data
- Develop a user interface for the application
- Test and debug the application
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 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.
Database Administrator
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.
Data Integration Specialist
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.
Data Scientist
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.
Data Analyst
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.
Database Marketing Manager
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.
Business Analyst
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.
Software Engineer
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.
Project Manager
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.
Forensic Analyst
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.
Quality Assurance 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.
Information Security 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.
Risk 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.
Compliance 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.
Technical Writer
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.
For more career information including salaries, visit:
OpenCourser.com/course/5sun9k/building
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.
Comprehensive textbook on database systems and covers all the major topics that are likely to be covered in this course. It is well-written and easy to follow, and it provides a good balance of theory and practice.
A comprehensive guide to understanding and improving the performance of SQL queries, with a focus on understanding query plans.
Provides a clear and detailed explanation of relational database design principles and techniques, useful both as background reading and as a later reference.
A collection of best practices, tips, and techniques for writing efficient, maintainable, and scalable SQL code.
An interactive and engaging introduction to SQL, focusing on understanding the concepts rather than just the syntax.
A collection of common mistakes and pitfalls to avoid when writing SQL queries and designing databases.
Practical guide to writing SQL queries. It covers all the basics of SQL, including how to select, insert, update, and delete data. It also provides a good overview of SQL's data types and operators.
Save
A recipe style guide to using Transact-SQL to perform tasks, manage and administer SQL Server databases.
An official guide from Microsoft, provides a comprehensive introduction to SQL Server, including its architecture, features, and usage.
Save
A concise and quick reference guide to SQL syntax and commands, including examples.
Good introduction to SQL Server for beginners. It covers all the basics of SQL Server, including how to create and manage databases, tables, and indexes. It also provides a good overview of SQL Server's features and functionality.
Provides an introduction to different SQL injection attack methods and techniques to defend against these attacks.
Provides a practical guide to designing relational databases. It covers all the basics of database design, including how to create tables, relationships, and indexes. It also provides a good overview of database normalization.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/5sun9k/building
Share
Similar courses
Here are nine courses similar to
Building Basic Relational Databases in SQL Server Management Studio.
Azure Database Administrator Associate
OpenCourser.com/course/epfy8r/azure
Azure Database Administrator Associate
Most relevant
SQL: A Practical Introduction for Querying Databases
OpenCourser.com/course/54rc5b/sql
SQL: A Practical Introduction for Querying Databases
Most relevant
Importing Data from Relational Databases in R 3
OpenCourser.com/course/fpokjx/importing
Importing Data from Relational Databases in R 3
Most relevant
Introduction to SQL
OpenCourser.com/course/0t1qcg/introduction
Introduction to SQL
Most relevant
SQL for Data Science with R
OpenCourser.com/course/3wzifm/sql
SQL for Data Science with R
Most relevant
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
OpenCourser.com/course/m4fmto/become
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
Simple Retrieval Queries in MySQL Workbench
OpenCourser.com/course/cr1bzl/simple
Simple Retrieval Queries in MySQL Workbench
Most relevant
SQL for Data Science
OpenCourser.com/course/eoz1cw/sql
SQL for Data Science
Most relevant
Hospital management database using SQL server
OpenCourser.com/course/0awcc5/hospital
Hospital management database using SQL server
Most relevant
Effort
65 minutes
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Mark Veljkov
Language
English
Good to know
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
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser