ANSI SQL Concepts
• Writing SQL from scratch
• Writing queries for realtime data
• SQL Commands DDL, DML, DQL, TCL, DCL
• Writing query to create, rename, delete table and fields
• Column and Table Alias
• UNION
• UNION ALL
• SQL Joins
• Inner Join
• Left Outer Join
• Right Outer Join
• Constraints
• Primary Key
• Unique Key
• Foreign Key
• Difference between Primary Key vs Unique Key
• Difference between Primary Key vs Foreign Key
• Default Constraint
• Check Constraint
• Distinct
• Date & Time functions
• Text Functions
• Math Functions
What is special in this course compare to other trainers?
• 26+ Years real-time experienced trainer.
• Teaching from the basic to advanced topic in methodological way.
• SQL queries will be practically explained with different RDBMS MySQL, MSSQL, Oracle servers
• All concept are explained with realtime data
• On spot practice
• Assignment for each concepts
• Online objective type test to check your knowledge
• Each query concept will be explained in step by step in depth.
• Interview tips
Who should take up SQL course?
Software Engineers and Data Analysts
Business Intelligence Professionals
SAS Developers wanting to learn the SQL
Those aspiring for a career in Data Science
What are the prerequisites?
No prior knowledge of SQL. Basic computer knowledge and installing software is required.