PHASE
- I
|
|
Lesson 1 |
|
1) |
What
Is SQL Server
|
|
SQL Server
Mystique |
|
Transact SQL |
|
SQL
Server History |
|
|
2) |
Overview of
Course |
|
|
3) |
Main Purpose of a Database |
|
What Makes Up a Database |
|
Two Main Types of Databases |
|
Normalization |
|
Denormalization |
|
Database Relationships |
|
Indexes |
|
Proper Design |
|
|
4) |
Real World Administration |
|
Designing/Building Databases |
|
Data Maintenance/Transfer |
|
Backup/Restore of Data |
|
Security |
|
|
5) |
Minimum Hardware Requirements |
|
Hardware Compatibility |
|
Optimizing Hardware for SQL Server |
|
|
6) |
SQL Server 2000 Editions |
|
Licensing |
|
Multiple Instances |
|
Choosing a Security Mode |
|
Collation and Sort Selection |
|
Network Libraries |
|
Installation Methods |
|
Upgrading to SQL Server 2000 |
|
Default Databases |
|
Installation |
|
Troubleshooting an Installation |
|
|
7) |
Security Overview |
|
Authentication Modes |
|
Roles |
|
Assigning Permissions |
|
Application Roles |
|
|
8) |
SQL Services |
|
SQL Services Issues |
|
|
9) |
System Databases |
|
Sample Databases |
|
|
10) |
How SQL Stores Data |
|
Fillfactor |
|
File and Log Location/Management |
|
|
11) |
Overview of Admin Tools |
|
Exam Considerations |
|
Microsoft Management Console |
|
Opening & Customizing
the Enterprise Mgr |
|
Using the Enterprise Manager |
|
|
12) |
Opening and Exploring the Query
Analyzer |
|
Issuing Queries Using the QA |
|
Query Analyzer Features |
|
Graphical Query Plan |
|
|
13) |
Using a Select Statement |
|
Basic Syntax |
|
Select Options |
|
Important Select Considerations |
|
|
14) |
Using an Insert Statement |
|
Basic Syntax |
|
Insert Options/Considerations |
|
|
15) |
Using the Update Statement |
|
Basic Syntax/Options |
|
Important Update Considerations |
|
|
16) |
Using the Delete Statement |
|
Basic Syntax/Important Considerations |
|
|
17) |
Using the Create Database Statement |
|
Database Properties and Options |
|
Database Creation Considerations |
|
Managing File Growth |
|
Shrinking Database Files |
|
Sizing the Database |
|
Importance of Good Design |
|
|
18) |
How Transaction Logs Work |
|
What Transactions Look Like |
|
Location / Location / Location |
|
Advantages of Using Transaction
Logs |
|
Transaction Log Options |
|
|
19) |
What Are Filegroups? |
|
Advantages of Filegroups |
|
Disadvantages of Filegroups |
|
Microsofts Recommendation on
Filegroups |
|
|
20) |
RAID Basics |
|
SQL and RAID |
|
|
21) |
What SQL Profiler Does |
|
Opening SQL Profiler |
|
Using SQL Profiler |
|
|
22) |
What are Operators? |
|
Creating an Operator |
|
Considerations When Using Operators |
|
|
23) |
Automating SQL Server |
|
Mail Enabling SQL Server |
|
Creating a New Job |
|
Scheduling a Job |
|
Job Notifications |
|
Starting/Stopping a Job |
|
Multi Server Jobs |
|
Viewing Job History |
|
|
24) |
What are Alerts |
|
Performance Alerts |
|
User Defined Alerts |
|
Disabling Alerts |
|
Considerations When Using Alerts |
|
|
25) |
Using SQL In a Distributed Environment |
|
Referring to SQL Server Objects |
|
Setting Up a Linked Server Relationship |
|
|
26) |
Backup Strategy |
|
Database Recovery Models |
|
SQL Server Backup |
|
Who When and Where |
|
System Databases |
|
User Databases |
|
Performing a Backup |
|
Using Multiple Devices |
|
SQL Backup Statement |
|
Tape Backup |
|
Backup Types |
|
Transaction Log Backups |
|
File and Filegroup Backups |
|
Full Backup Strategy |
|
Differential Backup Strategy |
|
Backup Review |
|
|
27) |
SQL Server Recovery Process |
|
Preparing to Restore a Database |
|
The SQL Restore Statement |
|
Restore Options |
|
Restoring Transaction Logs |
|
Restoring System Databases |
|
Bottom Line on Restoring Data |
|
|
28) |
Determining Requirements |
|
Clustering |
|
Standby Servers |
|
Log Shipping |
|
|
29) |
Importing and Exporting Data |
|
SQL Data Transport Tools |
|
DTS Overview |
|
Creating a DTS Package |
|
More DTS Package Functionality |
|
Defining Transformation Tasks
Creating |
|
Using DTS in Various Ways |
|
|
30) |
Performance Issues |
|
Monitoring and Tuning Basics |
|
Improving Performance |
|
Common Monitoring Tasks and Tools |
|
What To Monitor |
|
Locks |
|
|
31) |
Dealing With Distributed Data |
|
SQL Server Replication |
|
SQL Server Replication Types |
|
SQL Server Replication Models |
|
Replication Agents |
|
Web Based Data Applications |
|
SQL Server Replication Notes |
|
|
32) |
Value of SQL Server knowledge |
|
Microsofts MCDBA Certification |
|
|
/ 
+91 9819006132
+91 9819006132 
