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
File(s) password: www.downloadly.ir
Size
548 MB