DaguLearning

Course Title

Microsoft SQL Server Database Development (Project Based Bootcamp)

By learning the course through a practical project and online Bootcamp, you will be an experienced developer and able to manage data with Transact-SQL, query data with advanced Transact-SQL components, program databases using Transact-SQL, design and implement database objects, implement programmability objects, manage database concurrency, optimize database objects and SQL infrastructure.

Overview of Databases:

Overview of Databases, types of databases, and their applications.
Data Modelling:

How to model data from natural world environments and user requirements. Here you will learn Conceptual, Logical, and Physical data modeling.
Set up SQL Server Environment:

Download and Install SQL Server Instance.

Work with CREATE SQL Command:

Use CREATE command to create tables.
Work with DROP SQL Command:

Use the DROP command to remove tables and other database objects.
Work with ALTER SQL Command:

Use the ALTER command to update database objects.
Work with TRUNCATE SQL Command:

Use the TRUNCATE command to remove data from a table.
Rename Objects:

Rename database objects using built-in SQL server stored procedure.

SQL Insert Statement:

Use Insert statement to load data into a table.
SQL Update Statement:

Use an Update statement to modify stored data.
SQL Delete Statement:

Use the Delete statement to remove data from tables.

SELECT Statement:

Use SELECT, TOP, and DISTINCT clauses and key words to retrieve data from tables.
WHERE Statement:

Use the WHERE clause to filter data based on conditions.
BETWEEN and Wildcard Characters:

Use BETWEEN and Wildcard characters to filter data.
Group By, Order By, Having :

Use Group By, Order By, and Having clauses.

Basics of Transaction Control Language:

Deals with the basics of Transaction Control Language and types of TCL commands..
Commit command:

Deals about how to use the Commit command.
Rollback command:

Deals about the Rollback command.
Savepoint command:

Deals about the Savepoint command.

Join Statements:

Deals with the different types of Join statements and their applications.
CTE and Subqueries:

It deals with efficiently creating an SQL script to retrieve data using CTE and Subquery.
Built-in Aggregate Functions:

It deals with the various built-in aggregate functions.
Built-in String Functions:

It deals with the different types of built-in string functions.
Biult-in Datetime Functions:

It deals with the different types of built-in datetime functions.
Windows (Analytical) Functions:

It deals with the windows functions such as Rank, Dense Rank, Lead, and Lag.

Usage of Views:

It deals with the introduction and usage of views.
Creating Views:

It deals with how to create views.
Managing Views:

It deals with managing existing views.

Introduction to User Defined Functions:

This lesson deals with the basics of User Defined Functions.
Scalar Function:

It deals with creating a scalar function that returns a single value.
Inline Table valued Function:

It deals with creating an inline table-valued function.
Multi-Statement Table-Valued Function:

It deals with creating multi-statement table-valued functions.
Parameterized User Defined Function:

This deals with creating parameterized functions.

Getting started with Stored Procedures:

It deals with the basics of stored procedures, parameters, and variables.
Control Flow Statements:

It deals with the different types of control flow statements of Stored Procedures.
Exceptions Handling:

It deals with exception-handling mechanisms in Stored Procedures.
Dynamic SQL:

It deals with designing and implementing a dynamic SQL statement within a Stored Procedure.

Basics of SQL Server Triggers:

It deals with the basics of SQL server triggers and usages.
Data manipulation language (DML) triggers:

It deals with how to create Data Manipulation Language (DML) triggers.
Data Definition Language (DDL) triggers:

It deals with how to create Data Definition Language (DDL) triggers.

Using the Import & Export Wizard:

It deals with using the import and exports built-in wizard.
Reading and Writing data from and to CSV.file.:

It deals with reading data from and writing data into CSV file.
Reading and Writing XML Data:

It deals with reading data from and writing data into XML format.
Reading and Writing JSON Data:

It deals with reading data from and writing data into JSON format.

Conduct Peer Technical Assessment:

This deals with conducting a peer technical assessment. A group of peers conducts technical assessment and discussion.
Conduct Sample Mock Interview:

This deals with conducting a sample mock interview for trainees. It focuses on the core technical aspects of the course.