Scribd
Upload
17 views

What Is SQL

This document outlines an SQL syllabus for a training course. The syllabus covers introductory topics such as database design, normalization, and ERD diagrams. It then covers SQL concepts like DDL, DML, and DCL statements; clauses and operators; joins; subqueries; CTEs; window functions; pivoting and unpivoting. The course aims to help students with jobs in data engineering, science, and analysis. It includes weekly challenges, a certification exam, and opportunities for job referrals. The trainer has over 5 years of database experience.

Uploaded by

sumasaikat7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views

What Is SQL

This document outlines an SQL syllabus for a training course. The syllabus covers introductory topics such as database design, normalization, and ERD diagrams. It then covers SQL concepts like DDL, DML, and DCL statements; clauses and operators; joins; subqueries; CTEs; window functions; pivoting and unpivoting. The course aims to help students with jobs in data engineering, science, and analysis. It includes weekly challenges, a certification exam, and opportunities for job referrals. The trainer has over 5 years of database experience.

Uploaded by

sumasaikat7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

ForumDE

SQL Syllabus
Beware ✌️

 Money and Skillset can buy you happiness for sure; you know SQL holding #1 position for so
many years to playing with data and still no other Query language beat it.
 Friendly advice 😊 -> believe in your trainer, he has very special plan for you to shine in
your job
 This course is specifically designed for Data Engineers, Data Scientist, Data Analyst, Data
Warehouse Developers, Database Administrator (Beginners), SQL Experts
 Syllabus is just for reference, there is always a scope for more
 SQL has so many flavors few are T-SQL, Oracle SQL, IBM DB2 SQL, NOSQL
 Software’s we use initially - SSMS, SQL Server, CMD
 Let’s deep dive in

Intro

 Database, Datawarehouse and Data Lake


 Type of databases
 RDBMS
 Logical Schema Designing
 Data modeling
 Star Schema
 Fact & Dimension table
 Normalization
 Normal Forms
 Sequence Diagram
 E-R Diagram
 Flowcharts
 Physical Database Design
 Business Constraints – Primary key, Foreign Key, Candidate Key, Composite Key, Surrogate
Key, Unique Key, Check, Default, Not Null
 Index- Clustered and Non-Clustered

SQL -> T-SQL/Oracle

 Download and Install SSMS, SQL Server


 SQL commands- DDL, DML, DCL, TCL
 Select, INSERT, Update, Delete, Merge, Create, Alter, Truncate, Rename, Grant, Revoke,
Commit, Rollback, Save point, Drop
 Query Execution sequence/Order
 Clause, Operators, Predicates in SQL
 LIKE, IN, LIMIT, TOP, CASE, INSTRING, SUBSTRING, AVERAGE, COUNT, MAX, MIN, SUM
UPPER, LOWER, EXIST, EXTRACT, Wild Card Operators Etc.
 SUBQUERIES - Nested Subqueries, Corelated Subqueries, Inline View
 JOINS – Self Join, Inner Join, Left Outer Join, Right Outer Join, Cross Join
Contact Us:-9608703348,7870970617
Website:- https://forumde.in/
ForumDE
SQL Syllabus
 SET Operators – Union, Union All, Minus, Intersect
 CTE (Common Table Expression)
 Window Function – Rank, Dense Rank, Row number, Lead, Lag, First Value, Last_Value,
Percent Rank
 Pivot and Unpivot
 Rollup, Cube, Grouping Sets
 Views, Materialized View

Few Highlights

 Interview Preparation
 Weekly code challenge
 Certification exam will be conducted after training
 Best candidate will be referred personally

🤷♂️ we rise by lifting others

Amit Kaushik (amit.kaushik@gbdrift.com, 9928864784)

 More than 5 years of exp in Database designing,


Development, Analytics, ETL, problem solving | ex-WNS Bengaluru
 Currently working in a reputed MNC and handling big data.
 Oracle DBA Certified Associates
 SQL Expert (1Z0-047)
 Python, Power BI

Contact Us:-9608703348,7870970617
Website:- https://forumde.in/

You might also like