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

Instructor Image Pill
5 Lessons
6 months
30 Students
Free
This course is currently closed
Free
This course is currently closed
Course Details

SQL

Instructor Image Pill
5 Lessons
3 Quizzes
30 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” 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

The course will consist of :

  • 3 online instructor led classes over 1 week
  • 15+ hours of self study material provided throughout the week
  • Reading material, videos, example codes, quizzes, and assignments
  • Real life exercises

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 - Review / Project
4 Topics
Expand
Lesson Content
0% Complete 0/4 Steps
1-Review of concepts and key words
2-Review of SQL commands and terms
3-Table creation, data import and join practices
4-Hackerrank assignments
5 Closing
1 Quiz
Expand
Lesson Content
Final Quiz
Copyright 2023 - All Rights Reserved | We Can Code IT