Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Becoming a database administrator (DBA) can be a very rewarding and fulfilling career.
The path is relatively easy compared to other technical careers.
Microsoft SQL Server is among the top 3 relational database management systems in the world
and getting the skills to becoming an SQL Server DBA will serve you well and open many job opportunities .
Microsoft SQL Server Database Administrators (DBA) can earn $700 or more a day depending
on their experience and skills. It is also possible for a new DBA to start earning from $300 - $400 a day with the skills they will gain from this course in combination with their determination.
The advantage of this course is the amazing virtual labs facilities that is available for free from Microsoft. The virtual labs comes with Microsoft Server 2012 and also Microsoft SQL Server 2016 and various instances of SQL Server like SQL Server Analysis Server (SSAS), SQL Server Reporting Service (SSRS),SQL Server Integration service (SSIS). The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.
What you will learn in this course includes:
I look forward to seeing on the course.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: It is all about the Data|
What is a DBA
MSDN Virtual Labs
Importing and Exporting Data
|Section 2: Database Backup and Restore|
Copy Database Backup MethodPreview
Full Database BackupPreview
Differential Database Backup
Transaction Log Backup
Lab Exercise 1
Lab Exercise 2
|Section 3: SQL Server Configuration|
SQL Server Configuration Manager
Checking Installed Services With PowerShell
Connecting to Instances of SQL Server
Identifying Installed Databases
Identifying Other Server Objects
|Section 4: T-SQL Quick Guide|
T-SQL DML SELECT Query
T-SQL DML DELETE Query
T-SQL DML UPDATE Query
T-SQL DML INSERT Query
T-SQL DDL CREATE Query
T-SQL DDL ALTER Query
T-SQL DDL DROP Query
T-SQL DDL TRUNCATE Query
|Section 5: SQL Server Performance Monitoring|
Using Activity Monitor
Using Performance Monitor
|Section 6: Security|
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.