Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Study Materials - Data Engineer - Autumn 2023

    Uploaded by

    moisei.maryana
    The document provides study materials for a Data Engineer internship, including links to learning resources about data modeling, SQL, database administration, cloud concepts, database replication on cloud services like AWS RDS, Kafka, Bash scripting, data migration, and an English level test. The role of a Data Engineer is described as being responsible for data availability, storage, security, and transformation through setting up routines, processes, and services to keep data accessible and integrated. A solid understanding of databases, cloud services, and programming is important for the role.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Study Materials - Data Engineer - Autumn 2023

    Uploaded by

    moisei.maryana
    37 views2 pages
    The document provides study materials for a Data Engineer internship, including links to learning resources about data modeling, SQL, database administration, cloud concepts, database replication on cloud services like AWS RDS, Kafka, Bash scripting, data migration, and an English level test. The role of a Data Engineer is described as being responsible for data availability, storage, security, and transformation through setting up routines, processes, and services to keep data accessible and integrated. A solid understanding of databases, cloud services, and programming is important for the role.

    Original Description:

    gg

    Original Title

    Study Materials - Data Engineer_Autumn 2023

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides study materials for a Data Engineer internship, including links to learning resources about data modeling, SQL, database administration, cloud concepts, database replication on cloud services like AWS RDS, Kafka, Bash scripting, data migration, and an English level test. The role of a Data Engineer is described as being responsible for data availability, storage, security, and transformation through setting up routines, processes, and services to keep data accessible and integrated. A solid understanding of databases, cloud services, and programming is important for the role.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    37 views2 pages

    Study Materials - Data Engineer - Autumn 2023

    Uploaded by

    moisei.maryana
    The document provides study materials for a Data Engineer internship, including links to learning resources about data modeling, SQL, database administration, cloud concepts, database replication on cloud services like AWS RDS, Kafka, Bash scripting, data migration, and an English level test. The role of a Data Engineer is described as being responsible for data availability, storage, security, and transformation through setting up routines, processes, and services to keep data accessible and integrated. A solid understanding of databases, cloud services, and programming is important for the role.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Public

    ENDAVA INTERNSHIP PROGRAMME | AUTUMN 2023


    STUDY MATERIALS FOR DATA ENGINEER

    A Data Engineer/DataOps is the person responsible for data availability and storing, database
    management, security, and data transformation. This role is supposed to set up routines/processes and
    services that allow data to remain highly available and accessible for demanding consumers. It also
    comprises data integrity control, replication, secure data exposure, performance tuning, maintenance,
    viable backup procedures, planning, etc. And for ideal recipes some continuous troubleshooting,
    automation, and innovation are essential. So, Data Engineer/DataOps is an interesting, challenging,
    and demanding role in the market and is a role of your choice.
    To be better equipped for the qualifying test and interview, we encourage you to examine the
    studying materials, recommended for Data Engineering internship:

    • Data Modeling / DBMS:


    https://www.guru99.com/data-modeling-interview-questions-answers.html
    https://www.guru99.com/dbms-tutorial.html
    https://www.guru99.com/data-modelling-conceptual-logical.html

    • SQL / T-SQL / PL-SQL:


    https://www.guru99.com/sql.html
    https://www.guru99.com/ms-sql-server-tutorial.html
    https://www.guru99.com/sql-vs-pl-sql.html

    • DB administration:
    https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/introduction-to-
    oracle-database.html#GUID-CF765A7D-9429-4901-BF33-36E0B0220293
    https://dotnettutorials.net/course/oracle-dba-tutorials/

    • Cloud concepts:
    https://docs.microsoft.com/en-us/learn/paths/azure-fundamentals/
    https://aws.amazon.com/getting-started/

    • Cloud DB RDS:
    https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html
    https://www.techtarget.com/searchaws/definition/Amazon-Relational-Database-Service-
    RDS
    https://www.javatpoint.com/amazon-relational-database-service

    ENDAVA INTERNSHIP PROGRAMME | AUTUMN 2023


    1
    Public

    • DB Replication:
    https://www.arcion.io/learn/database-
    replication#:~:text=Database%20replication%20is%20the%20process,are%20using%20t
    o%20access%20it.
    https://www.striim.com/blog/a-guide-to-modern-database-replication/

    • Kafka essentials:
    https://kafka.apache.org/quickstart
    https://www.javatpoint.com/apache-kafka
    https://developer.confluent.io/what-is-apache-kafka/

    • Bash scripting fundamentals:


    https://www.freecodecamp.org/news/bash-scripting-tutorial-linux-shell-script-and-
    command-line-for-beginners/
    https://linuxconfig.org/bash-scripting-tutorial
    https://ryanstutorials.net/bash-scripting-tutorial/

    Data migration essentials:


    What is Data Migration? | Microsoft Azure
    Cloud Data Migration on AWS | Amazon Web Services

    • Test your English:


    https://learnenglish.britishcouncil.org/online-english-level-test

    ENDAVA INTERNSHIP PROGRAMME | AUTUMN 2023


    2

    You might also like