Course: SQL Server 2012 Administration and T-SQL

This course will start with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of the many built-in T-SQL functions, for doing things like working with numbers, string manipulation, as well as global functions for getting state information. You’ll also learn about how to rank results using special functions and the OVER clause.

In this course you’ll learn about the SELECT statement and its incredible flexibility when retrieving data from one or more database tables. You can shape the data you retrieve, and filter it using the WHERE clause. SQL Server rarely returns data in the order you want, so you can use the ORDER BY clause to sort it. Next you’ll learn some advanced ways to select data. With the GROUP BY clause, you can summarize the information in one or more tables, aggregating it various ways, if you wish. You’ll also learn how you can join the data together from multiple tables, efficiently including related data in the result sets.

When you retrieve data with a SELECT statement, SQL returns a result set. However, any actions you take on that data (besides just looking at it) involve data manipulation queries that use one of the following three T-SQL statements: INSERT, UPDATE, or DELETE. SQL queries that use these statements are sometimes known as action queries. You’ll learn about the basic uses of these statements. When you modify data in SQL Server, it is important to understand how isolation levels and locking can affect performance and concurrency. You’ll learn about these concepts and how they can affect T-SQL code you write, as well as mitigating measures you can take to avoid problems.

• The new version of SQL Server 2012 has many new features. This

• course will talk about these new features and give a tour of SQL
• Server 2012.You will see the differences between the available
• editions of SQL Server 2012. Get an overview of the components and
• tools that SQL Server 2012 includes. Learn about Management Studio
• and see the sample databases used in this course. You will see how
• to work with queries, tables, and views in SQL Server. Then the
• course will finish up with an overview of SQL Server Business
• Intelligence Services.

So your company has decided to purchase or upgrade to SQL Server 2012, so now what? This course will cover how to prepare for a SQL Server 2012 installation. It will help you to understand what is involved in upgrading an earlier version of SQL Server to SQL Server 2012. See how to install a default instance of SQL Server 2012 and find out how to configure the server after the installation.

The SQL Server 2012: Security Basics course will show you the basics of SQL Server security by giving you an understanding of potential data threats and how SQL Servers design protects against them. You will then learn about SQL Server and Windows integrated authentication. Then see how SQL Server provides an authorization system to control access to data and objects.

In the SQL Server 2012: Permissions and Data Protection course you will understand permissions in SQL Server and how they provide granular control over data and objects. Then you will learn how to provide a final layer of defense by encrypting data.

SQL Server 2012 Management Studio is an excellent tool that is used to code and administer SQL Server 2012. The course will show you Management Studio and how to write code and administer a server. Then the course will explore Management Studios Object Explorer tool. Then see how you can use the Query Editor to write and debug SQL Server code.

Creating a database is not just inputting data into a computer and expecting a database to appear. This course will teach you the basics of relational database design principles. You will then see how to create a SQL Server database based on sound design principles. Then see how to build tables using the SQL Server Management Studio designers. You will learn about SQL Server data types, how to create constraints, triggers, and indexes. Then to finish up create a database diagram and define relationships to enforce referential integrity.