T-SQL Fundamentals with SQL Server Training Course Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:
How to work with SQL Server and SQL Server Management Studio.
Meaning of Databases, SQL and RDBMS etc.
How to create tables, use DDL, DML and DAL.
Which are the various RDBMS Packages in the market and how they compare with each other.
An Introduction to NoSQL and how they are organizations are changing into hybrid databases.

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Market
  • Server
  • SQL

Course programme

Course Outline:

  • What is the meaning of Databases. Comparison of RDBMS and DBMS
  • Different RDBMS available in the market.
  • What is SQL Server? Working with SQL Server Management Studio
  • Working with sublanguages like DDL, DML, DAL.
  • Creation of Tables, data types, Constraints and their definition.
  • Using Insert, Delete and Update statements.
  • Using Select Query and its various operators.
  • Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
  • What are inbuilt functions? Math, String and Datetime functions.
  • Working with Views. How they are used for data access.
  • Working with Joins. Joins types and getting data from multiple tables.
  • Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
  • What are Common Table Expressions. Using Recursive Common Table expressions.

See related categories

T-SQL Fundamentals with SQL Server Training Course Training Course

Price on request

The best SQL Server courses

See all

See all