Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications - which may run either on the same computer or on another computer across a network.
Upon successful completion of the course, the learner will be able to
Build database using Data Definition Language Statements, Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database.
Write and manage database triggers, cursors and Index.
In this module you will be exposed to ERD Modelling.An ERD also known as an entity relationship model, is a graphical representation of an information system that depicts the relationships among people, objects, places, concepts or events within that system.
In this module you will be exposed to DDL and DML concepts. DDL (Data Definition Language) which deals with database schemas and descriptions, of how the data should reside in the database. DML (Data Manipulation Language) which deals with data manipulation, and includes most common SQL statements such INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.
In this module you will be exposed to Basic SELECT statements. The SELECT statement retrieves data from a database.The data is returned in a table-like structure called a result-set. SELECT is the most frequently used action on a database.
In this module you will be exposed to Aggregate Functions in Mssql. An aggregate function is a function where the values of multiple rows are grouped together to form a single value. These functions are useful while performing mathematical calculations.
In this module you will be exposed to Date,Time and String functions. Date,Time,String functions are to perform string and date related operations on data. These functions are useful while performing string concatenations, sub-strings,date between,datediff functions etc.
In this module you will be exposed to Nested/Subqueries. A Nested/subquery is a statement that has another SQL query embedded in the WHERE or the HAVING clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.
In this module you will be exposed to Joins queries. A Join statement is used to combine data or rows from two or more tables based on a common field between them.The most common type of join are Inner, Left, Right and Full Joins.
In this module you will be exposed to views. A view is a virtual table based on the result-set of an SQL statement. We can create a view by selecting fields from one or more tables present in the database.
In this module you will be exposed to Stored Procedures & Functions. Procedures and Functions are the subprograms which can be created and saved in the database as database objects. A function MUST return a value. A procedure cannot return a value. Procedures can return data in OUT parameters.
In this module you will be exposed to triggers. A trigger is a special type of stored procedure. DML triggers execute when a user tries to modify data through DML events like INSERT, UPDATE, or DELETE statements on a table.
In this module you will be exposed to Exceptions. Exceptions are error handling in Stored Procedures. TRY..CATCH blocks are used to handle the exceptions.
In this module you will be exposed to Set Operators. Set operators combine the results of two component queries into a single result. Queries containing set operators are called compound queries. SET operations to be performed on table data like Union, Union all, Intersect and Except.
In this module you will be exposed to Synonyms,Indexes,Analytic functions. Analytical functions are organizes data into partitions, computes functions over these partitions in a specified order, and returns the result. An index is used to speed up the performance of queries. It does this by reducing the number of database data are already fetched. A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
In this module you will be exposed to Pivoting,Merge. PIVOT performs an aggregation and, therefore, merges possible multiple rows into a single row in the output. The MERGE statement is used to make changes in one table based on values matched from anther. It can be used to combine insert, update, and delete operations into one statement.
Learning through E-Box is completely Hands-on and practice based thereby helping you understand the intricacies of Live Project Scenarios
E-Box’s programs and Courses are designed by Professionals in the Industry & Academicians, assuring a quality learning experience
With 100’s Mentors online ready to get your Doubts clarified and to Hand Hold you, you will always have someone to sort things our for you
All our Mentors are Top Professionals from their respective Industries. In E-Box you Learn and get mentored by professionals
Auto Evaluation is the Core of E-Box. Your solutions and answers are evaluated instantaneously by E-Box, thereby saving learners a lot of time
With Auto - Evaluation being the core of the Platform, E-Box uses AI & ML to assist Learners during their course of Study
E-Box’s AI algorithms provide you with Exercises that are Personalised and Adaptive based on your Interest and Calibre
Data becomes the core for evolving a personalised learning. E-Box uses these metrics for an Auto Corrective Learning Process