Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-03-05 13:33:39
30-Day Money-Back Guarantee
Development Database Design & Development SQL

SQL Bootcamp - Hands-On Exercises - SQLite - Part II

Start your journey with SQL and databases. Solve over 150 exercises and open the door to a career in IT! (DDL + DML)
New
Rating: 4.8 out of 54.8 (7 ratings)
10,041 students
Created by Paweł Krakowiak
Last updated 4/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • solve over 150 exercises in SQL and databases
  • test yourself in DDL (Data Definition Language) and DML (Data Manipulation Language)
  • test yourself in creating tables
  • test yourself in defining column/table constraints
  • test yourself in working with master and foreign keys
  • test yourself in inserting, modifying and deleting records
  • test yourself in creating views, triggers
  • work with documentation and Stack Overflow
  • deal with real programming problems
  • guaranteed instructor support

Course content

29 sections • 297 lectures • 4h 9m total length

  • Tip
    00:02

  • Intro
    00:02

  • Exercise 1
    00:09
  • Solution 1
    00:03
  • Exercise 2
    00:07
  • Solution 2
    00:03
  • Exercise 3
    00:14
  • Solution 3
    00:04
  • Exercise 4
    00:07
  • Solution 4
    00:05
  • Exercise 5
    00:09
  • Solution 5
    00:05

  • Exercise 1
    00:07
  • Solution 1
    00:12
  • Exercise 2
    00:08
  • Solution 2
    00:05

  • Exercise 1
    00:07
  • Solution 1
    00:03
  • Exercise 2
    00:07
  • Solution 2
    00:03
  • Exercise 3
    00:06
  • Solution 3
    00:03
  • Exercise 4
    00:18
  • Solution 4
    00:12
  • Exercise 5
    00:18
  • Solution 5
    00:12
  • Exercise 6
    00:15
  • Solution 6
    00:13
  • Exercise 7
    00:22
  • Solution 7
    00:13
  • Exercise 8
    00:19
  • Solution 8
    00:13
  • Exercise 9
    00:21
  • Solution 9
    00:13

  • Exercise 1
    00:06
  • Solution 1
    00:05
  • Exercise 2
    00:07
  • Solution 2
    00:05
  • Exercise 3
    00:48
  • Solution 3
    00:43
  • Exercise 4
    00:52
  • Solution 4
    00:44
  • Exercise 5
    00:46
  • Solution 5
    00:43
  • Exercise 6
    00:57
  • Solution 6
    00:45
  • Exercise 7
    00:49
  • Solution 7
    00:44
  • Exercise 8
    00:58
  • Solution 8
    00:52
  • Exercise 9
    00:59
  • Solution 9
    00:53
  • Exercise 10
    00:54
  • Solution 10
    00:52
  • Exercise 11
    01:05
  • Solution 11
    00:55
  • Exercise 12
    01:04
  • Solution 12
    00:54
  • Exercise 13
    01:03
  • Solution 13
    00:54

  • Exercise 1
    00:08
  • Solution 1
    00:04
  • Exercise 2
    00:14
  • Solution 2
    00:05
  • Exercise 3
    00:08
  • Solution 3
    00:05
  • Exercise 4
    00:10
  • Solution 4
    00:05
  • Exercise 5
    00:16
  • Solution 5
    00:08
  • Exercise 6
    00:10
  • Solution 6
    00:04
  • Exercise 7
    00:15
  • Solution 7
    00:07
  • Exercise 8
    00:11
  • Solution 8
    00:06
  • Exercise 9
    00:17
  • Solution 9
    00:09

  • Exercise 1
    00:09
  • Solution 1
    00:05
  • Exercise 2
    00:09
  • Solution 2
    00:06
  • Exercise 3
    00:41
  • Solution 3
    00:36
  • Exercise 4
    00:45
  • Solution 4
    00:36

  • Exercise 1
    00:13
  • Solution 1
    00:06
  • Exercise 2
    00:14
  • Solution 2
    00:08
  • Exercise 3
    00:13
  • Solution 3
    00:08

  • Exercise 1
    00:08
  • Solution 1
    00:03
  • Exercise 2
    00:11
  • Solution 2
    00:05
  • Exercise 3
    00:12
  • Solution 3
    00:04
  • Exercise 4
    00:24
  • Solution 4
    00:14
  • Exercise 5
    00:12
  • Solution 5
    00:04
  • Exercise 6
    00:24
  • Solution 6
    00:14
  • Exercise 7
    00:13
  • Solution 7
    00:04
  • Exercise 8
    00:12
  • Solution 8
    00:07

Requirements

  • completed SQL Bootcamp - Hands-On Exercises - SQLite - Part I
  • basic knowledge of SQL
  • internet access

Description

------------------------------------------------------------------------------

RECOMMENDED LEARNING PATH

------------------------------------------------------------------------------

  • 200+ Exercises - Programming in Python - from A to Z

  • 210+ Exercises - Python Standard Libraries - from A to Z

  • 150+ Exercises - Object Oriented Programming in Python - OOP

  • 100+ Exercises - Unit tests in Python - unittest framework

  • 100+ Exercises - Python Programming - Data Science - NumPy

  • 100+ Exercises - Python Programming - Data Science - Pandas

  • 100+ Exercises - Python - Data Science - scikit-learn

  • 250+ Exercises - Data Science Bootcamp in Python

  • SQL Bootcamp - Hands-On Exercises - SQLite - Part I

  • SQL Bootcamp - Hands-On Exercises - SQLite - Part II

------------------------------------------------------------------------------

COURSE DESCRIPTION

------------------------------------------------------------------------------

SQL Bootcamp - Hands-On Exercises - SQLite - Part II

Welcome to the course SQL Bootcamp - Hands-On Exercises - SQLite - Part II, where you can test your SQL programming skills.

This is the second part of the SQL Bootcamp - Hands-On Exercises series. The exercises in this part are mainly focused on creating DDL and DML queries to the database.

The course is designed for people who have basic knowledge in SQL and it consists of over 150 exercises with solutions.

This is a great test for people who are learning SQL and are looking for new challenges. Exercises are also a good test before the interview.

Knowledge of SQL is one of the most desirable technical skills on the job market. If you're wondering if it's worth taking a step towards SQL and databases, don't hesitate any longer and take the challenge today.

Who this course is for:

  • everyone who wants to test knowledge of SQL and databases
  • everyone who wants to learn by doing
  • web developers
  • mobile developers
  • data analysts
  • data scientists

Instructor

Paweł Krakowiak
Data Scientist, Securities Broker
Paweł Krakowiak
  • 4.6 Instructor Rating
  • 1,460 Reviews
  • 42,558 Students
  • 37 Courses

EN

Data Scientist/Python Developer/Securities Broker

Founder at e-smartdata[.]org.

A big fan of new technologies, especially in the areas of artificial intelligence, big data and cloud solutions.

A graduate of postgraduate studies at the Polish-Japanese Academy of Information Technology in the field of Computer Science in the Big Data specialization.

A graduate of Master's Degree in Financial and Actuarial Mathematics at the Faculty of Mathematics and Computer Science of the University of Lodz.

Stockbroker license holder with experience in teaching at a university.

Lecturer at the GPW Foundation (technical analysis, behavioral finance and portfolio management).

The main areas of interest are artificial intelligence, machine learning, deep learning and financial markets.

PL

Data Scientist, Securities Broker

Założyciel platformy e-smartdata[.]org

Miłośnik nowych technologii, szczególnie w obszarze sztucznej inteligencji, big data oraz rozwiązań chmurowych.

Absolwent podyplomowych studiów na Polsko-Japońskiej Akademii Technik Komputerowych na kierunku Informatyka, spec. Big Data.

Absolwent studiów magisterskich z matematyki finansowej i aktuarialnej na wydziale Matematyki i Informatyki Uniwersytetu Łódzkiego.

Od 2015 roku posiadacz licencji maklera papierów wartościowych z uprawnieniami do czynności doradztwa inwestycyjnego.

Wykładowca w Fundacji GPW prowadzący szkolenia dla inwestorów z zakresu analizy technicznej, finansów behawioralnych i zasad zarządzania portfelem instrumentów finansowych.

Z doświadczeniem w prowadzeniu zajęć dydaktycznych na wyższej uczelni z przedmiotów związanych z rachunkiem prawdopodobieństwa i statystyką.

Główne obszary zainteresowań to sztuczna inteligencja, uczenie maszynowe, uczenie głębokie i rynki finansowe.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.