Course Outline

Basic information about databases

  • Database files, Database Client / Server
  • Relational database management systems (RDBMS)

SQL Server versions and the differences between them

  • Express, Standard, Enterprise
  • Workgroup, Mobile , Developer

SQL Server Tools

  • SQL Server Management Studio
  • SQL Server Agent

Services in SQL Server

  • Database Services
  • Analysis Services
  • Reporting Services
  • Integration Services

Base system

  • Master
  • Model
  • Msdb
  • Tempdb
  • Distribution
  • Resource      

Create a database

  • The database files and their location
  • File size and its growth
  • Partitioning tables

Data Modification Language (DML)

  • INSERT
  • UPDATE
  • DELETE

Data Definition Language (DDL)

Designing Tables

  • Columns and Attributes
  • Determine the type of data
  • Indexes and Keys

Indexes

  • Clustered Indexes
  • Non-Clustered Indexes
  • REBUILD vs. REORGANIZE 

Creating a database application

Server-side programming

  • Procedures
  • Views
  • Functions
  • Triggers

Models play

  • Simple
  • Full
  • Bulk logged

Backup

  • Full
  • Differential
  • Transaction Log

Backup Strategies

  • Strategy full copy of the database
  • Strategy of full backups and transaction log
  • The strategy of incremental database backup
  • Strategy copy of the database files

Basic security and administration of SQL Server

Automation

  • Maintenance Plan
  • Jobs

Basic security and administration of SQL Server

  • Server Roles
  • Database Roles
  • SA Account
  • Creating Accounts
  • Schemes

High Availability

  • Log Shipping
  • Database Mirroring
  • Server Clustering

Replication

  • Snapshot Replication
  • Transactional Replication
  • Merge Replication

Activity Monitor SQL Server

  • SQL Server Profiler

Upgrade

  • In-Place vs. Side-By-Side
  • Service-Pack
  • Cluster

Best Practices

Requirements

Knowledge of computer and Windows operating system

 21 Hours

Testimonials (5)

Related Categories