- 5 Courses Completed
- 20 Levels Completed
- 0 Screencasts Watched
- 58,065 Total Points
Git: 1 Course Completed
Learn how to use Git by reviewing the basic concepts of Git version control. Try out this introductory course that was created with GitHub.
Discover the basics of Git, including how to initialize a repo. Learn how to add, commit, and push your code to GitHub.
Database: 2 Courses Completed
The Ins and Outs of Databases
Learn about databases from the inside out, as well as how to perform simple data queries and filter data with special query tools in SQL.
Find out how to add, revise, and remove data in an existing database.
Managing Databases and Tables
Discover basic concepts for creating and altering databases and tables.
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Learn how to use SQL aggregate functions, including COUNT, SUM, and AVG, to do calculations on groups of data.
Add constraints — like NOT NULL, UNIQUE, FOREIGN KEY, and PRIMARY KEY — to your tables to increase data integrity.
Normalization and Relationships
Apply normalization rules to create tables without duplicate data and build the appropriate relationships.
Inner Joins, Aliases, and Outer Joins
Explore writing a single query to pull data from multiple tables and using aliases to create succinct queries.
Dive deeper as you learn how to write queries within queries.
Electives: 1 Course Completed
Search for text patterns using regular expressions and learn to validate emails and URLs, capture information, and use simple patterns to save development time.
The String Story
Learn what regular expressions are, and write your first expression. Discover literals, operators, character sets, modifiers, and metacharacters.
Journey into validating emails with wildcards, escaping characters, groups, and anchors.
Take a voyage to the edge with word boundaries and creating optional variations. Negate characters within character sets, and then use the negated shorthand. Finally, match specific amounts of characters with interval expressions.
Discover multi-line strings, and journey deeper with much larger subject strings. Search the globe and properly drop anchors with global and multi-line modifiers.
Grab the loot with capture groups, and learn how to extract sections of text for reference. Also discover when it's appropriate to have groups not capture.
.NET: 1 Course Completed
Dive into the world of ASP.NET Core and learn how to build easy-to-maintain web applications with the MVC design pattern and ASP.NET Core.
Model View Controller
Explore the MVC design pattern and learn how to set up the interactions between each part of it.
Getting User Input
Set up a web application that will accept and utilize user-entered data.
Learn how to store user input in memory, retrieve and present data back to the user, and handle nulls.