Fayetteville Technical Community College · Courses
DBA
15 courses with the subject DBA, each shown exactly as we captured it from the college's catalog, with every element we hold. Where the wording looks broken, that is our reading of the catalog, not the college's text.
DBA 112Database Utilization 2 2 0 3 Database structures on business environments
Component: Prerequisites: None This course introduces basic database functions and uses. Emphasis is Corequisites: None placed on database manipulation with queries, reports, forms, and some Component: table creation. Upon completion, students should be able to enter and This course covers database administration issues and distributed manipulate data from the end user mode. database concepts. Topics include database administrator (DBA) goals and functions, backup and recovery, standards and procedures, training,
DBA 115Database Applications 2 2 0 3 and database security and performance evaluations. Upon completion
Component: This course applies concepts learned in DBA 110 to a specific DBMS. DBA 218 Google Data Analytics II 2 3 0 3 Topics include manipulating multiple tables, advanced queries, screens Prerequisites: None and reports, linking, and command files. Upon completion, students Corequisites: Take DBA-118 should be able to create multiple table systems that demonstrate updates, Component: screens, and reports representative of industry requirements. This course introduces the role of an advanced Google data analyst and how to make data-driven decisions using effective questions, data
Take DBA-110 students should be able to produce functional DBA documentation and
Corequisite
None administer a database.
DBA 118Google Data Analytics I 1 6 0 3 transformation, analyzation processes, visualization and programming
expertise. Upon completion, students should be able to create a data- Component: driven storyboard, develop dashboards and presentations, create This course introduces the role of a Google data analyst and how to make analytical reports using R, and showcase technical analytical skills. data-driven decisions using effective questions, data transformation and analyzation processes. Emphasis is placed on setting up a data toolbox,
None Emphasis is placed on setting up a design thinking, data-driven
Corequisite
None storytelling, dashboards, R programming, job portfolios and technical
DBA 120Topics include application development with GUI front-ends
and embedded programming. Upon completion, students should be DBA 125 Database Reporting 2 2 0 3 able to develop a SQL Server DBMS application which includes a GUI front-end and report generation. Component:
spreadsheets, database and query basics, visualization basics, effective communication techniques, and data validation. Upon completion, students should be able to review assessments, use formulas and Component: None caulcuations to analyze datasets, create queries, use visualization tools This course is designed to enhance programming skills developed in and communicate effectively with stakeholders.
This course is designed to develop SQL programming proficiency. Emphasis is placed on data definition, data manipulation, and data control statements as well as on report generation. Upon completion, Component: students should be able to write programs which create, update, and This course is designed to enhance programming skills developed in produce reports.
This course provides a survey of the tools used in designing, creating and publishing database reports. Topics include both relational and XML datasets. Upon completion, students should be able to demonstrate an Component: understanding of the different tools and frameworks used for database This course is designed to enhance programming skills developed in reporting. DBA 120. Topics include application development with GUI front-ends and embedded programming. Upon completion, students should be able
Component: systems project with minimal instructor support. Emphasis is placed on This course examines advanced Oracle database administration issues written and verbal communication skills, documentation, presentation, and distributed database concepts. Topics include backup and recovery, and user training. Upon completion, students should be able to present transporting of data between databases, database networking concepts, an operational database system which they have created. and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement DEA 111 Introduction to DEAT 2 2 0 3 networked database solutions. Prerequisites: None
Component: Topics covered include digitizing existing images, creating digital This course examines advanced SQL Server database administration images, manipulation of images and various forms of computer issues and distributed database concepts. Topics include backup and animation. Upon completion, students should be able to demonstrate a recovery, transporting of data between databases, database networking vocabulary of the digital effects and animation field and a knowledge of concepts, and resolution of database networking issues. Upon ourstanding examples of work in the field. completion, students should be able to manage backup recovery and implement networked database solutions. DEA 112 2D Design and Animation I 2 3 0 3
Component: animations for use in video, film or web applications. Topics include This course covers Oracle performance tuning concepts and techniques. multilayering, color correction, alpha channel creation, masking, and Topics include database tuning and Oracle performance tools. Upon keyframing. Upon completion, students should be able to demonstrate completion, students should be able to configure and diagnose an Oracle basic knowledge of 2D animation and add simple special effects and database for optimal performance. flying text to video, film or web applications. DBA 271 SQL Server Perf Tuning 2 2 0 3 DEA 212 2D Design & Animation II 2 3 0 3 Component: Component: This course covers SQL Server performance tuning concepts and This course covers relatively complex applications of 2D design and techniques. Topics include database tuning and SQL Server performance animation for use in video, film or web applications. Topics will include tools. Upon completion, students should be able to configure and designing animation that is true to the physics of movement, realism diagnose an SQL Server database for optimal performance. in the movements of animals and people, and combining elements of Refer to the FTCC website for the most current information. Go to www.faytechcc.edu/current-students/ and scroll down to Academic.
DBA 240 Database Analysis/Design 2 3 0 3 Prerequisites: None Component: This course introduces data warehousing and data mining techniques. This course is an exploration of the established and evolving Emphasis is placed on data warehouse design, data transference, methodologies for the analysis, design, and development of a database data cleansing, retrieval algorithms, and mining techniques. Upon system. Emphasis is placed on business data characteristics and usage, completion, students should be able to create, populate, and mine a data managing database projects, prototyping and modeling, and CASE warehouse. tools. Upon completion, students should be able to analyze, develop, and validate a database implementation plan. DBA 289 Database Project 1 4 0 3
