Brief Introduction
Understanding Databases and SQLDescription
In this course I'll teach you Structured Query Language - SQL for short - the fast and easy way.
We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro.
Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course.
We'll start out by learning fundamental database concepts, like... what is a database, what is a table, what are rows and columns, and what are data types.
After that I'll show you how to set up and use Microsoft SQL Server.
Then we'll dive right in to SQL itself. I'll teach you basic concepts like
- Select Statements
- Where, And or Not
- How to Order and Group By
- And cool things like that.
Then we'll move into slightly more difficult concepts like
- Having and Top Clauses
- Select Distinct
- Union
- And Functions
Then we'll jump into more advanced concepts like
- Insert and Update Statements
- Deleting and Altering Tables
- Joining Tables
- Primary Keys
- Indexing
- And more!
When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.
Join me today and I'll see you inside!
Requirements
- Requirements
- There are no programming skills necessary to take this course
- There is no special software needed for this course, we'll download the trial version of Miscrosoft SQL Server
John Elder
4.5 Raiting
MySQL for Beginners
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Learn how to Create, Use and Handle a MySQL Database from Scratch. Are you a Web Developer? An Application Developer? or A Programmer?...
Microsoft Access SQL: SQL for Non-Programmers
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Best-Selling Course. SQL Is One Of The Most Sought-After Skills By Employers....
70-461 Session 4: Querying Microsoft SQL Server (T-SQL)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761 If you are in UfB, welcome....
Microsoft Azure: From Zero to Hero - The Complete Guide
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Become an Azure Expert! Learn to design and build modern cloud apps from a certified Azure Architect Learn Microsoft Azure from a certified, experienced Azure Architect....
