Download AmigosCode – Advanced Databases 2020-2

Advanced Databases

Description

Advanced Databases, an advanced database mastery course by AmigoseCode Academy, introduces you to the advanced database concepts you need to write publishable programs. As a software engineer, knowing these concepts will ensure that you write a strong backend application and fully understand what is going on behind the scenes. In the following, you will get to know these concepts:

What you will learn

  • The Joins command
  • Profiles
  • Transactions
  • Database management
  • Stored functions/procedures
  • Schemas
  • Database backups
  • Install Postgres
  • Connecting to databases using the terminal
  • Datagrip
  • Install Datagrip
  • Datagrip configuration
  • Create a database using Datagrip
  • Skeleton functions
  • Create functions
  • Show and drop functions
  • Roles
  • Show roles
  • Create roles
  • Privatization
  • Re-requesting licenses
  • Member roles

Advanced Databases course specifications

  • Publisher: AmigosCode
  • teacher : Nelson
  • English language
  • Training level: advanced
  • Number of courses: 39
  • Training duration: 2 hours and 47 minutes

Chapters of the Advanced Databases course

# 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 Through 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

Course prerequisites

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

Pictures

Sample video

Installation guide

After Extract, view with your favorite Player.

Subtitle: None

Quality: 1080p

download link

Download – 548 MB

File(s) password: www.downloadly.ir

Size

548 MB

4.5/5 – (2000 points)

Be the first to comment

Leave a Reply

Your email address will not be published.


*