Mastering SQL - Practical Course for Intermediate

Home >

Catalog >

SQL Intermedio

Este curso es para ti si ya tienes conocimientos básicos de SQL, pero quieres aprender cosas más avanzadas para crear consultas más potentes. En el curso, se familiarizará con la agrupación de datos, el filtrado de datos agrupados. También aprenderá a trabajar con varias tablas de la base de datos al mismo tiempo, combinándolas. Conozca los diferentes tipos de uniones de tablas, aprenda a utilizarlas en la práctica.

Course

Gain insight into a topic and learn the fundamentals

4.6

(514)

Intermediate

Recommended experience

25 chapters

Flexible schedule

Learn at your own pace

View course modules

Outcomes

Learning outcomes

Modules

Testimonial

Recommendations

Codefinity advantages

FAQs

What you will learn

Familiarícese con técnicas avanzadas de SQL, como la agrupación y filtrado de datos, para construir consultas complejas.
Comprenda los matices de las subconsultas anidadas para un análisis de datos profundo.
Adquiera la capacidad de manipular varias tablas de bases de datos simultáneamente mediante diversas operaciones de unión.
Domine la aplicación de INNER JOIN, LEFT JOIN y RIGHT JOIN para la recuperación óptima de datos.

Details to know

Earn a career certificateAdd to your LinkedIn profile

Assessments25 assignments

AI copilotYour personal assistant

Equip your business with cutting-edge Data and AI expertise.

Join employees from leading companies and many of the Fortune 100 who trust Codefinity to elevate their skills.

This course is for you, if...

You’re preparing for a promotionPosition yourself for career advancement by acquiring new skills and knowledge that will make you stand out to your employer

You’re a jobseeker looking to enhance your resumeAdd valuable skills to your resume and make yourself more attractive to potential employers. This course will give you a competitive edge in the job market.

You want to escape the 9-to-5 grindOur course provides the skills needed to transition into freelancing or remote work, giving you the freedom to work on your terms.

You’re passionate about continuous learningStay ahead in the rapidly evolving IT field with our comprehensive course. It’s designed for lifelong learners who want to continuously enhance their skills and knowledge.

Data Engineer Course

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

There are 6 modules in this course

En esta sección, aprenderá a agrupar y trabajar con dichos datos. Para ello, nos familiarizaremos con un operador como GROUP BY. También aprenderás a filtrar datos agrupados utilizando el operador HAVING.

En esta sección, aprenderás qué son las subconsultas anidadas, cómo crearlas y cómo trabajar con ellas.

En esta sección, aprenderá cómo puede combinar varias tablas, trabajando así con una tabla común, lo que simplificará la creación de consultas.

Aprende los fundamentos del Lenguaje de Definición de Datos (DDL) y del Lenguaje de Manipulación de Datos (DML) en SQL, incluyendo cómo crear, modificar y eliminar objetos de la base de datos, así como también cómo insertar, actualizar y eliminar datos dentro de las tablas.

Chosen by students of top schools

Including 30 out of top-30 U.S. colleges

Why people choose Codefinity for their career

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style. The instructions are very clear and easy to understand. There is even a hint to help you get the answer, and if you still cannot get the answer, then you can display the answer. I love the learning style that is used, it engages me.

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming.

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Learner reviews

4.6

50 reviews

70%

22%

Showing 3 of 50 reviews

Christian Werner Hans Schindler

Reviewed on Nov 18, 2024

sometimes confusing, by adding new commands, that are not used in the task itself

Fred Shirley

Reviewed on Nov 13, 2024

Easy to follow, pretty straight forward, language and structure is simple to understand.

moitumago

Reviewed on Nov 13, 2024

Well done in terms of logic and prioritization. The examples and explanations are thoughtful and very detailed. However, a native-speaking editor is needed to have the thing polished. The materials contain errors, but they are minor ones, so pay attention, but don't worry. In general, the course is worth your money and time, especially if you are a beginner.

Recommended if you're interested in learning SQL

Codefinity advantages

AI-Assisted Learning

Embrace the fascination of Tech Skills! Our AI-assistant provides real-time feedback, personalized hints, and error explanations, empowering you to learn with confidence.

Workspaces

With Workspaces, you can create and share projects directly on our platform. We've prepared templates for your convenience

Learning tracks

Take control of your career development and commence your path into mastering the latest technologies

Real-world projects

Real-world projects elevate your portfolio, showcasing practical skills to impress potential employers

AI-Assisted Learning

Embrace the fascination of Tech Skills! Our AI-assistant provides real-time feedback, personalized hints, and error explanations, empowering you to learn with confidence.