Text
Murach's SQL server 2012 for developers
Get started fast
The concepts and terms you need for working with relational databases and SQL
* How to use the Management Studio to work with a SQL
Server database
Master the SQL that you'll use every day
* How to write SQL statements that retrieve and update the data in a database
* How to work with inner and outer joins, summary queries, and subqueries...it's all here
* How to use data types and built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values
Learn how to design and create a database
* How to design a database...the first step toward becoming a database administrator
* How to create a database and its tables using SQL statements or the Management Studio...valuable skills, whether you're on the DBA track or not
* How to take advantage of the new 2012 sequence feature to casily assign values to integer columns
Master advanced SQL features of the DBMS
* How to work with views, scripts, stored procedures, functions, table-valued parameters, triggers, cursors, transactions, locking, security, and XML....everything you need to complete your mastery of SQL
* How to use the FILESTREAM storage feature to work with large amounts of binary data, such as image, sound, and video files
Harness the power of the .NET Framework
How to use the Visual Studio IDE, SQL Server Data Tools (SSDT), and C# or Visual Basic to create traditional database objects like stored procedures, functions, and triggers
How to use SSDT with C# or Visual Basic to create database objects that can't be created with SQL, such as user-defined types and aggregate functions
Availability
#
Information Technology
005.7565/SYV/IT0477
IT0477
Available
Detail Information
- Series Title
-
-
- Call Number
-
005.7565/SYV/IT0477
- Publisher
-
Mumbai :
Shroff Publishers & Distributors Pvt.Ltd.,
2012
- Collation
-
-
- Language
-
English
- ISBN/ISSN
-
978-93-5023-939-1
- Classification
-
NONE
- Content Type
-
-
- Media Type
-
-
- Carrier Type
-
-
- Edition
-
First Edition
- Subject(s)
-
- Specific Detail Info
-
-
- Statement of Responsibility
-
-
Other version/related
No other version available
File Attachment
No Data
You must be logged in to post a comment