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
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
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
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
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
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