Imate žicu za učenje?

Microsoft SQL Server 2014: Design Reports and Create Data Sources and Datasets

Overview/Description SQL Server Reporting Services or SSRS enables developers to create robust reports, which can be accessed from a variety of sources. To create reports, SQL Server Reporting Services needs to be installed in either Native mode or SharePoint mode. The topology that is chosen depends on if you need to integrate the reports with SharePoint. The first step in creating reports is deciding what data is required and from where and which tool you will use to create the reports. This course will discuss the Reporting Services topologies and how to install and configure them. It...

Microsoft SQL Server 2014: Report Formatting and Interactivity

Overview/Description SQL Server provides two tools – SQL Server Data Tools Report Designer and Report Builder – to create robust reports in Reporting Services. Using either of these tools, developers or administrators can create different types of reports and format them accordingly using different options. This course will demonstrate how to create different types of reports, including tablix and matrix. It will also demonstrate how to add different options to the reports, including images, charts, column and heading formatting, and how to add interactivity. This course is one in a series...

Microsoft SQL Server 2014: Manage Reporting Services

Overview/Description An important administration task for SQL Server Reporting Services is to ensure that users can only access reports and parts of the reports that they require. Security for Reporting Services can be implemented at various levels, from the server down to specific items in a report. Administrators also have to manage the Report Server for performance and availability. This course will demonstrate how to configure security for reports and manage the Report Server, including backing up and restoring, troubleshooting, and performance tuning. This course is one in a series of...

Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules

Overview/Description An important administration task for SQL Server Reporting Services is to ensure users can only access reports and parts of the reports they require. Once users have access to the reports subscriptions can be created to ensure the reports being accessed have up-to-date data, as well as the creation of schedules to process the reports at specific intervals. This course will demonstrate how to process and view reports and how to create different subscriptions and schedules. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466...

Microsoft SQL Server 2014 - Developing Databases: New Features

Overview/Description Microsoft SQL Server 2014 builds from version 2012 to provide optimal performance for applications using In-Memory OLTP, which is a memory-optimized database engine integrated into the SQL Server engine. SQL Server 2014 also provides the ability to create hybrid platform and cloud scenarios by enabling cloud backups and recoveries to decrease on premise costs for storage. This course will discuss and demonstrate the objectives for SQL Server 2014 for the 70-464 Microsoft SQL Server: Developing Databases certification exam, this will include the In-Memory OLTP feature and...

MySQL: Database Concepts, Design, and Installation

Overview/Description MySQL is fast, reliable, easy to use, free to download and supports standard SQL. In this course, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. You’ll also be introduced to the core concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design. Target Audience Personnel at all levels of an enterprise seeking to attain competency in MySQL Prerequisites None Expected Duration (hours) 2.0 Lesson Objectives MySQL: Database Concepts, Design,...

MySQL: Querying Data Using the SELECT Statement

Overview/Description MySQL is fast, reliable, easy to use, free to download and supports standard SQL. In this course, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. You’ll also be introduced to the core concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design. Target Audience Personnel at all levels of an enterprise seeking to attain competency in MySQL Prerequisites None Expected Duration (hours) 3.0 Lesson Objectives MySQL: Querying Data Using the...

MySQL: Using the Data Manipulation and Definition Statements

Overview/Description It’s essential as a database administrator to understand how to use data definition and data manipulation statements in order to manage and modify database objects. In this course, you’ll learn how to use insert, update, and delete statements to manage data within a MySQL database. You’ll also learn how to use DDL statements to create, drop, and alter databases, tables, and views. Target Audience Personnel at all levels of an enterprise seeking to attain competency in MySQL Prerequisites None Expected Duration (hours) 2.0 Lesson Objectives MySQL: Using...

MySQL: General Syntax, Advanced Queries, and Stored Programs

Overview/Description As a MySQL Database Developer, you need to understand the overall general syntax in order to obtain the correct information and provide information in the code, such as comments. Creating programs that can be stored on the server and executed multiple times is also essential. In this course, you'll learn about the general syntax of MySQL, including comments, identifiers, and data types. The course also covers how to handle advanced queries and data management, as well as how to create and use stored programs. Target Audience Personnel at all levels of an enterprise...

MySQL: Advanced Routines, Optimization, and DCL

Overview/Description Writing advanced routines can be a big part of being a database developer as well as optimizing the database to ensure queries are running efficiently for end users. In this course, you'll learn how to create and use advanced procedures, functions, and triggers and how to optimize queries and performance of a MySQL database. This course also covers how to grant, revoke, and deny user permissions for the underlying database objects. Target Audience Personnel at all levels of an enterprise seeking to attain competency in MySQL Prerequisites None Expected...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?