Database Management & SQL

This professional Database Management & SQL program takes learners through Relational Data Modeling, SQL Queries, Joins and Aggregation, Constraints and Transactions, Indexes and Query Plans, Views and Procedures, Security and Backups, Reporting Project. Target audience: Analysts and developers who work with relational data.

Jane Instructor8 chapters26 hoursCertificate included

What you'll learn

Apply relational data modeling to a practical Database Management & SQL project.

Apply sql queries to a practical Database Management & SQL project.

Apply joins and aggregation to a practical Database Management & SQL project.

Apply constraints and transactions to a practical Database Management & SQL project.

Apply indexes and query plans to a practical Database Management & SQL project.

Apply views and procedures to a practical Database Management & SQL project.

Skills covered

SQL

Relational Modeling

Joins

Transactions

Indexes

Backups

Prerequisites

Basic programming or spreadsheet experience

Who this is for

Analysts and developers who work with relational data.

Course modules

1Relational Data ModelingFree preview

2SQL QueriesFree preview

3Joins and Aggregation

4Constraints and Transactions

5Indexes and Query Plans

6Views and Procedures

7Security and Backups

8Reporting Project

Assessments and certification

Database Management & SQL Practice Quiz

8 questions · 20 min · Pass mark 70%

Quiz

Database Management & SQL Certification Exam

8 questions · 60 min · Pass mark 70%

Final exam

Earn your AMNEXT ACADEMY certificate

Complete the course and pass its certification assessment to receive a verifiable certificate.