T-SQL Fundamentals with SQL Server Training Course Training Course

Some of our clients

Course Code

SQL100

Duration

14 hours (usually 2 days including breaks)

Requirements

Basic Computer Skills.

Overview

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.

Course Outline

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.

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

is growing fast!

We are looking to expand our presence in Canada!

As a Business Development Manager you will:

  • expand business in Canada
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!