Database Design & Programming w/SQL (CSC 2470)

Term: 2019 Spring Semester

Faculty

Scott T SebaughShow MyInfo popup for Scott T Sebaugh

Email address is hidden, click here to email

Mineral Area Community College :
Computer Science instructor

➢ Object Orient Programming Logic/Design
➢ C++, Python, JavaScript, C#
➢ CompTIA A+, CompTIA Linux
➢ Robotics (FRC 2019) STEM Mentor
➢ Cyber Security, Network Security+

Office - AS 17

• Office Hours: Mon - Fri
  
  • 10am - 11am 
  • 2pm to 3pm
  • or by appointment

 

Schedule

Tue-Thu, 9:30 AM - 10:45 AM (1/14/2019 - 5/18/2019) Location: MAIN TC T103

Description

Prerequisites: CIS2100 or higher with a minimum grade of C and one of the following:(1) a minimum score of 18 on the ACT reading, or 250 on the Accuplacer Next Generation reading, or (2) a minimum ACT reading score of 16, or Accuplacer Next Generation reading score of 240, AND a 3.5 cumulative high school grade point average or (3) or a minimum grade of C in RDG0900, ENG0990, or ENG0090, or (4) concurrent enrollment in RDG 0900, or (5) have earned 24 college-level semester credit hours.
Learn the concepts and terms needed for working with any database. Introduces Microsoft SQL Server 2016 and the Management Studio. Develop skills in running SQL statements to design a database and implement that design by using either SQL statements or the Management Studio. Develop skills for working with database features like views, scripts, stored procedures, functions, triggers, cursors, and transactions. Examine the management of database security and features for working with XML and BLOB data.