T-SQL Fundamentals with SQL Server Training Course

Basic Computer Skills.

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.

• 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.