The course will explore the relational database model with emphasis on the design and querying of relational databases. The course will improve student skills in programming, modeling the structure of data and administering databases.
The course will explore the relational database model with emphasis on the design and querying of relational databases. The course will improve student skills in programming, modeling the structure of data and administering databases.
Focus is placed on the 3 subsets of Structured Query Language (SQL): Data Control Language (DCL), Data Definition Language (DDL), and Data Manipulation Language (DML).
Students will learn to create and modify database tables, manipulate data, perform complex join queries, create triggers and stored procedures, enforce referential integrity constraints, control user permissions and concurrent access.
Welcome to CSI! Computer Systems Institute (CSI) is a dynamic institution providing career-focused high-quality programs designed to enhance job opportunities for our graduates and provide a skilled workforce for the community.
We strive to achieve this by employing qualified and enthusiastic professionals who create a stimulating learning environment and deliver effective career development services.
Founded in 1989 with the goal of bridging the gap between employers and a shortage in IT professionals by providing training to students and connecting them with employers.
Today, CSI is much more: It has grown, student services continue to develop and the opportunities available to students are greater than ever. CSI offers a diverse range of courses, including business, hospitality, customer service, computer science, and healthcare.
CSI has six campuses across Illinois and Massachusetts (Allston, Charlestown, Worcester, Chicago, Lombard, and Skokie).
Through new partnerships with local colleges, employers and organizations CSI continues to grow and expand its opportunities for students. CSI’s focus on helping students gain the academic skills, knowledge, and support they need to reach their personal and professional goals is stronger than ever.
CSI Vision:
To build a community where transformative experiences help each student reach their full potential.
CSI Mission:
We empower students to realize their career and academic goals by providing industry-relevant education through:
Career-focused academic programs
Practical application of learned content
Student-centered services and activities
Comprehensive career services
Learn about databases, querying, end user querying, relational models, SQL basics, operators, functions, summarizing data, grouping data, using joins, subqueries, set operations, inserting and deleting rows, dropping tables, indexes, creating views.
Learn the basics of organizing and querying data with SQL. This class provides an introduction to relational databases and how to sort, filter, group, and summarize data.
Students gain skills necessary for design, development, maintenance, management and administration of comprehensive relational databases for corporations and organizations.
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum
This course covers database fundamentals and how to create databases. Structured Query Language (SQL) is a programming language used for databases.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy