Database Applications Developer

This is a beginning course intended for students who plan to take additional computer science courses. The course covers an introduction to programming concepts such as designing, coding and testing. Other concepts such as computer hardware, operating systems, compilers and databases are also discussed. The Internet and an introduction to cybersecurity and cloud computing are also included.

should be taken in the intersession PRIOR to semester 1

This introductory course covers basic programming constructs and techniques using VB.Net. Students will learn how to plan, create and debug code based on Object Oriented Programming design and analysis techniques. Topics covered include Data Types, Variables, Decision Statements, Loops, Arrays Input/Output, and basics of Object Oriented Programming using Classes and Objects.

MATH 18, 20, or higher level recommended

See the full list: SMC GE Area IV-B Course

This introductory course in rhetoric emphasizes clear, effective written communication and preparation of the research paper.

This course covers the basic technologies used to program Web-based applications. Topics include: HTML5, Cascading Style Sheets (CSS), XML and JavaScript, along with a basic survey of the latest extensions on JS.

This course introduces the Python programming language. Students will learn how to write programs dealing in a wide range of application domains. Topics covered include the language syntax, IDE, control flow, strings, I/O, classes and regular expressions. Students may use either a PC (Windows) or a Mac (Linux) to complete their programming assignments.

This course introduces modern database concepts while emphasizing the relational database model. Topics include design methodologies, normalization of tables to reduce redundancies, supertypes and subtypes to reduce nulls, data integrity, referential integrity, and using locks and other techniques for concurrency control in a multi-user database. Factors that should be balanced during the design of a database are described. To document databases, entity relationship diagrams, relational schemas, and data dictionaries are described. Principles are applied by performing exercises using MySQL or other database management system. SQL and other languages are used to create and fill tables, retrieve data, and manipulate it by stored programs.

This course introduces cloud computing which shifts information systems from on-premises computing infrastructure to highly scalable internet architectures. The course provides a solid foundation of cloud computing technologies and provides students with the understanding required to effectively evaluate and assess the business and technical benefits of cloud computing and cloud applications. Students analyze a variety of cloud services (storage, servers and software applications) and cloud providers. Case studies will be used to examine various industry cloud practices and applications. The course also surveys cloud careers and discusses industry demand for cloud skills.

This course provides an exploration of intellectual, psychological, social and physical factors that impact lifelong learning, well-being and success. Topics include motivation and self-efficacy; critical thinking, academic integrity and active study strategies; health issues and lifestyle choices; relating to others as a global citizen; written and oral communication; time management; career exploration; and educational planning.

ENGL 2 recommended for transfer options

See the full list: SMC GE Area III Course

CS 79B or 79Y recommended

See the full list: Required Elective Course from "Program Electives" list below

CS 19, 83R or 85 recommended

See the full list: Required Elective Course from "Program Electives" list below

This course covers the fundamentals of Project Management theory, implementation, and best practices. It is aimed at students who work mostly in the Technology sectors covering software and website development, and other areas of computer science or information systems. Students will learn the theory, as well as the use of Project Management software to plan, track and manage project resources. Topics covered include project life cycles, tasks, schedules, resources, and costs.

This course covers advanced programming techniques using Visual Basic .NET. Topics include Structures, Classes, Events, Inheritance, and Polymorphism, Overloading, Dynamic Binding, Multiple Document Interface, Windows API, Collections, and Exception Handling. Students also learn how to interface to Databases and build Web forms.

VB.Net is an object-oriented programming language that is part of the .Net Microsoft suite. It provides a graphical programming environment used to create applications for Microsoft Windows and the Web. This course covers advanced concepts for VB .NET that relate to interfaces to databases. Topics include Object Oriented Programming, database interfaces programming, SQL query language, using LINQ and EM, and applying security measures in connections.

C # (read as C-Sharp) is a modern object-oriented language that enables programmers to quickly build solutions for the Microsoft.NET platform. In this class, programmers will learn to build C# components for use by Web and Windows-based applications. Students will generate MSIL (Microsoft Intermediate Language) code and PE (Portable Executable) files that utilize the services of the CLR (Common Language Runtime) which are all part of the Microsoft.NET platform.

VB.Net is an object-oriented programming language that is part of the .Net Microsoft suite. This course covers Web application development, including the use of ASP and VB .NET. Topics include ASP .NET, Web forms and controls, Web data access, state management, Web services, using AJAX and security measures implementation.

Microsoft SQL Server is a popular midrange relational database management system (DBMS) that is used in client/server systems and as a personal DBMS. It can be accessed through the Internet. Topics covered in this course include installing the software, principles of relational databases; creating databases, tables, indexes, and views; inserting, deleting, and updating raw data; updating transactions; and querying the database. With the Transact-SQL extensions, topics include creating functions, procedures, and triggers stored in the database.

This course is a practical, hands-on overview of the Oracle Database Management System to store, retrieve, and manipulate data. Oracle is a widely used database that runs on PC¿s, minicomputers, and mainframes, and Oracle programmers and developers are very much in demand. Oracle's SQL is used to create and alter tables with various constraints. Data is retrieved and manipulated by using SELECTS that can group data and retrieve data from several tables by joining them or by using set operations. Views are created. PL/SQL, with its variables, symbolic constants, IF statements, and loops is used to program stored functions, stored procedures, and triggers. Cursors and error handling (exceptions) are introduced.

In this introductory course students will learn how to defend and protect critical computer assets from various security threats including computer worms and viruses. This course will describe fundamental techniques and principles for modeling and analyzing security. Students will learn how to express security requirements, translate requirements into policies, implement mechanisms that enforce policy, and ensure that these policies are effective. Current industry best practices for safeguarding computer resources will be discussed. Various case studies will outline the typical way that security failures get exploited by attackers and how these attacks can be discovered, understood, and countered.

This course addresses cloud database management which supports a number of different approaches for storing data. In the course, students define, operate and scale both SQL and noSQL data storage solutions. This course considers factors that should be balanced during the design of a storage solution. Principles are applied by performing exercises using Amazon RDS and SQL to create and fill tables, retrieve and manipulate data. Object-based APIs are used to serialize objects to Amazon DynamoDB for noSQL solutions. Topics include automated backups, transaction logs, restoration and retention.

In this course, students will learn to deploy relational and non-relational databases in Azure. Students will define, operate and scale both SQL and noSQL data storage solutions. Principles are applied by performing exercises using the Azure SQL Database service as well as Azure Storage Explorer. Students will store, manage and analyze data in all the different storage options offered in Azure including blob storage, file storage, table storage, queue storage, Cognos DB and Azure Data Lakes.

This course teaches how to design and write applications utilizing Ruby on Rails, an open-source web application framework based on the Ruby programming language. In this course, students will create applications that gather information from a web server, query databases and render results.

This course teaches how to design and write applications that extend Web servers. These applications process data submitted from Web forms and access back-end databases to dynamically generate Web pages. This course covers the PHP server-side technology. PHP, which stands for "PHP: Hypertext Preprocessor" is a widely-used, Open Source, general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.