Filter interviews by
Print numbers in pyramid shape patterns using SQL code.
Use a loop to iterate through rows and columns to print the numbers in pyramid shape.
Increment the numbers in each row to create the pyramid effect.
Consider the spacing and alignment to create a visually appealing pyramid pattern.
Use SQL JOIN to combine two tables and display information.
Use the JOIN keyword to combine tables based on a related column
Specify the columns you want to display in the SELECT statement
Use ON clause to specify the column used for joining the tables
SQL join types allow combining data from multiple tables based on a specified condition.
Inner Join: Returns rows that have matching values in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns all rows when there is a match in either left or right ta...
Code to sort array without sort function
Iterate through the array and compare each element with the rest to find the smallest element
Swap the smallest element with the first element in the unsorted portion of the array
Repeat the process for the remaining unsorted portion of the array until fully sorted
Object-oriented programming concepts that focus on classes, objects, inheritance, encapsulation, and polymorphism.
Classes: Blueprint for creating objects with attributes and methods.
Objects: Instances of classes that contain data and behavior.
Inheritance: Ability for a class to inherit attributes and methods from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Pol...
The four pillars of OOP are Encapsulation, Abstraction, Inheritance, and Polymorphism, essential for structured programming.
Encapsulation: Bundling data and methods, e.g., a class with private variables and public methods.
Abstraction: Hiding complex implementation details, e.g., using interfaces to define methods without exposing their logic.
Inheritance: Creating new classes from existing ones, e.g., a 'Dog' class...
Different types of joins in SQL include inner join, outer join, left join, right join, and full join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows from one table and only matching rows from the other table
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the...
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
DBMS stands for Database Management System, which is a software system that manages databases.
RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.
RDBMS uses SQL for queryi...
List is a collection of objects, string array is an array of strings, etc. Each has its own characteristics and uses.
List: dynamic collection of objects, can grow/shrink in size. Example: List<Integer> numbers = new ArrayList<>();
String array: fixed-size array containing strings. Example: String[] names = new String[3];
Array: fixed-size collection of elements of the same type. Example: int[] scores = n...
Key types in SQL include primary keys, foreign keys, unique keys, and composite keys.
Primary key: uniquely identifies each record in a table.
Foreign key: establishes a relationship between two tables.
Unique key: ensures that all values in a column are unique.
Composite key: combination of multiple columns to uniquely identify a record.
I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.
Online test for aptitude and technical questions which is quite easy you need above 12 marks i guess , only then you will be considered for technical interview
I believe practical experience and skill development are more valuable than pursuing higher education at this stage in my career.
I am currently focused on gaining hands-on experience in SQL development, which I believe is crucial for my career growth.
I have been actively participating in online courses and certifications to enhance my skills, such as completing a SQL Server certification.
Networking with industry profes...
I come from a close-knit family that values support, love, and shared experiences, which have shaped who I am today.
My parents have been married for over 30 years, providing a strong foundation of love and commitment.
I have one younger sister who is pursuing her degree in environmental science, and we often collaborate on projects.
Family gatherings are a big deal for us; we celebrate holidays with big dinners and games...
Object-oriented programming concepts that focus on classes, objects, inheritance, encapsulation, and polymorphism.
Classes: Blueprint for creating objects with attributes and methods.
Objects: Instances of classes that contain data and behavior.
Inheritance: Ability for a class to inherit attributes and methods from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorp...
Print numbers in pyramid shape patterns using SQL code.
Use a loop to iterate through rows and columns to print the numbers in pyramid shape.
Increment the numbers in each row to create the pyramid effect.
Consider the spacing and alignment to create a visually appealing pyramid pattern.
Code to sort array without sort function
Iterate through the array and compare each element with the rest to find the smallest element
Swap the smallest element with the first element in the unsorted portion of the array
Repeat the process for the remaining unsorted portion of the array until fully sorted
List is a collection of objects, string array is an array of strings, etc. Each has its own characteristics and uses.
List: dynamic collection of objects, can grow/shrink in size. Example: List<Integer> numbers = new ArrayList<>();
String array: fixed-size array containing strings. Example: String[] names = new String[3];
Array: fixed-size collection of elements of the same type. Example: int[] scores = new in...
SQL join types allow combining data from multiple tables based on a specified condition.
Inner Join: Returns rows that have matching values in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns all rows when there is a match in either left or right table.
S...
Key types in SQL include primary keys, foreign keys, unique keys, and composite keys.
Primary key: uniquely identifies each record in a table.
Foreign key: establishes a relationship between two tables.
Unique key: ensures that all values in a column are unique.
Composite key: combination of multiple columns to uniquely identify a record.
Use SQL JOIN to combine two tables and display information.
Use the JOIN keyword to combine tables based on a related column
Specify the columns you want to display in the SELECT statement
Use ON clause to specify the column used for joining the tables
Learn how to join two tables in SQL to retrieve related data effectively.
Use INNER JOIN to get records that have matching values in both tables. Example: SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.a_id;
Use LEFT JOIN to get all records from the left table and matched records from the right table. Example: SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.a_id;
Use RIGHT JOIN to get all records...
The four pillars of OOP are Encapsulation, Abstraction, Inheritance, and Polymorphism, essential for structured programming.
Encapsulation: Bundling data and methods, e.g., a class with private variables and public methods.
Abstraction: Hiding complex implementation details, e.g., using interfaces to define methods without exposing their logic.
Inheritance: Creating new classes from existing ones, e.g., a 'Dog' class inhe...
I appeared for an interview in Jan 2024.
Online mcqs based on maths and oops, DBMS, SQL
I am a passionate SQL Developer with expertise in database management, data analysis, and performance optimization.
Over 5 years of experience in SQL development and database design.
Proficient in writing complex SQL queries for data extraction and reporting.
Experience with performance tuning and optimization of SQL queries.
Worked on projects involving data migration and ETL processes.
Strong understanding of relational d...
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
DBMS stands for Database Management System, which is a software system that manages databases.
RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.
RDBMS uses SQL for querying an...
Different types of joins in SQL include inner join, outer join, left join, right join, and full join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows from one table and only matching rows from the other table
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left...
SQL commands are used to interact with databases, such as SELECT, INSERT, UPDATE, DELETE.
Common SQL commands include SELECT, INSERT, UPDATE, DELETE.
SELECT is used to retrieve data from a database.
INSERT is used to add new records to a table.
UPDATE is used to modify existing records in a table.
DELETE is used to remove records from a table.
There are 2 portions in this round .for 1st 30 min , 20 multiple choice question based on quantitative and logical skills and second section is on DBMS , OOP , Sql Queries
I applied via Recruitment Consulltant and was interviewed in Jul 2023. There were 4 interview rounds.
Easy to medium Questions which contain Aptitude + Technical questions
Group Discussion on random topic was done among 25-30 people
Ci/cd pipeline automates the process of building, testing, and deploying code changes.
Automates code integration, testing, and deployment
Ensures consistency and reliability in software delivery
Facilitates faster feedback loops for developers
Examples: Jenkins, GitLab CI/CD, Azure DevOps
I applied via Referral and was interviewed in Oct 2023. There were 3 interview rounds.
Its general aptitude with 45min duration and 45 questaions
I applied via Job Portal and was interviewed in Sep 2023. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.
Experienced SQL Developer with a passion for data analysis and problem-solving.
Over 5 years of experience in SQL development
Proficient in writing complex queries and optimizing database performance
Skilled in data modeling and database design
Strong problem-solving skills and attention to detail
Previous projects include developing ETL processes for data migration
Yes, I am ready for WFO (Work From Office)
I am prepared to work from the office location
I have the necessary tools and resources to work effectively in the office
I am familiar with the office environment and protocols
I am ready to collaborate with team members in person
I applied via Job Portal and was interviewed before Dec 2023. There were 2 interview rounds.
Aptitude questions like train calender etc.
I applied via Referral and was interviewed before Aug 2022. There were 4 interview rounds.
Basic Aptitude questions , 25 questions
You would be given SQL scenario questions and ask to write queries.
Top trending discussions
The duration of Yardi Systems SQL Developer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 10 interview experiences
Difficulty level
Duration
based on 4 reviews
Rating in categories
Software Engineer
328
salaries
| ₹4.5 L/yr - ₹9.6 L/yr |
Software Analyst
278
salaries
| ₹5.5 L/yr - ₹12.4 L/yr |
Senior Software Analyst
155
salaries
| ₹6.2 L/yr - ₹15.5 L/yr |
Compliance Auditor
80
salaries
| ₹2.9 L/yr - ₹5.7 L/yr |
Audit Specialist
74
salaries
| ₹2 L/yr - ₹4.9 L/yr |
KPIT Technologies
Thomson Reuters
HighRadius
Oracle Cerner