It proved to be life changer for me, I had zero knowledge about Linux and now i am working as Linux SysAdmin as i have acquired my dream job. Hi Imran, I have completed this course twice. He also established a non-profit school for children from pre-K till 10th grade. He believes in education and giving back. He has helped almost 1000+ students to land a job of their dream in IT. He has some of the bestselling and highest rated online courses with over 300,000 students worldwide. Imran has been training since 2010 and provides onsite and online training on many IT subjects.
Some of his certifications are in Linux Systems Management, UNIX Operating Systems, Linux System Administration, System Internals, VMWare Certified Professional, RHCSA and Windows Server Certified He earned his Master of Business Administration (MBA) from New York Institute of Technology (NYIT). Imran earned his bachelor’s in Computer Information Systems from Baruch College, City University of New York as an honor student. He spearheaded projects like datacenter migration, introduction and deployment of VMWare, monitoring tools implementation, Amazon cloud migration and many more. He has utilized IT skills in many fortune 500 companies such as financial firm, fashion industry, tech media industry etc. He started his career with Time Warner (New York City) in 2000 as a systems administrator. Imran Afzal has over 20 years of experience in Systems administration/engineering, leadership, entrepreneurship, training, and public speaking.Ĭurrently Imran manages a large team of systems engineers, administrators and team leads globally. MS SQL Server Integration Services (SSIS) Transparent Data Encryption (TDE) and configurationīackup and restore of encrypted Databases MSSQL Data Encryption and type of encryption What Is Replication and Transactional Replication
Section 12 - Advanced SQL Server Administration Topics Section 11 - MSSQL Server Agent Management
Page Level Restore / Recovery using Full BackupsĬreating Maintenance Plan Backups/Re-indexing etc. Lab for Full, Differential and Transaction Log Backupsįull, Differential and Transaction Log database restoreĬomplete Backup, Restore and Restore in Time Lab Transaction Log Backups, Log Backup Chain and Tail-log Backup Recovery Models in MSSQL and how that impact backups an restore What are Pages, Extents, Page Architecture and PFS?īest practices while creating user Databaseīackup of a Database, Importance for DBA and Different Media used for Backups What is master, etmpdb, msdb and other system databases? MSSQL System Databases, DO's and DONT's of System databases Section 7 - Microsoft SQL Database AdministrationĮxploring SQL Server Management Studio (SSMS)Įxploring SQL Server Configuration Manager INSERT, UPDATE, DELETE and Truncate StatementsĬlustered ,Non-clustered Indexes and Index Design considerations WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause Section 6 - Query and Manipulation of Data using SQL What is a SQL Statement and types of SQL statements What is a Transaction and ACID properties?ĭatabase Normalization AND Different forms of Database NormalizationĬreate your first Database, Table and Populate table with data…
What is Relational Database and Relational Database Management System (RDBMS)? What is a key? primary, foreign, unique keys etc. Section 4 - Database Fundamentals and Design
Section 3 - Download, Install and Configure MS SQL Serverĭownload MSSQL and SQL Server Management Studioĭownload and Install AdventureWorks Database
Optional - Download and Install Oracle Virtualbox Section 2 - Download, Install and Configure Windowsĭownload and Install VMWare Workstation Player Plus, this course will prepare you for the SQL Server MCSA certification. This training course will provide you all the necessary skills you need to be a successful database administrator.
If you want to become SQL database administrator then this is the course for YOU. Database is a heart of IT which is needed to stored all critical data and information.
Microsoft SQL Server continues to be one of the world's most popular and top databases.