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

-

11 treff ( i Oslo ) i SQL programmering
 

Oslo 5 dager 22 500 kr
Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Microsoftkurs 20463. Under dette kurset lærer du deg hvordan du skaper ett datalager med SQL Server. [+]
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. [-]
Les mer
22 500 kr
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 5 dager 22 500 kr
27 Nov
Under dette kurset lærer du deg å planlegge og implementere en databasestruktur med høy ytelse og høy tillgjengelighet, med SQL Server og andre microsoftteknologier [+]
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. [-]
Les mer
5 dager 28 250 kr
In the Oracle Database 12c: New Features for Administrators course, you’ll learn about the new and enhanced features of Oracle Database 12c. Expert instructors will tea... [+]
In the Oracle Database 12c: New Features for Administrators course, you’ll learn about the new and enhanced features of Oracle Database 12c. Expert instructors will teach you how these features increase security, manageability and performance.    Explore the Following New Features: Online Data-file Move Heat Map Automatic Data Optimization Temporal history Temporal validity Row-archival Unified Auditing Administrative privileges Privilege Analysis Data Redaction Adaptive Execution Plans SQL Plan Directives Real-Time ADDM Compare Period ADDM Data Pump Partitioning SQL   Course objectives Create, manage and monitor multitenant container database and pluggable databases Manage datafile online operations, data lifecycle management with heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and Temporal Histor Set up the unified audit trail Understand and use the new privileges, such as SYSBACKUP, SYSDG, SYSKM and manage privilege analysis Create and manage Data Redaction masking policies Use the Recovery Manager enhancements Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM Compare two databases using Schema Change Plans to propagate changes from one environment to another Use Data Comparisons to compare data across environments Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements Manage resources in a multitenant container database and pluggable databases with enhanced Resource Manager Explore new Oracle Data Pump features and SQL*Loader Express Mode Use online operations during partition movement and compression, and other DDL operations Use partial global partitioned indexes Explain new SQL enhancements such as extended data type column and SQL row limiting clause   [-]
Les mer
5 dager 22 500 kr
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, d... [+]
After completing this course, students will be able to: Describe the components, architecture, and nature of a BI solution. 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 SQL Server Analysis Services. Use DAX to enhance a tabular model. Create reports with Reporting Services. Enhance reports with charts and parameters. Manage report execution and delivery. Implement a dashboard in SharePoint Server with PerformancePoint Services. Use Data Mining for Predictive Analysis. [-]
Les mer
Oslo 3 dager 14 500 kr
15 Jan
12 Feb
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
5 dager 22 500 kr
Under kurset lærer du deg administrasjon av SQL Server. Kurset dekker områder som installasjon og konfigurasjon, sikkerhet, høy tilgjengelighet, gjenoppretting, og ove... [+]
Plan and install SQL Server. Describe system databases, the physical structure of databases, and the most common configuration options related to them. Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server. Back up SQL Server databases. Restore SQL Server databases. Import and export data by using wizards, the bulk copy utility, and data-tier applications. Work with SQL Server security models, logins, users, and contained databases. Work with server roles and database roles. Use permissions to secure resources. Use SQL Server audit and Transparent Data Encryption. Work with SQL Server Agent to configure and execute jobs. Implement SQL Server Agent security, proxy accounts, and credentials. Configure database mail, alerts, and notifications. Create database maintenance plans. Use SQL Server Profiler, SQL Trace, and Distributed Relay. Use Distributed Management Views and configure data collection. [-]
Les mer
Nettstudier 2 semester 4 980 kr
På forespørsel
Installasjon, konfigurering og bruk av epost-tjener og Outlook klient. Bruk av PowerShell for å drifte Exchange server. Installasjon, konfigurering og bruk av SQL-tjener... [+]
Studieår: 2013-2014   Gjennomføring: Høst og vår Antall studiepoeng: 5.0 Forutsetninger: Kunnskaper om Windows server eller gode generelle nettverkskunnskaper eller tilsvarende. Innleveringer: 8 av 12 øvinger må være godkjent. Personlig veileder: ja Vurderingsform: 3 timers individuell skriftlig eksamen Ansvarlig: Jostein Lund Eksamensdato: 02.12.13 / 05.05.14         Læremål: KUNNSKAPER:Kandidaten:- har innsikt i drift av epost- og database-servere- kjenner til løsninger for å eksportere og importere data for epost- og database-servere FERDIGHETER:Kandidaten kan:- installere, konfigurere, drifte og sikre en Exchange epost-server- sette opp og distribuere Outlook til klienter- bruke PowerShell til å automatisere driftsoppgaver i Exchange- installere, konfigurere og drifte en SQL server GENERELL KOMPETANSE:Kandidaten har:- perspektiv og kompetanse i å velge riktige og tilpassete driftsløsninger- kompetanse i å formidle driftsterminologi, både muntlig og skriftlig Innhold:Installasjon, konfigurering og bruk av epost-tjener og Outlook klient. Bruk av PowerShell for å drifte Exchange server. Installasjon, konfigurering og bruk av SQL-tjener. Utveksling av data mellom løst sammenkoblede systemer. Finne, dele og publisere informasjon. Følgende programvare vil bli gjennomgått som supplement for å belyse den teoretiske gjennomgangen: Microsoft Exchange Server, Microsoft SharePoint Portal Server, Microsoft SQL Server. Nødvendig programvare kan fritt lastes ned.Les mer om faget her Påmeldingsfrist: 25.08.13 / 25.01.14         Velg semester:  Høst 2013    Vår 2014     Fag Drift av MS Exchange og MS SQL Server 4980,-         Semesteravgift og eksamenskostnader kommer i tillegg.   [-]
Les mer
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
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
3 dager 13 500 kr
Dette er et kurs for de som ønsker å lære SQL-programmering, og som har god generell datakunnskap som minimum forutsetninger. [+]
MålsettingDeltakerne skal på en effektiv måte kunne benytte Structured Query Language (SQL) som verktøy etter at kurset er ferdig. De vil lære å bruke de viktigste konseptene og funksjonene, og kjenne til grunnleggende prinsipper for utvalg og databaseoppbygging i SQL.   Dokumentasjon Addison Wesley – 'The Practical SQL Handbook, eller tilsvarende.    Kursinnhold     * Hva er en database?          o Generelle og grunnleggende gjennomgang av relasjonsdatabaser     * Hvordan opprette en database?          o Utgangspunkt, Data entitet modell, Entitet relasjons diagram og Normalisering    * Datatyper, operatorer          o Gjennomgang av datatyper og operatorer, samt eksempler som viser hvilken datatype man bør velge når man skal lagre forskjellige data     * Tabeller          o Hvordan opprette, endre og slette tabeller?     * DML (Data manipulationg language)          o Delete, Insert, Select og Where     * DDL (Data definition language)          o Create, Drop og Alter    * Views          o Hvorfor og hvordan benytte seg av utvalg/datavisninger    * Subquerys          o Hvordan benytte seg av subquerys, eksempler på hva dette kan benyttes til    * Tekst-funksjoner          o Instr, Replace, Trim, etc       MetodikkGateway tilbyr praktisk og virkelighetsnær opplæring. I tillegg til å jobbe med kurs og opplæring, er våre instruktører også konsulenter som jobber med utvikling og problemløsninger i den aktuelle programvare. Dette betyr at instruktørene kjenner den praktiske bruk av programmet i ulike bedriftsmiljøer.   Vi har som oftest små grupper på kurs, slik at kursleder kan ta seg av hver enkelt. Alle deltakere får egen PC under kurset. Kursleder vil vise ulike teknikker på storskjerm, deltakerne vil deretter få oppgaver der de kan prøve ut disse teknikkene.   Deltakerne vil få utdelt dokumentasjon som vil bli benyttet under kurset, slik at man lettere kan bruke dokumentasjonen som oppslagsverk i ettertid. [-]
Les mer

Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.
;