Skip to content

HawksSpawn/google-tech-dev-guide

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 

Repository files navigation

Google Tech Dev Guide

My work on the Google Tech Dev Guide. (I have included task lists to check my progress)

Follow me on my journey, the road is still long 😁

Note: in the External Resources section, I will add free and always-available public sources, such as YouTube videos, tutorials, etc ... that I will use along my path.

Recommendations and Resources

External Resources

CS50’s Understanding Technology

Syllabus

Hello, world!

This course is for students who don’t (yet) consider themselves computer persons. Designed for students who work with technology every day but don’t necessarily understand how it all works underneath the hood or how to solve problems when something goes wrong, this course fills in the gaps, empowering students to use and troubleshoot technology more effectively. Through lectures on hardware, the Internet, multimedia, security, programming, and web development as well as through readings on current events, this course equips students for today’s technology and prepares them for tomorrow’s as well.

Website

Lectures

  1. Hardware
  2. Internet
  3. Multimedia
  4. Security
  5. Web Development
  6. Programming

Certificate

SQL

Learn SQL Course, Codecademy

Syllabus

Learn to communicate with databases using SQL, the standard data management language.

Website

Modules

  1. Manipulation
  2. Queries
  3. Aggregate Functions
  4. Multiple Tables

Certificate

SQLCourse

Website

Courses

Beginner Course

Syllabus

Our Beginner SQL Course is the perfect place to start if you are new to the world of database programming or database administration. In addition to learning basic SQL commands and syntax – such as how to insert, update, and delete information from tables – users will be able to practice those same commands through our free online SQL interpreter. Enter SQL commands to receive immediate results and experiment to better understand how database concepts such as table drops and table selects work.

The SQL tutorial and online interpreter currently supports a subset of ANSI SQL. The basics of commands such as select, insert, update, delete, and drop will be covered in this gentle introduction to Structured Query Language (SQL).

If you are already familiar with the basics of SQL, you can still use this database course as a refresher and practice common SQL commands and statements.

Lessons

  1. What is SQL?
  2. Table Basics
  3. Selecting Data
  4. Creating Tables
  5. Inserting into a Table
  6. Updating Records
  7. Deleting Records
  8. Drop a Table
Advanced Course

Syllabus

This unique SQL database tutorial builds on the Beginner Course on this site. It provides budding database programmers and db admins with more advanced, easy-to-follow SQL instructions and the ability to practice what you learn on-line with immediate feedback, thanks to our SQL interpreter! You will receive immediate results on a web page after submitting your SQL Commands.

This continuation course will provide you with critical need-to-know advanced features and clauses of the select statement that were not supported in the previous SQLCourse.com site. Everything you learn here will be ANSI SQL compliant and should work with most SQL databases, including Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database.

If you are already familiar with advanced SQL commands and database administration concepts, you can still use this course as a refresher, and practice some SQL statements.

Lessons

  1. Advanced SQL Tutorial Introduction
  2. SELECT Statement
  3. Aggregate Functions
  4. GROUP BY clause
  5. HAVING clause
  6. ORDER BY clause
  7. Combining Conditions & Boolean Operators
  8. IN & BETWEEN
  9. Mathematical Functions
  10. Table Joins, a must

Additional Information

For more information on this guide take a look at the link below:

About

My work on the Google Tech Dev Guide.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published