1. Transaction isolation levels
  2. Window functions
  3. PIVOT / UNPIVOT
  4. Dynamic SQL Pivot
  5. Partitioning
  6. Stored Procedures
  7. Retrieve information about the database
  8. plit String function in SQL Server
  9. Insert
  10. Primary Keys
  11. Foreign Keys
  12. Last Inserted Identity
  13. SCOPE_IDENTITY()
  14. Sequences
  15. Index
  16. Full-Text Indexing
  17. Trigger
  18. Cursors
  19. Migration
  20. Table Valued Parameters
  21. DBMAIL
  22. In-Memory OLTP (Hekaton)
  23. Temporal Tables
  24. Use of TEMP Table
  25. Scheduled Task or Job
  26. Isolation levels and locking
  27. Sorting/ordering rows
  28. Privileges or Permissions
  29. QLCMD
  30. ​Resource Governor
  31. File Group
  32. Basic DDL Operations in MS SQL Server
  33. Subqueries
  34. Pagination
  35. CLUSTERED COLUMNSTORE
  36. Parsename
  37. Installing SQL Server on Windows
  38. Analyzing a Query
  39. Query Hints
  40. Query Store
  41. Querying results by page
  42. Schemas
  43. Backup and Restore Database
  44. Transaction handling
  45. Natively compiled modules (Hekaton)
  46. Spatial Data
  47. Dynamic SQL
  48. Dynamic data masking
  49. Export data in txt file by using SQLCMD
  50. Common Language Runtime Integration
  51. Delimiting special characters and reserved words
  52. DBCC
  53. BULK Import
  54. Service broker
  55. Permissions and Security
  56. Database permissions
  57. Row-level security
  58. Encryption
  59. PHANTOM read
  60. Filestream
  61. bcp (bulk copy program) Utility
  62. SQL Server Evolution through different versions (2000 - 2016)
  63. SQL Server Management Studio (SSMS)
  64. Managing Azure SQL Database
  65. System database - TempDb
  66. Microsoft SQL Server Management Studio Shortcut Keys

Coming soon

JOB OUTLOOK

​The Bureau of Labor Statistics projects 11 percent employment growth for database administrators by 2024. This outlook is promising, but tempered significantly from the large growth projection for the industry just a few years ago. Still, the strong growth estimate means that 13,400 new jobs will need to be filled by 2024.

Start SQL Server from here,

Free download

Free online sql Server  dba learning​​ 

​Courses

microsoft sql training online free

SQL Server 2008 R2 and SQL Server 2012 Certifications

                                                 The impact of certification in the workplace
66% of managers believe that certifications improve the service and support given to IT customers
75% of managers believe that certifications are important to team performance
40% of workers report that Microsoft certifications helped them find a job or led to a promotion

Source Microsoft Website

SQL Server DBA & Developer

Courses Study Topics

SQL Server Script Code

  1. ​​​​Database Administrator overview
  2. SQL Server overview
  3. SQL DBA Checklist
  4. Useful SQL DBA Perfmon Counters
  5. ​​SQL Server 2008 Architecture
  6. Installing SQL Server
  7. SQL Server installation walk-through
  8. Upgrading SQL Server
  9. The SQL Server 2008 Upgrade Matrix
  10. Client Installation and Configuration
  11. ​​SQL Server 2008 or latest Administration and Management Tools
  12. Different  Editions of SQL Server 
  13. ​SQL Server Licensing Models
  14. SQL Server Management Studio (SSMS)
  15. The SQL Server Profiler
  16. SQL Server System and Database Administration 
  17. SQL Server Security User Administration
  18. Getting started with Microsoft SQL Server
  19. Data Types
  20. Converting data types
  21. User Defined Table Types
  22. SELECT statement
  23. Alias Names in SQL Server
  24. NULLs
  25. Variables
  26. Dates
  27. Generating a range of dates
  28. Database Snapshots
  29. COALESCE
  30. IF...ELSE
  31. CASE Statement
  32. INSERT INTO
  33. MERGE
  34. CREATE VIEW
  35. Views
  36. UNION
  37. TRY/CATCH
  38. WHILE loop
  39. OVER Clause
  40. GROUP BY
  41. ORDER BY
  42. The STUFF Function
  43. JSON in SQL Server
  44. OPENJSON
  45. FOR JSON
  46. Queries with JSON data
  47. Storing JSON in SQL tables
  48. Modify JSON text
  49. FOR XML PATH
  50. Join
  51. ​cross apply
  52. Computed Columns
  53. Common Table Expressions
  54. Move and copy data around tables
  55. Limit Result Set
  56. Retrieve Information about your Instance
  57. With Ties Option
  58. String Functions
  59. Logical Functions
  60. Aggregate Functions
  61. String Aggregate functions in SQL Server
  62. Advanced options
  63. Ranking Functions

SQL Server DBA and Developers  Tools

Exam 70-452Certifications: SQL Server 2008 R2 & 2012
Development 
Administration
MSBI 

Microsoft Certified Technology Specialist (MCTS)

Exam 70-433
Exam 70-432

Exam 70-448

Microsoft Certified IT Professional (MCITP)



Exam 70-433
Exam 70-450
Exam 70-452

SQL Server 2012 (DENALI)


Exam 70-464
Exam 70-462
Exam 70-467