Lecture Details :
Visit my website at http://thenewboston.com for all of my videos!
My Google+ - https://plus.google.com/108291790892450338168/posts
My Second YouTube Channel - http://www.youtube.com/thenewbostontv
Course Description :
Introduction to Databases - Getting a MySQL Server - Creating a Database - SHOW and SELECT - Basic Rules for SQL Statements - Getting Multiple Columns - DISTINCT and LIMIT - Sorting Results - Sort Direction - Sort Direction - Basic Data Filtering and WHERE - Advanced Filtering Using AND and OR.
Are you IN or are you NOT IN? - How Search Engines Work - More on Wildcards - Regular Expressions - Creating Custom Columns - Functions - More on Aggregate Functions - GROUP BY - Subqueries - Another Subquery Example - How to Join Tables - Outer Joins - UNION - Full-Text Searching - INSERT INTO - How to Insert Multiple Rows.
UPDATE & DELETE - CREATE TABLE - NOT NULL & AUTO INCREMENT - ALTER / DROP / RENAME TABLE - Views - Final Video!.
Other Resources :
Other Computer Science Courses
- CSEP 503 Principles of Software Engineering by University of Washington
- Advanced Topics in Software Systems by University of Washington
- Software Engineering by IIT Bombay
- Programming Languages and Compilers by UC Berkeley
- CSE142: Computer Programming I by University of Washington
- An Introduction To Parallel Programming by Other
- The Structure and Interpretation of Computer Programs,Spring 2011 by UC Berkeley
- High Performance Computing by IISc Bangalore
- Introduction to Computer Science I by Harvard
- Introduction to Algorithms by MIT
» check out the complete list of Computer Science courses
Computer Science Lecture Notes
- Information Retrieval by University of Massachusetts
- Introduction to Java Development by N/A
- CPS 140 Computer Science by Duke University
- CSE 373/548: Analysis of Algorithms by Stony Brook University
- CS345 Data Mining and Clustering by Stanford
- CS 696 Emerging Technologies: Java Distributed Computing by UC San Diego
- Software Engineering and Security by Athens University of Economics and Business
- Pixels, Numbers, and Programs by University of Washington
- CS368: Java for C++ Programmers by University of Wisconsin