100%
Dark site-logo

We Can Code IT PreSkill

  • Home
  • Funding and Scholarships
  • Contact Us
Login
  • Home
  • Funding and Scholarships
  • Start Coding for FREE Now!
  • Profile
  • Login
  • Log Out
  • Achievements

SQL in 24

Instructor Image Mel
9 Lessons
6 months
5 Students
Free
This course is currently closed
Free
This course is currently closed
Course Details

SQL in 24

Instructor Image Mel
9 Lessons
5 Quizzes
5 Students
6 months
Current Status
Not Enrolled
Price
Closed
Get Started
This course is currently closed

Data increases exponentially with over 1.134 trillion MB of data created daily! To learn from this data, you need to be skilled in the TOP data programming language, SQL. “SQL in 24” is a fast-paced, straightforward introduction to SQL, the most common language used in querying databases and the TOP programming language in terms of number of job listings! 

Throughout this course, you will learn the foundations of SQL including:

  • Database basics, SQL/NoSQL, and database design
  • Installation and setting up a development environment
  • Creating tables and inserting data
  • Retrieving data and updating data
  • Sorting and filtering data
  • Working with different data types
  • Combining tables
  • Aggregate functions and transactions
  • Triggers, automation and views
  • Building a SQL application in Javascript

The course will consist of :

  • 5 online instructor led classes over 1 week for a total of 24 hours
  • 20+ hours of self study material provided throughout the week
  • Reading material, videos, example codes, quizzes, and assignments
  • Real life exercises and lots of practice!

Course Content

Expand All
1 Prework: Set up
1 Topic
Expand
Lesson Content
0% Complete 0/1 Steps
1-Setting up SQL Workbench
2 Lesson 1 - Intro to Databases, Setup, SQL Basics
6 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/6 Steps
1-Basic database concepts and database types
2-Database design fundamentals
3-Creating a table in SQL
4-Inserting, retrieving and updating data
5-Sorting and filtering data
6-Hackerrank practice
Intro to Databases, Setup, SQL Basics
3 Lesson 2 - Data Types and Combining tables
5 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/5 Steps
1-Different data types
2-Importing data from files
3-Different methods to combine tables
4-Combining tables in different scenarios
5-Assignment review
Data Types and Combining tables
4 Lesson 3 - Self-Study day
2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
1-Table creation, data import and join practices
2-Hackerrank assignments
5 Lesson 4 - Aggregate Functions and Transactions
4 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/4 Steps
1-The five aggregate functions
2-Scenarios that would utilize aggregate functions
3-Why we need transactions
4-Executing a transaction in a SQL database
Aggregate Functions and Transactions
6 Lesson 5 - Self-Study day
2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
1-Creating aggregate functions
2-Hackerrank Practice
7 Lesson 6 - Triggers, Automation and Views
4 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/4 Steps
1-What are triggers in MySQL and how are they used?
2-Creating a MySQL trigger
3- Automation in MySQL
4-MySQL Views, why we use them and how to create them
Triggers, Automation and Views
8 Lesson 7 - Final Assignment
5 Topics
Expand
Lesson Content
0% Complete 0/5 Steps
1-Creating Tables from an ER Diagram
2-Import data from files, create joins and aggregate functions
3-Create views and automate the database with functions and triggers
4-Create a connection with Javascript
5-Create a display from Javascript
9 Lesson 8 - Closing
1 Quiz
Expand
Lesson Content
Final Quiz
Copyright 2023 - All Rights Reserved | We Can Code IT