Advanced Database Systems & Design
About This Course
This comprehensive course delves into the foundational and advanced concepts of database systems and their role in decision support. Students will gain hands-on experience with relational and NoSQL databases, learning the intricacies of data modeling, normalization, query optimization, and advanced SQL techniques. The course also covers cutting-edge technologies such as Microsoft Azure Cosmos DB and Synapse Analytics, equipping learners with skills to handle modern data challenges. Weekly assignments and a final project ensure practical application of theoretical knowledge.
By the end of the course, students will be proficient in designing and managing complex databases, developing decision support systems (DSS), and utilizing cloud-based data solutions for real-world applications.
Curriculum
—————————–Week # 01 —————————
Decision Support Systems (DSS); Database Design; Conceptual Data Model
Decision Support Systems (DSS); Database Design; Conceptual Data Model
—————————–Week # 01 —————————
—————————–Week # 02 —————————
—————————–Week # 02 ————————–
—————————–Week # 03 ————————–
Introduction to Databases
—————————–Week # 03 ————————–
Introduction to Databases
—————————–Week # 04 ————————–
Structured Query Language (SQL)
—————————–Week # 04 ————————–
Simple Queries Using Structured Query Language (SQL)
—————————–Week # 05 ————————–
Join Operations; Beyond Simple Select Queries
—————————–Week # 05 ————————–
Join Operations; Beyond Simple Select Queries
—————————–Week # 06 ————————–
Stored Procedures, Functions, and Database Triggers
—————————–Week # 06 ————————–
Clarification or Help needed session for Week 6
—————————–Week # 07 ————————–
Incremental Refresh Techniques; Temporal Data Update Methodologies
—————————–Week # 07 ————————–
Clarification or Help needed session for Week 7
—————————–Week # 08 ————————–
NoSQL Database Concepts; NoSQL Database using Microsoft Azure Cosmos DB; Query Azure Data Lake Storage Gen2 using SQL language in Synapse Analytics
—————————–Week # 08 ————————–
SQL & Cloud Database Analytics Methodologies
Final Project
Your Instructors
Student Feedback
Reviews (1)
Md Habibur Rahman
4 months ago
very good
৳ 7,000.00৳ 12,000.00
Course categories
- Basic Computer Excel Training
- Comprehensive Artificial Intelligence Certification Program
- Comprehensive Networking Certification Program
- Comprehensive Selenium Software Testing Certification Program
- Cyber threats malware, phishing, DDoS, etc. attacks SQL injection, XSS, CSRF, etc. with their mitigation techniques
- Educate visa application process, laws, and regulations, visa categories
- Identifying Potential Leads, Gathering Contact Information
- Intensive IELTS Preparation
- Language
- Learn software development life cycle (SDLC), Manual, Automation, Database, and App
- Learn to generate reports, and perform complex analyses using SQL functions and techniques
- Power BI Dashboard, Reports with Star Schema and Snowflake Schema DAX Functions
- Professional IT Help-Desk Officer Certification Program
- Python Syntax, functions and Python-related libraries, statistics for Machine learning
- Software Database Testing (SQL) Certification Program
- SOFTWARE, WEBSITE, MOBILE APPLICATIONS ACCESSIBILITY TESTING
- SQL Server, Power BI, MSBI (SSIS, SSRS), Data Warehouse, and Advanced Excel for Data Analytics
- Statistics for Data Science Mastery
- Verifying the correctness, reliability, and performance of the database
Related Courses