Sollicitatievraag bij Yardi Systems
All basic Core SQL, such as DDL: CREATE, ALTER, DROP, TRUNCATE DML: INSERT, UPDATE, DELETE DQL: SELECT WHERE, ORDER BY, DISTINCT LIMIT / OFFSET Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) GROUP BY & HAVING JOINS: INNER, LEFT, RIGHT, FULL Subqueries (Scalar, Correlated, Nested) UNION, UNION ALL NULL handling (IS NULL, IFNULL / COALESCE) Indexes Views SQL Keys and some advanced such as Create function, create store procedure, performance tuning, Difference between function Vs Store procedure, 2nd Highest salary, department highest SQL Datatype and constraint management According to your answered they raised questions difficulties
Antwoord op sollicitatievraag
Anoniem
Always try to answer with simple theory and a easy example. Sometimes the explanation may not be perfectly theoretical, but the example should help answer the interviewer’s question clearly.