BI & Database Courses

Most popular
Trending

All BI & Database Courses

Course categories

We found 7 courses available for you
See

Fundamentals of Database Design: Principles and Techniques

18 Lessons
Intermediate

The course “Fundamentals of Database Design: Principles and Techniques” provides …

What you'll learn
Understanding the basic concepts of databases, data models, and relational database management systems (RDBMS).
Study of entity-relationship (ER) modeling and how to represent real-world entities and their relationships in a database.
Techniques for designing tables, attributes, and primary keys for data organization and integrity.
Exploration of normalization techniques to eliminate data redundancy and ensure data consistency.
Application of data constraints, foreign keys, and indexes for data integrity and efficient querying.
Practice in designing database schemas for specific application requirements and use cases.

Advanced Database Development: Optimizing Performance and Scalability

20 Lessons
Intermediate

The course “Advanced Database Development: Optimizing Performance and Scalability” is …

What you'll learn
Study of advanced indexing techniques, query optimization, and caching strategies to enhance database query performance.
Techniques for database partitioning, sharding, and replication to improve scalability and handle large amounts of data.
Exploration of database normalization and denormalization for efficient data storage and retrieval.
Application of advanced database features, such as stored procedures, triggers, and materialized views, for improved functionality and performance.
Practice in designing and implementing high-performance and scalable database solutions for real-world applications.

Data Modelling and Database Management: Designing Efficient Data Structures

20 Lessons
Intermediate

The course “Data Modelling and Database Management: Designing Efficient Data …

What you'll learn
Understanding the basics of data modelling techniques, such as entity-relationship diagrams (ERD) and UML diagrams.
Study of different data modelling approaches, including conceptual, logical, and physical data models.
Techniques for translating data models into database schemas and designing tables, keys, and relationships.
Exploration of database management systems (DBMS) and their role in efficiently managing data.
Application of indexing, partitioning, and clustering for optimizing database performance.
Practice in implementing data modelling concepts in popular database systems like MySQL, Oracle, or SQL Server.

Database Administration and Security: Ensuring Integrity and Protection of Data

17 Lessons
Intermediate

The course “Database Administration and Security: Ensuring Integrity and Protection …

What you'll learn
Understanding the basics of database management systems (DBMS) and their components.
Study of database security principles, including authentication, authorization, and encryption techniques.
Techniques for implementing access controls and managing user privileges to protect sensitive data.
Exploration of backup and recovery strategies to ensure data integrity and disaster recovery.
Application of database monitoring and performance tuning to optimize database performance.

Advanced Network Defense Techniques: Securing Data and Infrastructure

20 Lessons
Intermediate

The “Advanced Network Defense Techniques: Securing Data and Infrastructure” course …

What you'll learn
Building upon your foundational knowledge of cybersecurity to explore advanced techniques for defending networks and securing data and infrastructure.
Understanding the latest cyber threats and attack vectors, including advanced persistent threats (APTs) and zero-day vulnerabilities.
Study of advanced network security technologies, such as intrusion prevention systems (IPS), next-generation firewalls, and security information and event management (SIEM) solutions.
Techniques for implementing network segmentation and micro-segmentation to enhance network security.

Oracle Database Administration for Beginners

26 Lessons
All Levels

Oracle Database Administration for Absolute Beginners’ course explains about the …

What you'll learn
Develop a foundational understanding of Oracle database administration concepts and practices.
Learn to install, configure, and manage Oracle database instances.
Acquire skills in user management, backup and recovery, and performance tuning for efficient database administration.

Mastering Data Modeling Fundamentals

24 Lessons
15.3 hours
Beginner

“Mastering Data Modeling Fundamentals” is an in-depth and comprehensive course …

What you'll learn
Develop a strong foundation in data modeling fundamentals and its relevance in data management.
Learn to create entity-relationship diagrams and establish data relationships for efficient data organization.
Acquire techniques to ensure data integrity, design scalable databases, and adapt data models to meet evolving business needs.