AmigosCode – Advanced Databases 2020-2

In this course you will learn advanced database concepts that you must know to write production ready applications. As a software engineer knowing these concepts will make sure you write solid backend application and fully understand what goes on behind the scenes. You will learn the following:

What you’ll learn

• Joins
• Indexes
• Transactions
• Database Administration
• Functions / Stored Procedures
• Schemas
• Database Backups
• Function skeleton
• Create functions
• View and Drop Functions
• Roles
• View Roles
• Creating roles
• Privileges
• Revoking Permissions
• Member Roles

Specificatoin of Advanced Databases

• Publisher : AmigosCode
• Teacher : Nelson
• Language : English
• Level : Expert
• Number of Course : 39
• Duration : 2 hours and 47 minutes

Content of Advanced Databases

# Installing Postgres
# Datagrip
# Installing Datagrip
# Configure Datagrip
# Presentation assistant and Keymaps
# Connecting to Databases Using Terminal
# Create Database Using Datagrip
# Joins
# Inner Joins
# Left Joins
# Right Join
# Full Join
# Inner & Outer Joins
# Why Transactions
# Begin, Commit and Rollback
# Nested Transactions
# Primary Keys and Indexes
# View Indexes Trough Terminal
# Create and Drop Indexes
# Indexes in action
# Multi Column Indexes
# Unique Indexes
# Partial Indexes
# Function skeleton
# Create functions
# View and Drop Functions
# Roles
# View Roles
# Creating roles
# Privileges
# Revoking Permissions
# Member Roles
# What are Schemas
# Create Schemas
# Schema Search Path
# Grant Schema Usage
# Backing up Databases
# Restore Database
# Backup All databases

Requirements

• Specific knowledge of SQL Server is helpful, but not required.
• Basic SQL Knowledge is Preferred
• No previous programming experience is required!

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : Not Available

Quality: 1080p

Download Links

Download – 548 MB

File size

548 MB