RELATED RECENT PLACEMENTS
Parthiban M
Riverstone
SRM TRP Engineering College
Kotesh Mogudala
Tata Autocomp Systems
Anurag University, Hyderabad
Vipin Jiwane
Orena Solutions
Walchand College of Engineering, Sangli
Chandrakumar ADEPU
Selec Control
Ganapathy Engineering College
Jiji M
Adrasti
Sreepathy Institute of Management And Technology (SIMAT)
Durga Prasad Sunnam
Adrasti
Ucet Technical school in Dokiparru, Andhra Pradesh
Pratik Mankar
Adrasti
B R Harne College Of Engineering
MAHATHIR MOHAMED
TATsunoInida Pvt ltd
K.S.K College of Engineering and Technology
Syllabus
This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects
Course Overview
- 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.
Course Syllabus
On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.
Week 01 - Introduction to Databases
- 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
Week 02 - Creating Database Tables
- Database design
- ER model
- Entity and attributes
- Entity relationships
- Cardinality ratio
- Generalization, specialization, and aggregation
- Case study of Ecommerce website
Week 03 - Introduction to RDBMS
- 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
Week 04 - Database Design
- 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
Week 05 - SQL (Part 1)
- 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
Week 06 - SQL (Part 2)
- JOIN-types
- JOIN examples
- String operators
- Compound queries
- SQL index
- SQL views
- Query optimization
- Security Risks
Week 07 - NoSQL
- Introduction to NoSQL
- ACID
- Key value pair-based databases
- Search DB and Graph DB
- Advantages of NoSQL
- Introduction to MongoDB
Week 08 - MongoBD Basics
- 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
Week 09 - Redis
- In memory DB
- Redis
- Key value store
- Cashing layer
- Datatypes
- Transaction
- Backup of data from Redis
Week 10 - PL/SQL
- PL/SQL Basics
- Operators
- Record
- Recursive Functions
- Exception Handling
- Triggers
Week 11 - More about Databases
- 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
Our courses have been designed by industry experts to help students achieve their dream careers
Industry Projects
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
Scaling and Designing E-commerce Database
Our courses have been designed by industry experts to help students achieve their dream careers
Ratings & Reviews by Learners
Skill-Lync has received honest feedback from our learners around the globe.
Flexible Pricing
Talk to our career counsellors to get flexible payment options.
INR 40,000
Inclusive of all charges
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
1 Year Accessto Skill-Lync’s Learning Management System (LMS)
Personalized Pageto showcase Projects & Certifications
Live Individual & Group Sessionsto resolve queries, Discuss Progress and Study Plans.
Personalized & Hands-OnSupport over Mail, Telephone for Query Resolution & Overall Learner Progress.
Job-Oriented Industry Relevant Curriculumavailable at your fingertips curated by Global Industry Experts along with Live Sessions.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
1 industry expert
Our instructors are industry experts along with a passion to teach.
10 years in the experience range
Instructors with 10 years extensive industry experience.
Areas of expertise
- Full Stack development
Similar Courses
Got more questions?
Talk to our Team Directly
Please fill in your number & an expert from our team will call you shortly.