ssis presentation in powerpoint free download

• Preferences

SQL Tutorial - PowerPoint PPT Presentation

SQL Tutorial

Beginner lessons in structured query language (sql) used to manage database records. presentation by hitesh sahni ( www.hiteshsahni.com ) – powerpoint ppt presentation.

• By Hitesh Sahni
• www.hiteshsahni.com
• Overview of SQL (This may be review for some of you)
• Data Definition Language
• Creating tables (well just talk about this)
• Data Manipulation Language
• Inserting/Updating/Deleting data
• Retrieving data
• Single table queries
• SQL is a data manipulation language.
• SQL is not a programming language.
• SQL commands are interpreted by the DBMS engine.
• SQL commands can be used interactively as a query language within the DBMS.
• SQL commands can be embedded within programming languages.
• Data Definition Language (DDL)
• Commands that define a database - Create, Alter, Drop
• Data Manipulation Language (DML)
• Commands that maintain and query a database.
• Data Control Language (DCL)
• Commands that control a database, including administering privileges and committing data.
• Four basic commands
• SQLgtROLLBACK
• Rollback complete.
• REVERSES ALL CHANGES TO DATA MADE DURING YOUR SESSION
• SQLgtCOMMIT
• MAKES ALL CHANGES TO THIS POINT PERMANENT
• POINTS AT WHICH COMMIT IS ISSUED, DEFINE EXTENT OF ROLLBACK
• ROLLBACK REVERSES EVERY CHANGE SINCE THE LAST COMMIT
• EXITING SQLPLUS ISSUES A COMMIT
• SELECT column_name, column_name,
• FROM table_name
• WHERE condition/criteria
• This statement will retrieve the specified field values for all rows in the specified table that meet the specified conditions.
• Every SELECT statement returns a recordset.
• Semantics of an SQL query defined in terms of the following conceptual evaluation strategy
• Compute the cross-product of relation-list.
• Discard resulting tuples if they fail qualifications.
• Delete attributes that are not in target-list.
• If DISTINCT is specified, eliminate duplicate rows.
• This strategy is probably the least efficient way to compute a query! An optimizer will find more efficient strategies to compute the same answers.
• - All columns in a table
• SELECT EmployeeID, LastName, FirstName, BirthDate AS DOB FROM Employee
• SELECT EmployeeID, LastName, FirstName, FROM Employee AS E
• Dot Notation - ambiguous attribute names
• SELECT Customer.LName, E.Lname
• FROM Customer, Employee AS E
• Arithmetic operators , -, , /
• Comparison operators , gt, gt, lt, lt, ltgt
• Concatenation operator
• Substring comparisons , _
• ORDER BY Clause
• UNION, EXCEPT, INTERSECT
• SQL provides two ways to retrieve data from related tables
• Join - When two or more tables are joined by a common field.
• Subqueries - When one Select command is nested within another command.
• The WHERE clause is used to specify the common field.
• For every relationship among the tables in the FROM clause, you need one WHERE condition (2 tables - 1 join, 3 tables - 2 joins)
• Inner Join - records from two tables are selected only when the records have the same value in the common field that links the tables (the default join).
• Outer Join - A join between two tables that returns all the records from one table and, from the second table, only those records in which there is a matching value in the field on which the tables are joined.
• Plan your joins
• Draw a mini-ERD to show what tables are involved.
• Count the number of tables involved in the SELECT query.
• The number of joins is always one less than the number of tables in the query.
• Watch out for ambiguous column names.
• These functions are applied to a set(s) of records/rows and return one value for each set.
• These functions thus aggregate the rows to which they are applied.
• If one field in a Select clause is aggregated, all fields in the clause must be aggregated.
• Aggregation The process of transforming data from a detail to a summary level.
• You can aggregate a field by including it after the GROUP BY clause or by making it the argument of an aggregating function.
• When you use GROUP BY, every field in your recordset must be aggregated in some manner.
• The same rule applies when you use an aggregating function such as SUM, COUNT, AVERAGE . If one field in the Select clause is aggregated, then every other field in the Select clause must be aggregated in some manner.
• Additional SQL Clause - HAVING
• The HAVING clause is only used after the GROUP BY clause.
• The HAVING clause specifies criteria for a GROUP, similar to how the WHERE clause specifies criteria for individual rows.
• SELECT - list of attributes and functions
• FROM - list of tables
• WHERE - conditions / join conditions
• GROUP BY - attributes not aggregated in select clause
• HAVING - group condition
• ORDER BY - list of attributes
• ISM6217 - Advanced Database
• Subqueries (Nested queries)
• Correlated subquery
• Inner/outer
• Integrity constraints
• Scripts to create and populate the database are available on the 6217 Web site.
• A subquery is a query that is used in the WHERE condition of another query
• AKA Nested query
• Can be multiple levels of nesting
• Can be used with SELECT, INSERT, UPDATE
• List all suppliers who can deliver at least one product in less than 10 days
• List all suppliers who can deliver a product in less than the average delivery time.
• LIST SUP_NO, PART, DEL FOR QUOTES WHERE DEL gt ANY SUPPLIED BY 71
• LIST SUP_NO, PART, DEL FOR QUOTES WHERE DEL gt ALL SUPPLIED BY 71
• Who are alternate suppliers for parts supplied by 71?
• List all suppliers who have not provided a quote
• A correlated subquery is a subquery that is evaluated once for each row processed by the parent statement. The parent statement can be a SELECT, UPDATE, or DELETE statement. These examples show the general syntax of a correlated subquery
• List all suppliers, parts and prices where quoted price is less than the average quote for that part.
• Natural join/inner join
• This is what youre used to.
• Returns only rows where PK and FK values match.
• Does not repeat PK/FK columns
• Similar to natural join, but includes both PK and FK values in record set.
• Includes columns with null FK values
• Problem Inner join will not return a row that does not have a matching value.
• Sometimes this prevents you from getting the output you want.
• Example List all parts (including description) and any quotes that exist for each part. We want to include all parts even if there are no quotes for some of them.
• SELECT I.PART_NO, DESCRIPTION, SUPPLIER_NO, PRICE
• FROM INVENTORY I, QUOTATIONS Q
• WHERE I.PART_NO Q.PART_NO ()
• ORDER BY I.PART_NO
• WHERE I.PART_NO () Q.PART_NO
• Field values in a tuple are sometimes unknown (e.g., a rating has not been assigned) or inapplicable (e.g., no spouses name).
• SQL provides a special value null for such situations.
• The presence of null complicates many issues. E.g.
• Special operators needed to check if value is/is not null.
• Is ratinggt8 true or false when rating is equal to null? What about AND, OR and NOT connectives?
• We need a 3-valued logic (true, false and unknown).
• Meaning of constructs must be defined carefully. (e.g., WHERE clause eliminates rows that dont evaluate to true.)
• New operators (in particular, outer joins) possible/needed.
• An IC describes conditions that every legal instance of a relation must satisfy.
• Inserts/deletes/updates that violate ICs are disallowed.
• Can be used to ensure application semantics (e.g., sid is a key), or prevent inconsistencies (e.g., sname has to be a string, age must be lt 200)
• Types of ICs Domain constraints, primary key constraints, foreign key constraints, general constraints.
• Domain constraints Field values must be of right type. Always enforced.
• Useful when more general ICs than keys are involved.
• Can use queries to express constraint.
• Constraints can be named.
• Awkward and wrong!
• If Sailors is empty, the number of Boats tuples can be anything!
• ASSERTION is the right solution not associated with either table.
• Trigger procedure that starts automatically if specified changes occur to the DBMS
• Three parts
• Event (activates the trigger)
• Condition (tests whether the triggers should run)
• Action (what happens if the trigger runs)
• CREATE TRIGGER youngSailorUpdate
• AFTER INSERT ON SAILORS
• REFERENCING NEW TABLE NewSailors
• FOR EACH STATEMENT
• INTO YoungSailors(sid, name, age, rating)
• SELECT sid, name, age, rating
• FROM NewSailors N
• WHERE N.age lt 18
• Returns the remainder of m/n
• POWER (m,n)
• TRUNC(15.79,1)
• CONCAT(char1, char2)
• LOWER/UPPER
• LTRIM(char ,set) RTRIM(char ,set
• SUBSTR(char, m ,n)
• LENGTH(char)
• ADD_MONTHS(d,n)
• LAST_DAY(d)
• MONTHS_BETWEEN(d1, d2)
• ROUND(d,fmt)
• TO_CHAR(d , fmt , 'nlsparams' )
• TO_DATE(char , fmt , 'nlsparams' )
• All tables and views that are available to the user
• This table contains several hundred rows
• Useful Data Dictionary Views
• Use just like a table
• More useful (generally) than full tables
• Use DESCRIBE to see the columns in the view
• USER_TABLES
• USER_CONSTRAINTS
• USER_OBJECTS

PowerShow.com is a leading presentation sharing website. It has millions of presentations already uploaded and available with 1,000s more being uploaded by its users every day. Whatever your area of interest, here you’ll be able to find and view presentations you’ll love and possibly download. And, best of all, it is completely free and easy to use.

You might even have a presentation you’d like to share with others. If so, just upload it to PowerShow.com. We’ll convert it to an HTML5 slideshow that includes all the media types you’ve already added: audio, video, music, pictures, animations and transition effects. Then you can share it with your target audience as well as PowerShow.com’s millions of monthly visitors. And, again, it’s all free.

About the Developers

PowerShow.com is brought to you by  CrystalGraphics , the award-winning developer and market-leading publisher of rich-media enhancement products for presentations. Our product offerings include millions of PowerPoint templates, diagrams, animated 3D characters and more.

How To Get Free Access To Microsoft PowerPoint

E very time you need to present an overview of a plan or a report to a whole room of people, chances are you turn to Microsoft PowerPoint. And who doesn't? It's popular for its wide array of features that make creating effective presentations a walk in the park. PowerPoint comes with a host of keyboard shortcuts for easy navigation, subtitles and video recordings for your audience's benefit, and a variety of transitions, animations, and designs for better engagement.

But with these nifty features comes a hefty price tag. At the moment, the personal plan — which includes other Office apps — is at $69.99 a year. This might be the most budget-friendly option, especially if you plan to use the other Microsoft Office apps, too. Unfortunately, you can't buy PowerPoint alone, but there are a few workarounds you can use to get access to PowerPoint at no cost to you at all.

Read more: The 20 Best Mac Apps That Will Improve Your Apple Experience

Method #1: Sign Up For A Free Microsoft Account On The Office Website

Microsoft offers a web-based version of PowerPoint completely free of charge to all users. Here's how you can access it:

• Visit the Microsoft 365 page .
• If you already have a free account with Microsoft, click Sign in. Otherwise, press "Sign up for the free version of Microsoft 365" to create a new account at no cost.
• On the Office home page, select PowerPoint from the side panel on the left.
• Click on "Blank presentation" to create your presentation from scratch, or pick your preferred free PowerPoint template from the options at the top (there's also a host of editable templates you can find on the Microsoft 365 Create site ).
• Create your presentation as normal. Your edits will be saved automatically to your Microsoft OneDrive as long as you're connected to the internet.

It's important to keep in mind, though, that while you're free to use this web version of PowerPoint to create your slides and edit templates, there are certain features it doesn't have that you can find on the paid version. For instance, you can access only a handful of font styles and stock elements like images, videos, icons, and stickers. Designer is also available for use on up to three presentations per month only (it's unlimited for premium subscribers). When presenting, you won't find the Present Live and Always Use Subtitles options present in the paid plans. The biggest caveat of the free version is that it won't get any newly released features, unlike its premium counterparts.

Method #2: Install Microsoft 365 (Office) To Your Windows

Don't fancy working on your presentation in a browser? If you have a Windows computer with the Office 365 apps pre-installed or downloaded from a previous Office 365 trial, you can use the Microsoft 365 (Office) app instead. Unlike the individual Microsoft apps that you need to buy from the Microsoft Store, this one is free to download and use. Here's how to get free PowerPoint on the Microsoft 365 (Office) app:

• Search for Microsoft 365 (Office) on the Microsoft Store app.
• Install and open it.
• Sign in with your Microsoft account. Alternatively, press "Create free account" if you don't have one yet.
• Click on Create on the left side panel.
• Select Presentation.
• In the PowerPoint window that opens, log in using your account.
• Press Accept on the "Free 5-day pass" section. This lets you use PowerPoint (and Word and Excel) for five days — free of charge and without having to input any payment information.
• Create your presentation as usual. As you're using the desktop version, you can access the full features of PowerPoint, including the ability to present in Teams, export the presentation as a video file, translate the slides' content to a different language, and even work offline.

The only downside of this method is the time limit. Once the five days are up, you can no longer open the PowerPoint desktop app. However, all your files will still be accessible to you. If you saved them to OneDrive, you can continue editing them on the web app. If you saved them to your computer, you can upload them to OneDrive and edit them from there.

Method #3: Download The Microsoft PowerPoint App On Your Android Or iOS Device

If you're always on the move and need the flexibility of creating and editing presentations on your Android or iOS device, you'll be glad to know that PowerPoint is free and available for offline use on your mobile phones. But — of course, there's a but — you can only access the free version if your device is under 10.1 inches. Anything bigger than that requires a premium subscription. If your phone fits the bill, then follow these steps to get free PowerPoint on your device:

• Install Microsoft PowerPoint from the App Store or Google Play Store .
• Log in using your existing Microsoft email or enter a new email address to create one if you don't already have an account.
• On the "Get Microsoft 365 Personal Plan" screen, press Skip For Now.
• If you're offered a free trial, select Try later (or enjoy the free 30-day trial if you're interested).
• To make a new presentation, tap the plus sign in the upper right corner.
• Change the "Create in" option from OneDrive - Personal to a folder on your device. This allows you to save the presentation to your local storage and make offline edits.
• Press "Set as default" to set your local folder as the default file storage location.
• Choose your template from the selection or use a blank presentation.
• Edit your presentation as needed.

Do note that PowerPoint mobile comes with some restrictions. There's no option to insert stock elements, change the slide size to a custom size, use the Designer feature, or display the presentation in Immersive Reader mode. However, you can use font styles considered premium on the web app.

Method #4: Use Your School Email Address

Office 365 Education is free for students and teachers, provided they have an email address from an eligible school. To check for your eligibility, here's what you need to do:

• Go to the Office 365 Education page .
• Type in your school email address in the empty text field.
• Press "Get Started."
• On the next screen, verify your eligibility. If you're eligible, you'll be asked to select whether you're a student or a teacher. If your school isn't recognized, however, you'll get a message telling you so.
• For those who are eligible, proceed with creating your Office 365 Education account. Make sure your school email can receive external mail, as Microsoft will send you a verification code for your account.
• Once you're done filling out the form, press "Start." This will open your Office 365 account page.

You can then start making your PowerPoint presentation using the web app. If your school's plan supports it, you can also install the Office 365 apps to your computer by clicking the "Install Office" button on your Office 365 account page and running the downloaded installation file. What sets the Office 365 Education account apart from the regular free account is that you have unlimited personal cloud storage and access to other Office apps like Word, Excel, and Outlook.

Read the original article on SlashGear .

SSIS - Overview

Apr 07, 2013

190 likes | 384 Views

SSIS - Overview. John Manguno. Outline. What will we be discussing today? Matrix Reports Individualized Letters with SubReports (Award Letters) DrillDown Reporting Updating Data with SSRS Charts, Maps, and other BI like features (Google API Geolocation Data).

Share Presentation

• project deployment
• individual deployment
• project deployment model
• step 2 create

Presentation Transcript

SSIS - Overview John Manguno

Outline What will we be discussing today? Matrix Reports Individualized Letters with SubReports (Award Letters) DrillDown Reporting Updating Data with SSRS Charts, Maps, and other BI like features (Google API Geolocation Data) This session is more about demonstrating some of the possibilities of SSRS and less about how to actually accomplish those tasks, though we can certainly discuss any of these in more detail.

Project Deployment Model vs Legacy Package Deployment  • For all of the notes, go here: https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-2017 • TL:DR • Project deployment is the newer and more powerful way to write SSIS packages, and is what we will discuss in this session. • It requires installation of the SSISDB. ** Cannot be installed on SQL Express • All Integration Services objects are stored and managed on an instance of SQL Server in a database referred to as the SSISDB catalog. The catalog allows you to use folders to organize your projects and environments. Each instance of SQL Server can have one catalog. Each catalog can have zero or more folders.

I personally prefer to have separate Projects for discrete tasks, but you can also have a single Project with all of your packages. SSIS 2012 requires a full deploy every time, but SSIS 2016 allows for individual deployment.

Demo: Ice Cream SIS Integration Step 1 – create a Data Flow task to import CSV file to table. Step 2 – create a File System task to move file to archive. Step 3 – create a Data Flow task to create a csv file with SQL Query. Discuss deployment (SQLExpress does not support SSIS).

• More by User

03 – DTS to SSIS

SQL Academy 2008. 03 – DTS to SSIS. Bob Duffy Senior Consultant MCA Database| SQL Ranger. Agenda. What’s the Problem ? Upgrade Advisor DTS Package Support Migrating Packages Package Redesign Third Party Tools. Key Functional Differences. Migration Tools and Options.

673 views • 34 slides

DTS Conversion to SSIS

About the Speaker. Brian is a SQL Server MVPFounder of Pragmatic WorksCo-founder of SQLServerCentral.com and JumpstartTV.comWritten 10 SQL Server booksTrains at End to End Training (http://www.endtoendtraining.com). Failed Ad Campaign. Agenda. Mapping DTS knowledge and skills to SSISRunning DTS packages in 2005 or 2008Upgrading DTS PackagesUpgrading ActiveX Scripts.

424 views • 27 slides

SSIS Best Practices

SSIS Best Practices. Donald Farmer [email protected] Session Code: DAT310. Stating the obvious. Look outside of SSIS for perf. Demo. Understand Your Hardware. The basic topology. ETL Topology. Source. Destination. SSIS Data Flow. Load. Extract. Transform. ETL Topology.

365 views • 31 slides

Deploying SSIS Packages

••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••. Deploying SSIS Packages. SSIS. Presented by: Jose Chinchilla, MCP, MCTS, MCITP.

622 views • 6 slides

The ABCs of SSIS!

The ABCs of SSIS!. Glenda Gable Email: [email protected] LinkedIn: linkedin.com/in/tig313. Agenda.

287 views • 17 slides

SSIS Mentoring 101

Presenter: Maureen Zinda. SSIS Mentoring 101. What is an SSIS County Mentor? SSIS expectations/benefits County benefits Worker Mentor Program Coordinator. What is a SSIS County Mentor?. A person identified by the county

339 views • 9 slides

SSIS for the Disinterested

Brian Garraty @ NULLgarity. SSIS for the Disinterested. Who I am. Brian D. Garraty SQL Server DBA, Va Beach Public Schools HRSSUG Leadership Team Background in C++, VB, ASP, C# @ NULLgarity NULLgarity.wordpress.com >10 years experience with SSIS & DTS. Why I’ve Come to You Today.

826 views • 70 slides

Real-World SSIS

A Survival Guide Tim Mitchell. Real-World SSIS. What we’ll cover today. Lessons I’ve learned the hard way Methodologies to solve real problems in SSIS Tools to help out Solutions for SQL 2012 as well as earlier versions Demos. What we won’t cover. No intro to SSIS Books Online.

1.61k views • 138 slides

SSIS monitoring

SSIS monitoring. Using SSISDB and SSRS. Who am I?. Peter ter Braake Independent trainer/consultant MCT since 2002 MVP since 2012. Agenda. Create SSIS Project Project versus Package deployment Deploy Environments Execute package Monitoring SSMS reports SSISDB catalog

216 views • 7 slides

Designing an SSIS Framework

Designing an SSIS Framework. Andy Leonard SQLBits 9 1 Oct 2011. Europe’s Premier Community SQL Server Conference. # SQLBITS. Platinum Sponsor. Premium Sponsor. Please visit our Gold Sponsor stands, we couldn't do it without you…. Silver, Bronze and Exhibitors. All of you….

441 views • 25 slides

CDC+SSIS = SCD

CDC+SSIS = SCD. Patrick LeBlanc, SQL Server MVP. #49 Orlando. Contact Information. Email: [email protected] Twitter: patrickdba Blog: http://bidn.com/blogs/patrickleblanc. Overview. A Few Warehouse Terms Detecting Change Data (OLD SCHOOL) Change Data Capture

473 views • 18 slides

Performance Tuning SSIS

Performance Tuning SSIS. Brian Knight, CEO Pragmatic Works [email protected]. HR Departments are no fun. Don’t mention the stalking incident with Clay Aiken What happened in Vegas My prom date with a puppet Most unfortunate incident with a turtle My fear of bounce houses

423 views • 30 slides

SSIS Custom Components

SSIS Custom Components. Dave Ballantyne [email protected] @ davebally. Why ?. Provide new functionality not provided as standard. Why ?. Reusability Component is a DLL Single code base Can be used multiple times in a single project Can be shared across multiple projects

592 views • 34 slides

SSIS in Denali

SSIS in Denali. Peter ter Braake [email protected]. Agenda. New for developers SSISDB Catalog Dependency Analyser. New for developers. Source Assistant en Destination Assistant Vervangen Connection project Undo / Redo button Transformation configuration zonder inputs Vernieuwde toolbox

277 views • 17 slides

Performance Tuning SSIS. Brian Knight, CEO Pragmatic Works [email protected]. About the Ugly Guy Speaking. SQL Server MVP Founder of Pragmatic Works Co-Founder of BIDN.com, SQLServerCentral.com and SQLShare.com Written more than a dozen books on SQL Server. Mobile data.

526 views • 33 slides

SSIS Field Notes

SSIS Field Notes. Darren Green Konesans Ltd. My Checklist. Standards Logging Configuration. Common Princiapls. Common design decisions or patterns Logging Frameworks Custom vs Stock. Basic Standards. Solution and Project structure ETL vs ELT Staging Custom components.

323 views • 23 slides

Optimizing SSIS Performance

Optimizing SSIS Performance. Aaron Jackson. Primary Sponsor. Varigence software provides clients with efficient methods for developing, managing, and using Microsoft business intelligence solutions.

877 views • 61 slides

SSIS Interview Questions

SSIS Interview Questions for beginners and professionals with a list of top interview questions. Visit- http://www.hub4tech.com

189 views • 4 slides

SSIS Fiscal and SSIS Worker

SSIS Fiscal and SSIS Worker. Terminology disclaimer

347 views • 34 slides

106 views • 9 slides

SSIS Business Intelligence

Microsoft SQL Server Integrationu00a0Servicesu00a0also called either SQL Integrationu00a0Serviceu00a0oru00a0SSIS.

86 views • 6 slides