SQL Server 2014: Management Studio

Course description

This course introduces the learner to the basics of the SQL Server Management Studio system and provides practical approaches to implementing a database. Topics that will be covered include constraints and columns, indexes, data types, queries and much more. If you are looking to create or manage a database or write error-free codes with this software application, then this free online course is for you.

‘SQL Server 2014: Management Studio’ has been specially prepared to give you a comprehensive understanding of setting up an SQL Server environment and how to manipulate Management Studio, the integrated development environment for writing SQL codes and queries. Before writing codes in SQL, it is important to understand the various components in Management Studio. This course will introduce you to tools for integration services, SQL Server Profiler as well as server management tools. You will be taken through various options to personalize Management Studio using smart indenting. Did you know that the Object Explorer can display up to 65,536 objects at the same time? This course analyzes in detail Object Explorer and its uses in SQL Server. It is impossible to code in the SQL environment without the use of its tools. By completing this course, you will familiarize yourself will all the available tools and learn how to use them.

If you want to learn how to switch to full-screen mode, connect to other servers or use SQL commands to execute scripts and operating system commands, then you should complete this course. You will also be able to identify the different data types, including the sql_variant, XML data types as well as SQLCLR data types which are created using the C# and visual basic. This course explains the methods for creating new queries, managing multiple query windows and executing codes in a query editor. It illustrates the techniques for creating data manipulation language scripts and data definition language scripts in order to execute procedures. Did you know that you can write codes without accessing database objects? This course describes how to reconnect to the database server to test and run your codes. The modules include information about different recovery models (simple recovery model, full recovery model and bulk-logged recovery model) supported by SQL Server for recovering from a database server meltdown.

Furthermore, this course gives a brief history of the relational model and explains the relational database design principles. You will delve into creating your own databases and learn how to design them using SQL's features and tools. It will teach you in detail referential integrity, normalization as well as the different types of relationships in SQL. The course will teach you how to avoid the stress of having to write non-functional codes or using the wrong tools and not achieving the desired results. It also covers concepts like the foreign key, primary key and surrogate keys used in relational databases. Lastly, cascading updates and deletes options will be illustrated. The learning content will be of great interest to students, researchers and anyone with an interest in creating programs using SQL Server 2014 Management Studio. Register for this course today to start your next learning.