SQL Server Syllabus Covered

Overview of the SQL SERVER

  • Introduction of SQL SERVER
  • How SQL Works
  • Summary

Setting up and Installing SQL Server 2012

  • Overview of SQL Server 2012
  • Installation of SQL Server 2012
  • Features of SQL Server Express
  • SQL Server 2012 Express management tools
  • Summary

Coding Standards

  • Overview of coding standards follows during programming
  • Summary

FTP Management

  • Understanding FTP
  • Setting up FTP Server (Live)
  • Uploading and downloading FTP contents
  • Summary

Sending Emails

  • Designing email panel
  • How to send an email to various users
  • Sending auto emails
  • Summary

Deployment

  • Deploying application on Web Server
  • Summary

Live Project

  • Getting customer’s requirements
  • Preparing database and business logics
  • Developing application
  • Testing and implementing the project
  • Troubleshooting the project application after implementation
  • Summary

SQL Server

  • Introduction
  • SQL Syntax
  • SQL Select
  • SQL Distinct
  • SQL Where
  • SQL And & Or
  • SQL Order By
  • SQL Insert
  • SQL Update
  • SQL Delete
  • SQL Demo
  • SQL Try It
  • SQL Advanced
  • SQL Top
  • SQL Like
  • SQL Wildcards
  • SQL In
  • SQL Between
  • SQL Alias
  • SQL Joins
  • SQL Inner Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Union
  • SQL Select Into
  • SQL Create DB
  • SQL Create Table
  • SQL Constraints
  • SQL Not Null
  • SQL Unique
  • SQL Primary Key
  • SQL Foreign Key
  • SQL Check
  • SQL Default
  • SQL Create Index
  • SQL Drop
  • SQL Alter
  • SQL Increment
  • SQL Views
  • SQL Dates
  • SQL Nulls
  • SQL isnull()
  • SQL Data Types
  • SQL Functions
  • SQL Functions
  • SQL avg()
  • SQL count()
  • SQL first()
  • SQL last()
  • SQL max()
  • SQL min()
  • SQL sum()
  • SQL Group By
  • SQL Having
  • SQL ucase()
  • SQL lcase()
  • SQL mid()
  • SQL len()
  • SQL round()
  • SQL now()
  • SQL format()
  • Stored Procedure
  • Function
  • Trigger
  • Views
  • Cursor