FLASH-JET

Tech news and Utilities

Main menu

Skip to primary content
Skip to secondary content
  • Main
    • TrackIL
    • FJ Digital
    • How to Videos
    • Android Apps
    • Financial indicators
    • Contact us
  • Category
    • Drivers
    • Health
    • Products / Manuals
  • Products
    • Pinger – Ping entities on your LAN
    • WPI – Windows Performance indicator
    • Trafix – Web-traffic generator
    • BabyPDF
    • FJScan
    • iKiosk
    • MassMailer
    • FJAdmin
  • Search
  • Log In
  • Register

Tag Archives: DBA

All about SQL

Posted on December 16, 2014 by gmagen

 

Here you will find all you need regarding MS SQL:

During the following Scripts, the following Databases will be used:
1. ACDB
2. hr_script
3. Northwind
4. AdventureWorks 2012
5. AdventureWorks 2014
6. AdventureWorks_2017

SQL Basics:

01 - SELECT-ALIAS-DISTINCT
02 - WHERE - ORDER BY - TOP
03 - SCALAR_FUNCTIONS
04 - GROUP BY - HAVING
05 - JOIN - OUTER JOIN
06 - UNION-EXCEPT-INTERSECT
07 - SUBQUERIES
08 - DML
09 - CASE

DBA Database Design, Tables structure and indexing, T-SQL programming:

01 - DB Creation
02 - User Defined Datatypes
03 - Schemas & Tables
04 - Calculated Column
05 - Constraints
06 - Indexes
06A - Partitions
06B - Indexes & Partitions Exercise
07 - Execution Plan
08 - Variables - If Else - Goto - Loops
09 - Cursors
10 - Dynamic SQL
11 - Ranking Functions
12 - Temp Tables
13 - Table Variables
14 - SubQueris
15 - CTE
16 - Merge
17 - Views (includes views with encryption)
18 - Stored Procedures
19 - TVP - Table Valued Parameters
20 - User Defined Functions
21 - Transaction
22 - Triggers / Detailed link here
23 - Error Handling
23A - Try Catch
24 - XML
Advanced Dynamic SQL
Cursors - Solution
DDL Additional Demo
Divide Sample
Merge Solution
The 3 and 5 Divide Question
The Find_A_Question
The One Line Question
The Salary Question

 

Shorten URL: http://goo.gl/DvyvZ7

Posted in MS SQL.

Categories

Tags

Academic Analytics Android Arduino BitBucket Boot C# Comparison C Sharp Database Facebook GIT Google GPIO IDE IOS Iot Israel KM Kodi Learn Linkedin Linux MSSQL MS SQL Music Plugin Plug in Plugins python Raspberry Raspberry PI SBC SSRS Tutorial USB Video Visual Studio Wiki Win 10 Windows 10 Wordpress XBMC XBox Youtube
© 2023 FLASH-JET, all rights reserved.
Proudly powered by WordPress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT