+91 999 9123 502  
SKILL PATH

Learn SQL Server: Beginner to Advanced Course

An SQL server developer is tasked with developing and maintaining systems to store, organize and access databases. They conduct troubleshooting in databases to ensure the end-user can use them smoothly and maintain the organization's servers.

It also involves maintaining data quality and overseeing database security and creating database triggers for use in automation. It's a well-paying job because the entry-level salary is $69,000 per year.

104 Lessons
7 Study Mode Quizzes
09:06 HH:MM of learning

Path Courses

Getting Started with SQL Server

This course starts with a high-level introduction to relational databases. It follows up with SQL Keys and the use of the Data Definition, Data Manipulation and Data Controls Languages that are part of SQL. This course is designed for C# developers who use SQL Server in their applications.

What you will learn:

  • Introduction to Database
  • Introduction to SQL Server
  • Installing SQL Server and Components
  • SQL Server Database and Tables
  • SQL Keys
  • SQL Commands
  • SQL Constraints
  • Types of Database
Level : Beginner
Lessons : 23
Duration : 01h 34m
By: Shailendra Chauhan

T-SQL Fundamentals with SQL Server

Learn the T-SQL fundamentals concepts to interact with SQL Server. Become proficient in T-SQL to perform common data manipulation tasks.

In this course, you will learn the skills that empower you to query data, apply filters, join tables to summarize data and handling exceptions in SQL Server.

What you will learn:

  • Data Types, Variables and Operators
  • SQL Server Control Of Flow
  • SQL Query and Sub Query
  • SQL Clauses
  • SQL Predicates
  • SQL Joins
  • SQL Exceptions
  • Try..Catch
Level : Intermediate
Lessons : 26
Duration : 01h 43m
By: Shailendra Chauhan

SQL Server Views and Indexes

Views are virtual tables that are compiled at runtime. The data associated with views are not physically stored in the view, but it is stored in the base tables of the view. A view can be made over one or more database tables and contains those columns in view that you need to retrieve/query again and again.

An index is a database object which is associated with a table or view and used to speed up the retrieval of rows from the table or view. An index contains the keys fields or columns in the table or view.

What you will learn

  • SQL Server Views
  • Types of Views
  • SQL Sever Indexes
  • Types of Indexes
Level : Intermediate
Lessons : 6
Duration : 01h 08m
By: Bhawna Gunwani

SQL Server Stored Procedures and Functions

Both stored procedures and functions are database objects which contain a set of SQL statements to complete a task. In many ways, both are different from each other.

SQL Functions are used to perform complex calculations whereas, Stored Procedure are pre-compiled SQL code that can be used over and over again. Also, the function that we used in SQL Server is little different from the one we used in programming. SQL Server Functions can have only input parameters, but Stored Procedure can have input and output parameters.

What you will learn

  • Introduction to Stored Procedure
  • Types of Stored Procedure
  • Creating Stored Procedures For Insert, Update and Delete
  • Stored Procedures Parameters
  • SQL Server Functions
  • Scalar Functions
  • Table Valued Functions
Level : Intermediate
Lessons : 10
Duration : 01h 35m
By: Bhawna Gunwani

SQL Server Triggers and Cursors

SQL Trigger is a special type of stored procedure that is automatically fired/executed when a DDL or DML command statement related to the trigger is executed. Triggers are used to assess/evaluate data before or after data modification using DDL and DML statements. While, SQL Cursor is used to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time.

SQL Triggers are also used to preserve data integrity, to control server operations, to audit a server and to implement business logic or business rule. We use a cursor when we need to update records in a database table in a singleton fashion means row by row.

What you will learn

  • SQL Server Triggers
  • Types of Triggers
  • SQL Server Cursors
  • Types of Cursors
  • Cursor Alternatives
Level : Intermediate
Lessons : 12
Duration : 01h 30m
By: Bhawna Gunwani

Understanding and Managing Azure SQL Database

Microsoft Azure SQL Database is a relational database service offered by Microsoft as a PaaS. Azure SQL Database is completely managed by Microsoft. Azure SQL database offers enterprise-grade features like highly available, data protection, backup, high performance and scaling etc. and near-zero administration.

This course is designed for Azure Developer. Here, you will learn foundational knowledge of the tools available to create, update, and manage an Azure SQL Database.

What you will learn:

  • Introduction to Azure SQL Database
  • Database Deployment Models
  • Azure SQL Database Server
  • Creating and Managing Single Database
  • Purchasing Models: DTU and vCore
  • Azure SQL Database Tools
  • Database Migration Using DMA
  • Creating and Managing Elastic Pool
  • Creating Managed Instance
Level : Intermediate
Lessons : 27
Duration : 01h 32m
By: Shailendra Chauhan

Professional Reviews

Pricing Options

This Learning Path

For those looking for serious growth in one area, long term learning and earning diplomas.

  •   One Learning Path Access
  •   Path Access for 12 Months
  •   Study Mode Quizzes
  •   Certificate of Completion
  •   Discord Support Group
  •   Career Coaching
  •   Resume Building

₹4,000 ₹600

85% OFF
*Price exclusive of taxes
OR

All Learning Paths

For the hungry ones for serious growth in multiple areas, long term learning and earning diplomas.

  •   (25+) Learning Paths Access
  •   All Paths Access for 12 Months
  •   Study Mode Quizzes
  •   Certificate of Completion
  •   Discord Support Group
  •   Career Coaching
  •   Resume Building
  •   Interview Prep Sessions

₹20,000 ₹10,000

50% OFF
*Price exclusive of taxes

100% Money Back Guarantee

Our training programs are empowering thousands with expert knowledge - they will you too. If you're disappointed for whatever reason, you'll get your 100% refund. We won't make you beg or invoke any silly rules or conditions – if you're not satisfied within your first 5 days then we'll refund you without any fuss.
For more details do refer our Refund Policy.

We've trained thousands of developers working at companies such as:

Similar Learning Paths

View All

Learn new skills and discover the world of possibilities with step-by-step guidance. Start your journey today by exploring our curated learning paths.

Learn SQL Server: Beginner to Advanced
Learn SQL Server: Beginner to Advanced

06

Courses

09:06

HH:MM

₹600 ₹4,000
85% OFF (*Price exclusive of taxes)
Learn Angular: Beginner to Advanced
Learn Angular: Beginner to Advanced

08

Courses

12:23

HH:MM

₹900 ₹6,000
85% OFF (*Price exclusive of taxes)
Learn ASP.NET Web API: Beginner to Advanced
Learn ASP.NET Web API: Beginner to Advanced

04

Courses

07:37

HH:MM

₹900 ₹6,000
85% OFF (*Price exclusive of taxes)
Learn jQuery
Learn jQuery

02

Courses

02:55

HH:MM

₹450 ₹3,000
85% OFF (*Price exclusive of taxes)
Learn Azure Devops
Learn Azure Devops

03

Courses

03:08

HH:MM

₹900 ₹6,000
85% OFF (*Price exclusive of taxes)
Learn .NET/.NET5 Basics
Learn .NET/.NET5 Basics

02

Courses

02:50

HH:MM

₹450 ₹3,000
85% OFF (*Price exclusive of taxes)

FAQs

Q1. What are Learning Paths?

Learning Paths are structured curriculum roadmap that show you exactly where to start and what to learn next. We have Learning Paths that teach the core skills of .NET, .NET Core, JavaScript, Cloud Computing, and Front-end Frameworks like Angular and React.

Q2. Will I get Learning Path Certificate?

Yes, upon completion, Once you show us that you have performed all the activity guides you will get a course completion certificate issued by DotNetTricks.

Q3. I don't have any job or looking for new opportunity, how will I get a job?

With Yearly plus membership, you will get access to our personal career coaching sessions, where our mentor will tell your how you should draft your resume and what technologies you should learn as per your experience and interest. Also, we will discuss interview Q&A to prepare you for your next job interview.

Q4. What about Interview Prep and Career Coaching Sessions?

If you are a Project Manager, Team Lead, SSE & SE, and looking for a job change. We are having interview preparation sessions for Yearly plus members every Fri at 9PM IST. Discuss your interview Q&A live with our expert and ask for career guidance.

Q5. Can I share my subscription with someone else?

In short, no. Check our licensing that you agree to by using Dot Net Tricks Courses. We track this stuff, any abuse of copyright is taken seriously. Thanks for your understanding on this one.

Q6. If my Question is not listed here?

Question not here? Drop us an email at support@dotnettricks.com about it.