ANC-CSS3210.AD1
CSS3210: SQL
- Practice in 42 Laboratorios prácticos — nothing to install
- 5 Lecciones interactivas y 42 topics mapped to the official exam objectives
- 103 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso
42 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
5Lecciones interactivas
42Topics
42Laboratorio en vivo
103Preguntas del examen de práctica
3Vídeos
113Tarjetas didácticas
113Glosario de términos
01 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
5 Lecciones interactivas · 42 topics01 Executing Simple Query and Performing a Conditional Search 7 topics · 6 Laboratorio en vivo +
- TOPIC A: Connect to the SQL Database
- TOPIC B: Query a Database
- TOPIC C: Save a Query
- TOPIC D: Modify and Execute a Saved Query
- TOPIC E: Search Using One or More Conditions
- TOPIC F: Search for a Range of Values and NULL Values
- TOPIC G: Search Data Based on Patterns
6 Laboratorio en vivo in this lesson — see the labs panel →
02 Working with Functions and Organizing Data 9 topics · 9 Laboratorio en vivo +
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
- TOPIC D: Sort Data
- TOPIC E: Rank Data
- TOPIC F: Group Data
- TOPIC G: Filter Grouped Data
- TOPIC H: Summarize Grouped Data
- TOPIC I: Use PIVOT and UNPIVOT Operators
9 Laboratorio en vivo in this lesson — see the labs panel →
03 Retrieving Data from Tables and Exporting Query Results 5 topics · 5 Laboratorio en vivo +
- TOPIC A: Combine the Results of Two Queries
- TOPIC B: Compare the Results of Two Queries
- TOPIC C: Retrieve Data by Joining Tables
- TOPIC D: Generate a Text File
- TOPIC E: Generate an XML File
5 Laboratorio en vivo in this lesson — see the labs panel →
04 Using Subqueries, Manipulating Table Data and Structure 13 topics · 14 Laboratorio en vivo +
- TOPIC A: Search Based on Unknown Values
- TOPIC B: Compare a Value with Unknown Values
- TOPIC C: Search Based on the Existence of Records
- TOPIC D: Generate Output Using Correlated Subqueries
- TOPIC E: Filter Grouped Data Within Subqueries
- TOPIC F: Perform Multiple-Level Subqueries
- TOPIC G: Insert Data
- TOPIC H: Modify and Delete Data
- TOPIC I: Create a Table
- TOPIC J: Create a Table with Constraints
- TOPIC K: Modify a Table's Structure
- TOPIC L: Back Up Tables
- TOPIC M: Delete Tables
14 Laboratorio en vivo in this lesson — see the labs panel →
05 Working with Views, Indexing Data, and Managing Transactions 8 topics · 8 Laboratorio en vivo +
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
- TOPIC E: Create Indexes
- TOPIC F: Drop Indexes
- TOPIC G: Create Transactions
- TOPIC H: Commit Transactions
8 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
42 Laboratorio en vivos- Connecting to a Database
- Saving a Query and Modifying and Executing the Saved Query
- Comparing Column Values in a Table
- Searching Using Simple and Multiple Conditions
- Searching for a Range of Values and NULL Values
- Retrieving Data Based on Patterns
- Performing Date Calculations
- Using Aggregate Functions
- Manipulating String Values in a Table
- Sorting Data in a Table
- Ranking Data in a Table
- Grouping Data in a Table
- Filtering Grouped Data in a Table
- Summarizing Grouped Data
- Using the PIVOT and UNPIVOT Operators
- Combining the Results of Two Queries
- Comparing the Results of Two Queries
- Retrieving Data by Joining Tables
- Saving the Query Results in CSV Format
- Generating an XML File
- Searching for Records Based on Unknown Values
- Searching for Records by Comparing Them with Unknown Values
- Searching for Records Based on Their Existence in Another Table
- Generating Output Using Correlated Subqueries
- Filtering Grouped Data Within a Subquery
- Generating Output Using Nested Subqueries
- Inserting, Modifying, and Deleting Data
- Creating a Table
- Creating a Table with Constraints
- Adding and Dropping Columns in a Table
- Adding and Dropping Constraints in a Table
- Modifying the Column Definition in a Table
- Backing Up a Table
- Deleting a Table
- Creating Views
- Creating Views with Schema Binding
- Manipulating Data in Views
- Creating Aliases
- Modifying and Deleting Views
- Creating Indexes
- Dropping Indexes
- Creating and Comitting Transactions
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
Keep going
You might also like
Prepárate para CSS3210: SQL
Pago único. Acceso completo durante 1 año. Comienza con una prueba gratuita si primero quieres echar un vistazo.
- 1 año de acceso completo
- 42 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito