Basic SQL

Basic SQL

This course is intended for users who are new to writing SQL statements. It will help new users get started by understanding of RDBMS, SQL Server Architecture, learning basic statements for creating tables and inserting data. The course shows you how to create a database, create a table in the database, insert data into the table, update the data, read the data, delete the data, and then delete the table.

Total Lessons

3 Lessons

Program Duration

10hrs Self-Paced Learning

Learning Format

Basic SQL

Course Overview

Basic SQL

0.00

This SQL course enables a professional to manage database solutions and execute various operations on databases. Through a blend of hands-on and interactive lectures, one will learn about both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems. Important topics included in this SQL online course are Installing SQL server, Commands to access and manipulate data using queries, subqueries, joins, and unions and implementing programmability objects.

Offline Course
(Self-Paced)

  • 3 lesson
  • 10 hrs self paced learning
Clear

Description

With this course, you can learn about Tables, Views, Triggers, Stored Procedures and many more SQL commands.

Additional information

Classes

Free Course, Offline Course

Course Curriculum

  • Introduction to Relational Databases
  • SQL Server Architecture
  • Introduction to Entity Relationship Model
    Entities, Attributes, Relations, Degree of Relationship and Mapping cardinality
  • Introduction to SQL Server Management Studio
  • Introduction to SQL Commands and Datatypes
  • SQL Operators
    Arithmetic, Bitwise, Comparison, Logical Operators

Skills Covered

SQL Server Architecture

Working with SQL Operators, joins, Views

Manage Database with DDL, DML Commands

Various Operations on Database

Who can apply?

  • Anyone who is passionate to learn and enhance skills in data analytics
  • IT/ Non-IT Professionals
  • College Graduates
  • BI Professionals
  • Project Managers
  • MBA and BBA Students from all specializations