SQL Server- Basic to Advance

Introduction 4 lectures 01:52:29 Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from EmployeeRetrieving filtered data: select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from Employee where basicsalary > 40000 select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], Month(joindate) as [Month of Joining] from Employee where month(joindate) = 1Inserting data: Insert into Employee values(1, ’Ramkumar’ , ’Manager’ , 54000, ’1/20/2016’ , ’Chennai Tamilnadu’ , ’23445984’ , ’’ , 1)Inserting specific data: Insert into Employee(employeeid, employeename, designation , basicsalary) values(1, ’GuruPrasad’ , ’Manager’ , 58000)Updating data to a table: Update Employee set address = ‘Chennai’Updating specific record: Update Employee set address = ‘Chennai’, basicsalary = 40000 where employeename = ‘Pramod’Deleting the table record: Delete from EmployeeDeleting specific record: Delete from Employee where employeename = ‘GuruPrasad’ Table Structures in SQL Server CRUD Operations in SQL Server Introduction. 4 lectures 01:52:29 Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from EmployeeRetrieving filtered data: select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from Employee where basicsalary > 40000 select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], Month(joindate) as [Month of Joining] from Employee where month(joindate) = 1Inserting data: Insert into Employee values(1, ’Ramkumar’ , ’Manager’ , 54000, ’1/20/2016’ , ’Chennai Tamilnadu’ , ’23445984’ , ’’ , 1)Inserting specific data: Insert into Employee(employeeid, employeename, designation , basicsalary) values(1, ’GuruPrasad’ , ’Manager’ , 58000)Updating data to a table: Update Employee set address = ‘Chennai’Updating specific record: Update Employee set address = ‘Chennai’, basicsalary = 40000 where employeename = ‘Pramod’Deleting the table record: Delete from EmployeeDeleting specific record: Delete from Employee where employeename = ‘GuruPrasad’ Table Structures in SQL Server CRUD Operations in SQL Server Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software Introduction to SQL Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software Sql Server is a relational database management which stores, retrieves and manipulates the data Latest version of Sql Server is Microsoft SQL Server 2014 and its express edition can be downloaded free Windows Authentication will be done automatically with current windows userSQL Server Authentication will be done by creating a new SQL Server login Authenticating the user while connecting to Sql Server can be done in two ways: Windows Authentication and SQL Server Authentication Connecting, monitoring, querying, and manipulating the Sql Server will be done by Microsoft SQL Server Management Studio software SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from EmployeeRetrieving filtered data: select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from Employee where basicsalary > 40000 select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], Month(joindate) as [Month of Joining] from Employee where month(joindate) = 1Inserting data: Insert into Employee values(1, ’Ramkumar’ , ’Manager’ , 54000, ’1/20/2016’ , ’Chennai Tamilnadu’ , ’23445984’ , ’’ , 1)Inserting specific data: Insert into Employee(employeeid, employeename, designation , basicsalary) values(1, ’GuruPrasad’ , ’Manager’ , 58000)Updating data to a table: Update Employee set address = ‘Chennai’Updating specific record: Update Employee set address = ‘Chennai’, basicsalary = 40000 where employeename = ‘Pramod’Deleting the table record: Delete from EmployeeDeleting specific record: Delete from Employee where employeename = ‘GuruPrasad’ SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from EmployeeRetrieving filtered data: select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from Employee where basicsalary > 40000 select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], Month(joindate) as [Month of Joining] from Employee where month(joindate) = 1Inserting data: Insert into Employee values(1, ’Ramkumar’ , ’Manager’ , 54000, ’1/20/2016’ , ’Chennai Tamilnadu’ , ’23445984’ , ’’ , 1)Inserting specific data: Insert into Employee(employeeid, employeename, designation , basicsalary) values(1, ’GuruPrasad’ , ’Manager’ , 58000)Updating data to a table: Update Employee set address = ‘Chennai’Updating specific record: Update Employee set address = ‘Chennai’, basicsalary = 40000 where employeename = ‘Pramod’Deleting the table record: Delete from EmployeeDeleting specific record: Delete from Employee where employeename = ‘GuruPrasad’ SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from EmployeeRetrieving filtered data: select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0.10 as [HRA] from Employee where basicsalary > 40000 select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], Month(joindate) as [Month of Joining] from Employee where month(joindate) = 1Inserting data: Insert into Employee values(1, ’Ramkumar’ , ’Manager’ , 54000, ’1/20/2016’ , ’Chennai Tamilnadu’ , ’23445984’ , ’’ , 1)Inserting specific data: Insert into Employee(employeeid, employeename, designation , basicsalary) values(1, ’GuruPrasad’ , ’Manager’ , 58000)Updating data to a table: Update Employee set address = ‘Chennai’Updating specific record: Update Employee set address = ‘Chennai’, basicsalary = 40000 where employeename = ‘Pramod’Deleting the table record: Delete from EmployeeDeleting specific record: Delete from Employee where employeename = ‘GuruPrasad’ SQL Basic Queries Designing Database table:Create table Employee ( employeeid int, employeename varchar(100), designation varchar(50), basicsalary decimal(18,2), joindate datetime, address varchar(max), contactno varchar(30), emailid varchar(50), departmentid int )Retrieving table data: select employeeid, employeename, designation, basicsalary from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary] from Employee select employeeid as [ID], employeename as [Name], designation as [Designation], basicsalary as [Basic Salary], basicsalary * 0 Designing Database...