Twenty19

Login or Create Your Twenty19 Account


New to Twenty19? No Worries. Register for free!

Database Management Systems

Rs 2999

100%

21 Reviews

Whatever Programming language or platform you may be working on, a sound database knowledge is what you always need. Database as a technology is high in demand technology with exciting new products being launched rapidly along with good job prospects. In this course you will learn about Databases, RDBMS - SQL, NoSQL, OLAP Databases, MongoDB!

  • Learn Anytime/Anywhere
  • Clear your doubts
  • Project Based
  • Get Certificate

Buy "Database Management Systems"

Rs 2999 Have a Coupon Code ? Click 'Pay Online' & login to apply coupon code

pay online

or

Pay by DD/Cheque

Call us on 09962033243 in case of any difficulties.

  • Step 1 Buy this course by making an online or an offline payment

  • Step 2 Access the course anytime, anywhere, learn, practice, evaluate, clear your doubts & track your progress

  • Step 3 Complete the course & get Twenty19 Certificate

Buy & Start Training or Free Demo

571 views
  1. Chapter 1

  2. Chapter 2

  3. Chapter 3

    • 3.1 - Joins
    • 3.2 - SQL Functions and Views
  4. Chapter 4

    • 4.1 - NoSQL Overview
    • 4.2 - NoSQL Categories
    • 4.3 - No SQL Categories continued
    • 4.4 - Benefits of NoSQL, Scaling, Sharding, Replication
    • 4.5 - OLAP and OLTP
    • Quiz 2
  5. Chapter 5

  6. Chapter 6

    • 6.1 - Commercially Successful RDBMS
    • 6.2 - Criteria For RDBMS Selection
    • 6.3 - RDBMS vs. NoSQL Summary
    • Quiz 4
  • About this Training

    In this course you will learn about the concepts of DBMS, RDBMS, NoSQL, OLAP & OLTP with Real World Examples. You will do hands on SQL on your onw installed SQLITE system, you will create your own playground on MongoDB. You will also learn the tips and tricks on SQL tuning and performance tuning.
    This course would help build concept clarity using REAL WORLD EXAMPLES and foundation for strong programming skills

  • Project in this Training

    1.Create Real time Business Queries for a e-commerce book store on the SQLite Installation to query order details, book details etc. and import/export data using JOINS, Functions and Views
    2. Create CRUD operations on a MongoDB installation for an Employee database and perform Data Insert actions using CSV file and JSON file.

  • Clear your Doubts

    You can ask all the questions in 'Clarify your Doubts' forum anytime, course experts will answer all your questions.

  • Get Certificate

    Receive an E-certificate from us once you complete the course. You can Download the Certificate from your Twenty19 account and also showcase it to your friends and family.

MORZILLA not working

asked by Anumayank.

No Answers yet

how to download and open sqlite manager

asked by nagapurisai vishal

You can download it from
https://sourceforge.net/projects/sqlitemanager/

To open it:
Right click on the top of the Firefox, and choose customize.
Then look for the SQLite icon, drag it to toolbar. Click on the icon to use it.

answered by , [ Jun, 2016 ]

not getting not clear i didn't downloaded

answered by nagapurisai vishal, [ Jun, 2016 ]

Hi,

Are you referring to the project mentioned in this course, or some other. also what would be your objective of doing the project.

Thanks
Chhavi

answered by , [ Sep, 2015 ]

2.2. What is a trigger and an index?

asked by YashKothari

Sorry its from 2.3

answered by YashKothari, [ Jul, 2015 ]

Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are, in fact, written to be executed in response to any of the following events:

A database manipulation (DML) statement (DELETE, INSERT, or UPDATE).

A database definition (DDL) statement (CREATE, ALTER, or DROP).

A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).

Triggers could be defined on the table, view, schema, or database with which the event is associated.

Benefits of Triggers
Triggers can be written for the following purposes:

Generating some derived column values automatically

Enforcing referential integrity

Event logging and storing information on table access

Auditing

Synchronous replication of tables

Imposing security authorizations

Preventing invalid transactions

Indexes
Why is it needed?

When data is stored on disk based storage devices, it is stored as blocks of data. These blocks are accessed in their entirety, making them the atomic disk access operation. Disk blocks are structured in much the same way as linked lists; both contain a section for data, a pointer to the location of the next node (or block), and both need not be stored contiguously.

Due to the fact that a number of records can only be sorted on one field, we can state that searching on a field that isn’t sorted requires a Linear Search which requires N/2 block accesses (on average), where N is the number of blocks that the table spans. If that field is a non-key field (i.e. doesn’t contain unique entries) then the entire table space must be searched at N block accesses.

Whereas with a sorted field, a Binary Search may be used, this has log2 N block accesses. Also since the data is sorted given a non-key field, the rest of the table doesn’t need to be searched for duplicate values, once a higher value is found. Thus the performance increase is substantial.

What is indexing?

Indexing is a way of sorting a number of records on multiple fields. Creating an index on a field in a table creates another data structure which holds the field value, and pointer to the record it relates to. This index structure is then sorted, allowing Binary Searches to be performed on it.

The downside to indexing is that these indexes require additional space on the disk, since the indexes are stored together in a table using the MyISAM engine, this file can quickly reach the size limits of the underlying file system if many fields within the same table are indexed.

answered by , [ Jul, 2015 ]

Difference between char and varchar?

asked by YashKothari

CHAR

Used to store character string value of fixed length.

The maximum no. of characters the data type can hold is 255 characters.

It's 50% faster than VARCHAR.

Uses static memory allocation.

VARCHAR
Used to store variable length alphanumeric data.

The maximum this data type can hold is up to Pre-MySQL 5.0.3 :: 255 characters. In MySQL 5.0.3+ :: 65,535 characters shared for the row.

It's slower than CHAR.

Uses dynamic memory allocation.

answered by , [ Jul, 2015 ]

GROUP BY CLAUSE

asked by MohitBanerjee

GROUP BY lets you use aggregate functions, like AVG, MAX, MIN, SUM, and COUNT. Other hand DISTINCT just removes duplicates.

For example, if you have a bunch of purchase records, and you want to know how much was spent by each department, you might do something like:

SELECT department, SUM(amount) FROM purchases GROUP BY department
This will give you one row per department, containing the department name and the sum of all of the amount values in all rows for that department.


Because GROUP BY implicitly does a DISTINCT over the values of the column you're grouping by

answered by , [ Jun, 2015 ]

More Normalizing Examples

asked by MohdMonis

Hi..You want to know about a particular normalization technique in detail or for any specific database?

answered by Twenty19Expert Team, [ Nov, 2014 ]

DBA

asked by VijayKumar

Go to this link and you will find various Oracle certifications you can get. http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=651&intcmp=WWOUCERTTOPBAN2ADVCAR

answered by Twenty19Expert Team, [ Jul, 2014 ]

Can I download the videos & learn?

You can re-watch the videos as many times you wish but we do not allow downloading on our platform as we keep track of your progress in regards to the course you learn.

What is special about Twenty19 courses?

Twenty19 Training are fun to learn and they are structured to be easily understood by anyone.The courses are developed with College students in mind.So courses will have a lot of real world examples and Twenty19 courses are easy to take up and earn a certificate.

If I have any doubt while learning, How can I clear my doubts?

You can raise your doubt in Clear your doubts forum anytime, training experts will answer all your questions. You can also reach us at +91 9962033243 (give us a missed call), send an SMS or drop an email to trainings@twenty19.com, one of our team member will call you to support.

Is it safe to use my debit/credit card for making the payment?

No doubt, Your transaction is always safe and secure with Twenty19.

Do I get a certificate of completion?

Yes!! you will receive an E-certificate from us once you complete the training. You can include this is in your Resume to get placed better.

How will I receive the certificate?

Twenty19 certificates will be emailed to your Twenty19 registered Email ID .The very next day of your training completion you will be receiving the certificate.You can download and print your certificate.

Have Questions? Get in touch with us

Call
+91 9962033243

Email
trainings@twenty19.com

This is a Free Demo for "Database Management Systems" Course

Experience this course with few video lessons rightaway!

Start Learning

Live Trainings Feed

Latest Questions in Forum

Suggest a new Training

Teach

Are you an expert in your industry & are passionate about teaching? Join us!

create a training


This feature is not available during Free Demo. Purchase the course to access

Purchase "Database Management Systems"


Buy & Start Learning

Send me amazing internships by email

Confirmation email has been sent to your email address. Please click on "Confirm to get Internship alerts" button in the email.
Please provide a valid email address.
There were some issues. Please try again later.

Close