|
SQL100 |
T-SQL Fundamentals with SQL Server Training Course |
16 hours |
This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:
How to work with SQL Server and SQL Server Management Studio.
Meaning of Databases, SQL and RDBMS etc.
How to create tables, use DDL, DML and DAL.
Which are the various RDBMS Packages in the market and how they compare with each other.
An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
Course Outline:
What is the meaning of Databases. Comparison of RDBMS and DBMS
Different RDBMS available in the market.
What is SQL Server? Working with SQL Server Management Studio
Working with sublanguages like DDL, DML, DAL.
Creation of Tables, data types, Constraints and their definition.
Using Insert, Delete and Update statements.
Using Select Query and its various operators.
Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
What are inbuilt functions? Math, String and Datetime functions.
Working with Views. How they are used for data access.
Working with Joins. Joins types and getting data from multiple tables.
Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
What are Common Table Expressions. Using Recursive Common Table expressions.
|
|
mssql2016 |
MS SQL Server 2016 |
14 hours |
Performanace and Management
Enhanced Database Caching
Query data store
In-Memory OLTP in SQL Server 2016
Development
Temporal Database
Temporary Table and Variable Table in-memory
Native JSON
High Availability and Security
Enhanced AlwaysOn
Always Enrypted
Row-level Security
Dynamic Data Masking
Data Insight and Business Intelligence
Operational Analytics
New functionality Columnstore Index
Direct Query in SSAS Tabular
R Integration (language R in SQL Server)
Enhanced SSIS
Enhanced MDS
Reporting Services
New Report Server
Mobil Reports
SQL Server Mobile Report Publisher
Cloud and Hybrid
Stretch Database
Enhanced backup to Azure
Migration SQL Server to Azure
SSIS and Data Factory
|
|
67592 |
SQL Server 2008 Administration |
28 hours |
This SQL Server Administration training course teaches students how to administer a SQL Server 2008.
Objectives
Install and configure Microsoft SQL Server
Create databases and tables
Implement indexes and partitions
Take database snapshots
Implement service broker for asynchronous processing of database requests
Create and use full-text indexes
Secure SQL Server and implement policy-based management
Recover data
Automate administrative tasks with the SQL Server Agent
Use Dynamic Management Views to monitor the database and troubleshoot problems
Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication
Overview of Microsoft SQL Server 2008
Database Engine
Business Intelligence
Installing and Configuring SQL Server 2008
Editions of SQL Server
Infrastructure Requirements
Service Accounts
Collation Sequences
Authentication Modes
SQL Server Instances
Upgrading to SQL Server
Installing SQL Server
Using the Tools in SQL Server 2008
SQL Server Documentation
Management Tools in SQL Server
Performance Management Tools
Business Intelligence Tools
Creating Databases
SQL Server System Databases
SQL Server Database Structure
Creating a Database
Moving Databases
Designing Tables
Naming Objects
Schemas
Data Types
Column Properties
Creating Tables
Computed Columns
Sparse Columns
Constraints
Database Diagrams
Indexes
Index Structure
Clustered Indexes
Nonclustered Indexes
Included Columns
Filtered Indexes
Online Index Creation
Index Management and Maintenance
XML Indexes
Spatial Indexes
Partitioning
Partition Functions
Partition Schemes
Partitioning Tables and Indexes
Managing Partitions
Database Snapshots
Creating a Database Snapshot
Reverting Data Using a Database Snapshot
Service Broker
Service Broker Architecture
Message Types and Contracts
Queues and Services
Conversations
Sending and Receiving Messages
Queue Activation
Prioritization
Full-Text Indexing
Full-Text Catalogs
Full-Text Indexes
Querying Full-Text Data
Security
Configuring the Attack Surface
Endpoints
Principals, Securables, and Permissions
CLR Security
Data Encryption
Policy-Based Management
Overview of Policy-Based Management
Facets
Conditions
Policy Targets
Policies
Policy Categories
Policy Compliance
Data Recovery
Database Backups
Recovery Models
Database Restores
SQL Server Agent
Creating Jobs
Creating Maintenance Plans
Creating Alerts
Dynamic Management Views
Overview of DMVs
Retrieving Object Metadata
Database Diagnostics
High Availability
Failover Clustering
Database Mirroring
Log Shipping
Replication
|
|
66437 |
Microsoft SQL Server 2008/2012 (MSSQL) |
14 hours |
This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans.
The training also covers table expressions, ranking functions and how to deal with partitioned tables.
Module 1. Query Tuning
Tools for Query Tuning
Cached Query Execution Plans
Clearing the Cache
Analyzing Execution Plans
Hints
Using the Database Engine Tuning Advisor
Index Tuning
Table and Index Structures
Index Access Methods
Indexing Strategies
Module 2. Subqueries, Table Expression, and Ranking Functions
Writing Subqueries
Using Table Expressions
Using Ranking Functions
Module 3. Optimizing Joins and Set Operations
Fundamental Join Types
Join Algorithm
Set Operations
Using INTO with Set Operation
Module 4. Aggregating and Pivoting Data
Using the OVER Clause
Different types of aggregations (Cumulative, Sliding and Year-To-Date)
Pivoting and Unpivoting
Setup Custom Aggregations
Using GROUPING SETS Subclause
CUBE and RULLUP Subclauses
How to materialize Grouping Sets
Module 5. Using TOP and APPLY
SELECT TOP
Using the APPLY table operator
TOP n at the Group Level
Implementing Paging
Module 6. Optimizing Data Transformation
Inserting data with Enhanced VALUES Clause
Using the BULK Rowset Provider
Using INSERT EXEC
The Sequence Mechanisms
DELETE with joins
UPDATE with joins
MERGE statement
The OUTPUT Clause with INSERT
The OUTPUT Clause with DELETE
The OUTPUT Clause with UPDATE
The OUTPUT Clause with MERGE
Module 7. Querying Partitioned Tables
Partitioning in SQL Server
How to write queries on partitioned tables
How to write queries on partitioned views
|
|
3092 |
SQL-Sprache in MSSQL |
14 hours |
The course answers questions
How to build a query?
What opportunities have SQL?
What is a relational database?
What is the structure and SQL commands?
Relational database models
The structure of a relational database
Relational operators
Download the data
Rules for writing SQL queries
The syntax for the SELECT
Selecting all columns
Inquiries from arithmetic operations
Aliases columns
Literals
Concatenation
Restrict results
The WHERE clause
The comparison operators.
LIKE Condition
Prerequisite BETWEEN ... AND
IS NULL condition
IN condition.
Logical operators
Many of the conditions in the WHERE clause
The order of operators
DISTINCT clause
Sorting Data
The ORDER BY clause
Sorting by multiple columns or expressions
SQL Functions
The differences between the functions of single and multi-wierszowymi
Functions text, numeric, date,
Conversion functions
Nesting functions
Handling of NULL values
Aggregating data using the grouping function
Grouping functions
How grouping functions treat NULL values
Create groups of data - the GROUP BY clause
Grouping multiple columns
Reducing the function result grouping - the HAVING clause
Retrieving data from multiple tables
Types of joins
Aliases tables
Joins in the WHERE clause
INNER JOIN Inner join
External Merge LEFT, RIGHT
Cartesian product
Subqueries
Place subqueries in the SELECT command
Subqueries single and multi-lineage
Operators Subqueries single-line
Operators Subqueries multi-IN, ALL, ANY
Collective operators
UNION operator
INTERSECT operator
EXCEPT operator
Insert, update, and delete data
INSERT command
UPDATE command
DELETE command
Transactions |
|
ddavsvbsqls |
Entwicklung von Desktop-Anwendungen mit Visual Studio 2012, VB.NET und SQL Server 2012 |
21 hours |
This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.
VB.NET Language in Visual Studio 2012
VB.NET Object Orientation
VB.NET and Sql Server 2012
Part I. VB.NET Language in Visual Studio 2012
Module 1. Introduction to Visual Basic 2012
The Object-Oriented Programming
The Visual Studio 2012 IDE
Creating a new Application
Using the Help System
Module 2. The Microsoft .NET Framework
The .NET Framework Classes
Executing the Code
Common Language Runtime
Code Loading and Execution
Application Isolation
Security
Interoperability
Exception Handling
Module 3. The Visual Basic 2012 Language
Data Types
Storing Variables
Using Methods
Making Decisions
Working with Data Structures
Using Arrays, Enumerations and Collections
Module 4. Building Windows Applications
Responding to Events
Creating the Toolbar
Creating the Status Bar
Using Multiple Forms
OpenFileDialog and SaveDialog controls
PrintDialog and FolderBrowserDialog controls
Understanding Menu Features
Creating Menus
Context Menus
Part II. VB.NET Object Orientation
Module 5. Building Objects
Understanding Objects
Encapsulation
Methods and Properties
Managing Events
Building Classes
Using Constructors
Managing Inheritance
Module 6. Advanced Language Constructs
Using Lambda Expressions
Using Async and Wait
Using Iterators
Module 7. Exception Handling and Debugging
Handling Exceptions
Try, Catch, Finally
The Throw Keyword
The Exit Try Statement
Using Exit Try Statement
Using Exception Properties
Logging Errors
Module 8. Parallel Programming Using Tasks and Threads
Launching Parallel Tasks
Transforming Sequential Code to Parallel Code
Parallelizing Loops
Specifying the Desired Degree of Parallelism
Creating and Managing Tasks
Part III. VB.NET and Sql Server 2012
Module 9. Database Programming with Sql Server 20012 and ADO.NET
The ADO.NET architecture
The Connection class
The Command and DataReader Classes
The ExecuteReader(), ExecuteScalar(), ExecuteNonQuery() methods
Using Parameterized Commands
Calling Stored Procedure
Managing Transactions
Module 10. Data Components and the DataSet
Building a Data Access Component
Managing Disconnected Data
The DataSet Class
The DataAdapter Class: Filling a DataSet, working with Multiple Tables and Relationships
The DataView Class
Module 11. Using Data Binding
Basic Data Binding
Data Source Controls
The SqlDataSource
Inserting, Updating, Deleting and Selecting records
|
|
3033 |
Verwalten von Microsoft SQL Servern |
21 hours |
Szkolenie skierowane do administratorów, projektantów i programistów baz danych.
Cele szkolenia:
zdobycie i ugruntowanie umiejętności z zakresu tworzenia i zarządzania bazami danych
poznanie składni i wykorzystania języka SQL do pobierania i modyfikowania danych
stosowanie zasad bezpieczeństwa w bazie danych
wykorzystanie elementów zaawansowanych (replikacja, automatyzacja, BI)
wykorzystanie możliwości Microsoft SQL Server do tworzenia złożonych raportów i rozwiązań dla programistów
Podstawowe wiadomości o bazach danych
Bazy plikowe, bazy Client/Server
Systemy zarządzania relacyjną bazą danych (RDBMS)
Wersje SQL Server i różnice między nimi
Express, Standard, Enterprise
Workgroup, Mobile , Developer
Narzędzia SQL Server
SQL Server Management Studio
SQL Server Agent
Usługi w SQL Server
Database Services
Analysis Services
Reporting Services
Intergration Services
Bazy systemowe
Master
Model
Msdb
Tempdb
Distribution
Resource
Tworzenie bazy danych
Pliki bazy i ich lokalizacja
Rozmiar plików oraz ich przyrost
Partycjonowanie tabel
Język modyfikacji danych (DML)
INSERT
UPDATE
DELETE
Język definicji danych (DDL)
Projektowanie tabel
Kolumny i atrybuty
Określenie typu danych
Indeksy i klucze
Indeksy
Clustered Indexes
Non-Clustered Indexes
REBUILD vs. REORGANIZE
Tworzenie aplikacji bazodanowych
Programowanie po stronie serwera
Procedury
Widoki
Funkcje
Wyzwalacze
Modele odtwarzania
Simple
Full
Bulk logged
Kopie bezpieczeństwa
Pełna kopia bazy danych
Przyrostowa kopia bazy danych
Kopia dziennika transakcyjnego
Strategie kopii zapasowych
Strategia pełnych kopii bazy danych
Strategia pełnych kopii i dziennika transakcyjnego
Strategia przyrostowych kopii bazy danych
Strategia kopii plików bazy danych
Podstawy bezpieczeństwa i administracji SQL Server
Automatyzacja
Maintenance Plan
Podstawy bezpieczeństwa i administracji SQL Server
Tworzenie kont
Konto SA
Role Serwerowe
Role bazodanowe
Schematy
Wysoka dostępność
Log Shipping
Database Mirroring
Server Clustering
Replikacja
Replikacja migawkowa (Snapshot Replication)
Replikacja transakcyjna (Transactional Replication)
Replikacja przez scalanie (Merge Replication)
Monitorowanie aktywności SQL Server
SQL Server Profiler
Upgrade
In-Place vs. Migracja
Service-Pack
Cluster
Best Practices
|
|
3119 |
Business Intelligence mit MS SQL Server 2008 |
14 hours |
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
basis, objectives and application of data warehouse, data warehouse server types
base building ETL processes in SSIS
basic design data cubes in an Analysis Services: measure group measure
dimensions, hierarchies, attributes,
development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs,
Build and deploy, processing a partition
the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation,
base MDX language
|
