Get in Touch
 Duration 21 hours

Course Outline

Foundations of Databases

  • Definition and purpose of a database
  • Categorization of database types
  • Overview of relational databases
  • Introduction to Database Management Systems (DBMS)
  • Core functions of a DBMS
  • Overview of widely used DBMS software

Core Principles of Database Design

  • Conceptual, logical, and physical data modeling
  • Introduction to Entity-Relationship (ER) modeling
  • Construction of ER diagrams
  • Defining entities, attributes, and relationships

Normalization in Database Architecture

  • Normal forms (1NF, 2NF, 3NF, BCNF)
  • Advantages of applying normalization
  • Real-world examples of normalization
  • The role and application of denormalization

Getting Started with SQL

  • SQL syntax and command structure
  • SQL data types
  • Use of CREATE, ALTER, and DROP commands
  • Defining constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)

Data Manipulation in SQL

  • Executing INSERT commands
  • Performing bulk insert operations
  • Using UPDATE and DELETE commands
  • Applying conditions with the WHERE clause

Retrieving Data via SQL

  • Using the SELECT command
  • Data filtering through the WHERE clause
  • Ordering results with ORDER BY
  • Implementing LIMIT and OFFSET for pagination

Complex SQL Techniques

  • Join types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
  • Constructing subqueries
  • Aggregating data with GROUP BY and HAVING
  • Applying aggregate functions (COUNT, SUM, AVG, MAX, MIN)

Utilizing Indexes and Views

  • Creation and application of indexes
  • Trade-offs associated with indexing
  • Development and management of views
  • Leveraging views for query simplification

Ensuring Security and Transaction Integrity

  • Managing user roles and access permissions
  • Adhering to security best practices
  • Understanding ACID properties
  • Using COMMIT and ROLLBACK to manage transactions

Optimizing and Maintaining Databases

  • Analysis and optimization of SQL queries
  • Interpreting EXPLAIN plans
  • Developing backup strategies
  • Processes for database restoration

Recap and Future Pathways

Requirements

  • Familiarity with fundamental computer operations

Target Audience

  • Database administrators
  • IT professionals

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories