DAP 300A- Python for Data Analysis Part 1

Applied Bachelor’s Degree in Software Development

Course ID

DAP 300A

Course Credits

4

About DAP 300A- Python for Data Analysis Part 1

Data Science with Python – Part 1 is designed to introduce students to the fundamental concepts and tools of data science using Python, a powerful and versatile programming language. This course covers the essential techniques for data analysis and visualization, focusing on practical applications and hands-on experience.

Topics Covered In Course

DAP 300A Topics

  • Use various types of joins to retrieve data from multiple tables; use operators IN, EXISTS, ALL, ANY 
  • Create new tables from existing tables 
  • Maintain table by changing and saving data, utilizing UPDATE, INSERT, DELETE, COMMIT, ROLLBACK and DROP TABLE 
  • Create and use views for data update 
  • Define the security context of a database and its users in MS SQL Server; Manage database users and their privileges 
  • Create, use and drop index 
  • Use integrity constraints to control data entry 
  • Understand benefits of using SQL in programming environment 

Prerequisites

Students must have experience using a keyboard and mouse in a GUI-based OS such as Microsoft Windows or Macintosh and understand how to download and install programs found on the Internet. 

Meet The Faculty

Our expert, certified faculty members come with years of industry experience and are passionate about helping students build and advance their tech careers.
Meet The Faculty

Talk to an Advisor

Request an appointment with one of our IT expert Admissions Advisors for personalized guidance on building your education plan. You’ll be able to book an appointment instantly for a time that fits your schedule. 

Enrollment Deadline - September 23, 2024!

Request Transfer Support

  • Hidden

*By submitting this form, you are giving your express written consent for California Institute of Arts & Technology to contact you regarding our educational programs and services using email, telephone or text – including our use of automated technology for calls and periodic texts to any wireless number you provide. Message and data rates may apply. This consent is not required to purchase goods or services and you may always call us directly at 877-559-3621. You can opt-out at any time by calling us or responding STOP to any text message.