• hello@anchorsoftacademy.com

Database Administration, Design and SQL Mastery

Database Administration, Design and SQL Mastery

[ queries, stored procedures, views, triggers, security & more ]

Database Administration, Design and SQL Mastery

SCHEDULES & FEES

  • DateAug. 14, 2021
  • Duration 10 Weeks
  • Days and Time Saturdays 10am - 2pm
  • Fee N200,000
  • Registration Status Registration is closed for this batch.

COURSE DESCRIPTION

What is a database? A database is a collection of data stored in a format that makes it secure and easy to retrieve and manage. It is the security and management efficiency that makes database products attractive. There are two kinds of database systems: Relational and NoSQL.
Relational Database Management System(RDBMS) stores data in a database component called Table in ROWS and COLUMNS. One or more tables are usually related together, hence the name relational. Example includes MySQL, SQL Server, Oracle etc.

NoSQL database systems on the other hand store data in documents not tables, and do not use the SQL language for data administration. Examples include MongoDB, Cassandra, Redis etc.

This course is all about RDBMS and SQL. And we will be using the MySQL RDBMS product. Please note that the SQL language is 95% the same on all RDBMS products, with minor syntactical differences. Meaning that the SQL we will learn with MySQL in this course will be applicable to other RDBMS products like SQL Server, Oracle, PostgreSQL, etc.

Apart from tables, database contains a few components that are also very important. These include views, functions, stored procedures, and triggers. Mastering these components puts you in control of database design and administration. In this course, we will do all these more !!

After this course, you will have all it takes to take your first job as a database designer and administrator. Either managing a database to generate various reports for different levels of decision-makers or working with software developers to handle all the database-specific activities like tables relationships modeling, data-seeding, indexing, data partitioning for pre-production/staging QA testing, or user account security for the software applications under development. Database administrators are 'kings' in any enterprise.

TARGET AUDIENCE

[Absolute Beginners]

This course targets complete newbies. Absolutes beginners in database management and SQL. We'll go through the general concept about database, install MySQL database server and all necessary developer toolings.

WHAT YOU WILL LEARN

  • Writing simple and complex queries (including joins & subqueries )
  • Understand and implement data modeling
  • Views for reports
  • Functions
  • Stored procedures
  • Triggers and events
  • Transactions and data concurrency
  • Indexing for performance
  • User accounts management and database security

COURSE OUTLINE

  • Getting Started
    • Overview of SQL
    • Install MySQL and the Workbench tool
    • Create a database and write your first query
  • Getting Data from a Single Table
    • The SELECT statement
    • The SELECT with WHERE clause
    • AND, OR & NOT operators
    • IN operator
    • BETWEEN operator
    • LIKE operator
    • ORDER BY clause
    • LIMIT clause
  • Getting Data from Multiple Tables
    • Inner join
    • Self join
    • Implicit join
    • Outer join
    • Self Outer join
    • The USING clause
    • Natural join
    • Cross join
  • Insert, Update and Delete Data
    • Insert a row
    • Insert Multiple rows
    • Updating a row
    • Updating Multiple rows
    • Using Subqueries to Update
    • Deleting rows
    • Restoring the database
  • Summarizing Data
    • Aggregate function
    • The GROUP BY clause
    • The HAVING clause
    • The ROLLUP operator
  • Views
    • Creating views
    • Droping or Altering views
    • Updatable views
  • Stored Procedures
    • Stored Procedure Overview
    • Creating a Stored Procedure
    • Dropping a Stored Procedure
    • Parameters
    • Parameters with default values
    • Output Parameters
    • Variables
    • Functions
  • Triggers
    • Viewing triggers
    • Dropping triggers
    • Triggers events
  • Transactions and Concurrency
    • Transactions
    • Creating transactions
    • Concurrency and locking
    • Deadlocks
  • Database Designs
    • What is database design ?
    • Data modeling
    • Primary and foreign keys
    • Foreign keys constraints
    • Normalization
    • First, second and third normal forms
  • Indexing for Performance
    • Indexes overview
    • Creating indexes
    • Viewing indexes
    • Composite indexes
    • Order of columns in composite indexes
  • Database Security
    • General overview
    • Creating a user
    • Viewing users
    • Dropping users
    • Changing passwords
    • Granting privileges
    • Revoking privileges

Students' Testimonials

5-star testimonial Wura Ogundipe
[fullstack development]

When I decided to switch career into Software development ,As a beginner I knew I wanted a place where they will hold my hands through the journey.. Of all places I went to make enquiries , Anchorsoft academy was the only place where I saw their burning passion for producing strong full stack developers...

I have spent 10 weeks now and I can say for sure it’s the best thing that has happened to me this year
I enjoyed the excellent delivery of lectures & Hands on python web development training .

5-star testimonial Tosan Oke
[fullstack development]

Anchorsoft academy has a well structured curriculum that will take you from zero to mastery. I never really gained a good grasp of the fundamentals of software development (CSS, Python, API's) despite taking several online courses until I joined Anchorsoft, I am now fully confident in my abilities to build web applications.

Anchorsoft is highly recommend if you're seeking out a place to start or gain mastery of software development.