UrbanPro
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

true
true

Database management system

No Reviews Yet

Albatia, Agra

Course ID: 371064

Albatia, Agra

Students Interested 0 (Seats Left 0)

₹ 6,000

No Reviews Yet

About the Course

It will cover all the GATE concepts of DBMS and you can expect a deep understanding of database from this course. It will cover 


Unit–I


Introduction to Databases and TransactionsWhat is database system, purpose of database system, view of data, relationaldatabases, database architecture, transaction management,


Unit-II


Data ModelsThe importance of data models, Basic building blocks, Business rules, The evolutionof data models, Degrees of data abstraction.


Unit-III


Database Design ,ER-Diagram and Unified Modeling LanguageDatabase design and ER Model:overview, ER-Model, Constraints, ER-Diagrams, ERDIssues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UMLRelational database model:Logical view of data, keys, integrity rules.Relational Database design: features of good relational database design, atomicdomain and Normalization (1NF, 2NF, 3NF, BCNF).


Unit-IV


Relational Algebraand CalculusRelational algebra: introduction, Selection and projection, set operations, renaming,Joins, Division, syntax, semantics. Operators, grouping and ungrouping,relationalcomparison.Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra,computational capabilities.


Unit-V


Constraints, Views and SQLWhat is constraints, types of constrains, Integrity constraints,Views: Introduction to views, data independence, security, updates on views,comparison between tables and viewsSQL: data definition, aggregate function, Null Values, nested sub queries, Joinedrelations. Triggers.


Unit-VI


Transaction management and ConcurrencycontrolTransaction management: ACID properties, serializability and concurrency control,Lock based concurrency control (2PL, Deadlocks),Time stamping methods,optimistic methods, database recovery management. 

Date and Time

Not decided yet.

About the Trainer

Nagendra Singh picture

Avg Rating

0 Reviews

0 Students

1 Courses

Nagendra Singh

M.Tech

1 Years of Experience

I am pursuing m.tech in computer science at IIT Jodhpur. I have cleared GATE in CS with 98.14 percentile ( AIR 1850 ). And have 1 year of experience as a teaching assistant for Artificial Intelligence, machine learning for postgraduates, data structure and Python Programming for undergraduates at IIT Jodhpur.

Reviews

No reviews currently Be the First to Review

Discussions

Nagendra Singh picture

Nagendra Singh

No Reviews Yet

Students Interested 0 (Seats Left 0)

₹ 6,000

Post your requirement and let us connect you with best possible matches for BTech Tuition Post your requirement now

Enquire

Submit your enquiry for Database management system

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Nagendra

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Register for Free Master Class

BTech Tuition

tickYou have successfully registered

Nagendra Singh picture

Nagendra Singh

No Reviews Yet

Class Scheduled at

,

- hour

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more