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
Overview

What you'll
be able to do.

Everything about Database 2.0 is an online course from Skill-Lync: 12 weeks, 19 hours of content and 2 industry projects.

  • 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.
Curriculum

11 modules,
built with industry.

  1. 01Everything about Database 2.011 modules
    1. 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
    2. Creating Database TablesW02
      • Database design
      • ER model
      • Entity and attributes
      • Entity relationships
      • Cardinality ratio
      • Generalization, specialization, and aggregation
      • Case study of Ecommerce website
    3. 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
    4. 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
    5. 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
    6. SQL (Part 2)W06
      • JOIN-types
      • JOIN examples
      • String operators
      • Compound queries
      • SQL index
      • SQL views
      • Query optimization
      • Security Risks
    7. NoSQLW07
      • Introduction to NoSQL
      • ACID
      • Key value pair-based databases
      • Search DB and Graph DB
      • Advantages of NoSQL
      • Introduction to MongoDB
    8. 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
    9. RedisW09
      • In memory DB
      • Redis
      • Key value store
      • Cashing layer
      • Datatypes
      • Transaction
      • Backup of data from Redis
    10. PL/SQLW10
      • PL/SQL Basics
      • Operators
      • Record
      • Recursive Functions
      • Exception Handling
      • Triggers
    11. 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
Industry 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.

Designing an E-commerce Database

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…

Scaling and Designing E-commerce Database

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…

Learner stories

Learners from Skill-Lync's computer science programs.
In their own words.

Video stories from learners of related computer science programs, from Skill-Lync's YouTube channel.

Pravesh ShrivastavaPGP in Data Science / PG Program in Data Analytics & Data Science
Sumathi SrinivasanOla ElectricPG Program in Data Analytics and Data Science
VijayMIS Executive, Ola ElectricPG Program in Data Analytics & Data Science
NishaPG Program in FSD
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
Check eligibility →
Next step

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.

Get the syllabus + a call back

We'll email the full syllabus and call within one working day.

By submitting you agree to our Terms and Privacy Policy.

Call usEnquire
Talk to a career counsellor

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.