SQL Essentials Training & Certification

What will i learn?

Define RDBMS and three normalization forms
Using DDL Statements to Create and Manage Tables
Manipulating Data Using DML
Retrieving Data Using the SQL Select Statement
Restricting and Sorting Data
Displaying Data from Multiple Tables
Using the built-in functions.

About this course

DDL (Data Definitions Language) Commands

Goal: Data Definition Commands defines the syntax of a database and manipulate database objects.

Module Objectives:

RDBMS (Relational Database Management System) Introduction
Normalization in RDBMS
Create database objects i.e. Create Table
Delete database objects i. e. Delete Database
Alter database objects i.e. Change Column Name
Create, alter and delete constraints

Topics:

Relation Database Management System (RDBMS)
Normalization
Create Database objects
Data Types in SQL
Alter Table Statements
Drop Table Statements
Various Constraints
Creating Views

Hands-on/Demo/Use-case:

Create Table With Predefine Columns
Add New Column to Existing Table
Check the constraints on a table
Add Primary Key and Foreign Key on Table
Remove Unique Constraint

Get detailed course syllabus in your inbox

DML (Data Manipulation Language) Commands

Goal: DML Commands help to work with existing data. Using these commands we can add, modify, or delete the data.

Module Objectives:

Insert record/data in tables
Modify/Update the existing data
Retrieve the data from database from single table
Use of operators for data retrieval
Delete the data from tables

Topics:

Insert Statements
Insert – As- Select Statement
Update Statements
Delete Statements
Truncate Statements
Select Statement
Sorting and Filtering
SQL wildcard
CASE Expression

Hands-on/Demo/Use-case:

Insert the records in an existing table
Delete selective records
Update data in the table based on data from another table

Get detailed course syllabus in your inbox

Retrieve data from multiple tables

Goal: To combines columns from multiple tables in a database by using values common to tables

Module Objectives:

Retrieve records from multiple tables

Topics:

Self-Join
Inner Join
Left Join
Right Join
Cross Join

Hands-on/Demo/Use-case:

Retrieve data from multiple tables

Get detailed course syllabus in your inbox

Inbuilt Functions in SQL

Goal: Use Built-In functions to calculate values and manipulate data

Module Objectives:

Use of Built-in Functions
Use of Group by Command
Use of Having Commands

Topics:

Conversion Function
Logical Functions
Math Function
Aggregate Functions
String Functions
Date Functions

Hands-on/Demo/Use-case:

Determine the Count of rows satisfying a certain condition
Determine average of a column
Determine Sum of a column

Get detailed course syllabus in your inbox

Create Advance database objects

Goal: To create advanced database objects for data manipulation and data retrieval

Module Objectives:

Create Stored Procedure
Execute Stored Procedure
Create Functions
Create Triggers

Topics:

Custom Functions
Stored Procedure
Triggers

Hands-on/Demo/Use-case:

Create Functions
Create Triggers
Create and Execute Stored Procedure

Get detailed course syllabus in your inbox

Requirements

This course is for beginners with absolutely no experience in database. There are no pre-requisites for this course, however, some fundamentals knowledge about DBMS will be beneficial.

+ View more

Description

Learn how to write SQL (Structured Query Language) from scratch with SQL Essentials training course. This course will easily step you through writing SQL using Microsoft's SQL Server Management Studio. SQL allows you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL Server database. This course is designed for people wanting to learn how to interrogate data from a relational database, how to manipulate this data (Insert, update, and delete records).

Although we use SQL Server to interrogate data throughout this course, SQL is a common language easily adapted to other RDBMS (relational database management systems) such as MySQL, IBM DB2, PostgreSQL, Oracle, Ingres, Sybase and Microsoft Access.

Student feedback

Average rating

0%
0%
0%
0%
100%