.
Querying Data with Transact-SQL
1 - INTRODUCTION TO MICROSOFT SQL SERVER 2019
2 - INTRODUCTION TO T-SQL QUERYING3
3 - WRITING SELECT QUERIES
4 - QUERYING MULTIPLE TABLES
5 - SORTING AND FILTERING DATA
6 - WORKING WITH SQL SERVER 2019 DATA TYPES
7 - USING DML TO MODIFY DATA
8 - USING BUILT-IN FUNCTIONS
9 - GROUPING AND AGGREGATING DATA
10 - USING SUBQUERIES
11 - USING TABLE EXPRESSIONS
12 - USING SET OPERATORS
13 - USING WINDOWS RANKING, OFFSET, AND AGGREGATE FUNCTIONS
14 - PIVOTING AND GROUPING SETS
15 - EXECUTING STORED PROCEDURES
16 - PROGRAMMING WITH T-SQL
17 - IMPLEMENTING ERROR HANDLING
18 - IMPLEMENTING TRANSACTIONS
Developing SQL Database
1 - INTRODUCTION TO DATABASE DEVELOPMENT
2 - DESIGNING & IMPLEMENTING TABLES
3 - ADVANCED TABLE DESIGNS
4 - ENSURING DATA INTEGRITY THROUGH CONSTRAINTS
5 - INTRODUCTION TO INDEXES
6 - DESIGNING OPTIMIZED INDEX STRATEGIES
7 - COLUMNSTORE INDEXES
8 - DESIGNING AND IMPLEMENTING VIEWS
9 - DESIGNING AND IMPLEMENTING STORED PROCEDURES
10 - DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS
11 - RESPONDING TO DATA MANIPULATION VIA TRIGGERS
12 - USING IN-MEMORY TABLES
13 - IMPLEMENTING MANAGED CODE IN SQL SERVER
14 - STORING AND QUERYING XML DATA IN SQL SERVER
15 - STORING AND QUERYING SPATIAL DATA IN SQL SERVER
16 - STORING AND QUERYING BLOBS AND TEXT DOCUMENTS IN SQL SERVER
17 - SQL SERVER CONCURRENCY
18 - PERFORMANCE AND MONITORING
Administering a SQL Database Infrastructure
1- Configure data access and auditing
2-Manage backup and restore of databases
3-Manage and monitor SQL Server instances
4-Manage high availability and disaster recovery
Provisioning SQL Databases
1-Implement SQL in Azure
2-Manage databases and instances
3-Manage Storage
Business Intelligence Development
1- Introduction to Data Warehousing
2- Data Warehouse Hardware
3- Designing and Implementing a Data Warehouse
4- Creating an ETL Solution with SSIS
5- Implementing Control Flow in an SSIS Package
Querying Data with Transact-SQL
1 - INTRODUCTION TO MICROSOFT SQL SERVER 2019
The Basic Architecture of SQL Server SQL Server Editions and Versions Getting Started with SQL Server Management Studio Lab: Working with SQL Server 2019 Tools
2 - INTRODUCTION TO T-SQL QUERYING
Introducing T-SQL Understanding Sets Understanding Predicate Logic Understanding the Logical Order of Operations in SELECT statements Lab: Introduction to Transact-SQL Querying
3 - WRITING SELECT QUERIES
Writing Simple SELECT Statements Eliminating Duplicates with DISTINCT Using Column and Table
Aliases Writing Simple CASE Expressions Lab: Writing Basic SELECT Statements
4 - QUERYING MULTIPLE TABLES
Understanding Joins Querying with Inner Joins Querying with Outer Joins Querying with Cross Joins and Self Joins Lab: Querying Multiple Tables
5 - SORTING AND FILTERING DATA
Sorting Data Filtering Data with Predicates Filtering with TOP and OFFSET-FETCH Working with Unknown Values Lab: Sorting and Filtering Data
6 - WORKING WITH SQL SERVER 2019 DATA TYPES
Introducing SQL Server 2019 Data Types Working with Character Data Working with Date and Time Data Lab: Working with SQL Server 2019 Data Types
7 - USING DML TO MODIFY DATA
Inserting Data Modifying and Deleting Data Lab: Using DML to Modify Data
8 - USING BUILT-IN FUNCTIONS
Writing Queries with Built-In Functions Using Conversion Functions Using Logical Functions Using
Functions to Work with NULL Lab: Using Built-In Functions
9 - GROUPING AND AGGREGATING DATA
Using Aggregate Functions Using the GROUP BY Clause Filtering Groups with HAVING Lab: Grouping and Aggregating Data
10 - USING SUBQUERIES
Writing Self-Contained Subqueries Writing Correlated Subqueries Using the EXISTS Predicate with Subqueries Lab: Using Subqueries
11 - USING TABLE EXPRESSIONS
Using Views Using Inline Table-Valued Functions Using Derived Tables Using Common Table Expressions Lab: Using Table Expressions
12 - USING SET OPERATORS
Writing Queries with the UNION Operator Using EXCEPT and INTERSECT Using APPLY Lab: Using Set Operators
13 - USING WINDOWS RANKING, OFFSET, AND AGGREGATE FUNCTIONS
Creating Windows with OVER Exploring Window Functions Lab: Using Windows Ranking, Offset, and Aggregate Functions
14 - PIVOTING AND GROUPING SETS
Writing Queries with PIVOT and UNPIVOT Working with Grouping Sets Lab: Pivoting and Grouping Sets
15 - EXECUTING STORED PROCEDURES
Querying Data with Stored Procedures Passing Parameters to Stored Procedures Creating Simple Stored Procedures Working with Dynamic SQL Lab: Executing Stored Procedures
16 - PROGRAMMING WITH T-SQL
T-SQL Programming Elements Controlling Program Flow Lab: Programming with T-SQL
17 - IMPLEMENTING ERROR HANDLING
Implementing T-SQL error handling Implementing structured exception handling Lab: Implementing Error Handling
18 - IMPLEMENTING TRANSACTIONS
Transactions and the database engines controlling transactions Lab: Implementing Transactions
Developing SQL Database
1 - INTRODUCTION TO DATABASE DEVELOPMENT
Introduction to the SQL Server Platform SQL
Server Database Development Tasks
2 - DESIGNING & IMPLEMENTING TABLES
Designing Tables Data Types
Working with Schemas
Creating and Altering Tables
Lab: Designing and Implementing Tables
3 - ADVANCED TABLE DESIGNS
Partitioning data Compressing Data Temporal Tables Lab: Using Advanced Table Designs
4 - ENSURING DATA INTEGRITY THROUGH CONSTRAINTS
Enforcing data Integrity Implementing Domain Integrity Implementing Entity and Referential Integrity Lab: Using Data Integrity Through Constraints
5 - INTRODUCTION TO INDEXES
Core Indexing Concepts Data Types and Indexes Heaps, Clustered, and Nonclustered Indexes Single Column and Composite Indexes Lab: Implementing Indexes
6 - DESIGNING OPTIMIZED INDEX STRATEGIES
Index Strategies Managing Indexes Execution Plans the Database Engine Tuning Advisor Query Store Lab: Optimizing Indexes
7 - COLUMNSTORE INDEXES
Introduction to Columnstore Indexes Creating Columnstore Indexes Working with Columnstore Indexes Lab: Using Columnstore Indexes
8 - DESIGNING AND IMPLEMENTING VIEWS
Introduction to Views Creating and Managing Views Performance Considerations for Views Lab: Designing and Implementing Views
9 - DESIGNING AND IMPLEMENTING STORED PROCEDURES
Introduction to Stored Procedures Working with Stored Procedures Implementing
Parameterized Stored Procedures Controlling Execution Context Lab: Designing and Implementing Stored Procedures
10 - DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS
Overview of Functions Designing and Implementing Scalar Functions Designing and
Implementing Table-Valued Functions Considerations for Implementing Functions Alternatives to Functions Lab: Designing and Implementing User-Defined Functions
11 - RESPONDING TO DATA MANIPULATION VIA TRIGGERS
Designing DML Triggers Implementing DML Triggers Advanced Trigger Concepts Lab: Responding to Data Manipulation by Using Triggers
12 - USING IN-MEMORY TABLES
Memory-Optimized Tables Natively Compiled Stored Procedures Lab: Using In-Memory Database Capabilities
13 - IMPLEMENTING MANAGED CODE IN SQL SERVER
Introduction to CLR Integration in SQL Server Implementing and Publishing CLR Assemblies Lab: Implementing Managed Code in SQL Server
14 - STORING AND QUERYING XML DATA IN SQL SERVER
Introduction to XML and XML Schemas Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type Using the Transact-SQL FOR XML Statement Getting Started with XQuery Shredding XML Lab: Storing and Querying XML Data in SQL Server
15 - STORING AND QUERYING SPATIAL DATA IN SQL SERVER
Introduction to Spatial Data Working with SQL Server Spatial Data Types Using Spatial Data in Applications Lab: Working with SQL Server Spatial Data
16 - STORING AND QUERYING BLOBS AND TEXT DOCUMENTS IN SQL SERVER
Considerations for BLOB Data Working with FILESTREAM Using Full-Text Search Lab: Storing and Querying BLOBs and Text Documents in SQL Server
17 - SQL SERVER CONCURRENCY
Concurrency and Transactions Locking Internals Lab: SQL Server Concurrency
18 - PERFORMANCE AND MONITORING
Extended Events Working with extended Events Live Query Statistics Optimize Database File Configuration Metrics Lab: Monitoring, Tracing, and Baselining
2023-11-28
Asif
Course fee
2024-01-28
Sujan Das
The advance part of the SQL SERVER ADMINISTRATION
2024-01-28
Sujan Das
The advanced part of the sql server administration in this course will help software engineers to manage and handle large scaled projects.