Description
Who this course is for:
This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts.
- SQL Enthusiasts
- Data Analysts
- Data Engineers
- Data Scientists
What you’ll learn
-
BASICS OF DATABASES
-
SQL CONSTRAINTS IN DETAILS
-
NORMALIZATION IN RDBMS EXPAINED PRACTICALLY
-
ANOMALIES IN NORMALIZATION AND SQL OPERATORS
-
IN-BUILT SQL FUNCTIONS : DATE, STRING, AGGREGATE, SPECIAL,CONVERSION FUNCTIONS
-
WINDOWS RANKING, AGGREGATE AND ANALYTICAL FUNCTIONS
-
ALL ABOUT JOINS IN DETAILS
-
SET OPERATORS AND DERIVED TABLES
-
SUBQUERY AND CORELATED SUBQUERY
-
COMMON TABLE EXPRESSIONS, MULTIPLE CTEs AND RECURSIVE CTES
-
SQL VIEWS
-
INLINE TABLE VALUED FUNCTIONS_SYNONYMS_AND_SEQUENCES
-
INDEXES IN SQL
-
MERGE STATEMENT AND PIVOT AND UNPIVOT
-
T-SQL PROGRAMMING
-
STORED PROCEDURES, EXCEPTION HANDLING, CURSORS
-
STORED FUNCTIONS
-
BASICS OF TRIGGERS and MANY MORE….
-
COVERED MANY REAL TIME SQL QUERIES ASKED IN INTERVIEWS
Reviews
There are no reviews yet.