{Learn-Intern-Certify}©

In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language. The basic unit in PL/SQL is called a block, which is made up of three parts: a declarative part, an executable part, and an exception-building part. Test your PL/SQL knowledge by solving following 49 MCQ'S Loading...

SQLite is embedded relational database management system. It is self-contained, serverless, zero configuration and transactional SQL database engine. SQLite is free to use for any purpose commercial or private. In other words, "SQLite is an open source, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application". SQLite is different from other SQL databases because unlike most other SQL databases, SQLite does not have a separate server process. It reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.  SQLite was designed by D. Richard Hipp for the purpose of no administration required for operating a program in 2000. SQLite Features Following is a list of features which makes SQLite popular among other lightweight databases: SQLite is open-source . License is not required to work wit...

Data Modeling Data modeling (data modelling) is the analysis of data objects and their relationships to other data objects. Data modeling is often the first step in database design and object-oriented programming as the designers first create a conceptual model of how data items relate to each other. Data modeling involves a progression from conceptual model to logical model to physical schema. MongoDB Data Modeling In MongoDB, data has a flexible schema . It is totally different from SQL database where you had to determine and declare a table's schema before inserting data. MongoDB collections do not enforce document structure. The main challenge in data modeling is balancing the need of the application, the performance characteristics of the database engine, and the data retrieval patterns. Following things must be consider while designing MongoBD data models Always design schema according to requirements . Perform join on write operations only not on read operations. Obj...

MongoDB MongoDB (from humongous) is a free and open-source cross-platform document-oriented database program . Classified as a NoSQL database program , MongoDB uses JSON-like documents with schemas. MongoDB is developed by MongoDB Inc. and is free and open-source, published under a combination of the GNU Affero General Public License and the Apache License. Any relational database has a typical schema design that shows number of tables and the relationship between these tables. While in MongoDB, there is no concept of relationship. Document Database A record in MongoDB is a document, which is a data structure composed of field and value pairs. MongoDB documents are similar to JSON objects. The values of fields may include other documents, arrays, and arrays of documents. Following is the example of MongoDB document  Following are some advantages of using document database Documents correspond to native data types in many programming languages. Embedded documents and...