• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Unit 01: Introduction
Introduction to SQL Server and Databases 00:04:00
Download and Install SQL Server Express 00:05:00
Unit 02: Manipulating Tables and Data
Connect to Database Instance and Create a Database 00:06:00
Drop or Remove Database 00:04:00
What is a Database Table? 00:02:00
Create an SQL Database Table 00:32:00
Insert Data into the Table with SQL Script 00:15:00
Insert Data into the Table with Management Studio 00:05:00
Select Data from the Table with SQL Script 00:09:00
More Advanced Select Queries Part 1 00:18:00
Update Data in the Table 00:10:00
Update Data in the Table with Management Studio GUI 00:02:00
Delete Data from the Table with SQL Script 00:06:00
Delete Data from the Table with Management Studio GUI 00:01:00
Unit 03: Relationships and Foreign Keys
What are Relationships, Foreign Keys and Normalization 00:11:00
Create a Relationship in SQL Server 00:19:00
Insert Records in Related Tables 00:13:00
Run Queries on Related Tables 00:19:00
Left, Right and Full Joins 00:11:00
Unit 04: Group By and Aggregate Functions
Grouping Data using SQL GROUP BY Clause 00:12:00
SQL AVG Aggregate Function 00:11:00
SQL COUNT Aggregate Function 00:04:00
SQL MAX and MIN Aggregate Functions 00:04:00
SQL SUM Aggregate Function 00:04:00
Unit 05: Advanced SQL Server Objects and Concepts
Create and Manage Views 00:23:00
Scalar Valued Functions 00:27:00
Inline Table Valued Functions 00:09:00
Multi Statement Table Valued Functions 00:12:00
Stored Procedures 00:28:00
Table Triggers 00:19:00
Database Scripting, Backup and Restore 00:15:00

Microsoft SQL Server Development Training

4.9 ( 7 REVIEWS )
262 STUDENTS
$346.11
Microsoft SQL Server Development Training
  • Course Highlights

Learn basic Database Design, use of Microsoft SQL Management Studio, creating Complex Database Objects & boost up your skill with the Microsoft SQL Server Development Training. This expert-outlined course aims to help learners gain a good skill on database management, providing them with a solid foundation of knowledge to become a qualified professional.

This course provides you with fundamental SQL Server training that is enough to get you started at a Database Developer or Junior Database Administrator. From this course you will Learn basic Database Design, like- Tables, Columns, Data Types, Primary Keys, Normalization, SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping), INSERT INTO: How to insert data into a table, Learn to use Microsoft SQL Management Studio, Learn how to craft SQL statements based on real scenarios, Create Complex Database Objects, such as- Stored Procedures, Functions, Views, Triggers.

Gain both practical and theoretical understanding of microsoft SQL server development and increase your employability in this field.

Enrol in Microsoft SQL Server Development Training course today and learn the researched and proven approach adopted by successful salespeople to transform your career.

  • Learning outcome
  • Install SQL Server and SQL Server Management Studio.
  • Connect to a Database Instance, Create a Database & Tables and Run Queries against Tables.
  • General use of the Management Studio, Aggregate functions to do quick mathematical operations.
  • Export data to Excel using the Management Studio.
  • Creating and Managing Database Views, Custom Functions; Table Triggers and Stored Procedures.
  • How to Backup and Restore Databases.
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • 6+ hours of on-demand video lectures and downloadable resources.
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
  • You will be able to incorporate various practical sales techniques successfully and understand your customers better.
  • Who Is This Course For

This course is for Beginner Database Developer, Intermediate Database Developers, Potential Database Administrators, & Those who work in organizations where the company typically uses Microsoft databases.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel

Select your currency