Databases

  1. Learn SQL Server
  • Fixed Server-Level Roles
  • Backup and Restore Strategies
  • Permissions of Fixed Server Roles
  • Logon Triggers Permissions
  • Back-up and Restore Strategies
  • Indexes
  • Replication
  • Explore Data Fundamentals
  1. Exploring Database Fundamentals
    • Numerical/ Text
    • Relational Databases
    • Constraints
    • Structured Query Language
    • DDL: Use, Drop, Create, Truncate, Alter, and Delete
    • DML: Select – Insert – Update – Delete – Merge
  2. Create and Manipulating Data SQL Server
  • Character Data Types
  • DataTypes
  • SQL server support two types of Spatial data Types
  • Binary Data Types you can Choice from:
  • Development Life Cycle – Data Modeling
  • UNION Statements
  • Intersect / Except
  • Views
  • Stored Procedures:
  • User Defined Functions
  1. Database Fundamental Storage
  • Normalization
  • Primary Key
  • Composite Keys
  • Clustered Indexes
  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
  • 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
  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

A Paper on each of the above is coming soon....!

Lance West

 

DigiBrains@msn.com

 

 

  • Cyber-Security

 

  • Information Assurance training

 

  • IT Risk Analysis

 

  • BIA/BCP Development

 

  • Software Security

 

  • Databases
Print Print | Sitemap
© DigiBrains LLC