MCSA SQL 2016 Database Developer Training
Details
Order the MCSA SQL 2016 DataBasics Developer OEM CertKit. A dynamic, unique 1-click certification preparation product. OEM CertKit offers the student learning and certification preparation tools that are fully integrated into a customized learning management
system (LMS).
With the OEM CertKit the user has access to all following products from one LMS. Fully integrated products include: extensive E-Learning with 1 year online access, exam quizzes, tips and information, MeasureUp exam simulation is available for 60 days and starts
the first time you enter the practice test area. Some OEM Cert Kit titles include 1 year of online Mentoring and Virtual LABs (extra charge). * Check the General Properties section below to see if online Mentoring and Virtual LABs are included for this title.
Outline
Course: 2 Hours, 9 Minutes
- Course Introduction
- SQL Server 2016 Architecture Overview
- SQL Server 2016 Editions and Components
- SQL Server 2016 Functions and Capabilities
Course: 2 Hours, 21 Minutes
- Course Introduction
- SELECT Statements Overview
- Writing SELECT Statements in SQL Server 2016
- Calculated Expressions
Course: 2 Hours, 14 Minutes
- Course Introduction
- ORDER BY Clause
- Sorting Data
- Filtering Data
- WHERE Clause
- Predicates and Operators
Course: 1 Hour, 36 Minutes
- Course Introduction
- ORDER BY Clause
- Sorting Data
- Filtering Data
- WHERE Clause
- Predicates and Operators
Course: 2 Hours, 20 Minutes
- Course Introduction
- Aggregate Functions Overview
- SUM Aggregate Function
- AVG Aggregate Function
- MIN Aggregate Function
- MAX Aggregate Function
- COUNT Aggregate Fuction
- Aggregating Distinct Valuesnction
- NULL and Aggregate Functions
Course: 1 Hour, 36 Minutes
- Course Introduction
- Subqueries Overview
- Scalar Subqueries
- Writing Effective Scalar Subqueries
- Multi-valued Subqueries
Course: 1 Hour, 35 Minutes
- Course Introduction
- UNION vs. UNION ALL Operators
- Writing Queries That Use the UNION Operator
- Writing Queries That Use the UNION ALL Operator
- Mixed UNION and UNION ALL Operators
Course: 1 Hour, 57 Minutes
- Course Introduction
- Understanding Stored Procedures
- Using Stored Procedures
- Input parameters
- Output parameters
- Table-valued Functions
- Scalar-valued User-defined Functions
- TRY...CATCH Error Handling
- RAISERROR Statements
•TestPrep 70-761 Querying Data with Transact SQL Test your knowledge on the skills and competencies measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.
Developing SQL Databases (exam 70-762)19:38 hoursSQL Server 2016 Database ObjectsCourse: 1 Hour, 48 Minutes
- Course Introduction
- Creating Tables
- Dropping Tables
- Altering Tables
- Adding and Removing Columns
- Duplicating Tables
- Renaming Tables
- Constraints
- Naming Conventions
Course: 2 Hours, 5 Minutes
- Course Introduction
- Index Design Basics
- Tables Without Clustered Indexes
- Clustered vs. Nonclustered Indexes
- Creating Clustered Indexes
- Creating Nonclustered Indexes
- Creating Unique Indexes
- Creating Filtered Indexes
- Creating Indexes with Included Columns
- Deleting Indexes
- Modifying Indexes
Course: 1 Hour, 33 Minutes
- Course Introduction
- Columnstore Index Overview
- When to Implement a Columnstore Index
- Creating a Clustered Columnstore Index
- Columnstore Indexes Data Loading
- Columnstore Versioned Feature Summary
- Columnstore Indexes Query Performance
- Columnstore for Real-time Operational Analytics
- Columnstore Indexes for Data Warehousing
- Columnstore Indexes Defragmentation
Course: 2 Hours, 29 Minutes
- Course Introduction
- Types of Data Integrity
- Enforcing Data Integrity
- Entity and Referential Integrity
Course: 1 Hour, 55 Minutes
- Course Introduction
- Creating DML Triggers
- Creating CLR Triggers
- DML Trigger Security
- Implementing DDL Triggers
- Gathering DDL Trigger Information
- DDL Events and Event Groups
- Implementing Triggers
- Specifying First and Last Trigger
- Managing Transactions in Logon Triggers
- Disabling Logon Triggers
- AFTER Trigger
- INSTEAD Trigger
Course: 1 Hour, 43 Minutes
- Course Introduction1
- Transactions
- BEGIN TRANSACTION
- COMMIT TRANSACTION
- COMMIT WORK
- ROLLBACK TRANSACTION
- ROLLBACK WORK
- SAVE TRANSACTION
- DML Statements and Transactions
- Transactions in High-concurrency Databases
- Explicit Transactions
- Implicit Transactions
Course: 1 Hour, 47 Minutes
- Course Introduction
- Locking Basics
- Concurrency Effects
- Understanding Deadlocks
- Minimizing Deadlocks
- Handling Deadlocks
- Remediating Deadlocks
- Troubleshooting Locking Issues
- Lock Escalation Behavior
Course: 1 Hour, 59 Minutes
- Course Introduction
- Creating Statistics
- Modifying Statistics
- Viewing Statistics Properties
- Updating Statistics
- Maintenance Tasks
Course: 2 Hours, 12 Minutes
- Course Introduction
- Workloads
- Resource Governor
- Enabling Resource Governor
- Configuring Resource Governor
- Creating a Resource Pool
- Creating a Workload Group
- Disabling Resource Governor
- Memory Configuration
Course: 2 Hours, 7 Minutes
- Course Introduction
- Performance Metrics
- Performance Baseline
- Performance Monitor
- Dynamic Management Objects
- Troubleshooting Performance Issues
- Azure SQL Database Performance
Speaker/s
OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more.
OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.
Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.
OEM - Learn to WorkChoose from 1000+ training courses from 200+ brands for your personal and business development.
An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.
We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.
There are no reviews written yet about this product.
Add your review
Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.
What is OEM Office Elearning Menu?
OEM Office Elearning Menu provides ICT training to businesses and individuals, for end users or ICT professionals of all skill levels. From Microsoft Office to Certified Ethical Hacker, with over 200 brands of training we are sure we can get you started. By responding to new technology, we can always keep our training offerings relevant. Plus, we employ our own instructors, all of whom are certified and have years of hands-on experience.
What does OEM Office Elearning Menu do?
We offer comprehensive, customized ICT training from a variety of major A-brands to certification. For Microsoft Office, we can provide training in five languages: Dutch, English, French, German and Spanish. For Microsoft Office, we also take the exams. In addition to Microsoft Office, we offer customized training for all kinds of other software. This makes us the one-stop shop for all ICT training. Our goal is to teach people how to work with software in a goal-oriented and efficient way. We find good communication very important. We offer short lines of contact. Our customers always have a fixed point of contact with us.
How does a training course at OEM Office Elearning Menu work? ...
