IT-kurs
Systemutvikling
SQL programmering
Du har valgt: Oslo
Nullstill
Filter
Ferdig

-

5 treff ( i Oslo ) i SQL programmering

Sorter på søkerangering, kursnavn, pris, sted, kursdato


Oslo Og 4 andre steder 1 dag 3 200 kr
Utnytt mulighetene og jobb smartere og mer effektivt med nye Outlook 2010! Etter kurset skal deltakerne kunne benytte Outlook til å spare tid i en travel arbeidshverdag.... [+]
Agenda Smartere bruk av e-post Tilpasse visninger med feltknapper, gjøremålsområder, leserute med mer Favoritter og lag egne søkemapper for smart søk og organisering Utnytt kategorier og flagg og tilpass emnefeltet til din fordel Smart bruk av e-post – framdatering og ”stemmeknapper” Spar tid med automatikk via regler og Hurtigtrinn Utklipp, tabeller, bilder og skjermutsnitt som e-post Bruk Personruten effektivt Kontakter Tilpasse visninger (vis e-postadresser, kategorier med mer) Effektiv bruk av kontaktkort med bilde, vedlegg og kartsøk Kontaktgrupper, kontaktmapper og import av kundelister fra/til Excel Kalender Smarte visninger, personlige innstillinger og alternativer Utnytt din kalender med ulik intervallvisning og statusvisning Lag undermapper av din kalender Spar tid og hold oversikt med Kalendergrupper Hold deg oppdatert om andres tid og send avtaleoversikt via e-post Smarte valg på møteinnkallinger – oppdateringer, ta ut deltakerlister Oppgaver Bruk de rette ressurser og deleger oppgavene! Send epost direkte til Oppgaveblokken Tips til samarbeid med Word, Excel og PowerPoint Flette med Word, hyperkobling fra presentasjoner     [-]
Les mer
Oslo 3 dager 16 950 kr
This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming la... [+]
This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects. Learn To: Understand SQL statements, as well as the Oracle Relational Database. Use SQL Developer. Write reports using SQL statements. Manipulate data in relational tables and save the data. Understand the concepts of relational databases and the powerful SQL programming language. Write reports using SQL Statements. Innhold: Course Objectives Define the goals of the course List the features of Oracle Database 12c Describe the salient features of Oracle Cloud 12c Discuss the theoretical and physical aspects of a relational database Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS) Identify the development environments that can be used for this course Describe the database and schema used in this course Course Topics Introduction Course Objectives, Course Agenda and Appendixes Used in this Course Overview of Oracle Database 12c and Related Products Overview of relational database management concepts and terminologies Introduction to SQL and its development environments What is Oracle SQL Developer? Starting SQL*Plus from Oracle SQL Developer The Human Resource(HR) Schema Tables used in the Course Retrieving Data using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Using Single-Row Functions to Customize Output Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Using Conversion Functions and Conditional Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Use conditional IF THEN ELSE logic in a SELECT statement Reporting Aggregated Data Using the Group Functions Group Functions Creating Groups of Data Restricting Group Results Displaying Data From Multiple Tables Using Joins Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries to Solve Queries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using ORDER BY clause in set operations Managing Tables using DML statements Data Manipulation Language Database Transactions Introduction to Data Definition Language Data Definition Language Read full course description: Oracle Database: SQL Workshop I   Course material We use official Oracle material in our Oracle trainings. This include eKit (electronic documentation) and Lab environment from Oracle University.  [-]
Les mer
Oslo 5 dager 22 500 kr
Kursinstruktør    Kursinnhold About this CourseThis five-day instructor-led... [+]
Kursinstruktør    Kursinnhold About this CourseThis five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462 Below are the some of the new features of SQL Server that has been discussed in this course •Discussion around servicing SQL Server (Service Packs, Cumulative Updates, Hotfixes) ◦Understanding the relationship between the different levels of updates to the SQL Server product is very important for those working with it. The course now covers details on how hotfixes, cumulative updates and service packs are related and when to apply each type of update. •SQL Server use of automated update ◦SQL Server can now utilize Windows Update for servicing. The course shows how to enable automated updates and when the use of these updates should and should not be used. •Partial database containment ◦A significant challenge when migrating databases between servers is the management of objects such as logins that are not contained within the database. The course now discusses the partial containment options that are provided by SQL Server 2012. In particular, authentication-related changes are discussed. •Users with passwords (contained users) ◦The course shows how SQL Server 2012 allows users to be authenticated at the database level, rather than at the server level. This is an important first step in for database containment. •User-defined server roles ◦In earlier versions of SQL Server, user-defined roles could be created at the database level but not at the server level. In SQL Server 2012, user-defined roles can also be defined at the server level. This can help to increase the security of systems. Having the ability to configure more fine-grained permissions lets logins be assigned only the permissions that they need to do their work. •In-place upgrades of data-tier applications ◦In earlier versions of SQL Server, an upgrade of a data-tier application involved migrating all the data within a database to a new database. In SQL Server 2012 this is no longer needed and the course shows how data-tier applications can be upgraded much more quickly, and using less system resources. •Appendix with intro to AlwaysOn, High Availability and Replication concepts ◦Students who will be attempting the certification exam that is relevant to this course require knowledge of high availability and replication. In earlier versions of this course, none of these details were covered. In this version of the course, an appendix that covers the core concepts for high availability (including SQL Server 2012 AlwaysOn technologies) and replication is provided. Audience ProfileThe primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. At Course Completion After completing this course, students will be able to: •Plan and install SQL Server. •Describes the system databases, the physical structure of databases and the most common configuration options related to them. •Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server. •Create SQL Server Backups. •Restore SQL Server databases. •Use the import/export wizards and explain how they relate to SSIS. •Work with SQL Server security models, logins and users. •Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles. •Work with permissions and the assignment of permissions. •Work with SQL Server Audit. •Work with SQL Server Agent, jobs and job history. •Implement SQL Server agent security, proxy accounts and credentials. •Configure database mail, alerts and notifications. •Create database maintenance plans. •Work with SQL Profiler and SQL Trace stored procedures. •Introduce DMVs and the configuration of data collection. •Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications. •Troubleshoot SQL Server databases. Kurset fører til eksamen 70-462 Sertifiseringsløp [-]
Les mer
Oslo 22 500 kr
29 May
Kursinnhold About this Course Business intelligence (BI) is becoming increasingly important for... [+]
Kursinnhold About this Course Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution. This five-day instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466. Audience Profile This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:•Implementing reporting solutions by using SQL Server Reporting Services. •Implementing multidimensional databases by using SQL Server Analysis Services. •Creating tabular semantic data models for analysis by using SQL Server Analysis Services. •Create visualizations of data by using PowerView. •Create data mining solutions by using SQL Server Analysis Services. At Course Completion After completing this course, students will be able to:•Describe the components, architecture, and nature of a BI solution. •Create reports with Reporting Services. •Create reusable report items that simplify self-service reporting. •Manage report execution and delivery. •Create a multidimensional database with Analysis Services. •Implement dimensions in a cube. •Implement measures and measure groups in a cube. •Use MDX Syntax. •Customize a cube. •Implement a Tabular Data Model in PowerPivot. •Use DAX to query a tabular model. •Implement a Tabular Database. •Use PowerView to create interactive data visualizations. •Use Data Mining for Predictive Analysis. Kurset fører til eksamen 70-466 Sertifiseringsløp [-]
Les mer
Oslo 3 dager 14 500 kr
08 May
05 Jun
03 Jul
Dette er et grunnleggende kurs i SQL-programmering. Kurset passer godt for deg som skal jobbe med relasjonelle databaser, som f.eks. Oracle, PostgreSQL, Microsoft SQL-ser... [+]
Kursinstruktør Terje Berg-Hansen Terje Berg-Hansen har bred erfaring fra prosjektledelse, utvikling og drift med små og store databaser, både SQL- og NoSQL-baserte. I tillegg til å undervise i etablerte teknologier leder han også Oslo Hadoop User Group, og er levende interessert i nye teknologier, distribuerte databaser og Big Data Science.    Kursinnhold Dette er et grunnleggende kurs i SQL-programmering. Kurset passer godt for deg som skal jobbe med relasjonelle databaser, som f.eks. Oracle, PostgreSQL, Microsoft SQL-server eller MySQL/MariaDB.   Etter gjennomført kurs vil deltakerne være fortrolige med å opprette databaser og tabeller, sette inn data, endre og slette data og søke etter data i SQL-databaser.  Kursinnhold Introduksjon til relasjonsdatabaser og relasjonsmodellen: normalisering på tredje normalform. Introduksjon til MySQL, PostgreSQL, Oracle Express og tilhørende verktøy Introduksjon til SQL i Big Data (HiveQL, Cassandra QL, Phoenix HBase-klient) Søk i SQL-databaser, bl.a. med bruk av under-spørringer og inner og outer joins. Filtrering, gruppering og sortering av data. Oppretting, endring, kopiering og sletting av databaser og tabeller, Innsetting, oppdatering og sletting av data i tabeller Bruk av indekser og views. Skjema-design med bruk av ulike data-typer, tegnsett og lagringsformater. Introduksjon til MySQL, PostgreSQL og Oracle Express Bruk av bl.a. MySQL Workbench, PhPMyAdmin og Oracle Application Express. Kurset gjennomføres med en kombinasjon av online læringsmidler, gjennomgang av temaer og problemstillinger og praktiske øvelser med ulike typer datasett.    [-]
Les mer