• Home
  • ASP.NET CORE
    • ASP.NET CORE Online Training

      ASP.NET 7.0

      There are 3 phases to learn ASP.NET Core 7.0

      • Introduction to ASP.NET Core Fundamentals
      • ASP.NET Core Middleware
      • ASP.NET Core 7.0 Advanced Topics
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Hello! I'm Praveen Kumar M, a passionate and experienced .NET tutor dedicated to helping aspiring developers excel in their journey. With 13 years of hands-on experience in .NET development, I have a deep understanding of the language and its vast ecosystem.
      Worked in top MNC's like Accenture , Capgemini , Tech Mahindra and 3 years in Malaysia. My aim is to provide you with a comprehensive understanding of .NET, including C#, ASP.NET MVC Core, SQL Server, and more. Whether you're a beginner or have some prior experience, I tailor my teaching to your specific needs and learning style.
  • C#
    • C# Online Training

      C# 10.0

      There are 4 phases to learn C#.

      • Introduction to .NET Core & Language Fundamentals
      • Application Development and C# 10.0 new features
      • Files, Database’s, XML & Cloud Storage
      • Distributed Programming
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Hello! I'm Praveen Kumar M, a passionate and experienced .NET tutor dedicated to helping aspiring developers excel in their journey. With 13 years of hands-on experience in .NET development, I have a deep understanding of the language and its vast ecosystem.
      Worked in top MNC's like Accenture , Capgemini , Tech Mahindra and 3 years in Malaysia. My aim is to provide you with a comprehensive understanding of .NET, including C#, ASP.NET MVC Core, SQL Server, and more. Whether you're a beginner or have some prior experience, I tailor my teaching to your specific needs and learning style.
  • SQL SERVER
    • SQL SERVER Online Training

      SQL-SERVER 2022

      There are 4 phases to learn SQL SERVER 2022.

      • Introduction to Databases
      • Querying Data with Transact-SQL
      • Developing SQL Databases
      • Updating Your Skills to SQL Server 2022
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Hello! I'm Praveen Kumar M, a passionate and experienced .NET tutor dedicated to helping aspiring developers excel in their journey. With 13 years of hands-on experience in .NET development, I have a deep understanding of the language and its vast ecosystem.
      Worked in top MNC's like Accenture , Capgemini , Tech Mahindra and 3 years in Malaysia. My aim is to provide you with a comprehensive understanding of .NET, including C#, ASP.NET MVC Core, SQL Server, and more. Whether you're a beginner or have some prior experience, I tailor my teaching to your specific needs and learning style.
  • .NET Combo Package
    • .NET Combo Package Online Training

      .NET Core 7.0 Combo Package Include

      • C# 10.0
      • ASP.NET Core 7.0
      • SQL SERVER 2022
      • Git Hub for Developers
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Hello! I'm Praveen Kumar M, a passionate and experienced .NET tutor dedicated to helping aspiring developers excel in their journey. With 13 years of hands-on experience in .NET development, I have a deep understanding of the language and its vast ecosystem.
      Worked in top MNC's like Accenture , Capgemini , Tech Mahindra and 3 years in Malaysia. My aim is to provide you with a comprehensive understanding of .NET, including C#, ASP.NET MVC Core, SQL Server, and more. Whether you're a beginner or have some prior experience, I tailor my teaching to your specific needs and learning style.
  • CONTACT US
  • ABOUT US
  • BLOG
  • Home
  • ASP.NET CORE
    • ASP.NET CORE Online Training

      ASP.NET

      .NET is a developer platform made up of tools, programming languages, and libraries for building many different types of applications.
      The base platform provides components that apply to all different types of apps. Additional frameworks, such as ASP.NET, extend .NET with components for building specific types of apps.
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Lorem ipsum dolor sit amet consectetur, adipisicing elit. Esse ratione temporibus quibusdam repudiandae ut voluptatibus voluptate, quo aut. Libero nostrum aliquid itaque dicta earum minus magni laudantium tempora possimus officia!
  • C#
    • C# Online Training

      C#

      C# is a general-purpose, modern and object-oriented programming language pronounced as “C sharp”. It was developed by Microsoft led by Anders Hejlsberg and his team within the
      .Net initiative and was approved by the European Computer Manufacturers Association (ECMA) and International Standards Organization (ISO) . C# is among the languages for Common Language Infrastructure and the current version of C# is version 7.2.
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Lorem ipsum dolor sit amet consectetur, adipisicing elit. Esse ratione temporibus quibusdam repudiandae ut voluptatibus voluptate, quo aut. Libero nostrum aliquid itaque dicta earum minus magni laudantium tempora possimus officia!
  • SQL SERVER
    • SQL SERVER Online Training

      SQL-SERVER

      The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information. The system supports various business intelligence operations, analytics operations, and transaction processing.
    • Tutor Profile

      Tutor - DotNet Gurukul!

      Lorem ipsum dolor sit amet consectetur, adipisicing elit. Esse ratione temporibus quibusdam repudiandae ut voluptatibus voluptate, quo aut. Libero nostrum aliquid itaque dicta earum minus magni laudantium tempora possimus officia!
  • .NET Combo Package
  • Live Project
  • CONTACT US
  • ABOUT US
  • BLOG

Email

contactdotnetgurukul@gmail.com

Phone

9000366774

Quick Query

9000366774

SQL Server Course Online Training

₹7000/-₹4000/-

09 Sep 2023 to 23 Oct 2023 7:00 AM to 8:00 AM

No prerequisites required 

  1. Introduction to Databases

    1.  Introduction to Relational Databases

    2. Other Types of Databases and Storage

    3. Data Analysis

    4. Database Languages in SQL Server

    Lab:  Exploring and Querying SQL Server Databases using T-SQL

     

     Introduction to Microsoft SQL Server 2022 Tools

    1.  The Basic Architecture of SQL Server 2022

    2. SQL Server Editions and Versions

    3. Getting Started with SQL Server Management Studio

    Lab:   Working with SQL Server 2022 Tools

     

     Introduction to SQL Server 2022 Installation

    1. SQL Server 2022 Editions and Components

    2. Installing SQL Server 2022

    3. SQL Server Management Studio Enhancements     

    4. Lab: Exploring SQL Server 

    2022


     Data Modeling

    1. Data Modeling

    2. ANSI-SPARC Database Model

    3. Entity Relationship Modeling

    Lab:    Identify Components in Entity Relationship Modeling

     

    Normalization

    1. Fundamentals of Normalization

    2. Normal Form

    3. Denormalization

    Lab:    Normalizing Data

     

    Relationships and Types

    1.  Introduction to Relationships

    2. Planning Referential Integrity

    Lab:    Planning and Implementing Referential Integrity

     

       Performance

    1. Indexing

    2. Query Performance

    3. Concurrency

    Lab:    Performance Issues

     

       Introduction to Database Objects

    1. Tables

    2. Views

    3. Stored Procedures, Triggers, and Functions

    Lab:  Using SQL Server


Introduction to T-SQL Querying

  1.  Introducing T-SQL
  2.  Understanding Sets
  3.  Understanding Predicate Logic
  4.  Understanding the Logical Order of Operations in SELECT Statements
  5.  Lab:             Introduction to T-SQL Querying

Writing SELECT Queries

  1.  Writing Simple SELECT Statements
  2. Eliminating Duplicates with DISTINCT
  3. Using Column and Table Aliases
  4. Writing Simple CASE Expressions
  5. Lab:             Writing Basic SELECT Statements

Querying Multiple Tables

  1.  Understanding Joins
  2.  Querying with Inner Joins
  3.  Querying with Outer Joins
  4.  Querying with Cross Joins and Self Joins
  5. Lab:     Querying Multiple Tables

Sorting and Filtering Data

  1. Sorting Data
  2. Filtering Data with Predicates
  3. Filtering Data with TOP and OFFSET-FETCH
  4. Working with Unknown Values
  5. Lab:     Sorting and Filtering Data

  Working with SQL Server Data Types

  1. Introducing SQL Server Data Types
  2. Working with Character Data
  3. Working with Date and Time Data
  4. Lab:     Working with SQL Server 2022 Data Types

Using DML to Modify Data

  1. Adding Data to Tables
  2. Modifying and Removing Data
  3. Generating Automatic Column Values
  4. Lab:     Using DML to Modify Data

 Using Built-In Functions

  1. Writing Queries with Built-In Functions
  2. Using Conversion Functions
  3. Using Logical Functions
  4. Using Functions to Work with NULL
  5. Lab:      Using Built-in Functions

 Grouping and Aggregating Data

  1. Using Aggregate Functions
  2. Using the GROUP BY Clause
  3. Filtering Groups with HAVING
  4. Lab:     Grouping and Aggregating Data

 Using Subqueries

  1. Writing Self-Contained Subqueries
  2. Writing Correlated Subqueries
  3. Using the EXISTS Predicate with Subqueries
  4. Lab:     Using Subqueries

Using Table Expressions

  1. Using Views
  2. Using Inline TVFs
  3. Using Derived Tables
  4. Using CTEs
  5. Lab:     Using Table Expressions

 Using Table Expressions

  1. Using Views
  2. Using Inline TVFs
  3. Using Derived Tables
  4. Using CTEs
  5. Lab:     Using Table Expressions

Using Set Operators

  1. Writing Queries with the UNION Operator
  2. Using EXCEPT and INTERSECT
  3. Using APPLY
  4. Lab:     Using Set Operators

 Using Window Ranking, Offset, and Aggregate Functions

  1. Creating Windows with OVER
  2. Exploring Window Functions
  3. Lab:     Using Window Ranking, Offset, and Aggregate Functions

 Pivoting and Grouping Sets

  1. Writing Queries with PIVOT and UNPIVOT
  2. Working with Grouping Sets
  3. Lab:     Pivoting and Grouping Sets

 Executing Stored Procedures

  1. Querying Data with Stored Procedures
  2. Passing Parameters to Stored Procedures
  3. Creating Simple Stored Procedures
  4. Working with Dynamic SQL
  5. Lab:     Executing Stored Procedures

 Implementing Error Handling

  1. Implementing T-SQL Error Handling
  2. Implementing Structured Exception Handling
  3. Lab:     Implementing Error Handling

 Implementing Transactions

  1. Transactions and the Database Engine
  2. Controlling Transactions
  3. Lab:     Implementing Transactions

Designing and Implementing Tables

  1. Designing Tables
  2. Data Types
  3. Working with Schemas
  4. Creating and Altering Tables
  5. Lab:     Designing and Implementing Tables

 Advanced Table Designs

  1. Partitioning Data
  2. Compressing Data
  3. Temporal Tables
  4. Lab:     Using Advanced Table Designs

Introduction to Indexes

  1. Core Indexing Concepts
  2. Data Types and Indexes
  3. Heaps, Clustered, and Non-clustered Indexes
  4. Single Column and Composite Indexes
  5. Lab:     Implementing Indexes

 Designing Optimized Index Strategies

  1. Index Strategies
  2. Managing Indexes
  3. Execution Plans.
  4. The Database Engine Tuning Advisor
  5. Query Store
  6. Lab:     Optimizing Indexes

 Columnstore Indexes

  1. Introduction to Columnstore Indexes
  2. Creating Columnstore Indexes
  3. Working with Columnstore Indexes
  4. Lab:     Using Columnstore Indexes

  Designing and Implementing Views

  1. Introduction to Views
  2. Creating and Managing Views
  3. Performance Considerations for Views
  4. Lab:     Designing and Implementing Views

 Designing and Implementing Stored Procedures

  1. Introduction to Stored Procedures
  2. Working with Stored Procedures
  3. Implementing Parameterized Stored Procedures
  4. Controlling Execution Context
  5. Lab:     Designing and Implementing Stored Procedures

Designing and Implementing User-Defined Functions

  1. Overview of Functions
  2. Designing and Implementing Scalar Functions
  3. Designing and Implementing Table-Valued Functions
  4. Considerations for Implementing Functions
  5. Alternatives to Functions
  6. Lab:     Designing and Implementing User-Defined Functions

 Responding to Data Manipulation Via Triggers

  1. Designing DML Triggers
  2. Implementing DML Triggers
  3. Advanced Trigger Concepts
  4. Lab:     Responding to Data Manipulation by Using Triggers

 Using In-Memory Tables

  1. Memory-Optimized Tables
  2. Natively Compiled Stored Procedures
  3. Lab:     Using In-Memory Database Capabilities

 Implementing Managed Code in SQL Server

  1. Introduction to CLR Integration in SQL Server
  2. Implementing and Publishing CLR Assemblies
  3. Lab:     Implementing Managed Code in SQL Server

  Storing and Querying XML Data in SQL Server

  1. Introduction to XML and XML Schemas
  2. Storing XML Data and Schemas in SQL Server
  3. Implementing the XML Data Type
  4. Using the Transact-SQL FOR XML Statement
  5. Getting Started with XQuery
  6. Shredding XML
  7. Lab:     Storing and Querying XML Data in SQL Server

 Storing and Querying Spatial Data in SQL Server

  1. Introduction to Spatial Data
  2. Working with SQL Server Spatial Data Types
  3. Using Spatial Data in Applications
  4. Lab:     Working with SQL Server Spatial Data          

 Storing and Querying BLOBs and Text Documents in SQL Server

  1. Considerations for BLOB Data
  2. Working with FILESTREAM
  3. Using Full-Text Search
  4. Lab:     Storing and Querying BLOBs and Text Documents in SQL Server

 Storing and Querying BLOBs and Text Documents in SQL Server

  1. Considerations for BLOB Data
  2. Working with FILESTREAM
  3. Using Full-Text Search
  4. Lab:     Storing and Querying BLOBs and Text Documents in SQL Server

 SQL Server Concurrency

  1. Concurrency and Transactions
  2. Locking Internals
  3. Lab:     Concurrency and Transactions

 Performance and Monitoring

  1. Extended Events
  2. Working with Extended Events
  3. Live Query Statistics
  4. Optimize Database File Configuration
  5. Metrics
  6. Lab:     Monitoring, Tracing, and Baselining

What’s New in SQL Server Performance?

  1. Operational Analytics
  2. In-Memory OLTP Enhancements
  3. Query Store
  4. Live Query Statistics
  5. Native JSON
  6. Temporal Tables
  7. Lab :    Implementing SQL Server 2016 Performance Improvements

 What’s New in SQL Server Security

  1. Using Always Encrypted
  2. Row-Level Security
  3. Dynamic Data Masking
  4. Lab :    SQL Server 2016 Security Improvements

What’s New in SQL Server Availability and Scalability?

  1. Enhanced Always On Availability Groups
  2. What’s New with tempdb?
  3. Use Windows Server 2022 with SQL Server 2022
  4. Lab :    Monitoring tempdb

What’s New in SQL Server Reporting and BI

  1. Reporting Services Enhancements
  2. Power BI Enhancements
  3. Mobile Report Publisher
  4. Lab :    Implementing Power BI

What’s New in SQL Server Data Access?

  1. PolyBase
  2. What’s New in Integration Services?
  3. Working with SSIS and Azur
  4. Lab :    Exploring the New Features of SQL Server Integrated Services (SSIS)

New and Enhanced Features in SQL Server OLAP

  1. New and Enhanced Features in SQL Server OLAP
  2. What’s New in SQL Server Analysis Services?
  3. Lab :    OLAP with SQL Server

 

What’s New for SQL Server in the Cloud?

  1. Stretch Database
  2. Enhanced Backup to Azure
  3. What’s New in Azure SQL Database?
  4. Lab :    Using Stretch Database

No FAQ Data Found

Course Details
  SQL Server Course Online Training
  Start Date: 09 Sep 2023
  End Date: 23 Oct 2023
  Timing: 7:00 AM to 8:00 AM
  Duration: 1month 14day
Faculty Details
  NAME:Praveen Kumar Manda
  SUBJECT:SQL Server Course Online Training
  EXPERIENCE:13 Year
  EMAIL:praveen.camp@gmail.com
  WHATSAPP NO:9000366774

Share this Course on Social Media:

Do You Have Questions ?

We'll help you to grow your career and growth.
Contact Us Today