SQL

SQL

SQL is a programming language used to manage data in relational databases. It allows users to access multiple records with one command and eliminates the need to specify how to reach a record. It includes sublanguages for data query, manipulation, definition, and control, and was one of the first commercial languages to use the relational model.

6 courses cover this concept

15-415/615 Database Applications

Carnegie Mellon University

Fall 2016

This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.

No concepts data

+ 20 more concepts

CS 145 Data Management and Data Systems

Stanford University

Fall 2022

This course primarily focuses on the utilization of databases in applications, scaling for large datasets, and effective data systems design. It explores relational data models, SQL, and schema design, concluding with a hands-on SQL+Python project. The course requires CS 103 and CS 107 or equivalent as prerequisites.

No concepts data

+ 17 more concepts

CS 186 Introduction to Database Systems

UC Berkeley

Spring 2023

This project-heavy course covers access methods, data models, query languages, database services, and interfaces. It introduces transaction processing and requires CS 61A, CS 61B, and CS 61C as prerequisites/corequisites. It suggests proficiency in Java for project work.

No concepts data

+ 23 more concepts

CS 61A: Structure and Interpretation of Computer Programs

UC Berkeley

Fall 2022

A course that emphasizes software abstraction, equipping students with the skills to manage program complexity. Students will primarily use Python, with additional exposure to Scheme and SQL.

No concepts data

+ 32 more concepts

CS 88: Computational Structures in Data Science

UC Berkeley

Fall 2022

This course provides an introduction to computer science with an emphasis on functional programming, data abstraction, object-oriented programming, and program complexity. The course teaches foundational programming concepts primarily in Python.

No concepts data

+ 24 more concepts

CSE 154 Web Programming

University of Washington

Summer 2022

This course introduces the fundamental concepts of web programming and technologies required for web development. It covers the full spectrum of web development, from HTML, CSS, JavaScript to server-side technologies like Node.js, databases, and SQL.

No concepts data

+ 37 more concepts