CS 3743 Database Management Larry Clark My webpage

CS 3743 Database Management Larry Clark My webpage: www. cs. utsa. edu/~clark Fall 2018

Computer Science Main Lab • Location: NPB 2. 118 • It has about 40 Linux workstations running 14. 04 • On the left side, it also has about 40 VDI workstations. • For more information, see www. cs. utsa. edu/~clark/mainlab. htm • Your degree will probably be more enjoyable if you spend time in the Computer Science Main Lab.

VDI Servers • You can access our Virtual Desktop Infrastructure (VDI) servers from most browsers. • Link: https: //vdi. cs. utsa. edu • Your VDI login: abc 123 id • Your initial password: get. From. Instructor(lowercase, no spaces) • If you added the class since Friday, you probably don’t have a login id. If you don’t have a working login id, send me an email with your abc 123 id.

Servers for your programs • These are necessary for many of your programs in this class. • (First two programs use C and the last one uses Java. ) • At least one of the servers should be up at all times. • These run Ubuntu Linux 14. 04 • Server addresses are get. From. Instructor • Your login id is your abc 123 ID. • Your password is defaulted to your banner ID without the @ • You can get to these externally using: ssh –X get. From. Instructor. cs. utsa. edu

Attendance via i. Clicker • Attendance is required. • We will be using i. Clicker for attendance. I am still learning how to use the tools. • You will need to get the i. Clicker Smart Phone App.

syllabus

Data-Related Jobs Business Intelligence Dev. $50 -100 k ETL Software Engineer $60 -110 k Database Administrator (DBA) $70 -125 k Data Scientist $90 -150 k Data Architect $90 -170 k • Develops routine and ad hoc reports • Develops Extract, Load, and Transform programs • Cleans data • Defines job sequences • Models the data based on business requirements • Defines the physical tables and indexes considering performance • Tunes the databases • Analyzes raw data using statistical techniques • Uses data mining techniques to find patterns • Influences business direction • Defines the blueprint of how to integrate applications, data, and hardware • Determines how to distribute the data to optimize performance

Email from Spring 2018 CS 3743 Student Good evening Professor Clark, I just wanted to reach out via e-mail because you told us to let you know if this class had an value. Last week I had an interview with <major DBMS vendor> and many of the technical questions were in regards to SQL. They asked me a lot of questions on relational databases and normalization, and writing queries. My final interview was this week, and they called me this morning with an offer! I just thought you should know your hard work and all your help definitely doesn't go unnoticed, and I can credit my success in this interview to your teachings. I hope this brightened your day! Thank you, <spring 2018 CS 3743 student>

Your Grader: ? ? ? Email: His CS Lab Hours: ? ? ?

Plan Ahead When Graduating Begin Interviewing for Summer Internships Begin Interviewing for Full-time Jobs Begin Practicing in Mock Interviews Fall 2019 n/a Spring 2019 Now! Spring 2020 n/a Fall 2019 Now! Fall 2020 Fall 2019 for Summer 2020 Spring 2020 Now! Spring 2021 Fall 2019 for Summer 2020 Fall 2020 Now! Fall 2021 Fall 2020 for Summer 2021 Spring 2021 NLT Fall 2019 Spring 2022 Fall 2020 for Summer 2021 Fall 2021 NLT Spring 2020 Fall 2022 Fall 2021 for Summer 2022 Spring 2022 NLT Fall 2020

Computer Science Career Development Fall 2019 Session #0: Resume Writing Tips (online) Online at www. cs. utsa. edu/~clark (scroll down to Career Development) > Resume Writing Tips: resume. Writing. pptx Session #1: Resume Review Fri Sep 6 th, 3 -430 pm, NPB 1. 226 > Please bring your resume for review by employers, Career Center personnel, and me Session #2 & #3: Mock Interviews Session 2: Fri Sep 13 th, 1 -230 pm in Travis Room – HEB Stu Union 2. 202 (see below for a map) Session 3: Fri Sep 13 th, 3 -430 pm in Travis Room – HEB Stu Union 2. 202 (see below for a map) > Register through handshake(utsa. joinhandshake. com) > Please only sign up for one of the two sessions of Fri Sep 13 th > As groups of 4 -6 students, you will answer sample interview questions and receive feedback > Sample interview questions: Sample. Interview. Questions. htm > Network with possible employers Career Fair STEM Career Fair Tue Feb 19 th , 8: 30 -11: 30 am > Usually 50+ employers looking for CS students > Wear business attire > Bring your resume > Check out the UTSA Career Fair App