Designing an E-commerce Database
Databases are vital tools for storing, managing and retrieving information. They are also critical for building an e-commerce system. A well-structured database powers e-commerce a…
Computer Science · Course
Everything about Database 2.0
A comprehensive course on SQL and MongoDB using practical and real-world examples. This course is highly suited for beginners
- Duration
- 12 weeks
- Content
- 19 hours
- Projects
- 2
- Mode
- Online
OverviewWhat you'll
What you'll
be able to do.
- This course is designed for absolute beginners who don’t have any prior experience with database management.
- From the very basic topics like creating your first database to the most advanced topics like query implementation, everything is covered in this course.
- Through this course, the students will learn to create databases in a systematic way.
- Students will gain exposure to databases and their implementation using SQL and MongoDB.
- Through this course, students will learn to
- Design
- Create
- Manage
- Extract information
- Also, the students will be doing multiple projects on real-world problems, which will strengthen their base as professional database administrators.
Tools you'll use
MySQLMongoDB
Curriculum11 modules,
11 modules,
built with industry.
01Everything about Database 2.0
- Introduction to DatabasesW01
- Introduction to databases
- Downloading XAMPP and creating the first table
- Components of DBMS
- Characteristics of DBMS, ACID properties
- Databases vs File system
- Types of DB
- SQL vs NoSQL
- CRUD operations example in MySQL, OLTP, and OLAP
- Creating Database TablesW02
- Database design
- ER model
- Entity and attributes
- Entity relationships
- Cardinality ratio
- Generalization, specialization, and aggregation
- Case study of Ecommerce website
- Introduction to RDBMSW03
- RDBMS
- Converting ER diagram to table
- Properties of relational model
- Primary key and foreign key
- Relational model
- E-commerce use case
- Codd's rules
- Data integrity in RDBMS
- Database DesignW04
- Database design
- Redundancy
- Insertion anomaly
- Functional dependencies
- Closure set of attributes
- Lossy decomposition
- Dependency preserving
- Normalization
- Transitive dependency
- 3NF
- BCNF
- Multivalued dependency
- 5NF
- Comparison between Normal forms, OLTP, and OLAP
- SQL (Part 1)W05
- Discrete maths
- Relational Algebra and null values
- Relational calculus
- Characteristics of SQL
- Create a DB (example)
- SQL Constraints
- Foreign key
- SQL SELECT statement
- INSERT, DELETE statements
- Scalar and Aggregate functions
- HAVING clause
- SQL Aliases
- IN, BETWEEN operators
- EXISTS, ANY, ALL operator
- Auto increment
- MySQL best practices
- SQL (Part 2)W06
- JOIN-types
- JOIN examples
- String operators
- Compound queries
- SQL index
- SQL views
- Query optimization
- Security Risks
- NoSQLW07
- Introduction to NoSQL
- ACID
- Key value pair-based databases
- Search DB and Graph DB
- Advantages of NoSQL
- Introduction to MongoDB
- MongoBD BasicsW08
- Working with MongoDB
- CRUD Operations with examples
- Data Modelling in NoSQL
- One to One and One to Many relationships
- Advanced MongoDB queries
- Join, sort, group, and index
- RedisW09
- In memory DB
- Redis
- Key value store
- Cashing layer
- Datatypes
- Transaction
- Backup of data from Redis
- PL/SQLW10
- PL/SQL Basics
- Operators
- Record
- Recursive Functions
- Exception Handling
- Triggers
- More about DatabasesW11
- Transactions
- Concurrency control
- Isolation
- Consistency
- ACID
- Database lock
- Database lock types
- Lock Contention
- Deadlock
- Scaling the database
- Storage systems
- Database indexing
- Index types
- Distributed DB
- DB Replication
- Database sharding
- DB on Cloud
- Introduction to DatabasesW01
Industry projects2 projects
2 projects
you'll ship.
Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.
Scaling and Designing E-commerce Database
Scalability is key when deciding on your eCommerce platform. Your e-commerce website needs to be able to change and grow in order to meet demand. One of the critical components tha…
FeeOne fee.
One fee.
Everything included.
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
Premium
₹40,000
Inclusive of all charges- 1 Year Access
- Personalized Page
- Live Individual & Group Sessions
- Personalized & Hands-On
- Job-Oriented Industry Relevant Curriculum
Related
You might also like.
PG program · 24 weeksFull Stack Web Development→PG program · 16 weeksPre-Graduate Program in Full Stack Web Development→Course · 12 weeksData Structures and Algorithms using JAVA→Course · 12 weeksData Structures and Algorithms using Python→Course · 12 weeksThe Complete Front-End Development - 2.0→Course · 12 weeksIntroduction to Java Programming 2.0→
Next stepNot sure it's
Not sure it's
the right fit?
A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.