Cursus SQL at Mr Data Amsterdam

Total time
Logo Mr Data Business School (XADAT.NL)
Provider rating: starstarstarstarstar 9.7 Mr Data Business School (XADAT.NL) has an average rating of 9.7 (out of 16 reviews)

Tip: need more info about the programme, starting date or price? Request information for free!

Starting dates and places

There are no known starting dates for this product.

Mr Data Business School (XADAT.NL) offers their products as a default in the following regions: 's-Hertogenbosch, Alkmaar, Almere / Lelystad, Alphen aan den Rijn, Amersfoort, Amsterdam, Antwerpen, Apeldoorn, Arnhem, Assen, Breda, Brugge, Brussel, Delft, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gent, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Hilversum, Leeuwarden, Leiden, Maastricht, Middelburg, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

Description

Over SQL

SQL is de taal waarmee jij de communicatie tussen jouw database en applicatie verzorgt, of informatie uit je database prepareert voor data analyse of -visualisatie. Met SQL haal je met behulp van queries gegevens op uit de database, voeg je gegevens toe of pas je gegevens aan. Met een grondige kennis van SQL ben je in staat om complexe database applicaties te bouwen. Verder kun je met intelligente queries de belasting op jouw database beperken, wat de performance van jouw applicaties ten goede komt.

Tijdens de cursus

Tijdens de Cursus SQL maken we jou vertrouwd met concepten van relationele databases. Vervolgens leer je werken met de querytaal SQL. Je leert gecompliceerde selecti…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Over SQL

SQL is de taal waarmee jij de communicatie tussen jouw database en applicatie verzorgt, of informatie uit je database prepareert voor data analyse of -visualisatie. Met SQL haal je met behulp van queries gegevens op uit de database, voeg je gegevens toe of pas je gegevens aan. Met een grondige kennis van SQL ben je in staat om complexe database applicaties te bouwen. Verder kun je met intelligente queries de belasting op jouw database beperken, wat de performance van jouw applicaties ten goede komt.

Tijdens de cursus

Tijdens de Cursus SQL maken we jou vertrouwd met concepten van relationele databases. Vervolgens leer je werken met de querytaal SQL. Je leert gecompliceerde selecties maken met behulp van joins. We behandelen het bewerken van gegevens in een database en je leert hoe jij personen toegang geeft tot jouw gegevens. Verder gaan we in op het maken van views en het werken met transacties.

Resultaat

Na afloop van de cursus ben je volledig op de hoogte van de werking van SQL. Jij bent in staat om een efficiënt databasemodel te maken en de gegevens hieruit te normaliseren. Je kunt de gegevens optimaliseren en queries samenstellen. De kennis die je in deze cursus opdoet is toepasbaar op ieder databaseplatform, zoals SQL Server, Oracle en MySQL.

Praktijkcase

De praktijk loopt als rode draad door de opleiding. Je gaat aan de slag met de database MySQL en maakt zelf gecompliceerde selecties. Je normaliseert data en optimaliseert gegevens. Ook stel je queries samen en maak je een efficiënt databasemodel.

Competenties en vaardigheden

Om een goede SQL developer te worden, werk je tijdens de Cursus SQL aan de volgende competenties en vaardigheden: diverse SQL functies toepassen, data normaliseren, databases opmaken, data bewerken en database beveiligen via usermanagement.

Tijdens de SQL cursus leer je wat je met SQL kunt doen, hoe je data kunt bewerken, hoe je gegevens kunt toevoegen en wijzigen in databases en hoe je data kunt normaliseren.

Gerelateerd

  • Cursus SQL Server
  • Cursus SQL Server DBA
  • Cursus T-SQL
  • Cursus Oracle SQL
  • Cursus MySQL

Tijdens de cursus komen de volgende onderwerpen aan bod:

Relationele databases

We beginnen met een introductie in de relationele database. Je maakt kennis met de bouwstenen van een database, zoals tabellen, velden, veldtypes en indexen. Verder besteden we aandacht aan de relaties tussen tabellen en sleutelvelden (primary en foreign keys), die gegevens identificeren en koppelen. Ook gaan in op de rol van een DBMS (database management systeem), die wordt gebruikt om een database te beheren.

Normaliseren van data

Een goed georganiseerde database is gebaseerd op een logisch genormaliseerd datamodel. Op die manier ga je spaarzaam om met de opslagruimte en voorkom je meervoudige vastlegging van dezelfde data. Binnen deze module leer je wat normalisatie is en hoe je het toepast in een datamodel.

Introductie SQL en selecties maken

Binnen deze module gaan we in op wat SQL precies is en welke rol de taal speelt in een applicatie die gekoppeld wordt met een database. Jij leert hoe je het select-statement toepast en hoe je joins gebruikt om informatie uit meerdere tabellen ophaalt in één query.

SQL functies en geavanceerde selecties

Met behulp van SQL functies bewerk je de ruwe gegevens uit jouw database al met de query. Je leert de SQL-functies toepassen en gegevens aggregeren. Zo leer je onder andere records tellen die aan bepaalde voorwaarden voldoen en hoe je gegevens gegroepeerd ophaalt. Ook leer je verschillende subselect methoden kennen en toepassen.

Data bewerken en transacties

Tijdens deze module gaan we in op het toevoegen en wijzigen van gegevens in de database. Daarbij behandelen we ook het bundelen van queries met behulp van transacties.

Views en usermanagement

Met een view geef je een gedeelte van de database weer. Jij bepaalt daarbij zelf welke informatie getoond wordt en hoe je de data sorteert. Zo toon je voor een bepaalde gebruiker alleen die informatie die hij of zij nodig heeft. Op deze manier regel je ook de autorisatie voor verschillende gebruikers binnen jouw database. Tijdens deze module leer jij hoe je met informatie uit meerdere tabellen een view samenstelt en de toegang voor gebruikers beheert, om zo de veiligheid van jouw database optimaal in te stellen.

Data exporteren

Vaak zul je informatie uit de database willen gebruiken in andere systemen, voor data analyse, of in een visualisatietool. De informatie die als resultaat van je views of queries beschikbaar is, wil je dan kunnen exporteren. We gaan in deze module in op verschillende typen datastructuren, zoals CSV, JSON en XML, die vanuit een DMBS veelal beschikbaar zijn en waarmee informatie kan worden overgedragen aan externe systemen.

Praktijkcase

De praktijk loopt als rode draad door de opleiding. Je gaat aan de slag met de database MySQL en maakt zelf gecompliceerde selecties. Je normaliseert data en optimaliseert gegevens. Ook stel je queries samen en maak je een efficiënt databasemodel.

Alternatief

Wil jij graag nog dieper ingaan op het gebruik van SQL? Wil jij daarbij ook gebruik maken van Microsoft SQL server? Schrijf je dan in voor een cursus SQL Server! Tijdens de cursus SQL server ga je ook in op de basis van SQL: het bevragen van een database en data bewerken. Daarnaast leer je ook hoe je met een SQL server database kunt werken en hoe je queries maakt met T-SQL. Of wil jij liever als beheerder je eigen database opzetten? Dan kan je een cursus SQL Server DBA volgen! Tijdens de cursus SQL server DBA leer je hoe je een SQL server database installeert, configureert en beheert.

Start Business Management Courses Today.

XADAT.COM offers a range of short courses in London and Amsterdam including ERP for beginners, performance management, kpi, business intelligence tools, data warehousing, bi roadmap, analytics, big data, become a business analyst, become a data analyst, BI systems, BI Architecture, information visualization, business intelligence competency Center, Scrum methodology, Mobile BI, individual courses. Apply today!

 

Business Management Courses 1: ERP

This course is designed beginners working with and around ERP system. This material approaches real-world ERP system topics using an integrated process perspective of an organisation. Click “here” Download brochure ERP systems. Or contact XADAT.COM.

 

Business Management Courses 2: Performance management

This Course combines technical and social know-how to give you a solid framework for designing, configuring, and managing performance improvement initiatives with sustainable results. Managing Business Performance offers a unique blueprint for achieving organisational excellence through improved productivity, and efficiency.

Click “here” Download brochure Performance management. Or contact XADAT.COM.

 

performance management key performance indicators 2016

Business Management Courses 3: Business Intelligence Tools

Business Intelligence is a technology, system that provide managers to makeing desscions based on Data. End rsults ar performance dashboards, performance tools. companies with usefull visual guide to developing an effective business intelligence (BI) decision-support application. This book outlines a methodology that takes into account the complexity of developing applications in an integrated BI environment.

Business Management Courses 4: Data warehousing

This course focuses on how and why to modenize your data warehousing architecture. Also we will discuss workloads, what they mean in the world of data warehousing and Big Data. This is one of the most important and critical aspects of the future architecture of data management solution. Especially we discuss the data warehouse appliance, cloud computing, introduction of data visualization, and in-memory.

data warehousing what is data warehousing

Business Management Courses 5: Business Intelligence Strategy

business intelligence strategy-bi strategy

 

Business Management Courses 6: Business analyst

In course you will learn to be a Business Analyst. The business analyst is liaison between business stakeholders and the technical team (vendors. software developers, etc.) This course will deliver you usefull methodics, tools, tables, interview questions, checklist, templates that business analyst can use by day-to-day business .

business analyst business analyst course

 

Business Management Courses 7: Data visualization

This course will help you turn your data into high impact visual stories that stick with your audience. Epecifically, you’ll learn how to understand the importance of context and audience. Also we will focuss on determine the appropriate type of graph for your situation. Get started with direct attentions on your audience’s attention to the most important parts of your data. You will learn think like a designer and utilize concepts of design in data visualization.

 

Data visualization BI tools

Business Management Courses 8: Business Intelligence Competency Center Dashboard

  • Business Intelligence Organizations Trends
  • How Design Data driven Business Intelligence Organisation ?
  • What is Business Inteligence Competency Center?
  • Implementing Business Intelligence Competency Center Information Evolution Model
  • Change Management & BICC
    • Human Capital
    • Culture
    • Infrastucture
    • Customer Services
  • Best Practice Business Cases

Business Intelligence Competency Center Dashboard

 

Business Management Courses 9: Scrum Methdology

In this course you will learn about most popular agile methodologies today in 2016.

In this course you will understanding IT project management methodic for example: Agile, Scrum, XP, Lean, and, Kanban.

  • On time delivery of Agile projects
  • Deliver high-quality software system via Agile
  • Working in Agile teams

 

Business Management Courses 10: Mobile Analytics, Mobile App Analytics

mobile analytics
mobile app analytics

 

Business Management Courses skills

ERP, Performance management, Business Intelligence Tools, Data warehousing, Business Intelligence Strategy, Business analyst, Data visualization, Business Intelligence Competency Center, Dashboard, Scrum, Mobile Analytics, leadership, training, business ideas, communication skills, small business ideas, earn money online, dale, online courses, business administration, business management, leadership skills, small business, business development, carnegie learning online, carnegie learning, starting a business, online business, business class, training and development, business opportunities, presentation skills, business strategy, business school, business studies, management skills, business consultant, sales training, business degree, management courses, business management courses, online training, leadership training, customer service training, business coach, leadership development, business planning, business consulting, executive coaching, training courses, project management training, management training, business coaching, business courses, business opportunity, corporate training, business skills, communication skills training, business administration courses, business management course, training course, online training courses, online business courses, leadership courses, business degrees, business analyst training, hr training, training programs, train the trainer courses, train the trainer course, presentation skills training, business schools, business advice, staff training, management training programs, skills training, business course, business administration course, business education, business training, employee training, corporate trainer, business colleges, professional training, small business courses, business classes, management training courses, business courses online, change management training, leadership training programs, sales training courses, sales training programs, communication training, business leadership, business college, risk management training, manager training, training companies, corporate training companies, negotiation skills training, leadership course, business certificate, business analysis training, business study, supervisor training, business programs, leadership development training, business seminars, leadership seminars, degree in business, business universities, executive training, negotiation training, management classes, training development, business development courses, training company, business management skills, sales management training, corporate training programs, training skills, online business classes, training providers,

Business Management Courses Regio

Shanghai Pudong, China, Pakistan, Beijing, Municipality, Delhi, India. Lagos, Nigeria, Tianjin, China, Istanbul, Metropolitan, Turkey, Tokyo, Japan, Guangzhou, China, Mumbai, Moscow, Russia, São Paulo, Brazil, Shenzhen, Jakarta, Indonesia, South Korea, Kinshasa Democratic Republic, Congo, Egypt, Lahore, Badshahi, Mosque, Pakistan, Mexico, Lima, Peru, New York, United States London, UK, United Kingdom, Bengaluru, India, Bangkok, Thailand, Amsterdam

Amsterdam, Badshahi, Bangkok, Beijing, Bengaluru, Brazil, business administration, business administration course, business administration courses, business advice, business analysis training, business analyst, business analyst training, business certificate, business class, business classes, business coach, business coaching, business college, business colleges, business consultant, business consulting, business course, business courses, business courses online, business degree, business degrees, business development, business development courses, business education, business ideas, Business Intelligence Competency Center, business intelligence strategy, business intelligence tools, business leadership, business management, business management course, business management courses, business management skills, business opportunities, business opportunity, business planning, business programs, business school, business schools, business seminars, business skills, business strategy, business studies, business study, business training, business universities, carnegie learning, carnegie learning online, change management training, China, communication skills, communication skills training, communication training, Congo, corporate trainer, corporate training, corporate training companies, corporate training programs, customer service training, dale, Dashboard, Data visualization, data warehousing, degree in business, Delhi, earn money online, Egypt, employee training, ERP, executive coaching, executive training, Guangzhou, hr training, India, India. Lagos, Indonesia, Istanbul, Jakarta, Japan, Kinshasa Democratic Republic, Lahore, leadership, leadership course, leadership courses, leadership development, leadership development training, leadership seminars, leadership skills, leadership training, leadership training programs, Lima, london, management classes, management courses, management skills, management training, management training courses, management training programs, manager training, Metropolitan, Mexico, Mobile Analytics, Moscow, Mosque, Mumbai, Municipality, negotiation skills training, negotiation training, New York, Nigeria, online business, online business classes, online business courses, online courses, online training, online training courses, Pakistan, performance management, Peru, presentation skills, presentation skills training, professional training, project management training, risk management training, Russia, sales management training, sales training, sales training courses, sales training programs, São Paulo, Scrum, Shanghai Pudong, Shenzhen, skills training, small business, small business courses, small business ideas, South Korea, staff training, starting a business, supervisor training, Thailand, Tianjin, Tokyo, train the trainer course, train the trainer courses, training, training and development, training companies, training company, training course, training courses, training development, training programs, training providers, training skills, Turkey, UK, United Kingdom, United States LondonEdit

Search for:Recent Posts

  • Performance Management
  • Mobile Analytics Amsterdam London
  • Data warehousing Amsterdam London
  • Business intelligence tools Amterdam London
  • Performance management Amsterdam London

Recent Comments

Archives

  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • November 2015

Categories

  • 2016
  • agile bi methodology
  • Amsterdam
  • analytics
  • bi consultant
  • bi objects
  • bi reporting tools
  • bi sap
  • big data
  • big data etl tools
  • bobj
  • bobj business objects
  • Business Analyst
  • business analytics courses
  • Business Intelligence Analyst
  • business intelligence applications
  • Business Intelligence Competency Center
  • business intelligence consultants
  • business intelligence courses
  • business intelligence implementation plan
  • business intelligence purpose
  • business intelligence reporting
  • Business intelligence resume
  • business intelligence strategy
  • business intelligence support
  • business intelligence system
  • business intelligence system components
  • business intelligence systems
  • business intelligence systems definition
  • business intelligence team
  • business intelligence tools
  • business intelligence vision statement examples
  • business object
  • business object sap
  • business objects 4.1
  • business objects partners
  • business objects reporting
  • business objects reporting software
  • business objects reporting tutorial
  • business objects universe
  • business objects web intelligence
  • BUSINESS-OBJECTS-TUTORIAL
  • Dashboard
  • Data Analyst
  • data business intelligence
  • data etl
  • data integration tools
  • data integrator tool
  • Data visualization
  • data visualization service
  • Data warehousing
  • data warehousing tools
  • datastage etl
  • ERP
  • etl architecture
  • etl concepts
  • etl data quality
  • etl datastage
  • etl definition
  • etl developer
  • etl development
  • etl for big data
  • etl full form
  • etl job
  • etl meaning
  • etl means
  • etl process
  • etl programmer
  • etl software
  • etl sql
  • etl sql server
  • etl systems
  • etl testing
  • etl tools
  • etl tools list
  • free sap training
  • how to build a business intelligence system
  • key performance indicators
  • list of data integration tools
  • London
  • Mobile Analytics
  • performance management
  • sap
  • sap bi
  • sap bi bo
  • sap bi bw
  • sap bi certification
  • SAP BI Consultant Amsterdam
  • sap bi on hana
  • sap bi reporting tools
  • sap bi reports
  • sap bi training
  • sap bi tutorial
  • sap bi versions
  • sap bo
  • sap bo mobile
  • sap bo web intelligence
  • sap bobj
  • sap business intelligence software
  • sap business object
  • sap businessobjects
  • sap bw 7.4
  • sap bw basics
  • sap bw hana
  • sap bw on hana
  • sap bw reporting tools
  • sap bw training
  • sap bw tutorial
  • sap course
  • sap is retail
  • sap query
  • sap reporting
  • Scrum
  • sql etl
  • Uncategorized
  • use of business intelligence
  • what does etl stand for
  • What is Business Intelligence
  • What is data analysis
  • what is etl
  • what is etl testing
  • what is sap
  • what is sap bi
  • what is sap bw

Stay up-to-date on new reviews

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Where should we send the information?

Gender
(optional)
(optional)
(optional)
(optional)
infoThe provider Mr Data Business School (XADAT.NL) requires your phone number to process your information request. (optional)
(optional)
(optional)
We store your personal details, and share them with Mr Data Business School (XADAT.NL), in order to help you along via email and potentially via phone. You can find more info in our privacy policy.