About Our Course:
Designed by Industry expert currently working as Senior Associate in Data Analytics at PWC. In this course we’ll start off with an introduction to types of Databases. Then we’ll learn DDL & DML Commands, domain constraints, Different types of Operations in SQL, Nested queries and more.
What you will learn ?
- Introduction to SQL
- DML & DDL Commands
- TCL and DCL and its Clauses
- Domain constraints and its uses
- Different types of operations in SQL
- Types of Joins
- Advantages and disadvantages of Joins
- Views, Triggers, Nested queries
- 1 Lectures
- Introduction to Database & pro's and con's Preview
- 4 Lectures
- In Depth understanding of DML, DDL
- In Depth Understanding of TCL, DCL and It's Clauses
- Domain Constraints and It's uses
- Domain Constraints Keys - Primary & Foreign keys
- 5 Lectures
- Different types of Operations on SQL
- Different types of Grouping Operations on SQL
- All types of Joins and It's Advantages & Disadvantages
- Ranking Functions - SQL
- Views, Triggers, Nested Queries - SQL
- 3 Lectures
- Assignment Questions
What Akhil Vydyula has to say:
B.Tech with the expertise in Data Analytics and Machine Learning. I am two times GCP (Google Cloud Platform) certified and Worked on BNFS & RLT,TMT domain projects. Experience in performing Descriptive, Predictive, and Prescriptive Analytics by employing various data mining techniques.
I'd love to help you for making your career as Data Analyst. Happy Learning !!
Learn Now Pay later
Any student can pass the Perfect eLearning scholarship test and avail the Learn Now, Pay Later facility.
The words of these guys are pure pleasure.