Brief description
Microsoft SQL Server — relational database management (RDBMS) developed by Microsoft Corporation. The main query language used is Transact — SQL, created jointly by Microsoft and Sybase. Transact-SQL is an implementation of ANSI/ISO structured query language (SQL) extensions. Used to work with databases in the size from personal to large scale databases предприятия; competes with other DBMS in this segment of the market.
SQL Server — based data platform from Microsoft that provides a robust and sustainable performance (including the technology of in-memory data processing) and helps to extract valuable information from any data located on-premises and in the cloud.
Links to materials for the study
Basic course
- Landing page technical documentation for SQL Server
- Transact-SQL reference (Database Engine)
- Developer reference for SQL Server 2014
- Optimizing the performance of SQL Server queries
- The master of import and SQL Server export
- Start import wizard and export of SQL Server
Tutorials
Video
- A detailed video course on MS SQL Server and T-SQL syntax
- Video course on MS SQL Server 2012
- Dr. house approach to the optimization of SQL queries. Part 1
- Dr. house approach to the optimization of SQL queries. Part 2
- Backup and restore MS SQL Server
- Backup and restore of system databases in SQL Server 2014
Presentation
Recommended books
Software
Opportunities for certification
- Certification Microsoft SQL Server
- Exam 70-461 (Querying Microsoft SQL Server 2012/2014)
- Exam 70-464 (Developing Microsoft SQL Server Databases)