Learn ASP.NET MVC How to's for free here.
ITFunda.Com
Your details are safeBuyer's Satisfaction Contact Us
 Welcome Guest | Register | Login Why online training? | Buyers FAQs | Testimonials | Contact us 

Our Quality Professors


Our professors includes
Contact us for training ...

Tips and Tricks (Books) Category

Some more tutorials

Announcements

More ...

SQL Server How to Tips & Tricks


Tips and Tricks (Books) by Itfunda

Pricing and Details Support Forum Comments

SQL Server How to Tips & Tricks
Summary: This SQL Server How to Tips and Tricks eBook has solutions of 111 real time SQL Server problems that a developer face in most of the real time projects. All solutions are written with best practices and comes with complete to-the-point description and source code.

Author: Sheo Narayan, the founder of DotNetFunda.com

Coverage:

sql-server-tutorials  sql-server  sql-server-how-to  sql-server-tip-and-tricks  sql-server-tips  sql-tips 
Delivery mode (?): Electronic Delivery,
Duration/Validity: Life time

Tips for buying: You may buy without logging in, however to provide a better service we suggest to login.
License/Pricing details INR Price USD Price Discount Special discount Final price Buy
Downloadable eBook with Source code for the life time validity Rs 900.00 $18.00 40.00% - Rs 540.00/ $10.80 Continue >
Contact us for volume licenses discount.Payment can be done securely using Credit card, Debit card or Net banking.

Table of Contents


Content written in this book are based on SQL Server 2014. All solutions are given with the best practices.

Introduction


  1. Introductions
  2. How to install SQL Server database?
  3. How to connect database server in Microsoft Management Studio?

Database

  1. How to create a new database in SQL Server?
  2. How to create a new database user for SQL Server database?
  3. How to specify permissions (Read/Write) for a specific user in the database?
  4. How to rename the database in SQL Server?
  5. How to drop the database from SQL Server?
  6. How to take backup of the database in SQL Server?
  7. How to restore a database in SQL Server?
  8. How to export the database from SQL Server?
  9. How to import the database into SQL Server?
  10. How to generate SQL script of the whole database structure in SQL Server?
  11. How to shrink the database in SQL Server?

Table

  1. How to create a table in the database in SQL Server?
  2. How to specify a primary key in the database table in SQL Server?
  3. How to set more than one columns of the table as Primary key in SQL Server database?
  4. How to specify auto-increment column in the database while creating a new table in SQL Server?
  5. How to add a new column in the existing database table as Auto Increment column in the SQL Server?
  6. How to specify increment and initial value to the new auto increment column from the code in SQL Server?
  7. How to set a column as primary key to the existing database table in SQL Server?
  8. How to create a new column in the existing database table as Auto increment and primary key?
  9. How to and which data type should be used for what type of data?
  10. How to create computed column (eg. Salary column = Ctc column – Pf column = Net column) in SQL Server?
  11. How & why to specify a database table column as nullable in SQL Server?
  12. How to add primary key and foreign key relationship in a Sql Server database table?
  13. How to create indexes in the Sql Server database table?
  14. How to store data of other language in the Sql Server database table?

Table - Create, Read, Update, Delete (CRUD)

  1. How to insert a new record into SQL Server database?
  2. How to read data from SQL Server database table?
  3. How to insert multiple records into the Sql Server database table at once?
  4. How to update records into the Sql Server database table?
  5. How to delete a record from the Sql Server database?
  6. How to filter records of the database table in SQL Server?

Joins

  1. How to join more than one table and get the results in SQL server?
  2. How to perform left join (or left outer join) in SQL Server?
  3. How to perform right join (or right outer join) in SQL Server?

Views

  1. How to create a View in SQL Server?
  2. How to alter a Views in SQL Server database?

Variable declaration and setting values


  1. How to declare and use a variable in SQL Server?

Query


  1. How to select a database to work with in Query window in SQL Server?
  2. How to select all columns and records from the database table in SQL Server?
  3. How to return only few columns data from a SQL Server database?
  4. How to return top n records from the database in SQL Server?
  5. How to retrieve distinct (unique) record from SQL Server database?
  6. How to sorted records from the SQL Server database table?
  7. How to sort records based on multiple columns in SQL Server database?
  8. How to use sub-query to return data from database?
  9. How to get records having null value in a column of SQL Server database table?
  10. How to use not equal to condition in the query of SQL Server?
  11. How to return records in Group by a column value in SQL Server?
  12. How to filter result returned from Group by clause in SQL Server?
  13. How to use wild card characters in SQL Server database query?
  14. How to get a random unique value in SQL Server?
  15. How to retrieve random records from the database table in SQL Server?
  16. How to merge two column value as one in SQL Server?
  17. How to get records from the table that contains a specific word (in SQL Server)?
  18. How to convert rows into columns of the database tables in SQL Server?
  19. How to transfer data from one table to another in SQL Server?
  20. How to delete duplicate rows from the database table in SQL Server?
  21. How to write query to join tables form two different databases in SQL Server?
  22. How to get a default value for a nullable fields in SQL Server?

Build in functions

  1. How to know the installed SQL Server name and version?

Aggregate functions


  1. How to user aggregate functions like AVG, MIN, MAX, SUM etc in SQL Server?
String related
    1. How to concatenate two string types columns separated by a string in SQL Server?
    2. How to concatenate more than one columns in SQL Server?
DateTime related
  1. How to get current Date and time in SQL Server?
  2. How to return day, month, and year in the SQL Server database?
  3. How to return Day name of the week, day of the week, and month name in SQL Server?
  4. How to check for validate date in SQL Server?
  5. How to get the difference between two dates in SQL Server?
  6. How to get Age in year, month and date format in SQL Server?
Conversion related
  1. How to convert the data type of the SQL Server variables?
  2. How to convert a column value from one data type to another in SQL Server?
  3. How to get the length of the string in SQL Server?
  4. How to trim unnecessary space from the string in SQL Server?
  5. How to get a part of string from a sentence in SQL Server?

User defined functions (UDFs)


  1. How to create a User defined scalar function in SQL Server?
  2. How to create a Table-valued function in SQL Srever?
  3. How to create Multi-statement Table-valued function in SQL Server?

Stored Procedure


  1. How to create stored procedure that accepts parameters to fetch data from database?
  2. How to create parameter less stored procedure to return data from Sql Server database?
  3. How to execute a stored procedure from the query window in SQL Server?
  4. How to create a stored procedure to insert record into SQL Server database?
  5. How to create stored procedure to update record in the SQL Server database?
  6. How to create stored procedure to delete a record from the SQL Server database?
  7. How to alter / modify a stored procedure in SQL Server?
  8. How to create stored procedure to insert record and return identity column value?
  9. How to create stored procedure to return paginated data (custom paginations) from SQL Server database?
  10. How to create stored procedure that accepts optional parameter in SQL Server?

Transactions


  1. How to use transaction in stored procedure in SQL Server?

Error Handling


  1. How to handle error in stored procedures in SQL Server?
  2. How to catch and throw error in SQL Server?
  3. How to return a custom error message from SQL Server in case of error?
  4. How to get more details about an error occurred in SQL Server?

Loops and Conditions

  1. How to use IF condition in SQL Server?
  2. How to use WHILE loop in SQL Server?
  3. How to use CASE statement to check a value of the column in SQL Server?
  4. How to use CASE statement to check for searched condition in SQL Server?
  5. How to use CASE statement with ORDER BY clause in SQL Server?
  6. How to use CASE statement to set a variable value in SQL Server?

Common Table Expression (CTE)

  1. How to create a CTE (Common Table Expression) and use it?

Working with XML

  1. How to retrieve data in XML format from SQL Server?
  2. How to insert records from XML to SQL Server database table?
  3. How to temporarily hold data into table variable in SQL Server?
  4. How to temporarily hold data into temporary table in SQL Server?

Triggers


  1. How to create AFTER INSERT triggers in SQL Server?
  2. How to create AFTER UPDATE triggers in SQL Server?
  3. How to create AFTER DELETE triggers in SQL Server?
  4. How to disable a trigger in SQL Server?
  5. How to enable trigger in SQL Server?
  6. How to create INSTEAD OF trigger in SQL Server?


Are you facing any other problem related with SQL Server, please let us know, we shall solve and add as part of this eBook. 

What comes with this eBook

  1. Online - anywhere and anytime access 
  2. Complete downloadable eBook with no expiry date
  3. Complete source code is available in the eBook itself

Itfunda
ITFunda .com


Itfunda's Profile


ITFunda.Com is an e-commerce website that furnishes a platform to the interested buyer and seller to interact and transact for the software or software related services. 

We are a part of SN ITFunda Services LLP, a parent establishment of a popular Microsoft(R) technology related knowledge based website www.dotnetfunda.com.

SN ITFunda Services LLP is a authorized distributor / re-seller of
  • Own products
    • .NET How to's
    • ASP.NET How to's
    • jQuery How to's
    • ASP.NET AJAX Tutorials
    • .NET Corporate trainings and
    • Online .NET Trainings
  • TechSmith Corporation products like 
    • Camtasia Studio
    • SnagId
    • Morae
  • Nevron Software
    • Nevron .NET Vision
    • Nevron Chart for Sharepoint
    • Nevron Chart for SSRS
    • Nevron .NET Chart
    • Nevron Diagram for .NET
    • Nevron Gauge for .NET
    • Nevron Gauge for Sharepoint
    • Nevron Sharepoint Vision Suite
    • Nevron SSRS Vision
  • Questpond training materials
  • Deccansoft training materials

Comments


If you have bought this, please cast your vote and provide your comment about this tutorial.

Please Sign In to vote.

Share this to:

Facebook Twitter LinkedIn Google+ Pinterest Email Addthis

Other Trainings

About Us | Contact Us | Partners | Privacy Policy | Terms and Conditions | Buyer's FAQs | Seller's FAQs | Currency Converter | Go Top

Notice: If you found someone plagiarising our content/materials, kinldy let us know.

© SN ITFunda Services LLP. Site design and layout is copyright to SN ITFunda Services LLP.
Copying or duplicating or mimicking the site design and layout is prohibited and will be treated as a legal offence and will be prosecuted.
Logos, company, product, service or other names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 11032014 | 6/27/2017 8:09:59 AM