Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tas
Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.
SQL Server Database Administration Course Benefits
SQL Server Database Administration Course Information
Important SQL Server Database Administration Course Information
Prerequisites
Relational database experience
Working knowledge of computers and a familiarity with Microsoft Windows
SQL programming experience is helpful, but not required
Audience Profile
This course is helpful to those who are new to SQL Server administration and who will be responsible for administering SQL Server. A basic understanding of SQL Server or experience at the level of Microsoft SQL Server Training Course is required..
Exam Information
Optional Learning Tree exam is available at the end of class.
SQL Server Database Administration Course Outline
Getting Started with SQL Server
Setting up SQL Server
Selecting installation options
Installing a named instance
Leveraging essential tools
SQL Server Management Studio
Configuration Manager
Transact-SQL
sqlcmd
PowerShell
Constructing and Managing Databases
Inspecting storage structures
Relating servers, databases and files
Creating databases and transaction logs
Designing file groups
Upgrading and moving databases
Maximizing storage utilization
Placing tables on file groups
Choosing between upgrade and migration
Detaching and attaching databases
Controlling database space
Permitting automatic database growth
Adding database files to expand databases
Handling Server and Database Security
Implementing server security
Comparing authentication modes
Defining logins
Creating user-defined server roles
Enforcing password policy
Granting database access
Contrasting users and logins
Adding users
Defining new roles
Delegating privileges with predefined roles
Repairing mis-mapped logins
Granting and Revoking Permissions
Managing database-scoped privileges
Permitting object creation
Giving blanket permissions
Defining object-level permissions
Limiting object access
Meeting complex permission requirements with roles
Backup and Recovery
Backing up databases
Selecting a recovery model
Investigating the transaction log
Running full, log and differential backups
Restoring databases
Performing a post-crash log backup
Rebuilding the master database
Recovering user and system databases
Streamlining Tasks with Jobs, Alerts and Database Mail
Configuring SQL Server Agent
Setting agent properties
Implementing database mail
Defining jobs to handle routine tasks
Creating alerts and operators
Initiating multi-step jobs
Associating alerts with jobs
Database Maintenance and Monitoring
Handling fragmentation and database corruption
Identifying and curing fragmentation
Repairing database corruption
Building database maintenance plans
Scheduling plan execution
Notifying operators of success or failure
Resolving contention problems
Identifying blocked processes
Killing blockers
Learning Tree has helped more than 65,000 organisations and 2.5 million individuals worldwide develop the skills and earn the certifications necessary to support their careers and power organisational performance. Get started by exploring our enterprise solutions, services and capabilities.
Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course.
The SQL course and lab will teach you everything from the basics of SQL for Analytics to SQL for Data preparation. This includes, how to aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
This training course will teach you the essentials of SQL. In this course you’ll learn how to use SQL to create a database & tables, retrieve data from a database, filter data, aggregation, use functions, subqueries, join multiple tables and create views.
You will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy