Ensure you start to learn in the following order:
Step 1: Learn what is database and what is SQL?
Step 2: Learn what is DBMS and what is SQL Server?
Step 3: Learn basics of SQL Server and T-SQL Queries
Step 4: Learn Routine / Common SQL DBA Activities
Step 5: Learn Maintenance DBA Activities
Step 6: Learn Emergency DBA Activities
Step 7: Implement all above concepts in your PC ++ in on a Remote Sandbox provided in your Training Organization
Step 8: Learn and Implement / Simulate common errors and solutions that come in Real-time. There are POCs for various common errors and solutions. These are very much expected in almost every interview
Step 9: Attend minimum of FOUR to FIVE Mock Interviews from your trainining Institute.
The inventor of the relational model Edgar Codd proposed the theory of normalization with the introduction of First Normal Form and he continued to extend theory with Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop the theory of Boyce-Codd Normal Form.
Theory of Data Normalization in Sql is still being developed further. For example there are discussions even on 6th Normal Form. But in most practical applications normalization achieves its best in 3rd Normal Form. The evolution of Normalization theories is illustrated below
1st Normal Form >> 2nd Normal Form >> 3rd Normal Form >>4th Normal Form >> 5th Normal Form >>6th Normal Form
Database Normalization Examples –
Assume a video library maintains a database of movies rented out. Without any normalization all information is stored in one table as shown below.
Further We shall discuss on different normal forms in detailed:
SQL DBA Training with Real-time Project, Job Support
SQL DBA Online Training (LIVE, Instructor-Led)
Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24×7 Online Lab, Certification, Job Support with One Real-time Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.
SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is strongly committed to provide complete real-time and practical training exclusively on Microsoft SQL Server and Datawarehousing technologies. SQL School Training Institute established in February, 2008 is now one of the best training institute offering SQL Server and T-SQL (SQL Server) Training, SQL Database Administration (SQL DBA) Training and Business Intelligence (MSBI / SQL BI) Training.