Database Archives - Page 3 of 4

Updated on: 13th Oct 2020

PostgreSQL Tutorial

PostgreSQL is a popular relational database management system (RDBMS). Our PostgreSQL tutorial provides basic and advanced concepts of PostgreSQL. In this tutorial, we are going to learn all the topics of PostgreSQL language, such as create a database, drop a database, select database, select table, update a record, create a table, delete record, drop table, […]

Updated on: 12th Oct 2020

How to Download and Install SQL Server?

Ratings()

How to download SQL Server Setup Step 1) Go to URL: https://www.microsoft.com/en-in/sql-server/sql-server-downloads Microsoft provides two specialized free editions to work on MS SQL server: 1.Developer – It has all features which MS SQL server offers but we cannot use it in production. From the learning perspective, is it an ideal candidate to start. 2.Express: This […]

Updated on: 12th Oct 2020

Date Functions In SQL Server And MySQL Tutorial

Ratings()

SQL SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how […]

Updated on: 12th Oct 2020

SQL Server Tutorial

Ratings()

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. This tutorial explains some basic and advanced concepts of SQL […]

Updated on: 10th Oct 2020

SQL Applications Tutorial

Ratings()

SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it […]

Updated on: 10th Oct 2020

Full Join in SQL

Ratings()

Using Full Joins A FULL JOIN returns all the rows from the joined tables, whether they are matched or not i.e. you can say a full join combines the functions of a LEFT JOIN and a RIGHT JOIN. Full join is a type of outer join that’s why it is also referred as full outer […]

Updated on: 10th Oct 2020

SQL Command Cheat Sheet

Ratings()

SQL often called Structured Query Language is a declarative and multi-paradigm language that is the domain-specific language used for designing and managing data models to organize the data in relational model databases. SQL was designed by Donald Chamberlin and Raymond Boyce. SQL first appeared in the year 1974. SQL is static typing and strong discipline. […]

Updated on: 08th Oct 2020

Data Modelling

Ratings()

What is Data Modeling? The process of creating a model for the storage of data in a database is termed as data modeling. It is a theoretical presentation of data objects and associations among various data objects. Data modeling is a process of formulating data in an information system in a structured format. It helps […]

Updated on: 08th Oct 2020

Order By and Group By in SQL Tutorial

Ratings()

What is SQL? SQL stands for Structured Query Language. A query language is a kind of programming language that’s designed to facilitate retrieving specific information from databases, and that’s exactly what SQL does. To put it simply, SQL is the language of databases. That matters because most companies store their data in databases. And while […]

Updated on: 07th Oct 2020

Hibernate Interview Questions and Answers

Ratings()

If you’re looking for Hibernate 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 Hibernate has a market share of about $106,013 pa. So, You still have opportunity to move ahead in your career in Hibernate Developer. Mindmajix […]

Updated on: 07th Oct 2020

Data Modeling Interview Questions and Answers

Ratings()

Here I am going to share some Data Modeling interview questions and detailed answers based on my own experience during interview interactions in a few renowned IT MNCs. Below question-answers can be of your great help if you get a chance to face or take an interview on Data Modelling. 1. What Are the Three […]

Updated on: 05th Oct 2020

How To Start a Career in Database Administration?

Ratings()

Database Administration consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today’s organizations via their IT systems. The DBA is a critically important role in many of today’s […]

Updated on: 05th Oct 2020

Types Of SQL Indexes

Ratings()

Try to imagine this. Suddenly some very special friends turn up to your house for lunch or dinner. You want to show them your cooking skills. You do not need to worry as you have your mother’s big fat recipe book with you. All you need to do is,find out your favorite recipes from the […]

Updated on: 05th Oct 2020

Apache Solr Interview Questions and Answers

Ratings()

Apache Solr is a complete text-only platform that works as a search engine for various websites that basically used formats like HTTP and XML. Many organizations are in search of candidates that have immense knowledge along with adequate hands-on-training in this field. If you are looking for advancement in your career then the following Apache […]

Updated on: 05th Oct 2020

DB2 Interview Questions and Answers

Ratings()

Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object-relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form. DB2 is […]

PostgreSQL Tutorial

How to Download and Install SQL Server?

Date Functions In SQL Server And MySQL Tutorial

SQL Server Tutorial

SQL Applications Tutorial

Full Join in SQL

SQL Command Cheat Sheet

Data Modelling

Order By and Group By in SQL Tutorial

Hibernate Interview Questions and Answers

Data Modeling Interview Questions and Answers

How To Start a Career in Database Administration?

Types Of SQL Indexes

Apache Solr Interview Questions and Answers

DB2 Interview Questions and Answers

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