Why SQL Server
SQL Server is the biggest leap forward in Microsoft data platform history. Gain real time insights across your transnational and analytical data with a scalable database platform that has everything built in, from unparalleled in-memory performance, new security innovations and high availability, to advanced analytics that make mission-critical applications intelligent
With our selection of SQL training opportunities, you can learn how to implement and manage database solutions, migrate with the ability to scale on demand, work with powerful SQL Server features, and see how SQL Server integrates with other Microsoft products.
Database Design Methodology
This database training for beginners introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, T-SQL scripts, and writing database queries, in addition to executing stored procedures.
The database training course is designed for individuals seeking to learn database fundamentals, including relational databases, database management systems, and database components. Take this course and expand your database skills and knowledge today.
- What is Design Methodology?
- Critical Success factors in Database Design
- Conceptual Database Design Methodology
- Logical Database Design for Relational Model
- Physical Database Design for Relational Model
- Introduction to Core Database Concepts
This module defines databases, provides examples of relational database tables, and introduces common database terminology.
- Relational Concepts
In this module you’ll learn about normalization, referential integrity, and constraints.
What you’ll learn
After completing this course, students will be able to:
- Describe the basic architecture and concepts of Microsoft SQL Server 2014.
- Understand the similarities and differences between Transact-SQL and other computer languages.
- Write SELECT queries
- Query multiple tables
- Sort and filter data
- Describe the use of data types in SQL Server
- Modify data using Transact-SQL
- Use built-in functions
- Group and aggregate data
- Use subqueries
- Use table expressions
- Use set operators
- Use window ranking, offset and aggregate functions
- Implement pivoting and grouping sets
- Execute stored procedures
- Program with T-SQL
- Implement error handling
- Implement transactions
Developing Microsoft SQL Server
You Will Learn
Implementing Tables and Views
Find out how to implement disk-based tables based on appropriate data types and constraints and how to implement table objects using variables, temporary tables, and common table expressions. Hear how to implement views as a way of providing a de-normalized abstraction layer over the database schema for client applications.
Learn the difference between heaps, clustered indexes, and non-clustered indexes. Hear how to design and implement clustered and non-clustered indexes, including considerations for filtered indexes, data types, page density, and index maintenance.
Implementing Stored Procedures and Functions
Explore implementing and executing stored procedures, including execution context, parameters, and return values. Learn about the different kinds of functions that you can create, along with how to implement them.
Get an introduction to transactions and isolation concepts, and look at how to implement transactions, catch and resolve errors, set isolation levels, and design database objects for concurrency. Learn how to detect and resolve contention and locking issues, including deadlock.
Implementing In-Memory Objects
Find out how to implement clustered and non-clustered columnstore indexes on disk-based tables. Learn how (and when) to implement in-memory tables and stored procedures, and explore considerations for co-existence with disk-based tables and other database objects.
Optimizing and Troubleshooting Queries
Learn how to tune poorly performing queries, and get tips on dealing with common performance issues and tools you can use to analyze and tune workloads.
Administering Microsoft SQL Server
You Will Be Learn:
Install and Configure SQL Server
This module discusses issues and the major decisions involved in installing and initially configuring SQL Server. The information provided will help you to avoid making mistakes that are difficult to reverse and could require reinstallation.
Maintain Instances and Databases
In this module you will learn about some of the frequently used instance-level and database-level options. Implementing the primary automation features of jobs and alerts is discussed and demonstrated thoroughly.
Performance Optimization and Troubleshooting
SQL Servers operate in a dynamic environment; conditions change moment by moment. This module discusses and demonstrates primary diagnostic and performance enhancement tools such as the Profiler, the Database Engine Tuning Advisor, the Management Data Warehouse, and Catalog and Dynamic Management Views.
Protection and stewardship of data is one of the database administrator’s first orders of business. In this module you’ll gain an understanding of tasks and strategies that are related to backup and restore operations and investigating database integrity with DBCC commands. Maintenance of indexes, which are vitally important to the performance of queries, will also be discussed and demonstrated.
“When in doubt, it’s my fault” is what the DBA must live by, and this is definitely true regarding the stewardship of security. Instance, database, and object security strategies are examined as well as the implementation of logins and server roles, user and database roles, and leveraging schema objects.