SQL

ClusterPhi
Last Update September 6, 2022

About This Course

This online programme gives you complete insight of the relational database language, i.e. SQL (Structured Query Language)

Tags

Learning Objectives

Learn SQL to a foundational level
Be able to write data retrieval queries and evaluate the result set.
Be able to write SQL statements that edit existing data.
Be able to write SQL statements that create database objects.
Understand the structure and design of relational databases.
Understand the importance and major issues of database security and the maintenance of data integrity.

Target Audience

  • Software Developers, IT Professionals, Engineers, Analysts, Tech Support Professionals, Freshers

Curriculum

64 Lessons

Introduction to Basic Database Concepts

What is Data, Field, Record and database? Limitations of File Management System.
Basic Concepts of Advantages of DBMS.

Exploring Relational DBMS

E-R Modeling and Diagram

Normalization

First Normal Form Second Normal Form

Introduction to SQL Server

Introduction to SQL

Basics of SQL Types of SQL Statements DDL, DML, DQL, DCL and TCL

DDL and DML Statements

Working with Queries (DQL)

Aggregate Functions

Using functions in Queries Count, Sum, Min, Max, Avg Group By and Having Clause

Joins and Set Operations

Introduction to Joins Cross Joins Inner Join Outer Join Self Join

Implementation of Data integrity

In this module , we will learn correctness of data and types of integrity and types of constraints.

Working with Constraints

Unique Not NULL Primary Key Default Check Foreign Key

Implementing Views

Data Control language (DCL)

Working with Indexes

Writing Transact-SQL (T-SQL)

What is T-SQL?

Working with Stored Procedures and Functions

Introduction to stored procedures Benefits of Stored Procedures

Implementing Triggers

Introduction to triggers

Working with Cursors

Creating Cursors

Transaction Control Language (TCL)

Introduction Transactions process

Backup and Restore

Your Instructors

ClusterPhi

4.0/5
18 Courses
1 Review
66 Students
See more
Free
Level
All Levels
Lectures
64 lectures
Language
English
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Compare ×
Let's Compare! Continue shopping