Applied Technology College in San Diego

Request Info from CIAT Admissions Advisors

Talk to an Advisor

Book an appointment with one of our Admissions Advisors for personalized guidance on building your education plan.

Enrollment Deadline - March 8th, 2025

By checking this box, you agree to receive SMS messages from our organization regarding our services.

*By submitting this form, you are giving your express written consent for California Institute of Applied Technology to contact you regarding our educational programs and services using email, telephone or text – including 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 any time by calling us or responding STOP to any text message.

ASD263 — SQL and Database Management

Applied Bachelor’s Degree in Software Development

Course ID: ASD263
Course Credits: 4

About ASD263 — SQL and Database Management

This course empowers students with essential SQL skills and the ability to design and manage relational databases. Beginning with an introduction to SQL and client/server systems, the course covers data retrieval, updates, and advanced SQL skills, including working with views, scripts, stored procedures, functions, and triggers. It equips students with the knowledge and practical skills needed for effective SQL database management and efficient database design.

Topics Covered in Course

ASD263 Topics

Prepare for SQL Server tools by understanding client/server systems, relational databases, and basic SQL statements
Acquire fundamental SQL server management skills and prepare for coding SQL statements
Master SELECT statement basics

Proficiently grasp the SQL inner join technique for combining data from multiple tables
Master data grouping and summarization with SQL queries, laying the foundation for data analysis, and explore advanced analysis tools for complex tasks
Grasp the value of subqueries for problem-solving, use them thoughtfully when needed, and create views for recurring subqueries to enhance query efficiency and performance
Master the use of INSERT, UPDATE, DELETE, and MERGE statements
Learn SQL Server data types and their conversion
Learn SQL functions
Designing primary and existing databases
Create and modify databases, tables, and indexes by coding DDL statements
Create and manage database objects, including tables, keys, indexes, and constraints
Master the creation and use of views for controlled and flexible data access, providing security and simplicity in data retrieval for end users and applications
Excel at T-SQL scripting for versatility and dynamic problem-solving, and advance your skills with stored procedures, functions, and triggers for superior database control
Master SQL interaction with database objects, including stored procedures, functions, and triggers

Prerequisites

Programming experience in Python or any other programming language.

Address

401 Mile of Cars Way #100, National City, CA 91950

Phone

(877) 559-3621

Get Started

For Students

Information

GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government website at https://www.benefits.va.gov/gibill. CIAT is approved to offer VA benefits. *Financial aid is available for those who qualify. *Students are encouraged to take certification exams while actively enrolled in their Certificate or Degree program. Unlimited certification exam attempts expire 180 days after graduation. Select exams are not eligible for unlimited retakes - see certification exam policy for details. Certifications or courses may change to address industry trends or improve quality