Free online courseProgramming Databases

Conteúdo do Curso

• Video class: RDBMS and Setup [1 of 7] | Programming Databases with T-SQL for Beginners

  0h12m

• Exercise: What is the purpose of database normalization?

• Video class: Introduction to Transact-SQL [2 of 7] | Programming Databases with T-SQL for Beginners

  0h11m

• Exercise: What is a key concept in relational databases that is not directly related to spreadsheets?

• Video class: Sort and Filter Results in Transact-SQL [3 of 7] | Programming Databases with T-SQL for Beginners

  0h13m

• Exercise: How can data be sorted in a SQL query to display names alphabetically?

• Video class: Combining multiple tables with JOINS in Transact-SQL [4 of 7] | Databases with T-SQL for Beginners

  0h08m

• Exercise: What SQL operation allows combining rows from two tables based on a common field?

• Video class: Write Subqueries in Transact-SQL [5 of 7] | Programming Databases with T-SQL for Beginners

  0h04m

• Exercise: What is a subquery in Transact-SQL?

• Video class: Use Functions and GROUP BY in Transact-SQL [6 of 7] | Programming Databases with T-SQL for Beginners

  0h10m

• Exercise: Which SQL function is used to extract the year from a date value?

• Video class: Modify Data with Transact-SQL [7 of 7] | Programming Databases with T-SQL for Beginners

  0h13m

• Exercise: What is the purpose of the keyword 'IDENTITY' in SQL table creation?