Database Archives - Page 21 of 26

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

14/08/2019 Learning for Life Leave a Comment

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

12/08/2019 Learning for Life Leave a Comment

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

11/08/2019 Learning for Life Leave a Comment

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

06/07/2019 Learning for Life Leave a Comment

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

04/07/2019 Learning for Life Leave a Comment

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

24/06/2019 Learning for Life Leave a Comment

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

15/06/2019 Learning for Life Leave a Comment

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

05/06/2019 Learning for Life Leave a Comment

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

31/05/2019 Learning for Life Leave a Comment

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…]

SKILLSHARE AWS Database Services-iLLiTERATE

19/05/2019 Learning for Life Leave a Comment

SKILLSHARE AWS Database Services-iLLiTERATE
English | Size: 166.38 MB
Category: CBTs

Dear Learners, In this class, we will learn about AWS Database Services, Majorly there are two Database services used in AWS. One is RDS which provides lots of traditional database services such as MySQL, SQL Server, Oracle Server along with new popular DB Engines like Amazon Aurora DB, Maria DB and Postgre SQL. [Read more…]