Why should I learn MSSQL Database?

Learn MS-SQL from scratch and become a professional backend developer or database manager. Backend programming is one of the highest paid job. If you are already into front-end development and you are willing to learn backend then this course is for you. By learning MSSQL Database you can improve your CV and get higher pay. You can also start working on your individual project without depending on some other developer.

What will you learn?

  • Introduction To Database
  • SQL vs NOSQL
  • Normalization & De-Normalization
  • Getting started with Microsoft SQL server
  • Basic DML statements to get started
  • Data Types
  • Converting data types
  • User defined table types
  • SELECT statement 
  • ALIAS Names in SQL Server
  • NULLS
  • Variables
  • Dates
  • Generating a range of dates
  • INSERT
  • PRIMARY Keys
  • FOREIGN Keys
  • LAST INSERTED IDENTITY
  • Database Snapshots
  • COALESCE
  • IF…ELSE
  • CASE Statement
  • INSERT INTO
  • MERGE
  • CREATE VIEW
  • Views
  • UNION
  • TRY/CATCH
  • WHILE loop
  • OVER Clause
  • GROUP BY
  • ORDER BY
  • The STUFF Function
  • JSON in SQL Server
  • OPENJSON
  • FOR JSON
  • Queries with JSON data
  • Storing JSON in SQL tables
  • Modify JSON text
  • FOR XML PATH
  • JOIN
  • Cross Apply
  • Computed Columns
  • Common Table Expressions
  • Move and copy data around tables
  • Limit Result Set
  • Retrieve Information about your Instance
  • String Functions
  • Local Functions
  • Aggregate Functions
  • String Aggregate functions
  • PIVOT / UNPIVOT
  • Partitioning
  • Stored Procedures – with exercises
  • String Split Function
  • SCOPE_IDENTITY()
  • Sequences & Index
  • Full-Text Index
  • Triggers
  • Cursors
  • Transaction Isolation Level
  • Table Valued Parameters
  • DBMAIL
  • Temporal Tables
  • Temp Tables
  • Scheduled Tasks or Jobs
  • Basic DDL Operations in MS SQL Server
  • Subqueries
  • Pagination
  • Parsename
  • Schemas
  • Dynamic SQL
  • Delimiting special characters and reserved words
  • Bulk Imports
  • Permissions & Security
  • Database permissions
  • Encryption
  • FileStream
  • Sys Database

Course Fee:

Rs. 40000/-

CONTACT US TO GET ENROLLED