5.00(2)

Introduction to SQL and Database

  • Course level: Beginner

Description

This course covers the introduction and core fundamentals of Structured Query Language (SQL) and database knowledge from definition and concept to their usages for working with data.

SQL is the language used in relational databases, which stores much of the world’s information from customer purchase records to internet traffic histories. In today’s data career, you’ll need to work with SQL and databases from data extraction to data retrieval, data definition statements, and data manipulation. We will cover data types, syntaxes, clauses, CRUD, how to aggregate data, how to query a database and so much more. In this course, you’ll be introduced to everything you need to know about relational databases and SQL syntax to get started working with popular databases like SQL Server in no time.

In the end, you will have practice exercises, quizzes, and a project to test your understanding. Your instructors will be here to assist you when needed.

What Will I Learn?

  • After finishing this course, the learners will be able to:
  • Aggregate and query to get insights from data
  • Read, write, and transform data in tables
  • Query data productively from tables in the SQL Server database.
  • Understanding the concept of a database and how to use it.
  • Understanding the concept of Structure Query Language (SQL).
  • Explain system databases and objects.
  • Discussion of database concepts - definition of a database management system.

Topics for this course

24 Lessons

Database and SQL?

In this topic, we are going to learn the basic concept of database and structured query language (SQL). You will get to know the different types of databases, the syntax of how to create a database, and different types of SQL statements.
Introduction to database
Database Management System (DBMS)
OLAP and OLTP
Introduction to SQL
Quiz 1 – Topic 1
Assignment 1

Data Types?

In this topic, You will learn how to use Data types in SQL servers include numeric, string, date, and time and how to convert those data types into one another. You will find the example with a clear explanation along with each lesson.

Data Manipulation Language (DML)?

In this topic, we are going to focus on SQL data manipulation language, which is used to retrieve and manipulate data in a relational database. We will learn about their syntaxes like CREATE, INSERT, UPDATE and DELETE.

Data Query Language (DQL)?

In this topic, we are focusing on SQL data query language. You are going to learn about the SELECT statement and how to use SELECT with various conditions to retrieve data. After finishing this chapter you should be able to: Use SELECT statement to query columns from tabless to get data that you want Use SELECT DISTINCT to retrieve the distinct value How to work with NULL data Minimize the query result by using condition in the WHERE clause How to search patterns in your string data by using Wildcard and LIKE clause How to work with SQL operator OR, AND and BETWEEN Use aggregation in SQL Using SQL statement keyword GROUP BY, ORDER BY, and HAVING in your queries

About the instructor

5.00 (2 ratings)

6 Courses

10 students

Student Feedback

5.0

Total 2 Ratings

5
2 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

gggood

great one!

950$

Material Includes

  • Lesson Slides, Learning Docs

Requirements

  • Complete SQL Pre Course involving the installation of SQL Server and other packages

Target Audience

  • The course is designed for beginner-friendly so anyone who has an interest in learning about SQL and databases or desires to gain useful skills in SQL, this course could be useful for you.
  • This course expects no foundation in information bases; it is valuable for individuals who have known about datasets yet never assembled one, just as for the people who have worked with datasets previously yet are attempting to find out with regards to Microsoft's leader data set framework. Assuming you are a front-end software engineer and might want to know how data set chairmen deal with assembling data sets, this course is for you. On the off chance that you have a human sciences certification and are currently attempting to find a genuine line of work, this course could be useful for you also.