Database Administrator (DBA) | Developer- MS SQL Server,TSQL
What you'll learn
- Microsoft SQL Server Setup
- Installing Sample Databases
- Creating Database Objects
- Database Design
- Tracking database activities
- Creating stored procedures
- Database backup and recovery
- Monitoring Database Performance
- Database security and user accounts
- Querying Database with T-SQL
- Aggregating Data using aggregate functions
- Filtering and sorting records
- Extracting data from multiple tables
Course content
- Preview00:20
- Preview02:57
- Preview01:49
- Preview04:45
- Preview04:21
- 04:31Download SQL server
- 09:43Install SQL Server
- 05:48Install SSMS
- 08:10SQL Server Configuration Manager
- 10:53SQLCMD Utility
- 02:50Schema
- 07:46Connecting SSMS to SQL Server
Requirements
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
Description
SQL Server is Microsoft’s relational database management software and uses a common set of tools to deploy and manage databases both on-premises and in the cloud.
Microsoft SQL Server Management Studio is a rich, integrated administrative client designed to meet the SQL Server and Azure SQL Database administrator's server management requirements. In Management Studio, administrative tasks are accomplished using Object Explorer, which allows you to connect to any server in the SQL Server family and graphically browse its contents. A server can be an instance of the Database Engine, Analysis Services, Reporting Services, Integration Services or Azure SQL Database.
The tool components of Management Studio include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window.
Use Management Studio to:
Register servers.
Connect to an instance of the Database Engine, SSAS, SSRS, SSIS or Azure SQL Database.
Configure server properties.
Manage database and SSAS objects such as cubes, dimensions, and assemblies.
Create objects, such as databases, tables, cubes, database users, and logins.
Manage files and filegroups.
Attach or detach databases.
Launch scripting tools.
Manage security.
View system logs.
Monitor current activity.
Configure replication.
Manage full-text indexes.
SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
T-SQL, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.
Who this course is for:
- individuals who administer and maintain SQL Server databases.
- Beginner database administrators
Instructor
![Bluelime Learning Solutions](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 27,982 Reviews
- 685,750 Students
- 288 Courses
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.