Skip to main content

#SQL Developer Full Stack

A SQL Full Stack Developer is skilled in both backend and frontend development with a strong foundation in databases. They design and manage complex SQL queries, stored procedures, and database structures for data-driven applications. This versatile role is in high demand for building complete, end-to-end software solutions across industries.

Power BI SQL School Modules

Training Schedules

S NoTime (IST, Mon - Fri)Start Date
16 AM - 7 AMSep 30th
28 PM -9 PMSep 22nd
Linked in Sai Phanindra
SQL Developer Fullstack Training Highlights

SQL Developer
Training Course Contents:

Brochure DownloadRegister Now

Module 1: MSSQL & TSQL Queries

Ch 1: SQL SERVER INTRODUCTION

  • Database Introduction
  •  Types of Databases
  •  Need for & ETL, DWH
  •  BI Implementations
  •  SQL Server Advantages
  •  Version, Editions of MSSQL
  •  Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

  • SQL Server 2022, 2019
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

  • Need for Merge in ETL
  • Incremental Loads with SQL
  • MERGE and RANK Functions
  • Window Functions, Partition
  • Identify, Remove Duplicates

Ch 14: Grouping & Cube

  • Group By & HAVING
  • Cube, Rollup & Grouping
  • Joins with Group By
  • 3 Table, 4 Table Joins
  • Query Execution Order

Ch 15: Self Joins, Excel Analysis

  • Self Joins & Self References
  •  UNION, UNION ALL
  •  Sub Queries with Joins
  •  IIF, CASE, EXISTS Statements
  •  Excel Analytics, Pivot Reports

Module 2: Query Tuning

Ch 16: Query Audits, Perfmon

  • Query Performance Issues
  • Reasons for Slow Queries
  • Performance Tuning Options
  • Performance Tuning Tools
  • Query Store & History
  • Activity Monitor, Perfmon
  • DMVs & DMFs for Audits

Ch 17: Indexes & Tuning

  • Indexes : Sort Locations
  • Clustered & Online Indexes
  • Non Clustered, Columnstore
  • Included Indexes in Realtime
  • Filtered Indexes & Usage
  • Covering Index & Selectivity
  • Indexed Views (Materialized)

Ch 18: Partitions, Statistics

  • Partition Implementations
  • Partition Functions & Schemes
  • Primary & Secondary Types
  • Data Archival with Partitions
  • Compression with Partitions
  • Statistics : Realtime Use
  • Index, Column Stats, Updates

Ch 19: Tuning Tools, Exec Plans

  • Tuning Tools and Workloads
  • Profiler Tool : Trace Files
  • Trace Filters and Rollover
  • DTA Tool Recommendations
  • PDS, & Index Size, Index Scan
  • Execution Plans, Index Seeks
  • Query Cost Issues, Solutions

Ch 20: MOT & Temporal Tables

  • Memory Optimized Tables
  • Non Clustered Primary Keys
  • Stats Updates, Performance
  • Temporal Tables in Realtime
  • History Tracking & Testing
  • Timestamp Columns Usage
  • Tuning Stored Procedures

Ch 21: Locks & Isolation Levels

  • Transactions & Locks
  • Lock Types & Performance
  • Lock Management Options
  • Isolation Levels & TempDB
  • Snapshots and Performance
  • Deadlocks Simulations, Graphs
  • Profiler Tool & LIVE Locks

Module 3: TSQL Programming & Tuning

Ch 22: Adv. Stored Procedures 1

  • Declaring, Using Variables
  • Using Triggers with Views
  • Updatable Views, DML
  • Views & Stored Procedures
  • Data Distributions in Tables
  • Transactions with Procedures
  • Conditional Commits in SPs
  • Rollback Options in Realtime

Ch 23: Adv. Stored Procedures 2

  • Table Valued Parameters
  •  Using TVP with Procedures
  •  Creating User Defined Types
  •  Big Data Copy & Transactions
  •  Using SPs & Table Variables
  •  Transactional Integrity
  •  Output Parameters in SP
  •  IN and OUT Options Usage

Ch 24: Adv. Stored Procedures 3

  • Dynamic SQL Programs
  • sp_executesql Extended SP
  •  Formatting Queries, Nvarchar
  •  Cursors Types: Local, Global
  •  Cursor Types: Static, Dynamic
  •  Forward Only, Scroll Types
  •  WHILE Loop: @@Fetch Status
  •  Variables with Dynamic SQL

Ch 25: Complex Functions (UDF)

  • Inline, Table Line Functions
  • Multi Line Table Functions
  •  Using LOOPs in Functions
  •  Variables & Return Values
  •  Table Generation Logic
  •  Date & Time Data Types
  •  Calendar Data Generations

 Ch 26: Complex Functions – 2

  •  Reading JSON Data
  • Using OPENROWSET ()
  •  Using nvarchar(max) values
  •  Using PIVOT () Function
  •  Data De-duplication in SQL
  •  Recursive CTEs, Anchors
  •  Recursive CTEs, Anchors

Ch 27 – 30: Banking Project

  • Design & Planning Phase
  •  Querying Phase
  •  Programming Phase
  •  Debugging Phase
  •  Testing Phase
  •  Complete Project Solution
  •  Project FAQs, Resume Points

Module 4: Azure SQL Dev

Ch 31: Cloud Basics, Azure Funda

  • Cloud Fundamentals
  • Cloud Concepts, Benefits
  • IaaS, PaaS, SaaS Cloud Types
  • Azure Cloud Concepts
  • Azure Resources & Usage
  • Azure Services & Purpose
  • Azure Account & Subscription

Ch 32: Azure SQL Database

  • Azure SQL Services
  • Azure SQL Server Creation
  • Azure SQL Databases
  • Azure Firewall: Rules
  • Test Connections from SSMS
  • SSMS Tool: Test Connections
  • ADS Tool: Installation, use

Ch 33: Azure SQL DB Migrations

  • SQL DB Migration Options
  • Data Migration Assistant: DMA
  • DMA Tool, Migration Options
  • On-Premises DB Export
  • Azure SQL Database Import
  • Azure Storage Account
  • Linking SSMS with Azure

Ch 34: Azure SQL DB Licensing

  • Azure SQL DB Licensing
  • Per Database Licensing
  • DTUs: Basic, Standard Types
  • VPU and Plan Types
  • DTU Versus VPU Licensing
  • Elastic DTUs (eDTU) Usage
  • Elastic Query Processing

Ch 35: Azure SQL DB Metrics

  • Azure SQL DB Metrics
  • CPU, Memory, Log Metrics
  • Data File Metrics, Alerts
  • Action Groups & Emails
  • Query Performance Insight
  • Automated Tuning Options
  • Query Recommendations

Ch 36: Azure SQL DB Tuning, AI

  • Automated Tuning Options
  • Manual Tuning Options
  • Server Level Tuning
  • Database Level Tuning
  • AI Search Service, Tuning
  • AI Indexes and Practical Use
  • Watermark Columns, Updates

Ch 37: Azure PaaS & Azure IaaS

  • Azure PaaS: Operations
  • Azure Paas: Limitations
  • Azure IaaS: Advantages
  • Azure IaaS Components
  • Azure Virtual Machines
  • Capacity & Networking
  • Disk & Memory Config.

Ch 38: Azure IaaS Concepts

  • Azure Virtual Machines
  • SQL Server with Azure VM
  • Access Azure VM from SSMS
  • Migrations from PaaS
  • Migrations from On-Premise
  • Azure Data Studio, VMs
  • Comparing SSMS & ADS Tool

Ch 39 – 40: Banking Project

  • OLTP Databases in Azure
  • Code Based Deployments
  • Code Less Deployments
  • Debugging Phases in Azure
  • Testing Phases in Azure
  • Complete Project Solution
  • Project FAQs, Resume Points

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Why Choose SQL School

Play VideoWhy Choose SQL SchoolPlay Video
  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance

Call / WhatsApp: +91 9666640801