New course
CompTIA DataSys+
DataSys+ defines and confirms a consistent skill set appropriate for certified database administrators (DBAs).
Category
9
Students
enrolled
- Description
- Curriculum
Database Fundamentals
Understand database structure types while developing, modifying and running structured query language (SQL) code, providing the groundwork to gather, store, and drive data assets on any operating system.
Database Deployment
Compare and contrast the different aspects of database design and planning and explain the various phases of the implementation, testing, deployment and optimization of collected data.
Database Management and Maintenance
Learn the purpose of monitoring and reporting database performance, explain common database maintenance processes, and produce critical documentation.
Data and Database Security
Secure databases, protect against attacks, and control authorization while ensuring governance and regulatory compliance.
Business Continuity
Prepare for and recover from incidents by implementing best practices for disaster recovery, backup and restoration of database management systems.
Increase your ability to summarize important data governance concepts and apply data quality control concepts For more information on CompTIA Data+ visit https://www.comptia.org/certifications/datasys
Lesson 1
-
1
Understanding Database Types and Structures -
2
Identify Relational and Non-Relational Databases
-
3
RELATIONAL DATABASES
-
4
NON-RELATIONAL DATABASES
-
5
KEY DIFFERENCES BETWEEN DATABASE STRUCTURE TYPES
-
6
Review Activity: Relational and Non-Relational Databases -
7
Topic 1B Understand Different Types of NoSQL Databases and Tools
-
8
DOCUMENT-ORIENTED DATABASES
-
9
KEY-VALUE STORES
-
10
COLUMN-ORIENTED DATABASES
-
11
GRAPH DATABASES
-
12
NON-RELATIONAL DATA SYSTEMS
-
13
Review Activity: Different Types of NoSQL Databases and Tools
-
14
Topic 1C Understand Relational Database Design
-
15
NORMALIZATION
-
16
REFERENTIAL INTEGRITY
-
17
ENTITY RELATIONSHIP DIAGRAMS
-
18
RELATIONSHIPS AND KEY FIELDS
-
19
TYPES OF RELATIONSHIPS
-
20
Review Activity: Relational Database Design
-
21
Topic 1D Identify Other Data Systems
-
22
DATA WAREHOUSES
-
23
DATA MARTS
-
24
DATA LAKES
-
25
Review Activity: Other Data Systems
-
26
Summary
Lesson 2
-
27
Recognizing Standards and Commands
-
28
Topic 2A Understand Standards and Principles
-
29
ANSI AND ISO STANDARDS
-
30
ACID PRINCIPLES
-
31
Review Activity: Standards and Principles
-
32
Topic 2B Examine Operating Systems and Command Line Scripting
-
33
COMMAND LINE SCRIPTING
-
34
POWERSHELL
-
35
OTHER LANGUAGES
-
36
Review Activity: Operating Systems and Command Line Scripting
-
37
Summary
Lesson 3
-
38
Running Scripts for Data and Data Systems
-
39
Create and Alter Objects Using Data Definition Language
-
40
DATA DEFINITION LANGUAGE (DDL)
-
41
CREATING AND ALTERING DATABASES
-
42
CREATING TABLES
-
43
ALTERING TABLES
-
44
DELETING FIELDS AND TABLES
-
45
Review Activity: Data Definition Language
-
46
Topic 3B Manipulate Data Using Data Manipulation Language
-
47
DATA MANIPULATION LANGUAGE (DML)
-
48
SELECTING DATA
-
49
UPDATING DATA
-
50
SELECTING DATA FROM MULTIPLE TABLES
-
51
INSERTING DATA
-
52
DELETING DATA
-
53
GROUPING AND AGGREGATING DATA
-
54
Review Activity: Data Manipulation Language
-
55
Topic 3C Work with Transactions
-
56
TRANSACTION CONTROL LANGUAGE (TCL)
-
57
COMMITTING DATA
-
58
ROLLING BACK DATA
-
59
Review Activity: Transactions
-
60
Topic 3DPerform Data Management Tasks
-
61
CONVERTING DATA TYPES
-
62
APPENDING DATA
-
63
CREATING INDEXES
-
64
SHARING DATA EXPORTS
-
65
Review Activity: Data Management Tasks
-
66
Summary
Lesson 4
-
67
Explaining the Impact of Programming on Database Operations
-
68
Topic 4A Work with Views
-
69
CREATING VIEWS
-
70
SNAPSHOTS
-
71
Review Activity: Views
-
72
Topic 4B Understand Object-Relational Mapping
-
73
MAPPING OBJECTS
-
74
PERFORMING DATABASE OPERATIONS USING FRAMEWORKS
-
75
IMPACT OF PROGRAMMING ON DATABASE OPERATIONS
-
76
Review Activity: Object-Relational Mapping
-
77
Topic 4C Program with SQL
-
78
SET-BASED LOGIC
-
79
STORED PROCEDURES
-
80
CREATING STORED PROCEDURES
-
81
TYPES OF TRIGGERS
-
82
SETTING TRIGGERS
-
83
Review Activity: Program with SQL
-
84
Topic 4D Write Functions
-
85
TYPES OF FUNCTIONS
-
86
TEXT FUNCTIONS
-
87
DATE FUNCTIONS
-
88
LOGICAL FUNCTIONS
-
89
AGGREGATE FUNCTIONS
-
90
Review Activity: Functions
-
91
Summary
Lesson 5
-
92
Understanding Database Planning and Design
-
93
Topic 5A Understand Types of Architecture
-
94
CLOUD VS. ON-PREMISE
-
95
PLATFORM AS A SERVICE (PAAS)
-
96
SOFTWARE AS A SERVICE (SAAS)
-
97
INFRASTRUCTURE AS A SERVICE (IAAS)
-
98
Review Activity: Types of Architecture
-
99
Topic 5B Gather Data System Requirements
-
100
UNDERSTANDING THE OBJECTIVE OF THE DATABASE
-
101
IDENTIFYING USER-RELATED INFORMATION
-
102
GATHERING STORAGE AND SIZE REQUIREMENTS
-
103
GATHERING DATA SOURCES
-
104
Review Activity: Data System Requirements
-
105
Topic 5C Review Documentation Requirements
-
106
STANDARD OPERATING PROCEDURES
-
107
DATA DICTIONARY
-
108
SYSTEM SPECIFICATIONS AND REQUIREMENTS
-
109
MAINTENANCE DOCUMENTATION
-
110
LEVERAGING TOOLS FOR DOCUMENTATION
-
111
Review Activity: Documentation Requirements
-
112
Summary
Lesson 6
-
113
Implementing, Testing, and Deploying Databases
-
114
Topic 6A Prepare for Deployment
-
115
ACQUIRING ASSETS FOR DEPLOYMENT
-
116
TYPES OF DEPLOYMENT
-
117
CONSIDERATIONS FOR INSTALLATION AND CONFIGURATION
-
118
AUTHENTICATION MODES
-
119
RESTORING A DATABASE FROM BACKUP
-
120
CONFIGURING A DATABASE
-
121
Review Activity: Deployment
-
122
Topic 6B Conduct Testing and Other Quality Measures
-
123
DATABASE QUALITY CHECKS
-
124
ADDRESSING CODE AND SYNTAX
-
125
NEGATIVE TESTING
-
126
STRESS TESTING APPLICATIONS
-
127
REGRESSION TESTING
-
128
VERSION CONTROL
-
129
Review Activity: Testing and Other Quality Measures
-
130
Topic 6C Understand Validation Techniques and Methods
-
131
VALIDATING DATA INTEGRITY
-
132
VALIDATING DATA VALUES
-
133
AUTOMATED VALIDATION
-
134
DATA VERIFICATION METHODS
-
135
DATA MAPPING
-
136
Review Activity: Validation Techniques and Methods
-
137
Summary
Lesson 7
-
138
Monitoring and Reporting on Database Performance
-
139
Topic 7A Consider Database Connectivity Needs
-
140
CLIENT-SERVER ARCHITECTURE
-
141
DATABASE SERVER LOCATION
-
142
DOMAIN NAME SERVICE (DNS)
-
143
Review Activity: Database Connectivity Needs
-
144
Topic 7B Monitor the Database
-
145
MONITORING CONNECTIONS AND SESSIONS
-
146
DIFFERENT TYPES OF CONNECTIONS
-
147
GROWTH AND STORAGE LIMITS
-
148
RESOURCE UTILIZATION
-
149
REVIEWING LOG FILES AND ALERTS
-
150
JOB COMPLETION AND FAILURES
-
151
Review Activity: Monitor the Database
-
152
Topic 7C Understand and Address Deadlocks
-
153
HOW DEADLOCKS OCCUR
-
154
IDENTIFYING THE CAUSE OF A DEADLOCK
-
155
ADDRESSING A DEADLOCK
-
156
Review Activity: Deadlocks
-
157
Summary
Lesson 8
-
158
Understanding Common Data Maintenance Processes
-
159
Topic 8A Explain Patch Management
-
160
PATCH MANAGEMENT
-
161
TYPES OF PATCHES
-
162
Review Activity: Patch Management
-
163
Topic 8B Ensure Database Performance
-
164
PERFORMANCE TUNING
-
165
INDEX ANALYSIS AND OPTIMIZATION
-
166
QUERY OPTIMIZATION
-
167
QUERY EXECUTION PLAN
-
168
LOAD BALANCING
-
169
VALIDATING SCALABILITY
-
170
Review Activity: Database Performance
-
171
Topic 8C Ensure Database Integrity
-
172
DESIGNING FOR DATA INTEGRITY
-
173
LOCKING ORDER
-
174
DATA CORRUPTION CHECKS
-
175
Review Activity: Database Integrity
-
176
Summary
Lesson 9
-
177
Understanding Governance and Regulatory Compliance
-
178
Topic 9A Understand the Importance of Protecting Data and Preventing Data Loss
-
179
WHY WE PROTECT DATA
-
180
IDENTIFYING PRIVATE DATA
-
181
DATA AT REST
-
182
DATA IN TRANSIT
-
183
DATA ENDPOINTS
-
184
DATA LEAKAGE
-
185
DATA EXFILTRATION
-
186
Review Activity: The Importance of Protecting Data and Preventing Data Loss
-
187
Topic 9B Understand Data Retention Policies
-
188
THE PURPOSE OF DATA RETENTION POLICIES
-
189
ELEMENTS OF DATA RETENTION POLICIES
-
190
Review Activity: Data Retention Policies
-
191
Topic 9C Classify Data
-
192
CONFIDENTIAL DATA
-
193
PERSONALLY IDENTIFIABLE INFORMATION
-
194
PERSONAL HEALTH INFORMATION
-
195
PAYMENT CARD INDUSTRY DATA
-
196
Review Activity: Data Classification
-
197
Topic 9D Consider Global Jurisdiction and Regional Regulations
-
198
GLOBAL JURISDICTION
-
199
REGIONAL REGULATIONS
-
200
Review Activity: Global Jurisdiction and Regional Regulations
-
201
Topic 9E Understand Third-Party Agreements and Release Approvals
-
202
DATA SHARING AND USAGE
-
203
RELEASE APPROVALS
-
204
Review Activity: Third-Party Agreements and Release Approvals
-
205
Summary
Lesson 10
-
206
Securing Data
-
207
Topic 10A Understand Data Encryption
-
208
ENCRYPTING DATA IN TRANSIT
-
209
ENCRYPTING DATA AT REST
-
210
Review Activity: Data Encryption
-
211
Topic 10B Understand Data Masking
-
212
PSEUDONYMIZATION
-
213
ANONYMIZATION
-
214
THE CHALLENGES OF DATA DISCOVERY
-
215
Review Activity: Data Masking
-
216
Topic 10C Describe Data Destruction Techniques
-
217
LOGICAL DESTRUCTION
-
218
PHYSICAL DESTRUCTION
-
219
REGULATORY IMPACT ON DATA DESTRUCTION
-
220
Review Activity: Data Destruction Techniques
-
221
Topic 10D Audit Data Access
-
222
ACCOUNT AUTHORIZATION
-
223
CONNECTION REQUESTS
-
224
EXPIRED ACCOUNTS
-
225
Review Activity: Data Access Auditing
-
226
Topic 10E Audit Code and Changes
-
227
STRUCTURED QUERY LANGUAGE (SQL) CODE
-
228
CREDENTIAL STORAGE CHECKS
-
229
CHANGE MANAGEMENT
-
230
CHANGE MANAGEMENT PROCESS
-
231
CHANGE MANAGEMENT CONSIDERATIONS
-
232
Review Activity: Code Auditing and Change Management
-
233
Summary
Lesson 11
-
234
Lesson 11 Securing Data Access
-
235
Topic 11A Understand Identity and Access Management
-
236
AUTHENTICATION
-
237
IDENTITY AND ACCESS MANAGEMENT
-
238
Review Activity: Identity and Access Management
-
239
Topic 11B Understand Access Controls
-
240
PERMISSIONS AND ROLES
-
241
SCHEMAS
-
242
THE PRINCIPLE OF LEAST PRIVILEGE
-
243
Review Activity: Access Controls
-
244
Topic 11C Understand Password Policies
-
245
COMMON PASSWORD POLICIES
-
246
ENFORCEMENT OF PASSWORD POLICIES
-
247
Review Activity: Password Policies
-
248
Topic 11D Work with Service Accounts
-
249
SERVICE ACCOUNTS
-
250
BEST PRACTICES FOR SERVICE ACCOUNTS
-
251
SERVICE ACCOUNT ABUSE
-
252
Review Activity: Service Accounts
-
253
Lesson 11 Summary
Lesson 12
-
254
Lesson 12 Securing the Database and Server
-
255
Topic 12A Utilize Physical Security
-
256
Physical Access Controls
-
257
SURVEILLANCE
-
258
FIRE SUPPRESSION
-
259
COOLING SYSTEMS
-
260
Review Activity: Physical Security
-
261
Topic 12B Utilize Logical Security
-
262
FIREWALLS
-
263
Perimeter Network
-
264
PORT SECURITY
-
265
Review Activity: Logical Security
-
266
Lesson 12 Summary
Lesson 13
-
267
Lesson 13 Classifying Types of Attacks
-
268
Topic 13A Mitigate the SQL Injection Attack
-
269
IDENTIFYING A SQL INJECTION ATTACK
-
270
MITIGATING SQL INJECTION ATTACKS
-
271
Review Activity: The SQL Injection Attack
-
272
Topic 13B Mitigate the Denial of Service (DoS) Attack
-
273
IDENTIFYING A DOS ATTACK
-
274
MITIGATING DOS ATTACKS
-
275
Review Activity: The Denial of Service (DoS) Attack
-
276
Topic 13C Mitigate the On-Path Attack
-
277
IDENTIFYING AN ON-PATH ATTACK
-
278
MITIGATING ON-PATH ATTACKS
-
279
Review Activity: The On-Path Attack
-
280
Topic 13D Mitigate the Brute Force Attack
-
281
IDENTIFYING A BRUTE FORCE ATTACK
-
282
MITIGATING BRUTE FORCE ATTACKS
-
283
Review Activity: The Brute Force Attack
-
284
Topic 13E Mitigate Social Engineering Attacks
-
285
DESCRIBING SOCIAL ENGINEERING PRINCIPLES
-
286
IDENTIFYING PHISHING ATTACKS
-
287
MITIGATING SOCIAL ENGINEERING ATTACKS
-
288
Review Activity: Social Engineering Attacks
-
289
Topic 13F Mitigate Malware
-
290
IDENTIFYING TYPES OF MALWARE
-
291
MITIGATING MALWARE ATTACKS
-
292
Review Activity: Malware
-
293
Lesson 13 Summary
Lesson 14
-
294
Lesson 14 Planning for Disaster Recovery
-
295
Topic 14A Plan for Disaster Recovery
-
296
DISASTER RECOVERY DOCUMENTATION
-
297
ELEMENTS OF A DISASTER RECOVERY PLAN
-
298
BUSINESS CONTINUITY AND SYSTEM SECURITY
-
299
REPLICATION
-
300
LOG SHIPPING
-
301
HIGH AVAILABILITY
-
302
MIRRORING
-
303
Review Activity: Disaster Recovery
-
304
Topic 14B Conduct DR Plan Testing
-
305
DR PLAN TESTING METHODS
-
306
RECOVERY TIME OBJECTIVE (RTO)
-
307
RECOVERY POINT OBJECTIVE (RPO)
-
308
Review Activity: DR Plan Testing
-
309
Topic 14C Transition/Failback to Normal Operations
-
310
DISASTER RECOVERY FAILBACK
-
311
DISASTER RECOVERY RETROSPECTIVE
-
312
Review Activity: Transition/Failback to Normal Operations
-
313
Lesson 14 Summary
Lesson 15
-
314
Lesson 15 Implementing Backup and Restore Best Practices
-
315
Topic 15A Identify Types of Backups
-
316
FULL BACKUP
-
317
INCREMENTAL BACKUP
-
318
DIFFERENTIAL BACKUP
-
319
SYNTHETIC FULL BACKUP
-
320
DATABASE DUMPING
-
321
Review Activity: Types of Backups
-
322
Topic 15B Implement a Backup Strategy
-
323
SCHEDULING BACKUPS
-
324
Testing Backups
-
325
VALIDATING BACKUP HASH
-
326
Review Activity: A Backup Strategy
-
327
Topic 15C Store and Purge Backups
-
328
ON-SITE STORAGE
-
329
OFF-SITE STORAGE
-
330
ROTATING BOTH ON-SITE AND OFF-SITE
-
331
PURGING AND ARCHIVING DATA
-
332
Review Activity: Store and Purge Backups
-
333
Lesson 15 Summary
Glossary
