Email: online@course.in
Main Road
SQL INTERVIEW PREPARATION COURSE
SQL Professional Course
Job Aspirants
Online and Classroom Sessions
Week Days and Week Ends
30 to 45 days
•Understand the concepts in SQL
•Work with standard programming skills in SQL.
•You will learn basics of programming in SQL
•How to create your own SQL components from scratch.
•Learn or brush up with the basics of SQL
•Learn to design and run complex automated workflows for SQL
•Learn all the hooks and crooks of SQL at your pace.
•Learn SQL the Fast and Easy Way With This Popular Bundle Course!
•Learn how to code in SQL This SQL Course is set up for complete beginners!
•
•Free Aptitude classes & Mock interviews
•Exercises and handouts after every session
•Job Placement Assistance with Good Companies
•We Provide the Course Certificate of completion
•Assignments and test to ensure concept absorption.
•Hands On Experience – will be provided during the course to practice
•Training time : Week Day / Week End – Any Day Any Time – Students can come and study
•The course is all about familiarizing the trainees with simpler and smarter ways to develop the skills required for Implementation.
•
•CNC Engineer, Software Developer, Testing Engineer, Implementation, Core Java, Struts, hibernate, Asp.net, c#, SQL Server, CNC Programming, backETL Developer, Informatica MDM, SAP BO, SAP HANA, Oracle Apps Functional Finance, Finance Modules, 11i, R12, Oracle Apps, Oracle Apps DBA, EBusiness Suite
•Java Fullstack Developer, Java, Javascript, Data Structures, OOPS, Cassandra, NoSQL, Big Data, CI, XSLT, Maven, XML, Web Services, Microservices, SQL, Rest
•python, django, aws, Data Analytics, Full Stack Developer, Front End, ui/ux design, Ui Development, User Interface Designing, Jquery, Javascript
•Software Engineer, Business Operational Analyst, Project Manager, Software Test Engineer, Android Developers, HTML5 Developers, IT Help Desk, IT Freshers
•
Introduction
•About the course
•Why we are learning SQL
•Difference between Relational Algebra and SQL
•Various DBMS softwares
•Table Creation
•Create table
•Inserting tuples to table
•Constraints in SQL
•NOT NULL Constraint
•Unique constraint
•Primary Key Constraint
•Foreign Key Constraint
•Check Constraint
•Default Constraint
•Referential Trigger Actions
•How to use Referential Trigger Actions 1
•How to use Referential Trigger Actions 2
•Data Retrieval using SELECT-FROM-WHERE
•Select-From-Where Explained
•Inner Join without using Join Keyword in query
•Aliasing in SQL
•Aliasing explained
•Where to use Aliasing
•DISTINCT and ALL in SQL
•Difference between Distinct and All
•Set Operations in SQL
•Union of tables in SQL
•Intersect and Except in SQL
•Pattern Matching in SQL
•LIKE operator and Wildcards in SQL
•Concatenation , Between and Order By in SQL
•Concatenation in SQL
•Between in SQL
•Order By Clause in SQL
•Dealing with NULL values in SQL
•Arithmetic Operations in SQL query
•Dealing with NULL values while performing arithmetic operations
•Dealing with NULL values while performing comparison operations
•Dealing with NULL values while performing logical operation AND
•Dealing with NULL values while performing logical operations OR and NOT
•Dealing with NULL values while performing Join
•Aggregate Functions in SQL
•Aggregate Functions
•Dealing with NULL values while performing Aggregate Functions
•Group By Clause and Having Clause in SQL
•Group By clause explained with example
•More than one attribute in group by clause
•Having Clause in SQL
•Another Example on Group By Clause
•Another Example on Having Clause
•Connectives in SQL
•IN Operator
•NOT IN and dealing with NULL values
•Comparison using ANY,SOME,ALL
•Non Correlated Nested Queries in SQL
•Non Correlated Nested queries explained
•Non Correlated Nested Queries Explained 2
•Example on Non correlated Nested query
•Correlated Nested queries in SQL
•Correlated Nested queries explained
•Correlated Nested queries explained 2
•Correlated Nested Queries explained 3
•Correlated Nested Queries explained 4
•Correlated Nested Queries explained 5
•
© 2018 Digitalalice. Powered by Digitalalice