Learn SQL from scratch to a professional with step by step guide from real-life scenario perspective
What you will learn
Use SQL to query database
Use SQL to optimize database performance
Perform database restore
Use SQL to perform data analysis
Use SQL for data insight extraction
Description
‘;
}});
Course Introduction
Introduction
Course Overview
Assumption
What is Database?
Database Engine
What is RDMS?
RDBMS in Brief
Database and Tools
Database Tools
Database Structure and Objects
Create First Database
Restore Database
Tables and Views
Database Tables
Constraints
3. Table – Insert Data
4. Table – Update, Delete, Select Data
Database Views
Comparison Expressions
Comparison Operators
SQL Statements Fundamentals
SQL Statement Drill-Down
SQL Aggregate
Aggregate Practice
JOINs
JOIN (Inner Join, Outer Join, Union etc)
SQL Server In-Built Function
In-Built Functions
Index
Introduction to Index
Create Index
Optimize Index
DB Programming – Stored Procedure and Functions
Introduction to Stored Procedure
Stored Procedure – Demo
Scalar-Valued Function
Table-Valued Function
Error Handling
SQL Transaction
Dynamic Query
Stored Procedure as Inner Routine
Conclusion and Lots More
Thank You and follow up
