SQL Essentials Training And Certification

SQL Essentials Solutions Architect Training

SQL skills are highly sought after in web development, programming, data analysis and reporting environments. Learn how to write SQL (Structured Query Language) using Microsoft's SQL Server Management Studio from scratch with SQL Essentials training course.

Sports, Citrix, UST Global, Mindtree, TCS, Wipro, Infosys & other MNC's use Azure across industries.

Microsoft Aims for $20 Billion Cloud Sales Run Rate in 2018 - Satya Nadella, CEO.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Sql Essentials Training Certification UpComing Batches

Nov-04 - Dec-16

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Oct-28 - Dec-09

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Nov-16 - Dec-28

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-23 - Jan-04

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Nov-30 - Jan-11

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-07 - Jan-18

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

SQL Essentials Training & Certification.

SELF PACED

OL Tech Edu's SQL skills are highly sought after in web development, programming, data analysis and reporting environments. Learn how to write SQL (Structured Query Language) using Microsoft's SQL Server Management Studio from scratch with SQL Essentials training course.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
SQL Skills Are Highly Sought

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.

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.

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.

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.


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.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Projects

What are the system requirements for this course?

The system requirement for this course is a system with Intel i3 processor or above minimum 3GB RAM (4GB recommended) and an operating system can be of 32bit or 64 bit. In addition, you require Microsoft SQL server 2005 or above.

How will I execute the practicals?

The installation manual for installation into Windows system will be provided with step by step execution along with the screenshots.

Which Projects will be a part of the course?

Building a Multi table Relational Database, Problems and exercises based on given schema. exercises will be given as a part of the project.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2024 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers