CPD Computer Programming/Data (CPD)

This course introduces database concepts and describes how to properly design, create and interface with a relational database. The course begins with definition of important terms. It demonstrates the specific rules that one must follow to design and create a normalized relational database. SQL is also an important topic. Students complete a collection of hands-on labs to learn how to apply the techniques presented.

This course introduces database technology, relational database concepts, and the powerful SQL programming language. This course provides the students with the essential SQL skills of querying the database and the metadata along with creating database objects. Demonstrations and hands-on practice reinforce the concepts. Upon completion, the student should have the confidence and skill to develop, maintain, and utilize SQL scripts and code.

In this course students will gain the knowledge and skills to design server-side solutions for Microsoft SQL Server. The course focuses on teaching students the skills of database developers who are individuals who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.