Databases: Advanced Topics in SQL offered by Stanford University
- Private University
8180 acre campus- Estd. 1885
Databases: Advanced Topics in SQL at Stanford University Overview
Databases: Advanced Topics in SQL
at Stanford University
Learn about indexing techniques, query tuning best practices, and leveraging database features like partitioning for larger datasets
Mode of learning | Online |
Official Website | Go to Website  |
Course Level | UG Certificate |
Databases: Advanced Topics in SQL at Stanford University Highlights
Databases: Advanced Topics in SQL
at Stanford University
- Earn a certificate from Stanford University
- Learn from industry experts
Databases: Advanced Topics in SQL at Stanford University Course details
Databases: Advanced Topics in SQL
at Stanford University
Who should do this course?
- For individuals who want to enhance their knowledge & skills in the field
What are the course deliverables?
- Craft nested queries to retrieve results based on conditions from multiple tables
- Utilize diverse join types (INNER, OUTER, LEFT, RIGHT, FULL) to efficiently combine data from multiple tables
- Apply functions like RANK, LAG, LEAD, and MOVING AVERAGE to analyze data within partitions or sequences
- Improve code readability and modularity by defining temporary named result sets within queries
- Understand the ACID properties (Atomicity, Consistency, Isolation, Durability) and manage transactions using COMMIT, ROLLBACK, and SAVEPOINT
More about this course
- This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011
- This course is broad and practical, covering indexes, transactions, constraints, triggers, views, and authorization, all in the context of relational database systems and the SQL language
- This course builds on concepts introduced in Databases: Relational Databases and SQL and is recommended for learners seeking to advance their understanding and use of relational databases
Databases: Advanced Topics in SQL at Stanford University Curriculum
Databases: Advanced Topics in SQL
at Stanford University
Database Design
Relational Databases
Referential Integrity
Data Abstraction
Persistence
Reliability
Concurrency Controls
Query Languages
Authorization (Computing)
Database Systems
SQL (Programming Language)
Scalability
Databases: Advanced Topics in SQL at Stanford University Entry Requirements
Databases: Advanced Topics in SQL
at Stanford University
Eligibility criteria
- Education: Graduate
Conditional Offer
- Not mentioned
Other courses offered by Stanford University
Study in USAUniversities in USAUniversities in StanfordStanford UniversityDatabases: Advanced Topics in SQLDatabases: Advanced Topics in SQL at Stanford University Popular & recent articles
Databases: Advanced Topics in SQL
at Stanford University
View more articles
Databases: Advanced Topics in SQL at Stanford University Contact Information
Databases: Advanced Topics in SQL
at Stanford University