Sriram Sanka – My Experiences with Databases & More

Oracle-MySQL-SQL SERVER-Python-Azure-AWS-Oracle Cloud-GCP etc

  • Enter your email address to follow this blog and receive notifications of new posts by email.

  • Total Views

    • 588,532 hits
  • $riram $anka


    The experiences, Test cases, views, and opinions etc expressed in this website are my own and does not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.Product and company names mentioned in this website may be the trademarks of their respective owners.

Archive for the ‘Books’ Category

How to Install Python with Anaconda

Posted by Sriram Sanka on April 12, 2020


Refer to the document for help with installing Anaconda successfully Installing+Python.1

You can Download the individual version from https://www.anaconda.com/products/individual

I prefer Spider for the Sample Code snippets.

Sample Code for Sudoku Submitted at https://www.geeksforgeeks.org/sudoku-backtracking-7/

Input :

Output:

# N is the size of the 2D matrix   N*N
N = 9
 
# A utility function to print grid
def printing(arr):
    for i in range(N):
        for j in range(N):
            print(arr[i][j], end = " ")
        print()
 
# Checks whether it will be
# legal to assign num to the
# given row, col
def isSafe(grid, row, col, num):
   
    # Check if we find the same num
    # in the similar row , we
    # return false
    for x in range(9):
        if grid[row][x] == num:
            return False
 
    # Check if we find the same num in
    # the similar column , we
    # return false
    for x in range(9):
        if grid[x][col] == num:
            return False
 
    # Check if we find the same num in
    # the particular 3*3 matrix,
    # we return false
    startRow = row - row % 3
    startCol = col - col % 3
    for i in range(3):
        for j in range(3):
            if grid[i + startRow][j + startCol] == num:
                return False
    return True
 
# Takes a partially filled-in grid and attempts
# to assign values to all unassigned locations in
# such a way to meet the requirements for
# Sudoku solution (non-duplication across rows,
# columns, and boxes) */
def solveSuduko(grid, row, col):
   
    # Check if we have reached the 8th
    # row and 9th column (0
    # indexed matrix) , we are
    # returning true to avoid
    # further backtracking
    if (row == N - 1 and col == N):
        return True
       
    # Check if column value  becomes 9 ,
    # we move to next row and
    # column start from 0
    if col == N:
        row += 1
        col = 0
 
    # Check if the current position of
    # the grid already contains
    # value >0, we iterate for next column
    if grid[row][col] > 0:
        return solveSuduko(grid, row, col + 1)
    for num in range(1, N + 1, 1):
       
        # Check if it is safe to place
        # the num (1-9)  in the
        # given row ,col  ->we
        # move to next column
        if isSafe(grid, row, col, num):
           
            # Assigning the num in
            # the current (row,col)
            # position of the grid
            # and assuming our assined
            # num in the position
            # is correct
            grid[row][col] = num
 
            # Checking for next possibility with next
            # column
            if solveSuduko(grid, row, col + 1):
                return True
 
        # Removing the assigned num ,
        # since our assumption
        # was wrong , and we go for
        # next assumption with
        # diff num value
        grid[row][col] = 0
    return False
 
# Driver Code
 
# 0 means unassigned cells
grid = [[3, 0, 6, 5, 0, 8, 4, 0, 0],
        [5, 2, 0, 0, 0, 0, 0, 0, 0],
        [0, 8, 7, 0, 0, 0, 0, 3, 1],
        [0, 0, 3, 0, 1, 0, 0, 8, 0],
        [9, 0, 0, 8, 6, 3, 0, 0, 5],
        [0, 5, 0, 0, 9, 0, 6, 0, 0],
        [1, 3, 0, 0, 0, 0, 2, 5, 0],
        [0, 0, 0, 0, 0, 0, 0, 7, 4],
        [0, 0, 5, 2, 0, 6, 3, 0, 0]]
 
if (solveSuduko(grid, 0, 0)):
    printing(grid)
else:
    print("no solution  exists ")
 
    # This code is contributed by sudhanshgupta2019a

Posted in Anaconda, Books, Installation, Python | Tagged: , | Leave a Comment »

Microsoft__SQL_Server__2012_Pocket_Consultant By William R. Stanek

Posted by Sriram Sanka on May 8, 2012


Image

Well written and Well Organised  resource for DB Admins By William R. Stanek

 This Book really suits for 

  • Current SQL Server database administrators.
  • Accomplished users who have some administrator responsibilities.
  •  Administrators migrating to SQL Server 2012 from previous versions.
  •  Administrators transitioning from other database architectures.

I like the way author Presented the topics in a step-by-step manner and well categorized topics.

  •  Managing Your SQL Servers 
  •  Managing SQL Server Services and Clients 
  •  Implementing Policy-Based Management 
  •  Configuring and Tuning Your SQL Servers 
  •  Tuning and Linking Your SQL Servers 
  •  Database Administration Essentials
  •  Implementing SQL Server 2012 Security 
  •  Manipulating Schemas, Tables,and Views 
  •  Using Indexes, Constraints, and Partitions 
  •  Automating and Maintaining SQL Server 2012 
  •  SQL Server 2012 Backup and Recovery 
  •  SQL Server 2012 Profiling and Monitoring
 
 

Posted in Books | Leave a Comment »

SQL and Relational Theory, 2nd Edition by C.J. Date

Posted by Sriram Sanka on January 19, 2012


C.J. Date, is an independent author, lecturer, researcher, and consultant, specializing in relational database technology. He is best known for his book An Introduction to Database Systems.This book does n`t deal with SQL statements .. But  is all about between SQL and the Relational concepts theory  in a mathematical way.How SQL departs from relational theory, the basic principles of relational theory etc…

This Book contains 12 Chapters .. you can find Exercises  at the end of each chapter.I like the Appendix section  of this Book.

Appendix A:  The Relational Model
Appendix B : SQL Departures from the Relational Model
Appendix C:  A Relational Approach to Missing Information
Appendix D:  A Tutorial D Grammar
Appendix E:  Summary of Recommendations
Appendix F: Answers to Exercises
Appendix G: Suggestions for Further Reading.
I recommend this book  for all  who  works with SQL.
you can find his books and videos @ http://www.oreillynet.com/pub/au/2136

Posted in Books | 1 Comment »

 
Tales From A Lazy Fat DBA

Its all about Databases & their performance, troubleshooting & much more .... ¯\_(ツ)_/¯

Thinking Out Loud

Michael T. Dinh, Oracle DBA

Notes On Oracle

by Mehmet Eser

Oracle Diagnostician

Performance troubleshooting as exact science

deveshdba

get sum oracle stuffs

Data Warehousing with Oracle

Dani Schnider's Blog

ORASteps

Oracle DBA's Daily Work

DBAspaceblog.com

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Anand's Data Stories

Learn. Share. Repeat.

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBA's become bulletproof!

OraExpert Academy

Consulting and Training