SQL Server Crash Course 1:24:00 Connect: C:\>sqlcmd -S <instance>\<username> Basic Commands * sp = stored procedure > sp_databases > go Backup Files C:/Program Files/Microsoft SQL Server/MSSQL15…/MSSQL/Backup Restore Backup File SSMS > Databases (rclick) > Restore Database… Source = Device [elipse menu] Select backup devices Backup media type: File Backup media: [Add] Select .bak file Query ..
Category : Databases
Part 1 – Getting Setup https://www.udemy.com/aws-certified-solutions-architect-associate/learn/v4/t/lecture/5028334?start=15 Set Region to US-East Identity and Access Management (IAM) Create a Role for S3 administrative access Create our Security Groups Put these in your default VPC Networking > VPC > Security Groups Web-DMZ HTTP (80) SSH (22) 0.0.0.0/24 RDS-SG MySQL (3306) Web-DMZ Create our Elastic Load Balancer EC2 ..
Databases Create New Database CREATE DATABASE database; Set default database USE DATABASE database; Show Databases SHOW DATABASES; Tables Create CREATE TABLE [IF NOT EXISTS] tablename( col1 AS STRING, col2 AS INT, col3 AS VARCHAR(255) ) Example: CREATE TABLE [IF NOT EXISTS] users( id INT NOT NULL AUTO_INCREMENT, name STRING, age INT, color VARCHAR(25), PRIMARY KEY(id) ..
Recent Comments