Microsoft Access 2021 avanzado: Seguridad de la base de datos

Name: Microsoft Access 2021 avanzado: Seguridad de la base de datos
Author: John Varan

In this course, you will learn about the different classes of security, including both securing your data and protecting yourself from malware. We will also…

Preview the first lesson free — get full access to all 1 lessons.

Solicitar una demo Iniciar sesión

Curso: bajo demanda

Hello, my name is John Varon, and in these lessons you will learn about database security. In this lesson, I will show you about different types of security. Security comes in many forms and shapes, both in the digital world and in the real physical world. But all forms of security usually fall into three broad categories. The first category is authentication. Authentication is about identification. It is proving that you are who you say you are. In the real world, this is often accomplished by showing an ID card of some sort, usually one with your photo so it can be matched against your face. In the digital world, this is usually more complicated. The most common way is to create an account on a program or website with a username and password, which can be used to identify you in the future. Other systems may use biometric measures, such as fingerprints or facial recognition. Authorization is the second category. This step often comes right after or in conjunction with authentication. Once you prove who you are, the authorization step is to see if you have access to the thing you're trying to access. In software or websites, this is often done by checking a master list of users and what they have access to. This list would be maintained by an administrator user. It can also be done through the use of roles, where each user is placed into a small set of roles, and an authorization at various levels would be given to each role. Secrecy is the final category. Secrecy refers to keeping certain information out of the hands of people that should not have it. One way to achieve secrecy is to try to hide it, such as by putting a file into a folder whose name doesn't give any hints about what's in it, or naming the file something that isn't suspicious. This form of secrecy is called secrecy through obscurity and is widely recognized as not being very effective. No matter how well something is hidden, someone will eventually find it. A much more effective method of keeping a secret is through encryption. Encryption is a mathematical algorithm which changes data into another form, and is extremely difficult or impossible to change back without knowing something like a password. The idea behind encryption is that you could outright hand the encrypted information to anyone and still be confident that they would not be able to access the secret data. Obscurity is not necessary at all. When it comes to database applications like Microsoft Access 2021, all three of these categories are generally implemented. Thanks for watching. Stay tuned for the next lesson where I will show you about the Trust Center.

Avanzado Proveedor : John Varan 1 lección · 23m en Árabe, Alemán, Inglés, Español, Francés, Portugués, Chinese

Descripción del curso

Database security is often overlooked and underprioritized, yet it is one of the most important and critical parts of a successful database application. Database security comes in many forms, which is why we will discuss each form and how each affects database application design and implementation. Microsoft Trust Center has tools that help you protect yourself from malware that may come from other database files or add-ons downloaded from the internet. This course will build on your understanding of Microsoft Access 2021 by discussing the advanced security measures available, such as encryption and user role-based authorization and authentication.

In this course, you will learn about the different classes of security, including both securing your data and protecting yourself from malware. We will also discuss how to keep each class of security in mind when designing and implementing your database application. By the end of this course, you will be able to use database server systems and document management systems to enhance your Microsoft Access database application with increased features and improved security.

Lo que aprenderás

Identificar los diferentes tipos y clases de seguridad de bases de datos, incluida la seguridad de datos y la protección contra malware
Usar el Centro de confianza de Microsoft para protegerse contra malware de otros archivos de bases de datos o complementos descargados
Aplicar cifrado y comprender los diferentes tipos de cifrado y cuándo usar cada uno
Configurar la autorización y autenticación basadas en roles de usuario
Integrar otras aplicaciones como un servidor de bases de datos y SharePoint para mejorar características y seguridad en Microsoft Access 2021
Tener en cuenta cada clase de seguridad al diseñar e implementar su aplicación de base de datos

Puntos clave

La seguridad de bases de datos a menudo se pasa por alto pero es una de las partes más críticas de una aplicación de base de datos exitosa.
La seguridad de bases de datos se presenta de muchas formas, y cada forma afecta el diseño e implementación de la aplicación de base de datos.
El Centro de confianza de Microsoft proporciona herramientas para protegerse contra malware de otros archivos de bases de datos o complementos descargados de Internet.
Las medidas de seguridad avanzadas en Microsoft Access 2021 incluyen cifrado y autorización y autenticación basadas en roles de usuario.
Los sistemas de servidor de bases de datos y los sistemas de gestión de documentos pueden mejorar una aplicación de base de datos de Microsoft Access con características aumentadas y seguridad mejorada.

Preguntas frecuentes

¿Qué cubre este curso?

Se basa en su comprensión de Microsoft Access 2021 al cubrir medidas de seguridad avanzadas, incluidas las diferentes clases de seguridad, los tipos de cifrado y cuándo usar cada uno, autorización y autenticación basadas en roles de usuario, el Centro de confianza de Microsoft, y usar aplicaciones como un servidor de bases de datos y SharePoint para mejorar características y seguridad.

¿Qué habilidades ganaré de este curso?

El curso desarrolla habilidades en Acceso a datos, Programación de bases de datos, Seguridad de bases de datos, Microsoft Access, Componentes de acceso a datos de Microsoft y Seguridad avanzada de Oracle.

¿Qué temas se enseñan en las lecciones?

Las lecciones cubren Tipos de seguridad, Centro de confianza, Roles de usuario, Cifrado, Servidor de bases de datos y SharePoint.

¿Qué podré hacer al final del curso?

Al final, podrá usar sistemas de servidor de bases de datos y sistemas de gestión de documentos para mejorar su aplicación de base de datos de Microsoft Access con características aumentadas y seguridad mejorada.