Benutzer:MovGP0/Python/Queries

MovGP0

Über mich

Hilfen

Artikel

Weblinks

Literatur

Zitate

Notizen

Programmierung

MSCert

Physik

Programmierung Programmierung Administration • Links • Vorgehensmodelle • NuGet • Transformations • MSBuild • Raspberry • Cheatsheets • Git • Mathematica C♯ Program Flow Multithreading and asynchronous processing • Multithread management • Program flow • Events and callbacks • Exception handling Types Type creation • Type consumentation • Encapsulation • Class hierarchies • Reflection • Object life cycle • String manipulation Debugging and Security Input validation • Encryption • Assembly Management • Debugging • Diagnostics Data access I/O operations • Data consumtion • LINQ • Data serialization • Collections Theory Functional • Lambda Calculus • Category Theory F♯ Basics Data Structures • Classes • Generics • Units of Measure • Exception Handling • Pipes • Recursion • Pattern Matching • Lazy Evaluation • Asynchronous and Parallel Programming • Number Representations • Arithmetic Operators • Conversion Functions • Queries Quantitative Finance Math.NET • Statistics • Root Finding Algorithmns • Data Visualisation • Option Pricing • Volatility • Order Types and Market Data • Volatility Trading Python Classes • Loops • Anonymous Types • Lambda Expressions • Queries (LINQ) • Iterators (yield) PHP   T-SQL / SQL Server T-SQL Fundamantals Select • Programming • Pitfalls • Query from Multiple Tables • Groups and Summaries • Advanced Select • Aggregation and Windowing • Insert, Update, Delete • Strings • Date and Time • Numbers • Transactions, Locking, Blocking, Deadlock • Tables • Views • Large Tables and Databases • Indexes • Stored Procedures • User-Defined Functions and Types • Triggers • Error Handling • Query Performance and Tuning • Hints • Index Tuning and Statistics • XML • Files, Filegroups, Integrity • Backup • Recovery • Principals and Users • Securables, Permissions, Auditing • Objects and Dependencies SQL Server Performance Tuning Memory Performance Analysis • Disk Performance Analysis • CPU Performance Analysis • Baseline Creation • Query Performance Metrics • Query Performance Analysis • Index Architecture and Behavior • Index Analysis • Database Engine Tuning Advisor • Key Lookups • Statistics, Data Distributuon, and Cardinality • Index Fragmentation • Execution Plan Generation • Execution Plan Cache Behavior • Parameter Sniffing • Query Recompilation • Query Design Analysis • Reduce Query Resource Use • Blocking and Blocked Processes • Causes and Solutions for Deadlocks • Row-By-Row Processing • Memory-Optimized OLTP Tables and Procedures • Database Performance Testing • Database Workload Optimization • SQL Server Optimization Checklist Service Broker Message • Contract • Queue • Service • .NET Integration • Route • Security   Datatypes • Unit Testing • Dependency Injection • Partitioning • .NET General LINQ • Reactive Extensions • Entity Framework • OData • Windows Workflow Foundation • Threading • Logging • Unit Testing • Dependency Injection • Documentation • WinForms Performance Locking • Coding Style and Class Design • .NET Framework • Performance Counters • Event Tracing (ETW) • Windows Phone • Code Safety • Team ASP.NET Common OWIN • Razor • WebForms • MVC • WebAPI Core Configuration • Data Protection API • Dependency Injection • Routing Attack Vectors HTTPS • HSTS • HPKP • CSP • CSRF • Anti-XSS • CORS • Open Redirection • Click-Jacking Libraries OpenID • Azure AD Messaging WCF Basics Services • Addresses • Contracts • Hosting • Bindings • Endpoints • Metadata Exchange • Behaviour Configuration • Client-Side Programming • Architecture • Channels • Transport-Level Sessions • Reliability Advanced WCF Service Contract • Data Contract • Instance Management • Operations • Faults • Transactions • Concurrency Management • Queued Services • Security • Service Bus • Basic HTTP Auth Andere .NET Remoting • Message Queuing (MSMQ) • Protocol Buffers • ActiveMQ • Disruptor.NET • TIBCO Rendezvous • CQRS • Rebus User Interface WPF Data Binding • Resources • Transforms and Effects • 2D Drawing • 3D Drawing • Routed Events • Routed Commands • ICommandSource • Triggers • Behaviors • Visual State Manager • Theming • Layout • Templates • Popups • Dependency Object • Fonts • Composition API • MVVM Frameworks • Navigation Windows Forms INotifyPropertyChanged • DataBinding • Validation • PRISM DevExpress DataAnnotation • TaskbarButtonService, ApplicationJumpListService, NotificationService • Asynchronous Commands Xamarin DependencyService • Custom Renderer • Shaped Buttons Parallel Programming Common Processor • Locking Data Parallelism Parallel Loops • Parallel Aggregation Task Parallelism Parallel Tasks • Futures • Dynamic Task Parallelism • Pipelines Akka.NET Logging • Persistence • Dependency Injection • Cluster • Remote ECMAScript Languages ECMAScript • TypeScript • Elm • LESS Infrastruktur Node • Yeoman • Bower • Grunt • Jasmine • Karma • Protractor • Hapi • Redux AngularJS Validation • Testing Angular Modules • Animations • Attributes • Styles • Deployment • Dependency Injection • HTTP Client • Lifecycle • Pipes • Routing and Navigation • Security • Structural Directives (ngIf, ngFor, ngSwitch) • Testing • Forms Validation Other Knockout • RequireJS • PhoneGap/Cordova • React • fantasy-land • typed-contract • parsimmon SharePoint Notes Fields • Lists • Content Types • Workflow • Business Connectivity Services • Search • Managed Metadata • AngularJS • Publishing/Approval • LINQ to SharePoint Nintex Custom Activities 70-488 • 70-489 Design and Implement Search • Implement Business Connectivity Services (BCS) • Implement Implement User Profiles and Customize Social Workload • Implement ECM and WCM • Design for Performance and Troubleshooting • Implement Managed Metadata Service (MMS) Microsoft CRM Reporting and Dashboards • SharePoint Integration • Authentication • Entity Handling • Workflows • Queries Security Forms Authentication • Membership and Role Provider • Zertifikate • OAuth • OpenID • Windows Identity Foundation Dateiformate CSV • Excel • Word • PDF • Email Azure Notes Azure Pack • Single Sign-on • Data Storage • Logging • Tracing • Service Bus • HDInsight • Orleans Infrastructure Services Virtual Machines • Virtual Machine Networking • Virtual Machine Storage • Virtual Networks 70-533  • 70-534 Active Directory • Static IP Adresses • ACLs • Network Security Groups • Availability Sets • VPN • Load Balancing • CDN • Media Services • Multi-Factor Auth. Muster Architektur Entwurfsmuster • Architekturmuster • Patterns of Enterprise Application Architecture Daten Analysemuster • Datenbank-Muster Verteilte Systeme Enterprise Integration Patterns • SOA • Big Data • Cloud • Stability & Capacity Management Organisationsmuster • Refactoring • Lizenzmuster Antimuster Antimuster • Dark Patterns • SQL Antipatterns Powershell Grundlagen Subversion (SVN) • CmdletBinding • Parameter (Sets) • Return Type • Module • Exception Handling DSC Common Information Model (CIM) • Resources • Configuration and Parameters • Local Configuration Manager (LCM) • Credentials • SMB Pull Server • HTTP Pull Server Android ROM Flashen • Unit Testing • Assistant Machine Learning Neuronale Netze Propagierungsfunktionen • Aktivitätsfunktionen • Lernmethoden • Pattern Associator • Rekurrente Netze • Kompetitive Netze • Kohonennetze • Constrain Statisfaction Netze Tensorflow Linear Regression • Logistic Regression • Softmax Regression • Hidden Markov • K-Means Clustering • Self-Organizing Map • Autoencoder • Q-policy neural network • Perceptron • Convolutional Neuronal Network • Recurrent Neuronal Network • Seq2Seq • Ranking Core Server Hyper-V • Active Directory User Groups • Active Directory Domain Services • Active Directory Federation Services • DHCP • IIS • DNS • RDP • WSUS • User Permissions • IP • SMB • DHCP • IPAM • Sonstige Bot Framework Rich Messages • Queries class AnonObject(dict): __getattr__ = dict.get __setattr__ = dict.__setitem__ class Person: def __init__(self, name, age, hobby): self.hobby = hobby self.age = age self.name = name def __repr__(self): return "{0} is {1} and likes {2}".format(self.name, self.age, self.hobby) people = [ Person("Jeff", 50, "Biking"), Person("Michael", 40, "Motocross"), Person("Sarah", 30, "Running"), Person("Tony", 24, "Jogging"), Person("Zoe", 12, "TV") ] # Query bikers = [ AnonObject(Name=person.name, PastTime=person.hobby) ü select result into anonymous type for person in people if person.hobby == "Biking" ] bikers.sort(key=lambda p: p.Name) for biker in bikers: print(biker)