Discover the basics of SQL and learn how to manage databases efficiently with hands-on examples in this fun and friendly course.
This course is your friendly guide to SQL! You'll learn how to handle databases using simple commands and fun examples—perfect for anyone looking to start their journey in database management.
Learn how to use SQL to query and manipulate databases with practical hands on examples
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.
Understand basic database concepts
Create a database table
Create a view
8 Lectures
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...
this what i expected, but improvement can be done in terms of audibility. thanks for this lesson.
The course content was easy to understand. However the virtual labs were inaccessible so unable to practice what was taught, this was the prime reason for booking this course and I did not achieve it.
Good
I enjoyed the course. It was very informative and the instructor took his time to explain what he was doing really well.
I like the material for newbie's and the pace is perfect. A simple straight forward method that does not disappoint.
Very easy to understand. Keep up the good work.
Clear Instructions just need a little more insight
The instructor is very concise, speaks at a pace you can follow and provides comprehensive examples to help you understand.
Your email address will not be published. Required fields are marked *
Lawrence G.
great i enjoyed the course