SQL Hands-on Essential Training for Beginners
4.3 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
497 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Hands-on Essential Training for Beginners to your Wishlist.

Add to Wishlist

SQL Hands-on Essential Training for Beginners

Learn how to use SQL to query and manipulate databases with practical hands on examples
4.3 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
497 students enrolled
Created by Tech Academy
Last updated 8/2016
English
Current price: $10 Original price: $145 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand basic database concepts
  • Create a database table
  • Create a view
  • Add data into a table
  • Update existing data in a table
  • Delete data in a table
  • Read data from a table
  • Query a database
  • Use Aliases with queries
  • Understand C.R.U.D
View Curriculum
Requirements
  • Sample database required: We'll use MSDN Labs
Description

There is so much information around today and there has to be efficient mechanism in

place to manage tthe huge volume of data. This is where relational database

management systems -RDBMS comes in handy. An RDBMS is used to manage

databases.

What is a database? This is where information or data is stored. Databases actually

stored information or data inside tables which in turn consists of columns and rows just

like an excel spreadsheet. The columns represents the data fields for example LastName

while the rows represents individual records like Anderson. Database administrators or

data analyst need to interact with the data from the database from time to time and the

way they do that is by using SQL.

What is SQL - It stands for structural query language. It is an internationally used

lanaguage used to manipulate databases. With SQL you can do the following and much more:


Create a database
Create a table
create a view
Update a record
Delete  a record
Add a record
Read data from a table
Automate tasks


This course is a basic introductory course to SQL that will teach you the basic functions it

is used for on a database such as Create Read Update and Delete   collectively referred

to as C.R.U.D.  Over 85 percent of what you will do on a database will be CRUD related.

If you want to become a database administrator or developer this course will be a good

starting point.

What you learn on the course include:

Basic database concepts
How to create a Table
How to create a view
How to update data in a table
How to add data into a table
How to delete records in a table
How to use Aliases

I look forward to you signing up to the course.

Who is the target audience?
  • Aspiring database administrators
  • Aspiring database developers
  • Anyone who wants to learn something new new
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:08:44
+
The basics and Lab
6 Lectures 31:53



What is a query
09:41

MSDN Virtual Labs
03:49

Exploring MSDN Virtual Labs
08:02
+
C.R.U.D
9 Lectures 36:51
Introduction to C.R.U.D
01:31

How to create a database table
06:22

Adding records into a tabale
02:53

Reading data from a table
07:10

Updating records in a table
01:40

Deleting records from a database table
07:28

Creating views
04:59

Using Aliases
03:44

Conclusion
01:04
About the Instructor
Tech Academy
3.9 Average rating
78 Reviews
3,219 Students
5 Courses
Real Skills For The Real World

Tech Academy is a UK based e-learning provider that offers a range of high quality elearning solutions that teach real life  technical skills that are essential and relevant in today's commercial environment.

Our instructors have a wealth of experience in their respective courses and currently provide consultancy services to fortune 100 companies.

Our courses are presented in HD and are clear and concise to enable retention and provide intuitive learning experience for absolute beginners.