Linux Academy – Database Essentials-ViGOROUS

Linux Academy – Database Essentials-ViGOROUS
English | Size: 631.43 MB
Category: Tutorial


AWS Essentials is a course for those who are completely new to AWS. No prior AWS experience is required. We will introduce you to AWS, provide an overview of the core AWS services, and walk you through the process of setting up your own AWS account. Your learning will be reinforced with real-world scenario hands-on activities using our Live Environment, and quizzes will be used to help check your understanding of the presented topics. [Read more…]

Linkedin – Learning Aws for Developers Rds Mysql Database With Lambdas-BiFiSO

Linkedin – Learning AWS for Developers Rds Mysql Database With Lambdas-BiFiSO
English | Size: 178.25 MB
Category: Tutorial


The demands of online resources, especially databases, is growing for app development. AWS puts the power of relational databases (RDS) in the hands of developers with Lambdas, but without the difficulty of server configuration and maintenance. AWS provides the power of the server without the needs of configuration, development, and maintenance. In this course, learn how to leverage a RDS MySQL Database, a relational database that can be accessed from an app via Lambdas. Bear Cahill covers AWS account setup, creating a MySQL database, initializing a Node.js project, converting code to Lambda, testing, using SQL queries to work with rows of data, and more. [Read more…]

Linux Academy – Database Administration and SQL Language Basics

Linux Academy – Database Administration and SQL Language Basics-ViGOROUS
English | Size: 1.38 GB
Category: Tutorial


Welcome to the Database Administration and SQL Language Basics course! In this course, we will be using MySQL to learn about administering a database, as well as the basics of the SQL language. The first half of the course will begin with the installation of a MySQL server, then cover common administrative tasks such as creating databases and tables, inserting and viewing data, and running backups for recovery. [Read more…]

Technics Publications – Database Series The Definitive Guide to MySQL and MariaDB

Technics Publications – Database Series The Definitive Guide to MySQL and MariaDB-RiDWARE
English | Size: 591.08 MB
Category: Tutorial


Follow along with MySQL expert Victor Deras and master relational database constructs and MySQL (and MariaDB). Build powerful and robust relational databases after watching these 12 topics within the MySQL video series:

– Introducing MySQL. This first topic in the MySQL (and MariaDB) video series introduces you to this powerful open source relational database. Install both client and server, on Windows or Linux. MariaDB can also be used as an alternative to MySQL, and almost everything in this course also applies to MariaDB. [Read more…]

Pluralsight Programming SQL Server Database Triggers and Functions

Pluralsight Programming SQL Server Database Triggers and Functions
English | Size: 442.50 MB
Category: Tutorial


As a SQL Server Database Developer, it is often necessary to have business-layer logic that exists within the database to ensure clean, consistent data. Although constraints and foreign key relationships can go a long way to provide the essential relational guarantees, Triggers provide the ability to validate and act on data at the time of modification, while Functions help you provide consistent methods for accessing the data across applications. In this course, Programming SQL Server Triggers and Functions, you will learn foundational knowledge to better administer and develop efficient, high-performing Triggers and Functions. First, you will learn how to develop DML, DDL, and LOGON Triggers, and how to avoid common mistakes. Next, you will discover the differences between Multi-Statement and Single-Statement functions and how to write the most efficient functions possible. Finally, you will explore some lesser-known features and upcoming improvements in newer versions of SQL Server that can improve your overall experience with Triggers and Functions. When you are finished with this course you will have the skills and knowledge needed to administer and develop efficient, high-performing Triggers and Functions. [Read more…]

Pluralsight – Microsoft Azure Database Monitoring Playbook by John Savill

Pluralsight – Microsoft Azure Database Monitoring Playbook by John Savill
English | Size: 217.66 MB
Category: Tutorial


This course explores the key monitoring capabilities that can be used to gain insight and actionable steps for Azure SQL Database, Azure SQL Datawarehouse, and Azure Cosmos DB. [Read more…]

Udemy – Managed NoSQL Database In The Cloud Amazon AWS DynamoDB

Udemy – Managed NoSQL Database In The Cloud Amazon AWS DynamoDB-ELOHiM
English | Size: 2.23 GB
Category: Tutorial


Requirements
You should have familiarity with Windows/ Linux Operating System
You should have basic understanding of Databases and typical Database operations
You should have working knowledge of Amazon Web Services (AWS)
You should have some programming background in languages like Java, NodeJS and preferably Python
You should have zeal to learn Databases and new technology
[Read more…]

Pluralsight Microsoft Azure Database Monitoring Playbook

Pluralsight Microsoft Azure Database Monitoring Playbook
English | Size: 171.92 MB
Category: Tutorial


Using database services in the cloud can initially present challenges as to the right way to monitor the deployments. In this course, Microsoft Azure Database Monitoring Playbook, you will gain the ability to implement and use monitoring to achieve the results required. First, you will learn key aspects of monitoring databases in Azure. Next, you will discover monitoring options for Azure SQL Database in the portal and beyond. Finally, you will explore how to monitor Azure Cosmos DB and use that monitoring to ensure proper data partitioning. When you’re finished with this course, you will have the skills and knowledge of monitoring Azure database offerings needed to ensure the smooth operation and use of Azure-based deployments. [Read more…]

Skillshare SQL Master Database Queries In Just 90 Mins-ANALYTiCS

Skillshare SQL Master Database Queries In Just 90 Mins-ANALYTiCS
English | Size: 186.10 MB
Category: CBTs


Last time you tried to get a report from your raw data, however writing SQL queries proved to be a troublesome task..

But it doesn’t have to be this way!

You Will Walk Away With…

MORE TIME!
Master writing SQL queries in just 90 minutes!
Understand the essence of these queries, without memorizing them!
See how each of these queries are used with real examples!
[Read more…]

SKILLSHARE Learn ASP.Net MVC and Entity Framework (Database First)-iLLiTERATE

SKILLSHARE Learn ASP.Net MVC and Entity Framework (Database First)-iLLiTERATE
English | Size: 1.30 GB
Category: Tutorial


Using MVC, Entity Framework, and ASP.NET Scaffolding, you can create a web application that provides an interface to an existing database.

This course will show you how to automatically generate code that enables users to display, edit, create, and delete data that resides in a database table. The generated code corresponds to the columns in the database table.
[Read more…]