with SQL Server
The most direct path to mastering the SQL skills you'll actually use on the job
Lo que serás capaz de hacer
If you spend a lot of time extracting, transforming, or analyzing data from databases, - or you're aiming for one of the many highly paid career paths that rely heavily on this skill - then this course is for you. Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst , but also provides a strong foundation for even more exotic roles like that of a Data Scientist . Experienced Data Scientists will tell you that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well. In this course, I have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming. Instead, I carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional. This enabled me to condense a complete course on SQL into just 36 instructional videos, averaging less than 10 minutes in length. So if you can commit to a video a day, in just over one month you’ll have added an extremely valuable and lucrative skill to your arsenal (and just as importantly, your resume!). And to make sure all that knowledge sticks, I’ve included exercises... LOTS of exercises . Unlike most courses, which only feature sporadic opportunities to practice what you’ve learned, this course has practice problems after almost every video - so you can reinforce concepts right away. Take it from someone who has built their career almost entirely on self-taught technical skills: it’s worth the effort. Several recent surveys have shown that SQL is actually the MOST in-demand tech skill sought after by recruiters ! In short, learning SQL can change your life, if you put in the work Let me be your guide to this next step in your career - I think you’ll find the journey a lot less daunting, and maybe even a little more fun, than you would have ever expected.
- Use SQL to apply complex criteria and transformations to database data
- Master SQL functions for sophisticated data manipulation
- Leverage an understanding of relational database design to link together data stored across multiple tables
- Use aggregate queries to produce summarized views and analysis
- Be comfortable putting SQL and SQL Server on your resume
- Gain experience with the kind of SQL coding problems you are likely to encounter in an interview
Temario
UNIDAD 1 - Getting Started: SQL Basics · 17 leccionesUNIDAD 1 - Getting Started: SQL Basics
UNIDAD 1 - Getting Started: SQL Basics
- Introduction
- IMPORTANT: PLEASE READ
- A Note to Windows 11 Users...
- Installing SQL Server 2019 Express
- Installing SQL Server Management Studio
- Downloading the AdventureWorks Sample Database
- Database-ics
- Saving and Opening Files
- Introduction to SQL
- Introduction to SQL - Exercises
- Aliasing Columns
- Aliasing Columns - Exercises
- Selecting Custom Values
- Selecting Custom Values - Exercises
- Exporting Data From SSMS
- SQL Tips and Tricks
- SQL Tips and Tricks - Exercises
UNIDAD 2 - Filtering and Sorting Your Data · 16 leccionesUNIDAD 2 - Filtering and Sorting Your Data
UNIDAD 2 - Filtering and Sorting Your Data
- Applying Criteria With WHERE
- Applying Criteria With WHERE - Exercises
- Inequalities and NULLs
- Inequalities and NULLs - Exercises
- Multiple Criteria With AND, OR, and IN
- Multiple Criteria With AND, OR, and IN - Exercises
- Combining AND and OR
- Combining AND and OR - Exercises
- Selecting Numerical Values By Range
- Selecting Numerical Values By Range - Exercises
- Matching Text Patterns With Wildcards
- Matching Text Patterns With Wildcards - Exercises
- Sorting Data With ORDER BY
- Sorting Data With ORDER BY - Exercises
- Selecting Unique Values With SELECT DISTINCT
- Selecting Unique Values With SELECT DISTINCT - Exercises
UNIDAD 3 - Creating and Transforming Data With SQL Functions · 21 leccionesUNIDAD 3 - Creating and Transforming Data With SQL Functions
UNIDAD 3 - Creating and Transforming Data With SQL Functions
- Creating Basic Derived Columns
- Creating Basic Derived Columns - Exercises
- Introducing SQL Functions With Text Functions
- Introducing SQL Functions With Text Functions - Exercises
- The CONCAT_WS Function
- The CONCAT_WS Function - Exercises
- SSMS Tips and Tricks
- Advanced Text Manipulation With Nested Functions
- Advanced Text Manipulation With Nested Functions - Exercises
- Dates and Datetimes in SQL
- Dates and Datetimes in SQL - Exercises
- Date Math in SQL
- Date Math in SQL - Exercises
- Data Types and CASTing
- Data Types and CASTing - Exercises
- The FORMAT Function
- The FORMAT Function - Exercises
- Handling NULL Values With ISNULL
- Handling NULL Values With ISNULL - Exercises
- The Mighty CASE Statement
- The Mighty CASE Statement - Exercises
UNIDAD 4 - Putting It All Together - Combining Data From Different Tables · 13 leccionesUNIDAD 4 - Putting It All Together - Combining Data From Different Tables
UNIDAD 4 - Putting It All Together - Combining Data From Different Tables
- Stacking Table Rows With UNION
- Stacking Table Rows With UNION - Exercises
- Relationships and Normalization
- JOINs
- JOINs - Exercises
- Going Deeper With JOINs
- Going Deeper With JOINs - Exercises
- OUTER JOINs
- OUTER JOINs - Exercises
- Going Deeper With OUTER JOINs
- Going Deeper With OUTER JOINs - Exercises
- Entity Relationship Diagrams
- Formatting SQL Code
UNIDAD 5 - Coding Challenges and Outro · 2 leccionesUNIDAD 5 - Coding Challenges and Outro
UNIDAD 5 - Coding Challenges and Outro
- Coding Challenges
- Outro
UNIDAD 6 - Summarizing Your Data With Aggregate Queries · 8 leccionesUNIDAD 6 - Summarizing Your Data With Aggregate Queries
UNIDAD 6 - Summarizing Your Data With Aggregate Queries
- Aggregate Functions
- Aggregate Functions - Exercises
- Grouping Aggregate Calculations With GROUP BY
- Grouping Aggregate Calculations With GROUP BY - Exercises
- Filtering Aggregate Calculations With HAVING
- Filtering Aggregate Calculations With HAVING - Exercises
- The STRING_AGG Function
- The STRING_AGG Function - Exercises
UNIDAD 7 - Writing SQL with AI: Effective Prompting Strategies · 6 leccionesUNIDAD 7 - Writing SQL with AI: Effective Prompting Strategies
UNIDAD 7 - Writing SQL with AI: Effective Prompting Strategies
- Prompting 101
- Few-Shot Prompting
- Don't Be Shy with AI
- Structuring Prompts with XML
- Don't Overdo It
- Role Reversal Prompting
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
7 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Travis Cuzick.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 7 unidades · 83 lecciones · 35 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Travis Cuzick; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
