SQL Foundations Course
Upskilling Course, 100 Academic Hours
Juggle Big Data and Draw Insights Like a Pro!
SQL (Structured Query Language) is a standard language used to interact with, and manage, relational databases. Looking to master SQL and boost your career in data analysis? Join our SQL Foundation Course and become a confident ace of databases.
SQL programmers are essential for efficiently managing and analyzing large volumes of data. Wawiwa’s SQL course focuses on employability and opens great career opportunities.
In our comprehensive course, you will learn the basics of SQL programming and gain the skills needed to query and manipulate databases with ease. Our expert instructors will guide you through hands-on exercises, interactive lessons, and real-world projects, ensuring that you gain a deep understanding of SQL concepts and best practices. Wawiwa’s training methodology, JET Design™, focuses on hands-on practice and industry needs.
Who should attend?
Prerequisites:
- Previous experience working with data, high mathematical ability, accuracy and attention to detail
- Microsoft Windows installed and licensed on your laptop
Learning Goals
During this course, you’ll acquire in-demand SQL skills for a successful career in data analysis. You’ll improve your ability to work with large datasets y draw insights from data. You’ll boost your productivity and efficiency in SQL programming. You’ll also be able to use SQL to create datasets, to retrieve data, to update data, and to analyze complex databases.
What You'll Get...
- 100 academic hours of live classes with a professional instructor, teaching in your local language.
- Access to recordings of the sessions, in case you missed one or for reinforcement, for the duration of the course.
- Certificate of Completion, also a digital one for LinkedIn. Graduation requires attending at least 80% of the classes, submitting all exercises, and getting a passing grade in the final project.
- Lifelong membership in Wawiwa’s global alumni community, made of tech professionals that graduated Wawiwa’s reskilling and upskilling programs around the world.
Professional Supervisor
This unique program was built by a professional team made up of the leading experts in Data Science and Analytics, with vast knowledge and experience in training too. Supervising the plan is Wawiwa's Head of Data Analysis programs, Mrs. Talia Morchi.
Talía Morchi
Head of Data Analysis Programs
Talia has over 10 years of experience in the IT industry, having held the roles of Product Manager, Project Manager, and Data Solutions Manager, where she specialized in data analysis in addition to her other responsibilities.
She is a lecturer at Bar Ilan University, serving as the director of the BI Developer course and also teaching in the Data Science course. In addition, she is an undergraduate lecturer at Ono and the academic director and leading lecturer of the data analyst track at the G-Academy.
Talia is an expert in various development tools, including SQL, Python, Excel, and uniPaaS.
¿Qué opinan los licenciados?
Course Syllabus
- Introducción a SQL
- Introducción al entorno de trabajo
- Consulta SQL básica
- Columnas calculadas
- Data normalization
- Funciones incorporadas básicas y más comunes
- Clasificación de los resultados
- Agrupación y agregación
- Filtrado avanzado
- Trabajar con valores NULL
- Diagrama
- Unir tablas
- Declaración condicional
- Subconsultas correlacionadas y no correlacionadas
- Documentation
- Funciones de ventana
- CTE (Expresión común de tabla)
- DML (Lenguaje de manipulación de datos)
- DDL (Lenguaje de definición de datos)
- Análisis de datos mediante el círculo de trabajo del analista
- Escribir funciones escalares de usuario
- Tablas temporales y procedimientos almacenados
Interested in more details?
We’d be happy to answer all your questions!