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

No other version available

No Data