Members

SQL Server Training

If you buy the Unlimited Training package, you will have access to the following training materials:

• SQL Server 2012 video training (Basic tutorials)
• Additional SQL 2012 training videos (Advanced video tutorial)
• Useful Transact SQL Scripts
• PowerPoint Presentations and Misc documents

SQL Server 2012 Video Training (Basic tutorials):

The Basic tutorials include the following Microsoft SQL training videos.

1. Installation of SQL Server 2012
2. MSSQL 2012 Configuration Manager
3. Creating database objects in SQL 2012
4. TSQL commands like SEQUENCE and CONCAT
5. Database Relationships in SQL database
6. What is SQL Server Management Studio (SSMS)?
7. Introduction to Transact SQL (TSQL)
8. Using Inner and Outer Joins in SQL Server 2012
9. Implementing Security in MS SQL 2012
10. New Features like Contained Database, FileTable ..

Here is brief information on the individual lessons:

-Installation of SQL Server 2012:
In this training demo, we start by going over the hardware and software requirements for SQL 2012 installation. We run the Setup.exe which will launch the Installation center. We highlight the best practices that are used by the IT industry

-MSSQL 2012 Configuration Manager:
In this video tutorial, we are going to cover SQL Configuration Manager. It combines three utilities including Client Network utility, Server Network utility and Service Manager. Using the SQL Server configuration manager you can stop, start, pause and resume services in MSSQL.

-Creating database objects in SQL 2012:
In this tutorial video, we are going to show you how to create a database and a table in SQL Server 2012 version. We use two different ways to do this, SQL Management Studio and Transact SQL also known as TSQL.

-TSQL commands like SEQUENCE and CONCAT:
We cover new features in SQL Server 2012 from TSQL point of view. These include the Sequence object, DATEFROMPARTS, TIMEFROMPARTS and EOMONTH functions, OFFSET clause in MS SQL 2012, CHOOSE and Select IIF (Inline If) command

-Database Relationships in SQL database:
We kick off this SQL Server training session by covering terms like RDBMS, entity, field, ERD, Primary key (PK), Foreign key (FK), Inner and Outer Joins. Using SSMS we use TSQL to create the above mentioned tables and also populate them with data.

-What is SQL Server Management Studio (SSMS)?
Here we cover SQL Server Management Studio or SSMS. This is the central location for database administration and development in MSSQL 2012. Using SSMS you can execute Transact SQL, create and modify stored procedures, views, tables and also have access to the Template Explorer.

-Introduction to Transact SQL:
TSQL or Transact SQL is a powerful database language in SQL Server 2012. It includes DML (data manipulation language) and DDL (data definition language). We are going to look at Northwind database and use SQL Select, Insert, Delete and Update statements.

-Using Inner and Outer Joins in SQL 2012:
A SQL join facilitates in bringing data together from various tables. We go over basic concepts like Primary key, Foreign key, Inner and Outer joins in SQL 2012. An INNER JOIN is used to pull matching data from two tables; this concept is highlighted using Venn Diagrams.

-Implementing Security in MS SQL 2012:
There are many layers of Security in SQL Server including physical layer, surface area, object access etc. We start off this SQL training and discuss terminology like Principals, Roles, Securables and Microsoft recommended “Best Practices”.

-New Features like Contained Database, FileTable:
We start with a Contained Database which is a specialty db that is isolated from other SQL Server databases. Next thing we discuss is a FileTable, which is a specific table that stores file and directory information. We move onto ColumnStore index that is specially built for high performance in a MSSQL data warehouse system.

More info on these videos can be found at this page:

http://sqlserver2012tutorial.com/sql-server-tutorials-details

 

Additional SQL 2012 training videos (Advanced video tutorial):

Videos are coming soon …

 

 

Useful Transact SQL Scripts:

Here is a list of useful Transact SQL Scripts. These will assisst you in day to day operations as you learning MS SQL 2012. The first five TSQL scripts can be download for FREE:

1. How-to-create-database-in-sql-server-2012-0001.sql
2. Create-students-table-in-sql-server-2012-0002.sql
3. Rename-or-Change-sql-server-database-0003.sql
4. Using-insert-sql-statement-with-college-database-0004.sql
5. New-feature-SQL-Server-2012-Sequence-0005.sql
6. Assign-primary-key-to-a-SQL-table-0006.sql
7. Declaration-and-assignment-of-variables-0007.sql
8. How-to-use-new-sql-function-concat-0008.sql
9. Use-while-loop-in-sql-2012-0009.sql
10. Optimize-the-queries-with-temp-table-0010.sql
11. SQL-Server-2012-using-sql-select-statement-0011.sql
12. Difference-between-inner-and-outer-joins-0012.sql
13. Delete-data-from-microsoft-sql-server-table-0013.sql
14. Get-list-of-tables-in-MSSQL-2012-0014.sql
15. Microsoft-sql-server-update-statement-0015.sql
16. Make-copy-of-database-with-backup-database-0016.sql
17. Powerful-extended-stored-procedure-xp_cmdshell-0017.sql
18. Sql-script-to-restore-sql-2012-database-0018.sql
19. Delete-all-user-tables-in-SQL-2012-0019.sql
20. Drop-database-objects-like-database-tables-0020.sql