Overview

I have conducted more than 100+ Interviews.Most importantly I myself attended 30+ interviews and kept the interview questions from different Interviewers.That will be big boast to understand how different interviewer asked questions and what are the frequently asked questionsThere are some tough queries / tricks so If you learn them mostly tough queries can be answeredApproximately 3 hours of lecture dedicated to write variety of SQL queriesIf you are preparing for SQL Interview or an ETL developers add punch being a ETL + SQL pro-developer and answer most of SQL questionsThere are around 150+ mostly asked questions from simple to expert level are discussed. It also includes 12CLearn SQL from an Architect who worked 19+ years in SQL.An Oracle Certified Professions (OCP)Oracle Technology Network (OTN) Points: 12,975 Level: MasterJoin the course and learn the important aspects and practical details of SQL and clear the interview with easeI have kept related questions together so that one can easily memorize.See you in the Class.Course covered:Relational Database conceptsExplaining the theoretical and physical aspects of a relational databaseRelating clauses in SQL Select Statement to Components of an ERDExplaining the relationship between a database and SQLRestricting and Sorting DataApplying Rules of precedence for operators in an expressionLimiting Rows Returned in a SQL StatementUsing Substitution VariablesUsing the DEFINE and VERIFY commandsSorting DataUsing Conversion Functions and Conditional ExpressionsApplying the NVL, NULLIF, and COALESCE functions to dataUnderstanding implicit and explicit data type conversionUsing the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNesting multiple functionsDisplaying Data from Multiple TablesUsing Self-joinsUsing Various Types of JoinsUsing Non equijoinsUsing OUTER joinsUnderstanding and Using Cartesian ProductsUsing SET OperatorsMatching the SELECT statementsUsing the ORDER BY clause in set operationsUsing The INTERSECT operatorUsing The MINUS operatorUsing The UNION and UNION ALL operatorsManaging Indexes Synonyms and SequencesManaging IndexesManaging SynonymsManaging SequencesManaging ViewsManaging ViewsManaging Objects with Data Dictionary ViewsUsing data dictionary viewsRetrieving Data using the SQL SELECT StatementUsing Column aliasesUsing The SQL SELECT statementUsing concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keywordUsing Arithmetic expressions and NULL values in the SELECT statementUsing Single-Row Functions to Customize OutputManipulating strings with character functions in SQL SELECT and WHERE clausesPerforming arithmetic with date dataManipulating numbers with the ROUND, TRUNC and MOD functionsManipulating dates with the date functionReporting Aggregated Data Using Group FunctionsRestricting Group ResultsCreating Groups of DataUsing Group FunctionsUsing Subqueries to Solve QueriesUsing Single Row SubqueriesUsing Multiple Row SubqueriesUpdate and delete rows using correlated subqueriesManaging Tables using DML statementsManaging Database TransactionsControlling transactionsPerform Insert, Update and Delete operationsPerforming multi table InsertsPerforming Merge statementsUse DDL to manage tables and their relationshipsDescribing and Working with TablesDescribing and Working with Columns and Data TypesCreating tablesDropping columns and setting column UNUSEDTruncating tablesCreating and using Temporary TablesCreating and using external tablesManaging ConstraintsControlling User AccessDifferentiating system privileges from object privilegesGranting privileges on tablesDistinguishing between granting privileges and rolesManaging Data in Different Time ZonesWorking with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMPWorking with INTERVAL data types

Skills

Reviews