ISDWImplementing SQL Data Warehouse
Course Overview
As an administrator or developer, it's important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema. Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. Explore encryption-related tools and processes used in SQL Server 2016. To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. Explore data access and permissions, including database object permissions, users, and custom roles.
In order to properly design and implement a relational database schema, it's important to have an understanding of the fundamentals of SQL Server 2016. Explore the creation and altering of tables, including constraints. To optimize performance, you must understand how to properly design your SQL Server 2016 database. Examine database normalization and the various data types available in SQL Server 2016.
Key Takeaways
• Online learning that includes a broad catalogue of in-demand topics, built with deep expertise in the subject matter and scientifically proven learning science;
• Engaging learning experiences ranging from micro-learning to complete journeys and professional certifications that have impacted nearly half a billion people worldwide and certified more IT professionals than any firm on the planet; and
• A powerful, flexible, and engaging cloud-native plat-form designed to seamlessly integrate both with lead-ing HCM solutions and the natural flow of work.
Unlike other providers, Skillsoft is inclusive, with learning options for all. Our effectiveness, variety and global reach are unmatched.