SQL PROGRAMMING AND DATA BASE DESIGN- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

SQL PROGRAMMING AND DATA BASE DESIGN

TECHNICAL TALK- WORKSHOP 

Agenda:

Technologies Focused : SQL Programming and Data Base Design

Number of Students :80

Date of the Programme :17-03-2018

Location of the Programme :Chennai KaaShiv InfoTech

Programme Mission :

1. Social activities in spreading Microsoft Technologies to the students.

2. Awareness on Microsoft SQL Servers  and security.

3. Practical demos on Microsoft SQL Servers
4.Microsoft Today:Advanced SQL server.
5.Talk on SQL Applications and Its features.

Overview of SQL programming and Data base design:

Structure of SQL-Database programming with SQL-SQL Relationship fundamental-Using the WHERE clause:

Query  Based Language-Fundamentals of sub queries-Combining queries with set operators and Working with group function-Working with sequences:

Relational Database Fundamentals-Conceptual and physical modes of data transmission-Information about SELECT and WHERE-various levels of Data base transactions:

 Data base objects and Constrains-Transaction management and stored procedures:

What is queries and what is the use of queries:

 Using sub queries-why we need sub queries-roles of sub queries:

How to design normalized Table structure:

Controlling user access and  Data Base Transactions:

DML Operations- Views-SQL Functions and operators-Sorting and aggregating the data :

Relational Data base-Concepts and Entity Relationship model: