Databases

Table of Content

1. SQL Roles                                                                                                      p4 to p6

• Security
• Fixed Server Roles
• Servers
• Integrity

2. Learn SQL Server                                                                                        p6 to

• Fixed Server-Level Roles
• Working with Server-Level Roles
• Permissions and other Fixed Server Roles
• Login Triggers & SQL Server Permissions
• Back-up and Restore Strategies
• Indexes
• Replication
• Explore Data Fundamentals
  • Data Definition Language (DDL)
  • (DDL) code examples
  • Data Manipulation Language (DML)f
  • (DML) code examples
  • General Rules for Database Code
  • Data Type
  • Numeric Types
  • Character Data Types
  • Spatial data Types
  • Binary Data Types
  • Operators and Unions
  • Intersect/Except & Aggregate functions
  • Indexes
  • Stored Procedures
  • Views
  • Replication
• Backup and Restore Strategies

3. Database Fundamental Storage

• Database Life Cycle
• Plan the Physical Design
• Normalization
• Primary Key
• Composite Keys

4. Advance SQL Query Tuning

• Indexes Save Scanning
• Types of Indexes
• Joining Tables
• Nested Loop Joins
• Hash Joins
• Sort Merge Joins
• Partitioning Data:
• With SQL Server Profiler
• More on Types of Indexes
• Types of Joins

5. Triggers – Stored Procedures and Functions

• Functions
• Stored Procedure
• Steps query runs
• Triggers
• Input and output perimeters
• Cursor’s                                              
• Transactions
• Functions                               
• Recursion
• Table-Value Function
• After Trigger
• Instead Triggers
• Nested Triggers
• Triggers Database Level
• Insert
• Update Stored Procedure
• Delete Rules
• C# in visual studio for SQL          
• Installing a DLL – CLR Strict Security  
• Differences SQL vs C#
• Web Developing

6. Fundamental Administration

• Code to Create Tables and Data
• Authentication Options
• Fixed Server Roles
• Security Roles
• Windows Authentication
• SQL Server Roles
  • Fixed Server Roles
  • Public Roles
  • User-Defined Roles
  • Fixed Server Roles
• Object Permissions
• Guest Accounts

7. Reporting Services

• Present Data
• Report Builder
• Web Portal
• Installing Reporting Services
• Web Interface
• Report Builder
• Location of Downloads for Reporting Services
• Report Components
• Formatting a Report
• Shared Connection – Connection String
• Shared Data Set
• Grouping Records
• Parameter as a filter
• Hyper Link Actions
• Charts
• Gage

8. Designing DB Solutions for SQL Server