SQL Bootcamp - Hands-On Exercises - SQLite - Part I
What you'll learn
- solve 150 exercises using the SQL language
- test yourself in DQL (Data Query Language)
- test yourself in creating and executing database queries
- test yourself in sorting, filtering and grouping data
- test yourself in joining tables and creating subqueries.
- test yourself in creating complex queries
- deal with real programming problems
- work with documentation and Stack Overflow
- guaranteed instructor support
Requirements
- Basic knowledge of SQL and SQLite
Description
Welcome to SQL Bootcamp Part I, a practical and professionally designed course focused on helping learners build a solid foundation in SQL through direct, hands-on experience. This course is the first part of a comprehensive SQL Bootcamp series and concentrates on Data Query Language (DQL) using SQLite, a lightweight and powerful relational database engine.
In this part of the bootcamp, you will engage with carefully curated practice exercises, each targeting essential SQL querying skills. These exercises are crafted to simulate real-world scenarios and challenges you may encounter in data analysis, database management, or software development roles. Each exercise is accompanied by a complete, well-explained solution to reinforce your understanding and help you learn best practices in writing efficient and accurate SQL queries.
Throughout the course, you will explore fundamental SQL topics such as SELECT statements, filtering rows with WHERE, sorting results with ORDER BY, limiting outputs with LIMIT, and leveraging pattern matching with LIKE. Whether you're preparing for job interviews, academic assessments, or professional upskilling, this hands-on approach provides you with the tools and confidence to query data effectively.
Ideal for beginners and intermediate learners, this course sets a strong foundation for future SQL topics, including Data Manipulation Language (DML) and Data Definition Language (DDL). No prior experience is required—just your curiosity and a desire to learn SQL the practical way.
SQLite: Lightweight, Reliable, Zero-Configuration Database
SQLite is a self-contained, serverless SQL database engine that requires minimal setup and administration. Known for its efficiency and portability, it stores entire databases in a single file, making it ideal for embedded systems, mobile applications, and local data storage. Despite its compact size, SQLite supports powerful SQL features and ensures ACID compliance, offering a reliable solution for small to medium-scale applications.
sqlite3: Lightweight Database, Powerful Capabilities
sqlite3 is a self-contained, serverless, and zero-configuration relational database engine built into Python. It provides a simple and efficient way to manage structured data using SQL without the need for external database servers. Ideal for prototyping, small to medium-sized applications, and embedded systems, sqlite3 offers full transactional support and is easy to integrate into Python projects.
Who this course is for:
- Aspiring Data Analysts and Data Scientists
- Software Developers and Engineers
- Database Administrators and IT Professionals
- Business Analysts and Financial Professionals
- Career Changers Entering the Tech Industry
- Students and Recent Graduates in Computer Science or Related Fields
- Freelancers and Independent Consultants
Instructor
EN
Python Developer/AI Enthusiast/Data Scientist/Stockbroker
Enthusiast of new technologies, particularly in the areas of artificial intelligence, the Python language, big data and cloud solutions. Graduate of postgraduate studies at the Polish-Japanese Academy of Information Technology in the field of Computer Science and Big Data specialization. Master's degree graduate in Financial and Actuarial Mathematics at the Faculty of Mathematics and Computer Science at the University of Lodz. Former PhD student at the faculty of mathematics. Since 2015, a licensed Securities Broker with the right to provide investment advisory services (license number 3073). Lecturer at the GPW Foundation, conducting training for investors in the field of technical analysis, behavioral finance, and principles of managing a portfolio of financial instruments.
Founder at e-smartdata
PL
Data Scientist, Securities Broker
Jestem miłośnikiem nowych technologii, szczególnie w obszarze sztucznej inteligencji, języka Python big data oraz rozwiązań chmurowych. Posiadam stopień absolwenta podyplomowych studiów na kierunku Informatyka, specjalizacja Big Data w Polsko-Japońskiej Akademii Technik Komputerowych oraz magistra z Matematyki Finansowej i Aktuarialnej na wydziale Matematyki i Informatyki Uniwersytetu Łódzkiego. Od 2015 roku posiadam licencję Maklera Papierów Wartościowych z uprawnieniami do czynności doradztwa inwestycyjnego (nr 3073). Jestem również wykładowcą w Fundacji GPW prowadzącym szkolenia dla inwestorów z zakresu analizy technicznej, finansów behawioralnych i zasad zarządzania portfelem instrumentów finansowych. Mam doświadczenie w prowadzeniu zajęć dydaktycznych na wyższej uczelni z przedmiotów związanych z rachunkiem prawdopodobieństwa i statystyką. Moje główne obszary zainteresowań to język Python, sztuczna inteligencja, web development oraz rynki finansowe.
Założyciel platformy e-smartdata