Database Archives - Page 4 of 4

Updated on: 05th Oct 2020

SQL Interview Questions and Answers

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. SQL is the standard language for the Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database […]

Updated on: 30th Sep 2020

DBMS vs RDBMS vs NoSQL

Ratings()

What is Data? It is a piece of information. Example: Name of the Person, Age, Employee ID giving the information about a particular person What is a DataBase? The Database is a term which is a collection of Data, Database used to Store and Manipulate the Data. Let’s have an Example WhatsApp when we are […]

Updated on: 29th Sep 2020

Apache Cassandra Interfaces Tutorial

Ratings()

Introduction In this Apache Cassandra tutorial, you will learn Cassandra from the basics to get a fair idea of why Cassandra is such a robust NoSQL database system. Cassandra is basically a high performance, high availability and highly scalable distributed database that works well with structured, semi-structured and unstructured data. For structured data we have […]

Updated on: 27th Sep 2020

MongoDB Interview Questions and Answers

Ratings()

If you’re looking for MongoDB Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research MongoDB has a market share of about 4.5%. So, You still have the opportunity to move ahead in your career in MongoDB Development. ACTE […]

Updated on: 26th Sep 2020

mysql workbench tutorial

Ratings()

What Is MySQL? MySQL is an open-source relational database management system, which works on many platforms. It provides multi-user access to support many storage engines. MySQL has various features that enable us to do many tasks such as comprehensive application development, providing availability and scalability. Now, obviously, when you work at an industry level, you […]

Updated on: 26th Sep 2020

Apache Cassandra Architecture Tutorial

Ratings()

Cassandra is a distributed database from Apache that is highly scalable and designed to manage very large amounts of structured data. It provides high availability with no single point of failure. The tutorial starts off with a basic introduction of Cassandra followed by its architecture, installation, and important classes and interfaces. Thereafter, it proceeds to […]

Updated on: 25th Sep 2020

Cassandra Vs MongoDB

Ratings()

When it comes to NoSQL databases, MongoDB and Cassandra may seem similar but are quite different. Both have similar use cases, but are not intended for transactional data (i.e., accounting systems). Who Uses These Databases? In the case of Cassandra vs MongoDB, both have a strong following with big names using each one. Cassandra: Cassandra, […]

Updated on: 25th Sep 2020

SQL Server DBA Interview Questions and Answers

Ratings()

SQL is one of the most commonly used databases today. If you’re interviewing for certain IT jobs, like database administrator (DBA), knowledge of SQL may be required. It’s important to think about how to show that knowledge to portray yourself as the best candidate for the job. A database administrator is responsible for a wide […]

Updated on: 25th Sep 2020

NoSQL Database Tutorial

Ratings()

What is NoSQL Database? NoSQL Database is a non-relational Data Management System that does not require a fixed schema. It avoids joins, and is easy to scale. The major purpose of using a NoSQL database is for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. […]

Updated on: 25th Sep 2020

Data Manipulation in SQL Tutorial

Ratings()

DML stands for Data Manipulation Language.It is a language used for selecting, inserting, deleting and updating data in a database.It is used to retrieve and manipulate data in a relational database.DML performs read-only queries of data. What is Data Manipulation A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, […]

Updated on: 25th Sep 2020

SQL Server Reporting Services (SSRS) Tutorial

Ratings()

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and […]

Updated on: 22nd Sep 2020

Different types of Joins in SQL Server

Ratings()

This article will provide an overview of the SQL Join and cover all of the SQL join types including inner, self, cross and outer. For inner joins we’ll be discussing Equi and Theta joins. The ability to combine results from related rows from multiple tables is an important part of relational database system design. In […]

Updated on: 22nd Sep 2020

What is SSRS?

Ratings()

SSRS SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graphs, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services […]

Updated on: 21st Sep 2020

Schema in SQL

Ratings()

A schema in a SQL database is a collection of logical structures of data. The schema is owned by a database user and has the same name as the database user. From SQL Server 2005, a schema is an independent entity (container of objects) different from the user who creates that object. In other words, […]

SQL Interview Questions and Answers

DBMS vs RDBMS vs NoSQL

Apache Cassandra Interfaces Tutorial

MongoDB Interview Questions and Answers

mysql workbench tutorial

Apache Cassandra Architecture Tutorial

Cassandra Vs MongoDB

SQL Server DBA Interview Questions and Answers

NoSQL Database Tutorial

Data Manipulation in SQL Tutorial

SQL Server Reporting Services (SSRS) Tutorial

Different types of Joins in SQL Server

What is SSRS?

Schema in SQL

Course Enquiry

Chennai

Bangalore

Online

Corporate Training

Student | Trainer Support

Velachery

Tambaram

OMR

Porur

Anna Nagar

T. Nagar

Thiruvanmiyur

Siruseri

Maraimalai Nagar

Electronic City

BTM Layout

Marathahalli

Rajaji Nagar

Jaya Nagar

Kalyan Nagar

Indira Nagar

HSR Layout

Hebbal