SQL Server: Understanding Database Fundamentals (98-364) from Pluralsight

Learn the fundamentals of designing, using, and maintaining a SQL Server database. This course is applicable to anyone preparing for the 98-364 exam: Understanding Database Fundamentals.

It is very common for databases to be part of a company's I.T. infrastructure. In this course, SQL Server: Understanding Database Fundamentals (98-364), you will learn the information and skills necessary to pass the 98-364 exam. First, you will learn core database concepts around database structure and how data is stored, along with statements used to create objects and manipulate data. Next, you will discover database design concepts and relational integrity, plus the impact of primary, foreign, and composite keys. Finally, you will explore how to administer a database, including authentication methods, regular database maintenance, and how to back up and restore databases. When you are finished with this course, you will have the skills and knowledge to start creating and using databases, and to pass the 98-364 Understanding Database Fundamentals exam.

What's inside

Syllabus

Course Overview

Introduction

Understanding Core Database Concepts

How to Create Database Objects

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Provides a solid preparation for anyone planning to take or currently studying for the 98-364: Understanding Database Fundamentals exam

This course helps you efficiently prepare for the industry-recognized 98-364 Microsoft certification

Builds essential database skills that are valuable in many technical and non-technical professions

Suitable for beginners with little to no prior database knowledge

Covers the core database concepts, relational integrity, database administration, and maintenance

Career center

Learners who complete SQL Server: Understanding Database Fundamentals (98-364) will develop knowledge and skills that may be useful to these careers:

Database Architect

Database Architects design and implement database systems that meet the specific needs of organizations. A comprehensive understanding of database fundamentals is essential for Database Architects to create efficient, scalable, and secure databases. This course provides a solid grounding in database design concepts, enabling learners to excel in this role.

See salaries and explore the career path for Database Architect

Database Performance Analyst

Database Performance Analysts identify and resolve performance issues in databases. A deep understanding of database concepts and technologies is essential for Database Performance Analysts to effectively analyze and tune database performance. This course provides a solid grounding in database performance analysis techniques, enabling learners to excel in this role.

See salaries and explore the career path for Database Performance Analyst

Database Administrator

The course provides a comprehensive overview of database fundamentals, covering topics such as database design concepts and relational integrity. These concepts are essential for Database Administrators, who are responsible for the efficient management and maintenance of databases. Through this course, learners will gain a solid understanding of database administration practices, preparing them to excel in this role.

See salaries and explore the career path for Database Administrator

Cloud Database Administrator

Cloud Database Administrators manage and maintain databases in the cloud. A strong understanding of database fundamentals and cloud computing is essential for Cloud Database Administrators to effectively manage databases in the cloud. This course provides a solid grounding in database administration practices and cloud computing concepts, enabling learners to excel in this role.

See salaries and explore the career path for Cloud Database Administrator

Data Integration Specialist

Data Integration Specialists design and implement solutions to integrate data from multiple sources into a unified data platform. A strong understanding of database concepts and technologies is vital for Data Integration Specialists to effectively integrate data from diverse sources. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to build robust and scalable data integration solutions.

See salaries and explore the career path for Data Integration Specialist

Data Analyst

Database knowledge is highly beneficial for Data Analysts, who analyze large datasets to extract meaningful insights for businesses. They use SQL to interact with databases and retrieve data for analysis. This course will provide a foundational understanding of database concepts and techniques, which will enable learners to effectively query and extract data for analysis, laying a solid groundwork for their success as Data Analysts.

See salaries and explore the career path for Data Analyst

Data Warehouse Engineer

Data Warehouse Engineers design and manage data warehouses, which are central repositories for large volumes of data. A solid understanding of database concepts and technologies is vital for Data Warehouse Engineers to effectively build and maintain data warehouses. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to build and manage efficient and reliable data warehouses.

See salaries and explore the career path for Data Warehouse Engineer

Data Governance Specialist

Data Governance Specialists ensure the integrity and compliance of data within an organization. A comprehensive understanding of database concepts and technologies is vital for Data Governance Specialists to effectively implement and maintain data governance policies. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to effectively manage and govern data.

See salaries and explore the career path for Data Governance Specialist

ETL Developer

ETL Developers are responsible for extracting, transforming, and loading data into databases. A deep understanding of database concepts and technologies is vital for ETL Developers to effectively design and implement ETL processes. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to build efficient and reliable data pipelines.

See salaries and explore the career path for ETL Developer

BI Developer

BI Developers build business intelligence applications that help organizations analyze and visualize data. A strong understanding of database concepts is essential for BI Developers to effectively extract and transform data for analysis. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to develop robust and informative business intelligence applications.

See salaries and explore the career path for BI Developer

Data Scientist

Data Scientists utilize databases to store and manage massive datasets. A thorough understanding of database concepts and techniques is crucial for Data Scientists to effectively access, clean, and analyze data. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to extract and prepare data for analysis, enhancing their ability to derive meaningful insights.

See salaries and explore the career path for Data Scientist

Information Security Analyst

Databases are often targets of cyberattacks, making a strong understanding of database security essential for Information Security Analysts. This course covers authentication methods and database maintenance, providing learners with knowledge on how to protect databases from unauthorized access and malicious activities. By taking this course, learners will gain a valuable foundation for securing databases and preventing data breaches.

See salaries and explore the career path for Information Security Analyst

Systems Analyst

Systems Analysts design and implement computer systems, which often involve working with databases. A strong understanding of database concepts is crucial for Systems Analysts to effectively integrate databases into their system designs. This course will provide learners with the knowledge and skills to interact with databases using SQL, enabling them to build robust and efficient systems.

See salaries and explore the career path for Systems Analyst

Software Developer

Software Developers often work with databases to store and manage data used by software applications. A strong understanding of database concepts is crucial for Developers to effectively integrate database functionality into their software designs. This course will equip learners with the knowledge and skills to interact with databases using SQL, enabling them to build robust and efficient applications.

See salaries and explore the career path for Software Developer

Business Analyst

Business Analysts rely on data to understand business needs and improve processes. This course provides a solid foundation in database fundamentals, enabling learners to effectively extract and analyze data from databases. The knowledge gained from this course will empower Business Analysts to make informed decisions and provide valuable insights to stakeholders.

See salaries and explore the career path for Business Analyst

Reading list

We haven't picked any books for this reading list yet.

SQL Server

Understanding Database Fundamentals (98-364)

What's inside

Syllabus

Traffic lights

Save this course

Activities

Career center

Reading list

Share

Similar courses