Mastering Database and Search with SQL and Elasticsearch

Course Curriculum:

Week 1: Introduction to SQL (8 hours)

• Understanding SQL syntax and commands
• Creating, inserting, querying and updating data in SQL
• Basic database design principles
  
  

Week 2: Intermediate SQL (8 hours)

• Working with advanced SQL queries
• Joining multiple tables
• Understanding views and subqueries
  
  

Week 3: Elasticsearch Fundamentals (8 hours)

• Understanding Elasticsearch and its role in search and analytics
• Setting up and configuring Elasticsearch
• Basic indexing and querying with Elasticsearch
  
  

Week 4: Advanced Elasticsearch (8 hours)

• Understanding Elasticsearch search features like filters, aggregations, and highlighting
• Query optimization and performance tuning
• Understanding Elasticsearch data pipelines
  
  

Week 5: Working with Elasticsearch and
SQL Together (8 hours)

• Combining Elasticsearch and SQL to perform complex queries and analytics
• Integrating Elasticsearch with existing applications
  
  

Week 6: Building a Real-world Project with SQL and Elasticsearch (10 hours)

• Building a complete project using SQL and Elasticsearch
• Deploying and scaling the project using cloud technologies
  
  

Session Hours:

• 6 weeks of course work, 50 hours total
• 2 sessions per week, each session is 2.5 hours long

Course Fee:

• TBD