SQL Server Administration

Microsoft SQL Server: Our Microsoft SQL Server class covers topics from basic to advance levels. This class is designed for any level of students with or without I.T knowledge. This class is scheduled for three sessions a week over the four months. Major topics covers in this class are below, but more details on our curriculums: • Introduction to Operating system • SQL Server History/ Installation/Versions/Edition/Licensing • SQL Server Plan/ Installation/Instances/Components • Manage and Configure SQL Server Databases • SQL Server Objects and Relations • Introduction to T-SQL • Configure and Maintain Backups • Data Collection / Analyzation/ Troubleshooting • SQL Server Security • Manage Logins and Users • Troubleshoot Security • Data Encryption (Always Encrypted) • Certificates • SQL Server Connection Encryption • Data Encryption (Always Encrypted) • Certificates • SQL Server Connection Encryption • Auditing SQL Instances • SQL Server Management/ Maintenance • Data Import/Export • Recovery/ Restore Databases • Indexes/ statistics /DBCCs/DMVs • Plan and Configuring Disaster Recovery Plan • Plan/Configure/ Implementing Replication • Plan/Configure/ Implementing logshipping • Plan/Configure/ Implementing Clustering • Installing SQL instances on Clustering • Troubleshoot SQL Cluster Nodes • Plan/Configure/ Implementing AlwaysOn • Troubleshoot SQL AlwaysOn Replicas • Certificates/ Job Placement/ Resume Building/ and Interview Preparation Sessions.