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
Free
This course is currently closed
Free
This course is currently closed
Course Details

SQL in 24

Instructor Image Mel
9 Lessons
5 Quizzes
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: Setting up SQL Workbench
1 Topic
Expand
Lesson Content
0% Complete 0/1 Steps
1-Setting up SQL Workbench
2 Monday: 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
Monday - Intro to Databases, Setup, SQL Basics
3 Tuesday: 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
Tuesday: Data Types and Combining tables
4 Wednesday: 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 Thursday: Aggregate Functions and Transactions
5 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/5 Steps
1-The five aggregate functions
2-Scenarios that would utilize aggregate functions
3-Create transactions
4-Practice executing in a SQL database
5-Hackerrank practice and assignments
Thursday: Aggregate Functions and Transactions
6 Friday: Self-Study day
2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
1-Creating aggregate functions
2-Utilizing transactions
7 Saturday: Triggers, Automation and Views
4 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/4 Steps
1-Understanding why and how triggers are used in SQL
2-Creating a SQL trigger
3- Understanding why and how views are used in SQL
4-Creating a SQL trigger
Saturday: Triggers, Automation and Views
8 Sunday: Building a SQL application in Javascript
4 Topics | 1 Quiz
Expand
Lesson Content
0% Complete 0/4 Steps
1-Use Javascript to set up a SQL database
2-Use Javascript to set up a SQL database
3-Create methods in the application to insert, update and retrieve data
4-Create methods to process data
Sunday: Building a SQL application in Javascript
9 Postwork: Reviewing assignments
Copyright 2023 - All Rights Reserved | We Can Code IT