Databases

Table of Content

  1. SQL Roles                                                                                                      p4 to p6
  • Security
  • Fixed Server Roles
  • Servers
  • Integrity

 

  1. 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

 

  1. Database Fundamental Storage
  • Database Life Cycle
  • Plan the Physical Design
  • Normalization
  • Primary Key
  • Composite Keys

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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
  1. Designing DB Solutions for SQL Server
Database Development and Design
All Things Databases
Database Development and Design.pdf
Adobe Acrobat document [2.5 MB]

Lance West

 

DigiBrains@msn.com

 

 

  • Cyber-Security

 

  • Information Assurance training

 

  • IT Risk Analysis

 

  • BIA/BCP Development

 

  • Software Security

 

  • Databases
Print Print | Sitemap
© DigiBrains LLC